Skip to main content Skip to search Skip to main navigation
  • Live seminars & online courses
  • Self-paced learning
  • Free training
  • 4 locations
Follow us:
+49 89 62 82 4893
Data & Growth

Customer lifetime value calculation

Customer lifetime value CRM Customer retention
Customer lifetime value calculation

Customer lifetime value shows what a customer is worth across the entire relationship, which is what makes marketing budgets comparable. Here is the formula, a complete worked example, and the points where the number misleads.

What customer lifetime value tells you

Customer lifetime value, usually shortened to CLV, is the contribution a customer makes over the whole duration of the business relationship. That makes it the number which answers a question most teams get wrong by instinct: how much may we spend to acquire a customer? As long as that figure is unknown, marketing budget is allocated by feel and defended by feel.

The distinction that matters is the one against revenue. A customer who generates 3,000 in revenue at 12 percent margin is worth less than a customer who generates 1,200 at 45 percent. CLV therefore always works on contribution margin, never on revenue. Anyone who plugs in revenue gets figures that hold no weight in a controlling conversation.

The formula

For practical use a compact formula is enough. It has four inputs, and every one of them can come from your own shop or ERP.

CLV = contribution margin per order × orders per year × customer lifetime in years

Contribution margin per order is the average order value minus cost of goods, shipping, payment fees and returns. Orders per year follow from purchase frequency, and customer lifetime is the inverse of the churn rate, meaning the average time a customer stays active.

Which inputs to use

InputWhere it comes fromCommon mistake
Contribution margin per orderERP, after deducting returnsReturn costs are left out
Orders per yearOrders divided by active customersOne time and repeat buyers are mixed
Customer lifetime1 divided by the churn rateChurn is measured for new customers only

If those three values are missing, that is no reason to postpone the metric. An analytics setup that reliably captures orders per customer and repurchase rates is the prerequisite, and building exactly that is covered in depth in Data & Analytics Pro.

Worked example

An example with realistic numbers from a shop selling considered purchases in the mid price range.

  • Average order value: 180
  • Cost of goods: 78
  • Shipping and payment fees: 9
  • Return rate 8 percent, allocated cost 12
  • Contribution margin per order: 81
  • Orders per customer per year: 1.6
  • Churn 35 percent per year, so 2.86 years lifetime

That gives a CLV of 81 × 1.6 × 2.86, roughly 371 per customer. This is the amount available for acquisition, service and retention of that customer without the business running at a loss.

What it means for marketing

At a CLV of 371, acquisition costs of 60 to 90 per customer are defensible, as long as that figure is actually reached. A shop that knows this number can set bids to win customers instead of optimising to the last cent. A shop that does not know it optimises for order value and then wonders why margin is shrinking.

CLV versus CAC

Customer acquisition cost, CAC, is the average spend required to win one new customer. Only the ratio of the two makes steering possible. The rule of thumb is a CLV to CAC ratio of at least 3 to 1, and 4 to 1 for subscriptions and considered purchases.

RatioWhat it meansWhat to do
below 1 to 1Every new customer loses moneyStop acquisition, review channels, raise prices
1 to 1 up to 3 to 1The business barely carriesFix retention before increasing budget
3 to 1 up to 5 to 1Healthy rangeScaling is sensible and affordable
above 5 to 1Growth potential is left on the tableInvest more in acquisition, expand channels

One caution on interpretation: a ratio above 5 to 1 sounds disciplined but is often a sign of underinvesting in growth. The target is a corridor, not a maximisation exercise.

The three levers that genuinely raise the number

CLV has four components, but only three are influenceable in daily operations. Order frequency is the strongest lever because it works in both directions, raising contribution margin and lifetime at the same time.

One: repurchase rate

A single extra purchase per customer over two years changes CLV more than any price increase the market still accepts. The most effective measures are a reason to return, such as consumables, servicing or a service interval, plus a reminder at the right moment. Reminding does not mean mailing every week, it means writing when the product is actually used up.

Two: churn rate

Churn determines lifetime, and small shifts have an outsized effect. If churn falls from 35 to 25 percent, lifetime rises from 2.86 to 4 years, and CLV rises in the same proportion without any change in order value. Where customers drop out is measurable: after the first order, after a complaint, or after a delivery delay. That analysis is the subject of CRM, Retention & Customer Lifetime Value.

Three: contribution margin per order

Contribution margin responds to bundles, accessories and an honest return rate. Returns are the most commonly underestimated line item because they cost twice: shipping both ways plus the time until the goods can be resold. Product pages that show dimensions and materials correctly measurably reduce returns, which in turn raises contribution margin.

Where the formula misleads

CLV is an average, and as an average it is useful for steering but dangerous for forecasting. Four limitations are worth knowing.

  1. The average hides two businesses. Often 20 percent of customers carry 70 percent of the value. A single blended figure leads to expensive new customers being subsidised.
  2. The past is not a plan. The formula uses historical rates. If you recently switched channel or changed the range, the old rate no longer applies.
  3. Not every cohort behaves the same. Customers from paid search and customers from referrals have different repurchase rates. A blended number smears that difference away.
  4. Interest and inflation are missing. A euro in three years is worth less than today. For long lifetimes, as in subscriptions, it should be discounted.

In practice that means calculating CLV per cohort and per channel rather than as a single total. More work, but it is the only version that supports budget decisions.

Frequently asked questions

What is a good customer lifetime value?

An absolute figure cannot be judged good or bad, because CLV always stands in relation to acquisition cost. The relevant measure is the ratio: a CLV of at least three times CAC counts as healthy. On top of that, CLV has to exceed acquisition cost, otherwise the shop subsidises every bit of growth.

How do I calculate CLV without customer accounts?

Guest orders can be attributed too, using the email address as the identifier. Accuracy is slightly lower because customers using several addresses get counted twice, but it is enough for a reliable order of magnitude. More important than the matching is that returns and cancellations are properly excluded, otherwise the figure is systematically too high.

What role does CLV play in performance marketing?

It is the basis for bid strategy. Without CLV you bid on first order value, which disadvantages channels with a low first order but a high repurchase rate. With CLV, bids can be differentiated per channel, which makes budget allocation considerably sharper. The practical execution is covered in Performance Marketing Mastery.

How often should CLV be recalculated?

Quarterly is enough for steering. More often only makes sense if you recently changed prices, range or channels, because then historical rates no longer describe current behaviour. More important than frequency is that the definition is fixed once and then left alone, otherwise there is no time series.

Conclusion

Customer lifetime value is not a metric for the annual report, it is a tool for budget decisions. Knowing it means you can justify acquisition spend instead of defending it, and calculating it per channel and cohort shows which part of marketing builds customers and which part merely buys orders. The arithmetic takes half an hour, the data foundation is the real work.

E-Commerce Masterclass

Think higher. Go further.

The masterclasses bring the subject areas together — compact, intensive days with a clear outcome. For everyone who makes decisions.

Explore masterclasses