Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 17

Reed Elsevier Philippines Marketing Analytics Specialist Interview Questions

The questions to prepare for a Reed Elsevier Philippines Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated daily.

18questions
~2htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
Validating Executive SQL ReportsEasy

Explain how to validate a SQL report before sharing it with leadership, including checks for filters, aggregations, and edge cases.

Data WranglingAggregationsQualityReed Elsevier Philippines
Detect and Handle Outliers in SQLEasy

Explain common SQL-friendly ways to detect outliers and how to handle them without distorting downstream analysis.

Data WranglingGroup ByAggregationsReed Elsevier Philippines
Handling Missing Data in SQLEasy

Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.

Data WranglingCase WhenQualityReed Elsevier Philippines
SQL Insights for Dashboard ReportingEasy

Explain how SQL prepares clean, aggregated data for dashboards and how to describe business impact from visualization work.

JoinsData WranglingAggregationsReed Elsevier Philippines
Top Categories With Window FunctionsMedium
Practice
Practice drill

Rank monthly LexisNexis content categories by view volume using aggregation, joins, CTEs, and RANK.

Window FunctionsData AnalysissqlReed Elsevier PhilippinesTaboola
SQL Joins and De-duplicationMedium
Practice
Practice drill

De-duplicate incoming QA records and identify unmatched or inconsistent account data using joins and validation rules.

data cleaningJoinssqlReed Elsevier Philippines
Rolling Average with SQL WindowsMedium
Practice
Practice drill

Calculate each active RpmGlobal Enterprise Planning user's 30-day rolling average of daily activity.

TavantRpmglobalTwo Six Technologies
2
Behavioral & Leadership11 questions · ~88 min
Using Data to Shift StrategyMedium

Tests data-driven influence in marketing: turning analysis into a strategic recommendation and aligning stakeholders around action.

Influence Without AuthorityCommunicationOwnershipReed Elsevier Philippines
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Calculate Customer Lifetime ValueMedium

Walk through the math of customer lifetime value using retention, churn, and margin assumptions.

CACRetentionLTVReed Elsevier Philippines
Campaign Execution PitchHard

Evaluates your ability to plan and justify a marketing analytics campaign for Reed Elsevier Philippines stakeholders.

Stakeholder ManagementReed Elsevier Philippines
Measure Marketing Campaign SuccessEasy

Define campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.

Funnel AnalysisKPIsLeading IndicatorsReed Elsevier Philippines

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 3 hands-on drills to finish this plan.