Dataford
Top 10
Prep plan
Updated weekly · Last refresh Sep 10

Activision Data Analyst Interview Questions

The questions to prepare for a Activision Data Analyst interview. Questions from real interview reports rank first. Updated daily.

10questions
~2htotal time
Track your progressSign up free to work through all 10 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~48 min
SQL Top 10% by EngagementMedium
Practice

Rank Facebook users by total session duration and return the top 10% using aggregation and NTILE.

Rankingtop kActivision
Relating Players and MatchesMedium

Assesses SQL join strategy and data modeling for linking player and match datasets.

data relationshipsdatabase managementActivision
Rank Top SKUs and Forecast Next QuarterHard
Practice
Practice drill

Use window functions and CTEs to rank top SKUs by revenue and project next-quarter performance.

Data WranglingGroup ByAggregationsActivision
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
More SQL & Data Manipulation questions with a free account
2
Statistics & Probability3 questions · ~28 min
Design A/B Test for Ad PlacementHard

Tests experimental design, metrics, and decision criteria for ad placement changes at Activision.

ExperimentationSample SizeA/B TestingActivision
Check Linear Regression AssumptionsMedium

Tests statistical understanding and diagnostic skills for regression modeling.

RegressionCorrelationHypothesis TestingActivision
Measure Ad CannibalizationHard

Tests causal reasoning and measurement of revenue tradeoffs from ad changes at Activision.

ExperimentationCausal InferenceA/B TestingActivision
3
More topics4 questions · ~37 min
Diagnose a Sudden DAU DropHard

Investigate whether an 8.2% DAU decline is driven by product breakage, logging issues, or normal seasonal patterns.

DAU/MAUDiagnosisTime SeriesActivision
Recommend After Conflicting ResultsHard

Tests product analytics judgment and tradeoff framing for retention versus monetization.

Feature PrioritizationUser NeedsValue PropositionActivision
Measure Marketing Campaign SuccessEasy

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

Funnel AnalysisKPIsLeading IndicatorsActivision
More questions with a free account

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 10 questions plus 2 hands-on drills to finish this plan.