Customer cohort: payback period and retention
For a cohort of customers calculates cumulative margin by month, CAC payback period, LTV for the period and the LTV to CAC ratio.
At a glance
- What question does it answer?
- How fast a customer pays back acquisition and whether the model is sound by the LTV to CAC ratio.
- What data is needed?
- CAC and the margin per order.
- How to read the result?
- There is no single norm in Russia: enter your own payback and LTV-to-CAC thresholds from the history of your cohorts. Below 1 a customer loses money; the shorter the payback at the same LTV, the sooner the money returns and the less of it is tied up. Compare marginal CAC with customer margin: an extra budget must pay back. Example on the default values: CAC RUB 1,200 with customer profit of RUB 231 over the cohort period: LTV for the period RUB 1,431, LTV to CAC 1.19, payback in 6 months.
Why and how to reason
A customer brings money not at once but month by month, and not all return. So a cohort is evaluated: a group of customers who came in the same month. For each month we take the share of customers still active, the number of orders per active customer and the order margin. Month margin = active x orders x order margin. Accumulated margin grows, and when it catches up with the acquisition cost (CAC), the investment has paid back.
LTV over the period is the accumulated margin over all observed months. LTV / CAC shows how many times it exceeds the investment.
Example. CAC RUB 1,200, order margin RUB 900. Month 1: 900. Month 2: 22% x 0.5 x 900 = 99, accumulated 999. Month 3: +72 = 1,071. Then 1,129, 1,179, 1,224 in month six: accumulated margin passed 1,200, payback is 6 months. Over 12 months RUB 1,431 accumulated, LTV / CAC = 1.19. Net profit per customer RUB 231.
When to use it
It fits when you have retention data over several months, to determine the allowable CAC and payback period. Suitable for online stores and brands with repeat purchases. Assumption: future cohorts behave like past ones. For a new channel data is scarce, start with cautious values. It is worth observing longer than 12 months if customers return. Remember to update cohort data every quarter.
How to read the result
Compare the payback period (6 months) with your ability to wait: you need cash to fund this period. LTV / CAC of 1.19 over a year says the customer returns the investment, but the profit is small and further retention decides everything. The retention drop happens in the first months, so work on them. Decision: increase budget on channels with fast payback, raise retention and repeat purchases, reduce CAC. Compare payback with cash turnover: if payback is six months and you need a return in three, the channel cannot be scaled without external funding. Check how the picture changes at retention 20% higher or lower.
Common mistakes
The usual mistakes: entering retention from total visitors rather than the cohort’s customers; using revenue instead of margin; mixing cohorts of different channels; taking too optimistic orders per month. Also: not including returns in margin. Also: taking retention from early cohorts, which are more loyal than later ones.
What data is needed?
- CAC and the margin per order.
- The cohort by month: the share of active customers and orders per active customer.
- Optionally: marginal CAC (the cost of customers an extra budget brings).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Customer acquisition cost (CAC) | ₽ | 1,200 | Advertising, contractors, creatives, services, marketing salaries ÷ new customers. |
| Margin per order | ₽ | 900 | After cost, fees, logistics and returns. |
| Marginal CAC (optional) | ₽ | 0 | The cost of customers an extra budget brings; usually above average. Optional. Empty: the field is ignored (counted as zero in sums). |
| Extend the retention curve beyond the table | No: only the months of the table | Tail: the active share after the last month of the table falls by the given percent a month, orders per active customer as in the last month. An assumption, check it on your cohort. | |
| Months of the tail | months | 12 | How many months to extend the retention curve; needed only when the tail is on. |
| Fall of active customers in the tail per month | % | 5 | Take it from your data: the ratio of the share of active customers of the last month to the previous. The example is illustrative. |
| Discount rate | % a year | 0 | 0: no discounting, as before. The margin of a month is brought to the day of acquisition; enter your own rate. |
How it is calculated
| Step | Formula |
|---|---|
| Month margin | Active × orders × margin per order |
| Payback | The first month where cumulative margin ≥ CAC |
| LTV / CAC | Cumulative margin ÷ CAC |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- LTV over the cohort period
- 1,431 ₽
- LTV / CAC
- 1.19×Below 1 is a loss. Set your own target from your history: there is no single benchmark in Russia.
- CAC payback period
- 6 monthsThe cohort month in which cumulative margin first covers CAC. Set the acceptable period yourself: there is no single benchmark in Russia.
- Profit per customer over the period
- 231 ₽
Data as a table
| Cohort month | Cumulative margin |
|---|---|
| 1 | 900 |
| 2 | 999 |
| 3 | 1,071 |
| 4 | 1,130 |
| 5 | 1,179 |
| 6 | 1,224 |
| 7 | 1,265 |
| 8 | 1,301 |
| 9 | 1,337 |
| 10 | 1,368 |
| 11 | 1,400 |
| 12 | 1,431 |
Cumulative margin per customer
| Month | Cumulative margin | Net of CAC |
|---|---|---|
| 1 | 900 ₽ | −300 ₽ |
| 2 | 999 ₽ | −201 ₽ |
| 3 | 1,071 ₽ | −129 ₽ |
| 4 | 1,129.5 ₽ | −70.5 ₽ |
| 5 | 1,179 ₽ | −21 ₽ |
| 6 | 1,224 ₽ | 24 ₽ |
| 7 | 1,264.5 ₽ | 64.5 ₽ |
| 8 | 1,300.5 ₽ | 100.5 ₽ |
| 9 | 1,336.5 ₽ | 136.5 ₽ |
| 10 | 1,368 ₽ | 168 ₽ |
| 11 | 1,399.5 ₽ | 199.5 ₽ |
| 12 | 1,431 ₽ | 231 ₽ |
Cohort data are more reliable than snapshots: calculate separately by acquisition channel and arrival month. Blended CAC is needed for the financial model, but channels should be managed by their own CAC.
Nuances and limits
- Cohort data are more reliable than snapshots: calculate by channel and arrival month.
- Do not enter optimistic retention: take it from a real cohort.