E-commerce Cohort Analysis: Repeat Purchase, Revenue per Cohort & Payback
First purchase with MINIFS and cohort labels, cohort sizes between two dates, calendar month numbers, a triangle of distinct active customers, a retention heat map, cumulative revenue per customer with a cohort chart, CAC payback by cohort and channel cohorts compared: 8 graded labs on one fictional online shop.
The first lesson is free — no account needed.
About this course
An e-commerce cohort analysis course that turns one fictional online shop's order list into cohort tables in a spreadsheet, for e-commerce managers, marketers and data analysts. You tag every order with the customer's first purchase date using MINIFS, a cohort label and new versus repeat, count each month's new customers between two dates, give every order its month number counted in calendar months rather than 30-day blocks, build the triangle of distinct active customers and see how far order counts overstate it, turn it into a retention percentage heat map with a weighted retention curve, track cumulative revenue per original customer with a cohort chart, find the month each cohort paid back its acquisition cost and compare the cohorts of paid channels by CAC, month-3 retention and margin per dollar of CAC. The first lab is free.
Lessons
- First Purchase per Customer (MINIFS) and the Cohort LabelFree
- Cohort Size: New Customers per First-Purchase Month Pro
- Months Since First Purchase: Calendar Months, Not 30-Day Blocks Pro
- The Repeat-Purchase Triangle: Counting Active Customers, Not Orders Pro
- Retention % Triangle and a Heat Map Pro
- Revenue per Cohort and Cumulative Revenue per Customer Pro
- CAC Payback by Cohort: When Does Cumulative Margin Beat CAC? Pro
- Comparing Acquisition Channels' Cohorts Pro