Trackum

Customer lifetime value (CLV): formula and examples

CLV shows what a customer brings in over the whole relationship. Formulas, three examples and the question of how much a new customer may cost in advertising.

Guide · · 5 min read · Written with AI, AI-assisted review on

Customer lifetime value (CLV): formula and examples
📷 Jacek Dylag · Unsplash

You calculate customer lifetime value (CLV) by multiplying the average order value by the number of purchases per year and the customer lifetime in years. CLV, also called lifetime value (LTV), says how much a customer brings in over the whole relationship with your business. For advertising it is the most important upper limit: it shows the most you may spend on a new customer. This article works through three examples (subscription, online shop, trades business) and shows how to use the value for Google Ads and Meta.

What is customer lifetime value and what do you need it for?

Customer lifetime value is the total value of a customer across all purchases, contracts and follow-on jobs. You can state it as revenue or as gross profit, meaning revenue minus variable costs. For decisions about advertising, gross profit is more informative, because it shows what is left after the cost of goods and the cost of carrying out the work.

Without CLV you judge advertising only by the first purchase. That puts businesses with repeat purchases at a disadvantage: a new customer who brings in hardly anything on the first job but stays for five years is worth more than the first revenue suggests. Conversely, a customer with high first revenue who never comes back can be worth less than they seem. For this, Google Analytics 4 (GA4) has the User lifetime report in its explorations. But it works with users as GA4 recognises them. It does not know the customers in your CRM or shop. For reliable values you therefore need your own customer data.

Calculating customer lifetime value: formulas and examples

There are two basic formulas. For businesses with one-off purchases: CLV equals average order value times purchases per year times customer lifetime in years. If you want gross profit, you multiply the result by your margin. For subscriptions with a constant churn rate: CLV equals monthly fee times margin, divided by the monthly churn rate. With 5% churn per month, a customer stays 20 months on average (1 divided by 0.05).

Examples of CLV (assumed values)
BusinessAssumptionsRevenue CLVGross profit CLV
Software subscription€29 a month, 5% churn per month, margin 80%€580€464
Online shopOrder value €60, 2.5 orders a year, 3 years customer lifetime, margin 35%€450€157.50
Heating installerFirst job €1,800, servicing €200 a year over 6 years, margin 30%€3,000€900

The values are worked examples and not industry values. Put in your own figures as soon as you have them.

→ Cookie banner with Consent Mode v2: compliant, with no monthly licence

Where do you get the figures for CLV?

The figures almost always exist already: in the shop system (orders per customer), in the CRM (jobs and contracts per customer) or in the accounts. Pick out customers who first bought two or three years ago. Add up what they have brought in since. That is more honest than any assumption. If there is no history yet, start with a cautious estimate and update it as soon as real data is available.

Separate new customers from existing customers and watch for outliers. A single large customer lifts the average without being typical for new customers. If in doubt, also take the middle value (median) and work with the more cautious of the two figures.

How does CLV determine what a new customer may cost in advertising?

The upper limit for the cost of winning a customer (customer acquisition cost, CAC) is their gross profit CLV. Anything above that is a loss-making business. Because you also want to allow for profit and risk, you set the affordable value below it. Online shop example: the gross profit CLV is €157.50. If you want to keep half of it as profit, a new customer may cost at most about €79. Then there is the time factor: the gross profit is spread over three years, but you pay for the advertising immediately. Anyone with little liquidity therefore also works with the gross profit of the first months.

CPA (cost per acquisition) in Google Ads measures the cost per conversion. A conversion is not always a customer. For service businesses it is usually an enquiry. You then calculate: affordable CAC times close rate equals affordable price per enquiry. For the heating installer, the gross profit CLV is €900. If half remains as profit, the affordable CAC is €450. If one in five enquiries becomes a customer (close rate 20%), an enquiry may cost €90.

→ Setting up Google Consent Mode v2 correctly: no warning in Tag Assistant

How do you use CLV for conversion values in Google Ads and Meta?

Automated bidding strategies such as target ROAS in Google Ads steer bids by conversion value. For them to work sensibly, the value has to match reality. The same goes for Meta: the value is passed together with the purchase event, through the pixel or the Conversions API. There are three levels for the value:

  • Shop: report the real basket value with every purchase. CLV then helps you set the target ROAS lower than the first purchase alone would allow.
  • Enquiries: give each enquiry a value of gross profit CLV times close rate; for the heating installer, €900 times 20%, so €180.
  • Later: send the actual order value back as an offline conversion as soon as the job is in the CRM.

All conversion values in an account should be on the same basis, either revenue or gross profit. Otherwise the values cannot be compared with one another. Target ROAS then loses its meaning.

Which mistakes distort customer lifetime value?

  • Using revenue instead of gross profit: CLV comes out too high.
  • Assuming too long a customer lifetime without checking it against real customers.
  • Mixing new and existing customers: regular customers are then over-represented.
  • Forgetting cancellations, returns and discounts.
  • Using a single CLV for all products and channels, although customers from different sources can bring in different amounts.

How does CLV get into your ad accounts?

For CLV to reach your advertising, every customer has to be traceable back to the ad. That works if the source (UTM parameters, click ID) is in every enquiry and later sales are reported back to Google Ads and Meta. Trackum sets up both (€50 extra each, excl. VAT), with a connection to your CRM or shop if you want one. Whether your conversion tracking already delivers clean values is shown by the free check at trackum.app/check.

Frequently asked questions

How do you calculate customer lifetime value simply?

Multiply the average order value by the purchases per year and the customer lifetime in years. For gross profit, multiply the result by your margin as well.

What is the difference between CLV and CAC?

CLV is the value a customer brings in over the whole relationship. CAC (customer acquisition cost) is the cost of winning that customer. CAC should be well below the gross profit CLV.

Which period should I use for CLV?

Use the period for which you have documented customer data. Do not plan with years your business has not yet experienced. The longer the period, the more uncertain the calculation becomes.

Can I read CLV in Google Analytics 4?

In its explorations, GA4 offers the User lifetime report with revenue and engagement over a user’s lifetime. That is a guide, but it does not replace customer data from your shop or CRM, because GA4 counts users and not people.

Sources

  1. Google Analytics Help: User lifetime support.google.com
  2. Google Ads Help: Target ROAS bidding strategy support.google.com
  3. Google Ads Help: Conversion values support.google.com
  4. Google Ads Help: Offline conversion imports support.google.com
Help