Evaluate user retention over time to assess product stickiness and long-term growth viability.
Do not scale acquisition until first-month retention is materially improved. Growth efforts should prioritize early value reinforcement rather than downstream engagement optimizations.
Cohort analysis shows sharp churn in the first month across all cohorts, with retention stabilizing after month two. Later cohorts do not outperform earlier cohorts, indicating limited improvement in early product experience over time. As a result, acquisition spend increases user volume without meaningfully increasing retained users.
Customers were grouped by first purchase month and tracked across subsequent months. Retention drops significantly in month one, then plateaus across cohorts, suggesting repeat usage rather than habit-forming growth. Downstream engagement remains stable, but does not compensate for early churn.
Focusing on early retention delays short-term user growth, but avoids inefficient acquisition spend that does not translate into long-term value.
Supporting Code (GitHub): https://github.com/adamtran042-portfolio/case-2-early-retention-constraint
| cohort_index/cohort_month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2010-12 | 100 | 36.6 | 32.3 | 38.4 | 36.3 | 39.8 | 36.3 | 34.9 | 35.4 | 39.5 | 37.4 | 50.3 | 26.6 |
| 2011-01 | 100 | 22.1 | 26.6 | 23.0 | 32.1 | 28.8 | 24.7 | 24.2 | 30.0 | 32.6 | 36.5 | 11.8 | 0.0 |
| 2011-02 | 100 | 18.7 | 18.7 | 28.4 | 27.1 | 24.7 | 25.3 | 27.9 | 24.7 | 30.5 | 6.8 | 0.0 | 0.0 |
| 2011-03 | 100 | 15.0 | 25.2 | 19.9 | 22.3 | 16.8 | 26.8 | 23.0 | 27.9 | 8.6 | 0.0 | 0.0 | 0.0 |
| 2011-04 | 100 | 21.3 | 20.3 | 21.0 | 19.7 | 22.7 | 21.7 | 26.0 | 7.3 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-05 | 100 | 19.0 | 17.3 | 17.3 | 20.8 | 23.2 | 26.4 | 9.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-06 | 100 | 17.4 | 15.7 | 26.4 | 23.1 | 33.5 | 9.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-07 | 100 | 18.1 | 20.7 | 22.3 | 27.1 | 11.2 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-08 | 100 | 20.7 | 24.9 | 24.3 | 12.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-09 | 100 | 23.4 | 30.1 | 11.4 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-10 | 100 | 24.0 | 11.5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-11 | 100 | 11.1 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2011-12 | 100 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |