Growth wants to know whether the people who join come back. A user's cohort is the first day they were active; retention asks how many of that cohort returned on a particular later day.
A user can appear many times on one day, and a day with no activity has no row.
One row per cohort that exists in the data, with the columns:
cohort_date — 'YYYY-MM-DD', the cohort's first active daycohort_size — distinct users whose first active day is that dateday_1_retained — how many of them were active again exactly one day laterday_7_retained — how many were active exactly seven days later| cohort_date | cohort_size | day_1_retained | day_7_retained |
|---|---|---|---|
| 2024-01-01 | 2 | 1 | 2 |
| 2024-01-02 | 1 | 0 | 0 |
activity| user_id | active_date |
|---|---|
| 1 | 2024-01-01 |
| 1 | 2024-01-02 |
| 1 | 2024-01-08 |
| 2 | 2024-01-01 |
| 2 | 2024-01-08 |
| 3 | 2024-01-02 |
| cohort_date | cohort_size | day_1_retained | day_7_retained |
|---|---|---|---|
| 2024-01-01 | 2 | 1 | 2 |
| 2024-01-02 | 1 | 0 | 0 |
activity| user_id | active_date |
|---|---|
| 1 | 2024-03-01 |
| 2 | 2024-03-01 |
| cohort_date | cohort_size | day_1_retained | day_7_retained |
|---|---|---|---|
| 2024-03-01 | 2 | 0 | 0 |
Community-reported interview topic. Not an official company question and no affiliation is implied.
Run against the public tests, or submit to score against all of them.