Snap Business Analyst Interview Questions

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

16questions

~3htotal time

Track your progressSign up free to work through all 16 questions and resume where you left off.

MetricsStart here. 3 questions · ~29 min

Investigate a 15% CTR drop across multiple campaigns by decomposing performance and separating measurement issues from real demand changes.

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 Series

Snap

Metrics for Snapchat+ AdoptionMedium

Tests product analytics thinking and metric selection for subscription feature adoption.

adoptionkpi hierarchy

Snap

SQL & Data Manipulation4 questions + 1 drill · ~48 min

Calculate monthly Snapchat AR lens retention by comparing each month's active users with the prior month's users.

CTR by Country and DeviceMedium

Practice

Calculate Snapchat click-through rates by country and device using a left join and distinct impression counts.

JoinsGroup Bysql

Snap

Window Functions vs AggregationsMedium

Tests understanding of SQL analytics patterns and when to use window functions.

Window FunctionsAggregations

Snap

Compare day-seven retention for Snap users who engaged with a campaign on day one versus those who did not.

More SQL & Data Manipulation questions with a free account

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

Behavioral & Leadership7 questions · ~67 min

More Behavioral & Leadership questions with a free account