Dataford
Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Oct 30

Top 50 Cohort Analysis Interview Questions

The most frequently asked Cohort Analysis questions across all roles and companies, ranked by real interview frequency. Updated daily.

50questions
~12htotal time
166companies covered
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 26 questions · ~370 min
Retention Rate SQL QueryMedium
Practice

Calculate monthly Remitly transfer retention for a signup cohort using CTEs, joins, date functions, and distinct user counts.

sql queryCohort AnalysisRemitlyAvepointGloboforce
Monthly Retention Cohort AnalysisHard
Practice

Build monthly signup cohorts with CTEs and joins to calculate month 0-2 retention for a self-serve product.

Data Analysisuser retentionCohort AnalysisRed VenturesBILLOpenAI
Cohort Conversion ComparisonMedium
Practice
Recently asked

Compare Mirakl buyer cohort conversion rates using aggregation, a LEFT JOIN, and RANK window functions.

Window FunctionsCohort AnalysisAggregationsMiraklSimilarWeb
Cohort Analysis SQLHard
Practice
Recently asked

Calculate monthly signup cohort retention for Initio Capital users using CTEs, joins, date functions, and distinct counts.

sqlCohort AnalysisIInitio CapitalOscar Insurance
Cohort Analysis Q1 vs Q2Hard
Practice

Compare Starlink portal retention for Q1 and Q2 signup cohorts using CTEs, joins, date arithmetic, and distinct-user aggregation.

sql queryCohort AnalysisSpacexPlaid
Consecutive Months MAU SQLMedium
Practice
Recently asked

Count Starbucks Rewards users active in each month who also purchased during the immediately preceding month.

Window FunctionsLag/LeadDate FunctionsStarbucks
Pre/Post Launch Cohort ComparisonMedium
Practice
Recently asked

Compare pre- and post-launch event activity and active users for each signup cohort.

Date FunctionsGroup ByCase WhenScientific Research
Cohort Conversion Before vs AfterHard
Practice

Compare pre and post campaign conversion rates by customer signup cohort using joins, a CTE, conditional aggregation, and date intervals.

sqlCohort AnalysisAggregationsSantander
More SQL & Data Manipulation 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
2
Metrics24 questions · ~342 min
More Metrics questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.