Scopely Product Analyst Interview Questions
The questions to prepare for a Scopely Product Analyst interview. Questions from real interview reports rank first. Updated weekly.
Use PostgreSQL CTEs and conditional aggregation to calculate daily active users and D1/D7 cohort retention for Monopoly GO!.
ScopelyCalculate Day 7 retention for a Monopoly GO! signup cohort using a CTE, left join, date filtering, and conditional aggregation.
ScopelyUse aggregation and sorting to identify the 10 MONOPOLY GO! players with the highest positive in-game spending.
ScopelyFramework for choosing a feature's primary success metric and guardrails before launch.
ScopelyDefine a success metric for a new feature that captures real user value, not just raw usage.
ScopelySign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.
ScopelyTests ability to design a rigorous experiment for a game UX change at scale.
ScopelyChoose the most important launch metrics, balancing early signals, long-term outcomes, and a clear KPI hierarchy.
ScopelyEvaluates statistical understanding and ability to connect metrics to game KPIs.
Scopely