Customer Lifetime Value (CLV): Formula, Examples and How to Raise It

The CLV formula with illustrative numbers, and the ratio to acquisition cost that it feeds.

What is customer lifetime value?

Customer lifetime value is the money one customer is worth to you from their first order to their last. Not one transaction — the whole relationship.

CLV and LTV mean the same thing. Ecommerce teams tend to say CLV; SaaS and app teams say LTV. This page uses both, and so will the tools you read.

It sits in the decide layer of our marketing analytics guide — the methods that turn collected data into a spending decision. The number it pairs with is customer acquisition cost, which our CAC guide owns in full. We will not re-explain CAC here; we take it as an input.

Two versions of CLV exist, and mixing them up is the most common mistake we see:

• Historic CLV — what customers who joined in a past period actually spent. It is a fact, from your order data. It only describes customers whose lifetime is (mostly) over.
• Predictive CLV — what a customer who joined recently is expected to spend. It is a model, from patterns in older customers. Useful for decisions, but it is a forecast and should be labelled as one.

Historic CLV tells you the truth about last year. Predictive CLV lets you act this quarter. You need the first to trust the second.

What is the customer lifetime value formula?

The simple formula is three numbers multiplied together:

CLV = average order value × purchase frequency per year × customer lifespan in years

• Average order value (AOV) — total revenue ÷ number of orders.
• Purchase frequency — number of orders ÷ number of unique customers, over a year.
• Customer lifespan — how many years the average customer keeps buying.

That gives you revenue CLV. It flatters every business, because you do not keep revenue — you keep margin. The version worth using is:

CLV (margin) = AOV × frequency × lifespan × gross margin %

Gross margin is what is left after the cost of the product, shipping, payment fees and any per-order discounts. A 55% margin turns a ₹9,600 revenue CLV into ₹5,280 of profit CLV. That is the number to compare against acquisition cost, because CAC is paid in real money, not in revenue.

One more piece for subscriptions. If you do not know your customer lifespan yet, derive it from churn:

Lifespan (months) = 1 ÷ monthly churn rate

A business losing 2.5% of subscribers a month keeps the average subscriber for 1 ÷ 0.025 = 40 months. That is an average across everyone, not a promise about any one customer — but it is the standard shortcut, and it is good enough for a first pass.

Three worked examples in rupees

Every number below is illustrative — chosen to show the arithmetic, not drawn from any client or industry average. Plug in your own.

All figures illustrative. LTV:CAC uses margin CLV, not revenue CLV — using revenue would roughly double every ratio and hide a loss-making channel.

The skincare brand. ₹1,200 × 4 × 2 = ₹9,600 in revenue. At 55% gross margin that is ₹5,280 of profit per customer. If Meta ads bring a customer for ₹1,500, the ratio is 5,280 ÷ 1,500 = 3.5. Fine. If a discount-heavy coupon site brings one for ₹1,500 but those customers buy twice, not eight times, their CLV is ₹1,320 and the same CAC loses money.

The dental clinic. ₹2,500 × 2 × 5 = ₹25,000 across five years of check-ups and cleans. At 40% margin, ₹10,000. A Google Ads patient costing ₹3,000 returns 3.3 times that — but only if the clinic actually keeps patients for five years. A clinic that never sends a recall reminder may have a two-year lifespan and a ratio of 1.3.

The SaaS. ₹8,000 a month for 40 months is ₹3,20,000. At 75% margin, ₹2,40,000. A ₹60,000 CAC — a sales rep's time plus LinkedIn ads — gives 4.0. Notice how sensitive this is: if churn is 4% a month instead of 2.5%, lifespan drops to 25 months and margin CLV to ₹1,50,000. Same product, ratio falls to 2.5.

What is a good LTV:CAC ratio?

The widely quoted rule of thumb is 3:1 — three rupees of margin CLV for every rupee spent acquiring the customer. Below 1:1 you lose money on every customer. Between 1 and 3 you are paying for growth with thin or no profit. Well above 3, you could probably spend more to grow faster.

Treat it as a rule of thumb, not a law. It comes from venture-backed SaaS, where cash is patient and lifespans are long. A cash-flow-funded D2C brand may need 3:1 within the first 90 days, not over two years, because it cannot wait two years to be paid back.

That is why the payback period matters as much as the ratio: how many months until a customer's cumulative margin covers their CAC. The CAC calculator works out both the ratio and the payback months from your inputs, and the CAC guide covers what belongs inside the cost side. This page stops here on CAC.

Why CLV by channel and cohort is the real use

A single blended CLV for the whole business is a vanity number. It looks good in a deck and changes nothing.

The version that changes a budget is CLV split by acquisition channel — and then by the month a customer arrived. Because the question is never "what is a customer worth?" It is "which channel brings the customers who stay?"

Take the skincare brand again. Suppose its blended CAC is ₹1,500 and blended margin CLV is ₹5,280. Split it:

• Google Search customers (illustrative): CAC ₹2,200, margin CLV ₹7,500. Ratio 3.4.
• Meta prospecting customers: CAC ₹1,300, margin CLV ₹4,800. Ratio 3.7.
• Coupon-site customers: CAC ₹900, margin CLV ₹1,400. Ratio 1.6.

On CAC alone, the coupon site looks like the best channel. On CLV, it is the worst. Cheap customers who buy once are expensive customers. Most ad-account "optimisation" never sees this, because the ad platform's window closes days after the first purchase.

The method for building this — grouping customers by their first-order month or channel and tracking each group's spend in the months after — is cohort analysis. The cohort analysis post in this series walks through the retention triangle step by step; we will not repeat it here. And if you want to see why a channel's customers behave differently, mapping the customer journey is where the answer usually sits.

How to calculate CLV from an order export

You do not need a data warehouse for the first version. You need your order export and a pivot table. The steps below produce historic CLV, overall and by channel.

1. Export 24 months of orders. Every ecommerce platform, billing tool and clinic-management system has an order or invoice export. You need four columns at minimum: order ID, order date, a customer identifier (customer ID or email) and order value net of discounts. Add a fifth if you have it — the channel or campaign the customer's first order came from.
2. Pivot by customer. One row per customer with: count of orders, sum of order value, first order date, last order date. In Google Sheets or Excel this is one pivot table with the customer identifier as the row.
3. Work out AOV. Total revenue ÷ total orders across the whole export. Illustration: ₹48,00,000 ÷ 4,000 orders = ₹1,200.
4. Work out purchase frequency per year. Total orders ÷ unique customers, then divide by the years in your window. Illustration: 4,000 orders ÷ 1,000 customers = 4 over two years = 2 per year. (Yes, lower than the table above — this is a different illustrative dataset, and this is exactly why you compute your own.)
5. Estimate lifespan. For customers with two or more orders, average (last order date − first order date). Then add half of your typical gap between orders, because the customer has probably not finished buying on the day of their last order. Be honest that this is an estimate — see the limits section.
6. Multiply, then apply margin. AOV × frequency × lifespan gives revenue CLV. Multiply by your gross margin for the number you compare with CAC.
7. Repeat by first-order channel. Filter the customer pivot by the channel column and rerun steps 3–6 for each. Put the result next to that channel's CAC from your ad accounts. This table — channel, CAC, margin CLV, ratio — is the deliverable.

If you cannot get a first-order channel into the export, the fix is upstream: consistent UTM parameters on every campaign and a CRM or platform that stores the first touch against the customer record.

Where does the CLV data come from?

Four sources, in rough order of how much work each takes:

• The order export. The most honest source, because it is real money. It is also the least connected — it rarely knows which ad brought the customer.
• The CRM. For clinics, B2B and anything with a sales step, the CRM is where the lifetime lives — every invoice, every renewal, and (if you tag it) the original source. Its weakness is discipline: an untagged lead is an unattributed customer forever.
• GA4 with User-ID. GA4 can tie a customer's behaviour together across sessions and devices if you send it your own identifier — Google's User-ID documentation is explicit that the ID must be unique per user, persistent, and must not contain anything a third party could use to identify the person. With that in place, the User lifetime exploration reports total and average lifetime value by the source, medium and campaign that acquired the user — with the caveats that it only covers users active after 15 August 2020 and its end date is fixed to yesterday. GA4 also offers predictive metrics, including "predicted revenue" — the revenue expected in the next 28 days from a user active in the last 28 — but only once at least 1,000 returning users have triggered the purchase condition and 1,000 have not, over a seven-day period in the last 28 days. Smaller stores will not see it. Our GA4 explainer covers how the property has to be set up for any of this to work.
• BigQuery. When the spreadsheet stops coping — usually past a few lakh orders, or when you want CLV joined to ad cost automatically — GA4's raw event export into BigQuery is the next step. Google's export documentation states that the BigQuery sandbox is free, standard properties are capped at 1 million exported events a day, and streaming export is billed separately. BigQuery for marketers in this series shows the actual queries.

Whichever source you use, the rule is the same: the first-touch channel has to be stored against the customer, not the session. That is a tracking decision made on day one, and it is the part most businesses skipped.

How to raise customer lifetime value

The formula has three levers and a multiplier. Every tactic pulls one of them.

• Lifespan — retention. The biggest lever, because it multiplies everything else. For a clinic it is the six-month recall message. For a subscription it is fixing the reason people cancel in month two. For D2C it is the replenishment reminder timed to when the product runs out.
• Frequency — repeat purchase. Post-purchase email and WhatsApp flows, loyalty points, and a second-order offer that lands before the customer forgets you. Our ecommerce email marketing post covers the flows that do this without spamming.
• AOV — cross-sell and bundles. The dentist who offers a cleaning with the check-up. The skincare brand whose cart suggests the serum that goes with the cleanser. Small percentages, applied to every order.
• Margin — service and cost. Fewer returns, fewer support tickets, fewer refunds. Unglamorous, but every rupee saved per order goes straight into margin CLV.

And one lever on the acquisition side: buy better customers. Once you know which channel's customers stay, shift spend towards it even if its CAC is higher. This is where we spend most of our time inside performance marketing engagements — the tracking so CLV by channel can be measured at all, then the budget moves that follow from it.

The honest limits of CLV

CLV is a useful number that is easy to get confidently wrong. Four traps:

• Survivorship bias. Your lifespan estimate is built from customers who stayed long enough to buy twice. The ones who bought once and left are in the data as a lifespan of zero — but they are often excluded when people "average the repeat customers". Include them, or you will overstate lifespan badly.
• Small samples. A channel that brought 40 customers last quarter does not have a CLV. It has noise. Wait for a few hundred customers per channel before moving budget on the strength of a ratio.
• Unfinished lifetimes. Customers acquired six months ago have not shown you their lifetime. Historic CLV for recent cohorts is always understated — which is exactly what cohort analysis is for.
• Revenue instead of margin. Already said, worth repeating. A 3:1 ratio on revenue can be 1.5:1 on margin. Only the margin version tells you whether you made money.

There is also the question of discounting — money two years from now is worth less than money today — which formal CLV models handle and this simple formula ignores. For a spending decision this quarter, the simple formula is usually good enough. For a valuation, it is not.

Where to go from here

Run the seven steps once on your own order export. You will get a number that is roughly right, which beats a benchmark that is precisely irrelevant.

Then split it by channel, put it next to CAC, and look at the ratio for each. That single table — built in an afternoon — is the most useful piece of marketing analytics most Indian businesses have never produced.