Ecommerce LTV: compare customers at the same age

Customer lifetime value is an estimate of value over a defined customer relationship or observation horizon. ROI.LIVE keeps revenue value separate from contribution value. A customer who spends $180 has not generated $180 available to fund acquisition after products, fulfillment, fees and retention costs.

Cohort analysis groups customers by a shared starting event, often their first purchase, and compares what happens as each group ages. The age comparison is essential. A new group has had less time to place a second order.

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.

Keep immature cells blank. A group that began in July cannot have an observed twelve-month result in September. Do not fill that gap with a forecast unless it is clearly labeled and kept separate from actual observations.

A fair comparison

This table is illustrative. It uses contribution per acquired customer after variable order costs, before acquisition cost.

Compare January's $32 and April's $35 at day ninety. Do not compare January's $45 at day one hundred eighty with April's day-ninety result and call the difference deterioration. Even the matched-age difference may reflect product mix, seasonality, price or channel changes.

Keep the denominator intact

Divide cohort totals by all acquired customers in the cohort when estimating value per acquired customer. Calculating only among repeat buyers overstates what a new customer is expected to produce. Keep one-time buyers in the denominator.

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.

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 forecasting beyond the observed horizon, state the repeat rate, order contribution, timing and attrition assumptions. Show a lower-repeat scenario and compare the model with mature cohorts when they become available.

A forecast should not be silently substituted for actual customer value. Nor should an average across very old and very new customers be treated as a current acquisition ceiling without checking maturity and mix.

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.

Substantively revised September 7, 2026. Definitions, calculations, sources and internal destinations were reviewed for this edition.