A customer is more than their first purchase. When you calculate the Customer Lifetime Value, you calculate the profit over the entire customer relationship. This tells you how much new customers may cost and which channels are worthwhile. This article walks through an example and shows how to use the result in online marketing.
How can you calculate the Customer Lifetime Value?
You can calculate the Customer Lifetime Value by multiplying the annual profit by the customer lifespan and subtracting the acquisition costs. Profit instead of revenue is the most important rule here. Profit is the contribution margin, meaning the revenue from an order after deducting direct costs. The result shows the customer value over the entire relationship.
Which example case accompanies the article?
Imagine a small online shop. All numbers in this article are assumptions and serve only for illustration.
- An average order generates €60 revenue and €24 contribution margin.
- A customer orders an average of twice per year.
- Of all customers, 60% remain active for another year.
- Acquiring a new customer costs €30.
- Managing an active customer costs €6 per year.
Which calculation methods exist?
You calculate CLV in three calculation levels. The levels differ in effort and accuracy. The Gründerplattform describes similar levels from rough to detailed. The table shows what each level yields in the example.
| Level | Calculation method | Result in example | Limitation |
|---|---|---|---|
| 1 Rough and quick | (Contribution margin × Orders per year) × Lifespan minus Acquisition costs | €90 | Ignores service costs and time value of money |
| 2 With service costs and discounting | (Annual contribution minus Service costs) × discounted lifespan minus Acquisition costs | €68 | The interest rate is an assumption |
| 3 By channel or segment | Separate lifespan and separate acquisition costs per channel | Search €104, Social Media €76 | Requires clean data per channel |
How do you calculate roughly and quickly?
First calculate with the simple formula. The annual contribution of a customer is €24 times 2 orders, which is €48. With a customer lifespan of 2.5 years, that gives €120. After deducting the €30 acquisition costs, €90 remains. How to derive the lifespan is shown in the next section.
How do service costs and discounting change the result?
The simple formula leaves out two things. Customers cause ongoing service costs, €6 per year in the example. Additionally, one euro in three years is worth less than one euro today. The discounting accounts for this via an interest rate, here 5%.
The annual contribution therefore drops to €42. If you discount each subsequent year by 5%, the lifespan is mathematically shortened from 2.5 to around 2.33 years. That yields €98 and after deducting acquisition costs €68.
When is calculation by channel worthwhile?
An average hides differences. Therefore calculate separately as soon as you acquire customers from multiple channels. In the example, customers from search remain active for an average of 3 years and cost €40 to acquire. Customers from social media remain for 2 years and cost €20. That yields €104 for search and €76 for social media.
With equal shares of both channels, the average is €90, the value from level 1.
Which metrics do you need for the formula?
For the formula you need five metrics. These are contribution margin per order, orders per year, customer retention rate, customer lifespan, and acquisition costs. Good data first applies as a rule. The accuracy of the result depends directly on them.
Where do the values in the example come from?
- You take the contribution margin from your shop system or your merchandise management system.
- You count the orders per year from the order data per customer.
- You calculate the customer retention rate from the customer numbers, as the next section shows.
- The acquisition costs result from advertising expenses divided by the acquired new customers.
- You estimate the service costs from the effort for service and emails.
If this data is in multiple systems, a Data Warehouse brings it together.
How do you derive the lifespan?
The customer lifespan follows from the customer retention rate. The Gründerplattform calculates it like this: You subtract the new customers from the customers at the end and divide by the customers at the beginning. In the example, you start with 1,000 customers and end with 1,100. In between, you acquire 500 new customers.
The customer retention rate is therefore 600 divided by 1,000, which is 60%. The lifespan is 1 divided by 0.4, which is 2.5 years.
Which errors distort the customer value?
Three errors distort the customer value particularly easily. You calculate with revenue instead of profit, you only use one average, or you forget that the numbers are based on assumptions. Average hides differences, and false assumptions distort every budget.
What happens with the wrong basis?
If you calculate with revenue instead of contribution margin, the result in the example rises from €90 to €270. The result would be three times as high. Revenue ignores the costs that each order causes.
Why isn't one average enough?
In the example, the average is €90. Behind this are €104 for customers from search and €76 for customers from social media. Those who only see the average distribute their budget based on false assumptions.
How do you deal with limited data?
According to Gründerplattform, every calculation is based on assumptions and is a forecast. Young companies still have little data. In this case, start with estimated values and gradually replace them with real numbers.
Which method fits your company?
Which calculation level fits depends on your data. Data situation decides the accuracy, not the desire for a complicated formula.
Which level fits your data situation?
- If you have little customer data, start with level 1 and estimated values.
- If you have long customer relationships or ongoing service costs, choose level 2.
- If you acquire customers through multiple channels, calculate according to level 3.
How do you use CLV for marketing decisions?
CLV controls budget, channels, and customer care. It shows how much you may spend on a new customer, which channels deliver good customers, and where retention marketing is worthwhile.
What follows from the result for the budget?
The customer acquisition costs must be smaller than the contribution margin over the entire relationship. According to Gründerplattform, it is common for acquisition to cost more than the first revenues bring in. In the example, €24 contribution margin remains after the first order with €30 acquisition costs. Over the entire relationship, the customer brings €120 contribution margin; after deducting acquisition costs, €90 remains.
Those who only measure the first purchase underestimate profitable customers, as conversion tracking in e-commerce shows. Therefore keep CLV as a fixed value in your reporting.
Which channels deserve more budget?
In the example, social media appears cheaper with €20 acquisition costs. Per euro of acquisition costs, social media brings €4.80 contribution margin, search €3.60. Per customer, however, search leaves more profit, namely €104 instead of €76. If your budget is tight, the value per euro counts. If you can acquire more customers, the profit per customer counts.
How do you control Google Ads with CLV?
Google Ads can weight customers differently according to their lifecycle. According to Google Ads Help, you set higher bids for new customers, valuable new customers, or inactive customers with lifecycle goals. For this you need customer lists with at least 100 active members. Your CLV shows which group is worth how much. The implementation in Google Ads campaigns can thus be specifically controlled.
How do you increase customer value with retention marketing?
Retention marketing increases the customer retention rate and thus extends the lifespan. In the example, the customer retention rate rises from 60 to 70%. The lifespan thereby grows from 2.5 to around 3.3 years and the CLV from €90 to €130.
Three levers are available for this.
- Personalized content in emails and on the website, as hyperpersonalization describes.
- Automated email flows for repurchase and reactivation.
- More support for customers with high CLV, because every euro pays off more strongly there.
Conclusion
Calculating Customer Lifetime Value means evaluating customers beyond the first purchase. Start with the simple formula and estimated values. Replace these step by step with real data and later calculate by channel. Use the result for budget, channel selection, and customer retention.
Your customer value shows how much new customers may cost. How you acquire these new customers through search engines and ads, we clarify in a free initial consultation.
Sources & further reading
- Gründerplattform (n.d.): Customer Lifetime Value, How much is my customer worth? Available online at: https://gruenderplattform.de/startup-gruenden/customer-lifetime-value
- Google Ads Help (n.d.): Define your customer lists, Customer lifecycle goals. Available online at: https://support.google.com/google-ads/answer/14007601
- Andon, P., Baxter, J. and Bradley, G. (2003): Calculating Customer Lifetime Value (CLV), Theory and Practice. In: Günter, B. and Helm, S. (eds.): Kundenwert. Gabler Verlag, Wiesbaden, ISBN 978-3-322-99329-8. Available online at: https://doi.org/10.1007/978-3-322-99328-1_12