Activision Data Analyst Interview Questions
The questions to prepare for a Activision Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Calculate daily impressions per active user and its 7-day rolling average using PostgreSQL aggregations and date-based windows.
ActivisionRank Facebook users by total session duration and return the top 10% using aggregation and NTILE.
ActivisionCompute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.
Meta
Spotify
Meta ITInvestigate whether an 8.2% DAU decline is driven by product breakage, logging issues, or normal seasonal patterns.
ActivisionDefine campaign success using business KPIs, funnel conversion, acquisition cost, and leading indicators tied to outcomes.
ActivisionSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests experimental design, metrics, and decision criteria for ad placement changes at Activision.
ActivisionTests statistical understanding and diagnostic skills for regression modeling.
ActivisionAssesses end-to-end experimental design for monetization in global games.
ActivisionTests product analytics judgment and tradeoff framing for retention versus monetization.
Activision