Dataford
Top 50
Topic roadmap
Updated weekly · Last refresh Sep 13

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
~10htotal time
70companies 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. 21 questions · ~244 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

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

sqlCohort AnalysisIInitio CapitalOscar Insurance
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
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 AnalysisSpacex
Six-Month User Retention CohortsHard
Practice

Calculate six-month retention by signup cohort using CTEs, joins, aggregations, and month-based date logic.

Window FunctionsRetentionCohort AnalysisNykaa
Retention Cohorts With Complex JoinsHard
Practice

Build twelve-month Twitch viewer retention cohorts with CTEs, joins, date offsets, and conditional aggregation.

JoinssqlCohort AnalysisTwitch
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
Metrics28 questions · ~325 min
More Metrics questions with a free account
3
More topics1 question · ~12 min
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.