Top 50 Retention Interview Questions
The most frequently asked Retention questions across all roles and companies, ranked by real interview frequency. Updated daily.
Calculate monthly active-user retention for Unity Ads using CTEs, joins, date truncation, and conditional aggregation.
Insurify
Unity
DoorDashCompute 7-day NYC rider retention by signup cohort using joins, CTEs, date filters, and distinct retained-user aggregation.
Asana
UberCalculate cohort month-over-month retention for Thumbtack service professionals using CTEs, date truncation, joins, and aggregation.
ThumbtackCalculate month-over-month active user retention using multi-table joins, monthly cohorts, and prior-month comparisons.
Meta LogisticsWrite a SQL query to find the monthly retention rate of users who signed up for a free tier of MongoDB Atlas over the last year. Treat retention for each ...
MongoDBCalculate monthly active-creator retention from TikTok video interactions using date-based cohorts and aggregation.
TikTokCalculate monthly cohort retention for users acquired through a specific Affirm paid social campaign.
AffirmCalculate day-over-day Uber driver retention across a 30-day activity period using date series generation and aggregations.
Uber DriversSign up to see every question
Create a free account to unlock this list and practice real interview questions.