How to Calculate Customer Lifetime Value (CLV) for Ecommerce
Customer lifetime value tells you how much a customer is worth over the whole relationship — the number that decides how much you can afford to spend acquiring one. Here's the formula, a worked example, and the version that's actually true.
Most stores optimize the first sale. The ones that win optimize the lifetime — and that starts with knowing how to calculate CLV correctly.
Key Takeaways
- CLV is the total profit a customer generates over the whole relationship — it sets the ceiling on what you can spend to acquire one.
- Calculate it as AOV x purchase frequency x lifespan, then multiply by gross margin to get the true, margin-based number.
- Judge growth with the CLV-to-CAC ratio; roughly 3:1 is healthy, below 1:1 means you lose money on every customer.
- Always use margin, not revenue, and keep CLV live and segmented instead of a one-off spreadsheet.
What customer lifetime value (CLV) means
Customer lifetime value (CLV, sometimes LTV) is the total profit you expect from a customer across the entire time they buy from you — not just their first order. It reframes a customer from a one-off transaction into an asset with a value you can measure, grow, and compare against what it costs to acquire them.
Why CLV matters
CLV sets the ceiling on acquisition spend. If a customer is worth 180 dollars over their lifetime, paying 60 dollars to acquire one is a strong investment; paying 200 dollars is slow bankruptcy. Without CLV, every marketing decision is a guess.
The CLV formula, with a worked example
The practical ecommerce formula has three inputs: average order value, purchase frequency, and customer lifespan. Multiply them to get lifetime revenue, then apply your margin to get lifetime profit.
Worked example
If your average order value is 60 dollars, a customer buys 3 times a year, and the average customer stays for 2 years, lifetime revenue is 60 x 3 x 2 = 360 dollars. At a 50 percent gross margin, lifetime profit (margin-based CLV) is 180 dollars. That 180 dollars — not the 360 dollars — is what you can spend against.
- Average order value (AOV): total revenue divided by number of orders.
- Purchase frequency: average orders per customer in a period.
- Customer lifespan: how long, on average, a customer keeps buying.
- Lifetime revenue: AOV x frequency x lifespan.
- Margin-based CLV: lifetime revenue x gross margin percent.
CLV vs CAC: the ratio that decides growth
CLV only becomes a decision tool when you put it next to customer acquisition cost (CAC) — what you spend on marketing and sales to win one customer. The CLV-to-CAC ratio is the single clearest read on whether your growth is healthy.
A widely used benchmark is roughly 3:1 — for every dollar spent acquiring a customer, you earn about three back over their lifetime. Below 1:1 you lose money on every customer; far above 3:1 you may be underinvesting in growth. Tracking this ratio is core to honest ecommerce profit analytics.
Margin-based CLV: the number that's actually true
Most CLV calculations you find online use revenue, which overstates the number — sometimes by double. Spending against revenue-based CLV is how stores convince themselves an unprofitable acquisition channel is fine. Always run CLV on margin, after cost of goods, fees, and expected returns.
This is the same discipline that makes pricing and forecasting trustworthy: decisions are only as honest as the margin underneath them. If you have built a Shopify profit and loss view, you already have the gross margin number CLV needs.
Keep CLV live, not a one-time spreadsheet
CLV calculated once in a spreadsheet is stale within a quarter — AOV, frequency, and retention all move. The useful version updates continuously from your live order history, segmented so you can see which customers, products, and channels produce the most valuable buyers.
That live, segmented view is what an executive dashboard and an AI CFO for Shopify provide — turning CLV from a static estimate into an operating metric. And because lifetime value is created after the first sale, it ties directly into ecommerce retention marketing, where the real growth in CLV happens.
Let the AI analyst handle it for you
AI CEO does the analysis for you — reading every order, product, and customer to tell you what's working, what's slipping, and what to do next in plain English.
- Turns raw Shopify data into clear answers and a ranked list of actions, not just charts.
- Tracks revenue, margin, and customer trends and alerts you the moment something shifts.
- Explains the 'so what' behind every number, so you decide in minutes instead of hours.
Frequently Asked Questions
What is the formula for customer lifetime value?
The practical ecommerce formula is: average order value x purchase frequency x customer lifespan = lifetime revenue, then multiply by your gross margin percent to get margin-based CLV. For example, a 60 dollar AOV, 3 orders a year, a 2-year lifespan, and a 50 percent margin gives a CLV of 180 dollars.
Should CLV be based on revenue or profit?
Profit. Revenue-based CLV overstates a customer's worth — often by roughly double — which leads stores to overspend on acquisition. Calculate CLV on margin, after cost of goods, payment and shipping fees, and expected returns, so the number reflects money you actually keep.
What is a good CLV-to-CAC ratio?
A common benchmark is about 3:1 — you earn roughly three dollars in lifetime value for every dollar spent acquiring a customer. Below 1:1 you lose money on each customer; well above 3:1 can signal you are underinvesting in growth. The right target depends on margins and growth stage.
How can I track customer lifetime value automatically?
Connect your order history to a profit analytics or AI CFO layer that recalculates CLV continuously and segments it by customer, product, and channel. That keeps the number current as AOV, frequency, and retention shift, instead of relying on a spreadsheet that goes stale within a quarter.
Keep Reading
Ecommerce Profit Analytics
Find your store's true margin — the basis for honest CLV.
Ecommerce Retention Marketing
Where lifetime value is actually grown, after the first sale.
Ecommerce Profit Analytics
True margin by product, customer, and channel.
Executive Dashboard
Live CLV, CAC, and KPIs across the business.
Put Your Store on Autopilot
AI CEO runs marketing, operations, and finance for your Shopify store — from the same live data, with you in control.