Dataford
Top 16
Prep plan
Updated weekly · Last refresh Aug 30

Just Play Marketing Analytics Specialist Interview Questions

The questions to prepare for a Just Play Marketing Analytics Specialist interview. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 6 questions · ~48 min
Diagnose Conversion Drop Post LaunchMedium

Diagnose why conversion fell from 4.8% to 3.1% after a launch by breaking the metric across funnel steps, cohorts, and segments.

Funnel AnalysisConversion RateDiagnosisJust Play
Calculate CAC From Campaign InputsMedium

Calculate customer acquisition cost from campaign budget, impression cost, and conversion rate.

CACConversion Ratecampaign performanceJust Play
KPIs for Paid Social vs Retail MediaEasy

Tests your judgment in selecting KPIs across different paid media channels.

KPIcampaign healthJust Play
Reducing Budget Waste in Ad SetsMedium

Tests your optimization thinking for reallocating spend based on performance signals.

roioptimizationJust Play
More Metrics questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
UTM Data Quality in AnalysisMedium

Tests your approach to data quality issues in marketing attribution and reporting.

campaign analysisnull handlingdata integrityJust Play
SQL for Campaign PerformanceEasy

Tests SQL skills for pulling campaign metrics from relational data sources.

campaign performancesql queriesJust Play
Advanced Excel for Marketing DataMedium

Tests your ability to transform and combine marketing data efficiently using advanced Excel tools.

pivot tablesData WranglingExcelJust Play
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
Pivot Lucid Campaign Performance by MonthMedium
Practice
Practice drill

Use joins, a CTE, CASE expressions, and monthly pivoting to compare Lucid campaign performance across channels.

pivot tablesnull handlingData WranglingLucid Motors
Analyze Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership7 questions · ~56 min
Translating Analysis Into StrategyMedium

Tests whether you can turn complex analysis into clear business recommendations and influence non-technical stakeholders to act.

impactCommunicationquantitative problem solvingJust Play
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.