Of January's signups, who came back in February
Marketing wants an M+1 retention report — "of the users whose first activity was in January, what percentage returned in February?". A standard cohort report. Treat the month of a user's first event as the cohort, and the month of any of their events as activity. For each cohort, count the cohort size, the number of users in that cohort who had an event in the next calendar month, and the retention percentage (returned divided by cohort size, times 100). Sort by cohort month.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| cohort | cohort_size | retained_m1 | retention_pct |
|---|---|---|---|
| 2024-01-01T00:00:00.000Z | 2 | 1 | 50.00 |
| 2024-02-01T00:00:00.000Z | 1 | 0 | 0.00 |
| 2024-03-01T00:00:00.000Z | 1 | 1 | 100.00 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in