01
Six cohorts per plan
4,711 subscribers were grouped by plan and start month into six monthly cohorts, each followed for months 0 to 5.
The method
Product analytics case study
Comparing retention across Standard and Pro plans.
I analyzed July to December 2018 monthly cohorts to compare retention behavior across Fumble’s two subscription plans and surface plan-level patterns relevant to an investor discussion.
Fumble is a dating app with two subscription plans, Standard and Pro. The exercise asked for the July to December 2018 monthly cohorts to be analyzed over their first six months for retention and average revenue, with the results prepared for an investor conversation.
What this isThis is a product exercise on a supplied dataset. It reports what the data shows and does not claim why, and no product change was shipped.
The ideaA cohort analysis of Fumble's Jul to Dec 2018 subscribers: retention by month for the Standard and Pro plans, compared cohort by cohort, with every number recomputed from the workbook.
01
4,711 subscribers were grouped by plan and start month into six monthly cohorts, each followed for months 0 to 5.
The method02
A subscriber counts as retained at month m when their active months exceed m. Every chart is recomputed from the workbook, never typed.
The method03
Pooled across its six cohorts, Standard retention falls from 100% at month 0 to 32.4% at month 5.
Standard retention04
Pooled across its six cohorts, Pro retention falls from 100% at month 0 to 46.5% at month 5.
Pro retention05
Pro retains more than Standard at month 5 in 6 of 6 cohorts, compared cohort by cohort.
The comparison06
The supplied workbook sits behind every chart, with a preview of its rows and a download.
The source data| Retention month | |||||||
|---|---|---|---|---|---|---|---|
| Cohort | Users | 0 | 1 | 2 | 3 | 4 | 5 |
| Jul ’18 | 151 | 100.0 | 90.1 | 80.8 | 68.2 | 60.9 | 57.6 |
| Aug ’18 | 160 | 100.0 | 89.4 | 73.8 | 63.8 | 57.5 | 54.4 |
| Sep ’18 | 234 | 100.0 | 82.9 | 80.3 | 65.8 | 60.3 | 46.6 |
| Oct ’18 | 279 | 100.0 | 90.7 | 75.3 | 64.9 | 41.6 | 25.1 |
| Nov ’18 | 260 | 100.0 | 75.8 | 72.3 | 51.9 | 22.3 | 21.5 |
| Dec ’18 | 307 | 100.0 | 95.4 | 64.5 | 16.0 | 15.3 | 13.4 |
Values are % of the cohort. Darker tint means a higher value.
| Retention month | Jul ’18 cohort | Aug ’18 cohort | Sep ’18 cohort | Oct ’18 cohort | Nov ’18 cohort | Dec ’18 cohort | Standard Plan, all six cohorts pooled |
|---|---|---|---|---|---|---|---|
| 0 | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% |
| 1 | 90.1% | 89.4% | 82.9% | 90.7% | 75.8% | 95.4% | 87.4% |
| 2 | 80.8% | 73.8% | 80.3% | 75.3% | 72.3% | 64.5% | 73.6% |
| 3 | 68.2% | 63.8% | 65.8% | 64.9% | 51.9% | 16.0% | 52.0% |
| 4 | 60.9% | 57.5% | 60.3% | 41.6% | 22.3% | 15.3% | 39.3% |
| 5 | 57.6% | 54.4% | 46.6% | 25.1% | 21.5% | 13.4% | 32.4% |
The ink line pools all six cohorts. Each tinted line is one cohort; point at the chart to read exact values.
| Retention month | |||||||
|---|---|---|---|---|---|---|---|
| Cohort | Users | 0 | 1 | 2 | 3 | 4 | 5 |
| Jul ’18 | 85 | 100.0 | 96.5 | 92.9 | 88.2 | 72.9 | 71.8 |
| Aug ’18 | 85 | 100.0 | 98.8 | 92.9 | 85.9 | 76.5 | 72.9 |
| Sep ’18 | 95 | 100.0 | 92.6 | 86.3 | 76.8 | 65.3 | 53.7 |
| Oct ’18 | 101 | 100.0 | 98.0 | 85.1 | 71.3 | 60.4 | 44.6 |
| Nov ’18 | 131 | 100.0 | 78.6 | 72.5 | 54.2 | 29.0 | 29.0 |
| Dec ’18 | 125 | 100.0 | 99.2 | 72.0 | 29.6 | 28.0 | 25.6 |
Values are % of the cohort. Darker tint means a higher value.
| Retention month | Jul ’18 cohort | Aug ’18 cohort | Sep ’18 cohort | Oct ’18 cohort | Nov ’18 cohort | Dec ’18 cohort | Pro Plan, all six cohorts pooled |
|---|---|---|---|---|---|---|---|
| 0 | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% |
| 1 | 96.5% | 98.8% | 92.6% | 98.0% | 78.6% | 99.2% | 93.2% |
| 2 | 92.9% | 92.9% | 86.3% | 85.1% | 72.5% | 72.0% | 82.2% |
| 3 | 88.2% | 85.9% | 76.8% | 71.3% | 54.2% | 29.6% | 64.5% |
| 4 | 72.9% | 76.5% | 65.3% | 60.4% | 29.0% | 28.0% | 51.9% |
| 5 | 71.8% | 72.9% | 53.7% | 44.6% | 29.0% | 25.6% | 46.5% |
The ink line pools all six cohorts. Each tinted line is one cohort; point at the chart to read exact values.
4,711 subscribers with plan, start month and active months.
Six monthly cohorts per plan, grouped by start month, Jul to Dec 2018.
Retained at month m when active months exceed m. Month 0 is the cohort size.
Counts and percentages for months 0 to 5, built in Python.
Standard and Pro compared cohort by cohort at month 5.
Data snapshotThe charts on this page are computed from the current workbook. The original one-page analysis was built from an earlier data snapshot and differs slightly for the July cohort (Standard 145 vs 151 users, Pro 84 vs 85), so its numbers are kept out of these charts rather than mixed in.
RevenueThe brief also asked for average revenue. The workbook holds a lifetime revenue total per subscriber with no stated first-six-month method, so no revenue figure is shown rather than assuming one.
| Category | Pro Plan | Standard Plan |
|---|---|---|
| Jul ’18 | 71.8% | 57.6% |
| Aug ’18 | 72.9% | 54.4% |
| Sep ’18 | 53.7% | 46.6% |
| Oct ’18 | 44.6% | 25.1% |
| Nov ’18 | 29.0% | 21.5% |
| Dec ’18 | 25.6% | 13.4% |
Share of each cohort still active at retention month 5, from the current workbook.
The gap at month 5, in percentage points
| Cohort | Pro | Standard | Gap |
|---|---|---|---|
| Jul ’18 | 71.8% | 57.6% | +14.1 pts |
| Aug ’18 | 72.9% | 54.4% | +18.6 pts |
| Sep ’18 | 53.7% | 46.6% | +7.1 pts |
| Oct ’18 | 44.6% | 25.1% | +19.5 pts |
| Nov ’18 | 29.0% | 21.5% | +7.5 pts |
| Dec ’18 | 25.6% | 13.4% | +12.2 pts |
Standard-plan cohorts contain more users in absolute terms.
These are descriptive observations. The data does not explain why Pro users stay longer, and later cohorts have had less time to accumulate months, so a cohort-by-cohort read is the fairest comparison.
From the same course file. It is not part of the cohort analysis.
1 / 4
Step 01
A profile card in the Tumble dating app carries a Report button next to the person's name.
Step 02
Tapping Report opens a form with two dropdowns and a place to record a statement.
Step 03
With a reason, an action and a recorded statement, the form shows the statement and is ready to submit.
Step 04
A confirmation sets an expectation for a reply and returns the user to the home screen.
Subscriber rows with plan, start month and active months.
| ID | Join Date | End Date | Plan Type | Revenue | Start Month | Active Months |
|---|---|---|---|---|---|---|
| 89950 | 2018-01-25 | 2019-03-02 | Standard Plan | $160.00 | Jan-2018 | 14 |
| 89951 | 2018-01-26 | 2018-03-27 | Standard Plan | $40.00 | Jan-2018 | 2 |
| 89952 | 2018-01-26 | 2021-01-27 | Pro Plan | $1,234.29 | Jan-2018 | 37 |
| 89953 | 2018-01-26 | 2021-01-27 | Pro Plan | $1,234.29 | Jan-2018 | 37 |
| 89954 | 2018-01-27 | 2021-01-27 | Pro Plan | $1,234.29 | Jan-2018 | 37 |
| 89955 | 2018-01-27 | 2021-07-11 | Standard Plan | $461.71 | Jan-2018 | 43 |
| 89958 | 2018-01-29 | 2018-10-26 | Standard Plan | $180.00 | Jan-2018 | 9 |
| 89984 | 2018-02-03 | 2018-04-19 | Standard Plan | $40.00 | Feb-2018 | 3 |
First 8 of 4,711 rows. The full workbook is not embedded in the page.
The raw data behind every chart, and the related prototype file.
Download the original documents (zip)Dataset · XLSX
Figma prototype