Customer Lifetime Value Formula: How to Calculate CLV (With a Worked Example)

What Is Customer Lifetime Value (CLV)?

CLV estimates how much a customer is worth to your business for as long as they keep buying from you. It's forward-looking by design: instead of asking "how much did this customer spend last quarter," it asks "how much will this relationship be worth in total."

Marketing, growth, and finance teams use CLV to answer three practical questions:

• How much can we afford to spend acquiring a customer? (This is where CLV meets customer acquisition cost — a related but distinct metric covered in depth in our CAC guide.)
• Which customer segments or channels produce the most valuable customers, not just the most customers?
• Where should we invest in retention, and what's the payoff if we succeed? (See our retention KPIs guide for the broader retention metric set CLV sits alongside.)

The Customer Lifetime Value Formula

There isn't one universal CLV formula — there are a few, depending on how precise you need to be. All of them build on the same three inputs: how much a customer spends per order, how often they buy, and how long they stick around.

Basic CLV formula (revenue-based)

CLV = Average Order Value × Purchase Frequency × Customer Lifespan

• Average Order Value (AOV): total revenue ÷ number of orders, over a set period
• Purchase Frequency: number of orders ÷ number of unique customers, over the same period
• Customer Lifespan: the average number of periods (usually years) a customer keeps buying before churning, often estimated as 1 ÷ churn rate

CLV formula with profit margin

CLV = (Average Order Value × Purchase Frequency × Customer Lifespan) × Gross Margin %

This version answers "what is this customer worth in profit," not just revenue — the number you actually want when comparing CLV to acquisition cost.

CLV formula for subscription businesses

CLV = (Average Revenue Per Account × Gross Margin %) ÷ Monthly Churn Rate

Subscription and SaaS businesses typically don't have discrete "orders," so CLV is expressed as monthly or annual recurring revenue divided by churn, which effectively estimates the average customer lifespan for you.

Worked Example: Calculating CLV Step by Step

Here's the full calculation using realistic numbers for a mid-sized e-commerce brand.

Inputs:

Calculation:

So this customer is worth $1,020 in lifetime revenue, or $612 in lifetime profit. If this brand's customer acquisition cost is, say, $150, the CLV:CAC ratio is roughly 4:1 on a profit basis ($612 ÷ $150) — generally considered a healthy range, though the "right" ratio varies by industry and growth stage.

Common Customer Lifetime Value Calculation Mistakes

Most CLV numbers that get challenged in a board meeting fail for one of these reasons:

Using revenue instead of margin. Revenue-based CLV looks impressive but overstates what a customer is actually worth. Always calculate a margin-adjusted version before comparing CLV to CAC or using it to set acquisition budgets.

Averaging across a customer base that isn't homogeneous. A single blended CLV hides the fact that your best segment might be worth 5-10x your worst. Calculating CLV per segment, channel, or cohort is almost always more useful than one company-wide number.

Estimating lifespan from too little history. If your product is 18 months old, you don't have enough churn data to reliably estimate a 3-year customer lifespan. Early-stage businesses should treat CLV as a rough, evolving estimate — not a fixed input to a spreadsheet model.

Ignoring changing purchase behavior over time. Static formulas assume a customer's spending and frequency stay flat for their entire lifespan. In reality, spend often rises after the first few purchases and drops before churn — which is why predictive, cohort-based CLV models tend to outperform a single static formula.

Recalculating manually and infrequently. CLV calculated once a quarter in a spreadsheet is already stale by the time it reaches a budgeting decision. Treating CLV as a live, continuously updated number — rather than a static report — is what separates teams that actually act on it from teams that just report it.

CLV vs. CAC vs. Retention KPIs: How the Metrics Relate

CLV doesn't exist in isolation — it's most useful next to the metrics that explain why it's moving:

• CLV vs. CAC: CAC tells you what it costs to win a customer; CLV tells you what that customer is worth once won. The ratio between them is a core efficiency signal for any growth team. Our detailed breakdown is in Cut the Cost of Acquiring a Customer with Questera.
• CLV vs. retention KPIs: Retention rate, churn rate, and repeat purchase rate are the levers that move CLV. A 5-point improvement in retention can meaningfully change lifetime value without touching acquisition spend at all. For the full set of retention metrics and how to move them, see Retention KPIs: How to Measure and Improve Customer Retention.

Think of it as a chain: retention and engagement drive CLV, and CLV — measured against CAC — tells you whether your growth motion is actually profitable.

How Questera's GIA Automates CLV Modeling and Dashboards

The formulas above are simple to write down and genuinely hard to maintain by hand, especially per-segment, per-channel, and updated in real time. That's the gap most spreadsheet-based CLV processes eventually hit.

Questera is the agentic operating system for growth & engagement — a set of AI agents that monitor real-time customer signals and act across channels instead of waiting for someone to run a report. Inside that system, GIA (the Data Analysis Agent) is built specifically for this kind of modeling: GIA continuously pulls behavioral and transaction data, calculates CLV per segment and cohort automatically, and surfaces it in live dashboards instead of a formula that goes stale the moment new orders come in.

Where GIA fits with Questera's other agents:

• SEGA (Segmentation Agent) builds the behavior-based segments GIA calculates CLV against, so you get lifetime value by customer type — not one blended average.
• ELMA (Email Lifecycle Marketing Agent) and OMNIA (Omni Channel Journey Agent) act on what GIA finds — for example, triggering a retention journey for a segment whose predicted CLV is dropping.
• SARA (Smart Ads Agent) uses CLV signals to guide retargeting spend toward the customers most likely to be worth acquiring again.

The result is CLV that updates as customer behavior changes, broken down by the segments that actually matter, without anyone rebuilding a spreadsheet model every quarter.

See how GIA calculates and visualizes CLV automatically — Get Started Today.

Got an idea? Build it now!
Just start with a simple Prompt

Get Started Today

Frequently Asked Questions

What is the customer lifetime value formula?
The basic formula is CLV = Average Order Value × Purchase Frequency × Customer Lifespan. For a more accurate, profit-focused number, multiply the result by your gross margin percentage. Subscription businesses typically use Average Revenue Per Account × Gross Margin ÷ Churn Rate instead, since they don't have discrete "orders."

What's the difference between CLV and CAC?
CLV measures how much revenue or profit a customer generates over their entire relationship with your business, while CAC (customer acquisition cost) measures how much it costs to acquire that customer in the first place. Comparing the two — usually as a CLV:CAC ratio — tells you whether your acquisition spend is actually profitable, not just whether it's generating customers.

How does churn affect the customer lifetime value formula?
Churn directly determines customer lifespan, one of the three core inputs to CLV: a common estimate is Customer Lifespan = 1 ÷ Churn Rate. Higher churn shortens the expected lifespan and lowers CLV, which is why even small improvements in retention can produce outsized gains in lifetime value.

How can I calculate CLV without doing it manually in a spreadsheet?
Automated platforms like Questera's GIA (Data Analysis Agent) pull transaction and behavioral data directly from your systems and calculate CLV continuously, broken out by segment or cohort, without manual formula maintenance. This avoids the stale, blended, and error-prone CLV numbers that come from quarterly spreadsheet updates.