Building a Cohort Table from Raw Orders
This lesson is part of the course
In this lesson
You tag every order with the customer's first-order month and month number, then build the cohort table with one COUNTIFS formula.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Purchase Frequency, AOV and a Simple CLV Locked
- CLV with Margin, Retention and Discounting Locked
- Building a Cohort Table from Raw Orders Locked
- Retention Rates and the Retention Curve Locked
- Cohort CLV: Cumulative Margin per Customer and CAC Payback Locked
- Churn, Survival and Expected Customer Lifetime Locked
- Segment CLV and the CAC Ceiling Locked
- Predicting Repeat Purchases with a Recency/Frequency Scorecard Locked