Why Customer Lifetime Value matters
A rising CLV can reflect larger purchases, more frequent buying, or longer retention. A fall calls for checking which of those three drivers changed.
- Business question
- How much revenue can we reasonably expect from a typical customer before that relationship ends?
- Teams that use it
- Growth, finance, customer success, marketing, and leadership teams.
- Decisions it supports
- Acquisition budgets, retention investment, customer segmentation, pricing, and service levels.
Customer Lifetime Value formula
Average Purchase Value × Purchase Frequency × Customer Lifespan
Formula components
- Average purchase value
- Revenue from the measured orders divided by the number of those orders.
- Purchase frequency
- The average number of purchases made by a customer in the chosen period.
- Customer lifespan
- The average length of the customer relationship, expressed in the same time unit used for purchase frequency.
How to calculate Customer Lifetime Value
- Choose a representative customer group and a consistent observation window.
- Calculate its average purchase value and average purchases per customer per year.
- Estimate the average customer lifespan in years from historical customer records.
- Multiply the three inputs and keep revenue CLV separate from profit-based lifetime value.
Customer Lifetime Value example
A fictional online supplier has an average order value of £68. Its customers place four orders per year and remain active for an average of three years.
- Average purchase value = £68.
- Purchase frequency = 4 orders per year.
- Customer lifespan = 3 years.
- CLV = £68 × 4 × 3 = £816.
The estimated revenue CLV is £816 per customer.
On these assumptions, a typical customer contributes about £816 in revenue over the relationship. The company would still need margin and cost data to estimate lifetime profit.
How to interpret the result
Compare CLV over time and across meaningful segments, not only as one company-wide average. A stable overall value can hide a valuable segment improving while another deteriorates.
There is no universal “good” CLV. Product margin, acquisition channel, customer type, purchase cycle, business maturity, and the prediction method all change what the number means.
Common mistakes and limitations
- Treating revenue as profit
- The workbook formula estimates revenue. It does not subtract fulfilment, support, discounts, or acquisition costs.
- Mixing time units
- Monthly purchase frequency cannot be multiplied by a lifespan in years without conversion.
- Overconfident lifespan estimates
- Young businesses and fast-changing products may not have enough history for a stable lifespan assumption.
- Averages hiding segments
- Enterprise and self-serve customers, for example, can have very different economics.