Top 18
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

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
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
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
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
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
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 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
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
2
Behavioral & Leadership11 questions · ~88 min
Using Data to Change a Manager’s MindMedium

Tests influence without authority: using data to respectfully persuade a manager to change a decision and own the outcome.

Influence Without AuthorityStakeholder ManagementCommunicationReed 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.