Start studying
Module 14 · Data Science in Practice Module contents
Module 14  ·  Card 4 / 12intermediate

Cohort Analysis

Cohort analysis groups users by a shared starting point, such as the month they signed up, and tracks each group over time.

It separates how behaviour changes as accounts age from how it differs between groups.

For example, a table of sign-up months against months since sign-up shows what share of each cohort is still active.

If newer cohorts keep more users than older ones did at the same age, the product is probably improving.

Overall averages mix old and new users, so they can hide a decline in new cohorts behind loyal older ones.

Learn in depth ↓
Module 14 · Data Science in Practice · 12 concepts
In depth  /  15 lines

Cohort Analysis, in more detail

Cohort analysis shows how groups behave over their lifetime, which overall totals cannot.

It exists because a business mixes customers of very different ages at every moment.

Without it, growth from new users can hide worsening behaviour, or the other way round.

A cohort is usually defined by when users started, such as all sign-ups in March.

Other cohorts group users by first product, marketing channel or region.

The standard view is a triangle-shaped table, with cohorts as rows and months since start as columns.

Each cell holds a measure such as the share still active, or revenue per user.

Reading along a row shows how one cohort ages.

Reading down a column compares cohorts at the same age, which shows whether things are improving.

Reading diagonally shows the effect of a calendar event, such as an outage hitting every cohort in the same month.

Building one in pandas needs each user's start date and each activity date, grouped by both.

Small cohorts give noisy rates, so very young or small cohorts need caution.

Retention curves, one line per cohort, are an easy-to-read chart of the same table.

In practice, cohort tables are a standard view for subscription businesses, apps and marketplaces.

The usual mistake is comparing cohorts at different ages, such as a 3 month old cohort against a 12 month old one.

Want the full technical article? Wikipedia ↗
Test yourself

One question on this card. Every option explains itself once you pick, right or wrong.

Question 1
Overall retention looks steady, but a cohort table shows each new sign-up month keeping fewer users than the one before. What is happening?
Data Science in Practice

12 concepts in this module, then a graded test with every answer explained.

Study this module →
↑↓ move↵ openesc close