Explain cohort analysis and write a retention query
Tests your grasp of user behavior metrics. First, define a cohort (e.g., May signups). Then, explain why it's better than aggregate retention. Finally, outline a query grouping users by signup week and checking for activity. A red flag is a flawed query.
This tests your ability to translate a business need into a precise data analysis method and a query. A great answer defines a cohort (e.g., users from a specific signup period), contrasts this with misleading aggregate metrics, and outlines a pseudo-query. The query should join users to their activity, group by the signup cohort, and use conditional aggregation to count users returning at specific intervals (week 1, 2, 4).
Read the original → amplitude.com
- #analytics
- #metrics
- #sql
- #data
- #product
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.