Canadian University DubaiSchool of Managementcud.ac.ae ↗
EXPLORE ANALYTICS / CASE 02

Which customers
come back?

Cohort analysis starts with a definition. Here, a cohort is the month of a customer’s first purchase; retention means at least one purchase in a later month.

Synthetic teaching case
Retention by acquisition cohort · Every cohort has three follow-up months
CohortCustomersMonth 0Month 1Month 2Month 3
Read the heatmap correctly

Each cell divides returning customers by the original cohort size. The overall rate is weighted by customer counts, not an average of percentages. A customer can return in month 3 without returning in month 2. Channel differences are descriptive and do not establish that a channel caused retention.

Inspect the SQL
Student challenge: compare weighted retention with an unweighted cohort average. Explain when they differ and which question each answers.