Before using a lifetime-value figure to approve more acquisition spend, check what the figure includes. Customer lifetime value estimates value over a defined relationship or observation horizon. ROI.LIVE separates revenue from contribution: a customer spending $180 does not leave $180 for acquisition after product, fulfillment, fees and retention costs.
Give new customers the same time to buy again before comparing them with older ones. Cohort analysis groups people by a shared starting event, often their first purchase, and follows each group as it ages. That lets you compare like periods instead of penalizing the new group for time it has not had.
Define the cohort and the clock
Choose the entry event and date, such as first completed order in January. Record acquired customers, net revenue, variable costs and contribution at consistent ages: thirty, ninety, one hundred eighty or three hundred sixty-five days. Use a horizon that fits the buying cycle and available data.
Leave a future period blank until the customers have lived through it. A group that began in July has no observed twelve-month result in September. If you need a forecast, label it and keep it apart from the actual observations so the spending decision does not rest on a result that has not happened.
A fair comparison
This table is illustrative. It uses contribution per acquired customer after variable order costs, before acquisition cost.
Compare the day-90 column
| Acquisition cohort | Customers | Day 90 contribution | Day 180 contribution | Day 365 contribution |
|---|---|---|---|---|
| January | 200 | $32 | $45 | Not yet observed |
| April | 180 | $35 | Not yet observed | Not yet observed |
| July | 220 | Not yet observed | Not yet observed | Not yet observed |
In the sample, compare January's $32 with April's $35 at day ninety. Comparing January's $45 at day one hundred eighty with April's day-ninety result would make April look worse without giving it the same time to earn. Even at matching ages, product mix, seasonality, price and channel changes may explain the difference.
Editable resource
Use the worksheet
The CSV opens in Excel, Google Sheets or another spreadsheet editor. It contains labeled fields; sample data, where included, is illustrative.
Download the editable worksheet (CSV)
Preview the fields
- Cohort start
- Acquired customers
- Observed through
- Age days
- Net revenue
- Variable order costs
- Retention costs included
- Contribution before acquisition
- Acquisition cost
- Forecast or actual
- Definitions and limitations
Keep the denominator intact
Keep every acquired customer in the calculation, including the people who bought once and never returned. Divide the cohort total by that full group to estimate value per acquired customer. Counting repeat buyers alone overstates what you should expect from a new customer.
Separate order count from customer count. The share of customers who purchase once does not directly reveal the share of transactions made by those customers. Repeat buyers can contribute different numbers of orders.
Move from revenue to contribution
Subtract product costs, variable fulfillment, fees, shipping subsidy, returns and the incremental retention costs included in the chosen model. State which costs remain outside it. Avoid calling a revenue-to-acquisition-cost ratio profit.
A revenue multiple does not show profit
Read the full explanation
For illustration, $180 of observed revenue divided by $55 acquisition cost equals 3.27. That ratio alone does not show whether the customer is profitable. If contribution before acquisition is $70, the amount remaining after the $55 acquisition cost is $15, before any excluded costs.
The breakeven acquisition guide explains how to use that contribution in a spending decision.
Forecast with explicit assumptions
If you need a forecast beyond the observed period, show the repeat rate, order contribution, timing and attrition assumptions. Run a lower-repeat case as well. Compare the model with mature cohorts when they become available so you can see which expectations held up.
Keep forecast value apart from actual customer value. Before using an average as today's acquisition ceiling, check the age and mix of the customers inside it. A blend of old and new customers can hide the difference you need to understand.
Connect the cohort to the operating decision
Use the analysis to ask which customers can be acquired within the cash and contribution limits of the business. A group with stronger repeat buying may still take too long to repay its acquisition cost. The email-list economics guide separates retention revenue attribution from incremental contribution.
Keep the cohort source, definitions, extraction date and cost treatment with the report. The investment-cycle guide combines the evidence with inventory and cash planning. Start by building one matched-age table from actual records before quoting a lifetime-value multiple in a budget meeting.
Questions owners ask
Can a three-month cohort be compared with a twelve-month cohort?
Compare them at the same customer age. Different observation lengths create an unfair comparison unless the shorter period is explicitly modeled as a forecast.
Should one-time buyers remain in the LTV denominator?
Yes when estimating value per acquired customer. Excluding them overstates expected value for a newly acquired customer.
Is a 3:1 revenue-to-CAC ratio profitable?
The ratio alone cannot establish profitability. Subtract the relevant order and retention costs and inspect the remaining contribution and cash timing.
What should happen to immature cells?
Leave them unobserved. If a forecast is needed, label it separately with its assumptions and compare it with actual results when the cohort matures.
Method
This guide presents ROI.LIVE’s editorial analysis and worked methods. Numerical examples are illustrative unless expressly identified otherwise. No ranking, citation or business outcome is guaranteed.
Substantively revised September 8, 2026. Definitions, calculations, sources and internal destinations were reviewed for this edition.
