A store-wide lifetime value number can hide major differences between customers. Buyers acquired through different channels, campaigns, products, and promotions may have very different repeat rates and margins. Cohort analysis makes those differences visible by grouping customers according to when or how they were acquired and tracking their value over time.
Define LTV before calculating the ratio
Customer lifetime value (LTV) can mean cumulative revenue, gross profit, or contribution margin generated by a customer over a defined period. For acquisition decisions, a margin-based measure is usually more useful than revenue because it accounts for product costs and, depending on the definition, fulfillment, discounts, and returns. State the time horizon and included costs.
CAC should use the same customer definition and acquisition cohort. If the denominator is first-time buyers acquired in March, the numerator should include the acquisition costs assigned to that March cohort under a consistent rule. Avoid mixing all orders with new customers.
Core formulas
| Metric | Formula | What it tells you |
|---|---|---|
| Cohort CAC | Acquisition cost for cohort ÷ new customers in cohort | Cost to acquire a customer in that group |
| Cumulative contribution LTV | Cumulative cohort contribution margin ÷ customers in cohort | Value generated per acquired customer to date |
| LTV:CAC | Cumulative or forecast LTV ÷ cohort CAC | Value relative to acquisition cost |
| Payback period | First period cumulative contribution per customer covers CAC | Time until acquisition cost is recovered |
Build a cohort table
Track each acquisition month across subsequent months. The example below is illustrative only; it shows how cumulative contribution per customer can be compared with the cohort’s CAC.
| Acquisition cohort | CAC | Month 1 cumulative | Month 3 cumulative | Month 6 cumulative | Payback by month 6? |
|---|---|---|---|---|---|
| January | $80 | $22 | $54 | $91 | Yes |
| February | $95 | $18 | $49 | $78 | No |
| March | $72 | $25 | $61 | $96 | Yes |
In this illustration, January and March cohorts have generated cumulative contribution above CAC by month six. February has not yet paid back. That does not mean February customers are unprofitable for life; it means the observed payback has not happened within the measured window.
Segment carefully
Useful cuts include acquisition channel, campaign, first product, discount level, geography, and subscription versus one-time purchase. Do not create so many segments that each contains too few customers to be stable. Compare cohorts at the same age: a six-month-old cohort should not be compared with a two-month-old cohort on cumulative value.
Common LTV:CAC mistakes
| Mistake | Why it misleads | Better approach |
|---|---|---|
| Using revenue as profit | Ignores product and variable costs | Use contribution margin or show both |
| Mixing new and returning buyers | Makes CAC denominator inconsistent | Define first-time customer cohorts |
| Comparing cohorts at different ages | Older cohorts had more time to spend | Compare equal elapsed periods |
| Using an optimistic lifetime forecast | Extrapolates beyond observed behavior | Show observed and forecast value separately |
| Ignoring refunds and churn | Overstates retained value | Use net orders and retention curves |
Use the result in budget decisions
LTV:CAC is not a universal pass/fail ratio. Cash constraints, gross margin, growth targets, and payback requirements matter. A business with strong lifetime economics may still run out of cash if acquisition payback is too slow. A lower LTV:CAC channel may be attractive if it scales incrementally and pays back quickly.
Report observed LTV separately from modeled LTV. Include cohort size, data maturity, margin definition, and uncertainty. Revisit forecasts as actual repeat behavior arrives. Use cohort evidence to inform channel strategy, then validate large budget changes with experiments.
Frequently asked questions
What is a good LTV:CAC ratio?
There is no universal target. It depends on gross margin, cash needs, retention, growth rate, and how quickly acquisition costs are recovered.
Should LTV be based on revenue or gross profit?
For unit economics, gross-profit LTV is often more decision-useful because it accounts for the cost of delivering the product or service.
How do I calculate customer payback?
Compare cumulative gross profit generated by an acquired cohort with the acquisition cost for that cohort, and identify when cumulative gross profit covers CAC.
Can attribution data calculate cohort LTV?
Attribution tools can help describe acquisition sources, but cohort LTV and payback should be calculated from actual customer revenue, margin, and cost data over time.
For cohort-level LTV:CAC and payback analysis, ThoughtMetric may provide a complementary e-commerce attribution view of the channels associated with customer acquisition. Use actual cohort revenue, gross margin, and acquisition costs for the LTV and payback calculations; do not substitute attributed revenue for realized customer value.
Leave a Reply