How to Calculate Customer Lifetime Value in Shopify (3 Methods)
You know some customers are worth more than others. But do you know how much more? And do you know which acquisition channels, products, or campaigns bring in the high-value ones?
Customer lifetime value (CLV) is the single most important metric most Shopify merchants aren't tracking. It tells you how much a customer is worth over their entire relationship with your store — not just their first order. And once you know it, every decision about ad spend, discounts, retention, and inventory gets sharper.
Here's how to calculate it — from a simple formula you can do in your head, to methods that use your real Shopify data.
What Is Customer Lifetime Value?
Customer lifetime value is the total revenue (or profit) you can expect from a single customer over the entire time they buy from you.
A customer who orders once for £40 has a very different value than one who orders four times a year for three years. CLV captures that difference.
Why it matters for Shopify merchants:
- Ad spend decisions — if your CLV is £120, you can afford to spend more than £40 to acquire a customer. If you're only looking at first-order revenue, you'll underspend and lose to competitors who know their numbers.
- Retention vs. acquisition — CLV tells you whether to invest in getting new customers or keeping existing ones.
- Discount strategy — offering 20% off to win a customer with a £200 CLV is a good trade. Offering it to a one-time buyer isn't.
- Product strategy — some products attract high-CLV customers. Others attract one-and-done bargain hunters. You want to know which is which.
Method 1: The Simple Formula
The quickest way to estimate CLV uses three numbers you can pull from your Shopify admin:
CLV = Average Order Value × Purchase Frequency × Customer Lifespan
Here's how to find each:
Average Order Value (AOV) Go to Shopify Analytics → Reports → Average order value. Or divide total revenue by total orders for a period.
Example: £18,000 revenue ÷ 400 orders = £45 AOV
Purchase Frequency Divide total orders by total unique customers over the same period.
Example: 400 orders ÷ 280 customers = 1.43 orders per customer
Customer Lifespan This is the tricky one. For newer stores, estimate how long a customer stays active. For established stores, look at the gap between a customer's first and last order.
Example: Average customer stays active for 2 years
CLV = £45 × 1.43 × 2 = £128.70
This tells you a typical customer is worth about £129 over their lifetime. If you're spending £15 to acquire them via Facebook Ads, that's an 8.6x return — far more impressive than the 3x return you'd see looking at first-order ROAS alone.
Limitations of the Simple Formula
- It uses averages, which hide the spread between your best and worst customers
- It doesn't account for refunds, discounts, or cost of goods
- Customer lifespan is hard to estimate for newer stores
- It treats all customers the same — but a customer who found you via Google Search behaves very differently from one who clicked a TikTok ad
Method 2: Cohort Analysis in Shopify Reports
A more accurate approach is to track groups of customers over time. Shopify's built-in cohort reports let you see how spending develops after a customer's first purchase.
How to access it:
- Go to Analytics → Reports in your Shopify admin
- Look for Returning customer rate and Customer cohort analysis (available on Shopify and Advanced plans)
- Group by first-purchase month
What to look for:
- Month 1 → Month 3 retention: What percentage of customers come back within 90 days? If it's under 20%, you have a retention problem.
- Revenue per cohort over time: Does spending increase, stay flat, or drop off? Increasing means your product drives loyalty. Dropping means you're a one-purchase store.
- Compare cohorts by acquisition source: Did your Black Friday customers have the same 6-month value as your organic customers? Usually not.
Cohort analysis is powerful but manual. You're looking at charts and trying to draw conclusions yourself. And Shopify's built-in reports won't cross-reference with your Klaviyo, GA4, or ad platform data — so you're only seeing part of the picture.
Method 3: Ask AI to Calculate It From Your Real Data
The fastest and most flexible way to calculate CLV is to ask an AI tool that's connected to your actual Shopify data. Instead of pulling numbers manually and plugging them into formulas, you ask a question and get an answer.
With Ask AI, you can connect your Shopify store and then ask questions like:
"What's the average customer lifetime value for customers acquired in Q1?"
The AI calculates it from your real order history — every customer, every order, every refund. No averages of averages. No spreadsheets.
But the real power is in the follow-up questions:
"Which acquisition channel has the highest CLV?"
"What products do my highest-CLV customers buy first?"
"Compare CLV for customers who used a discount code vs. those who didn't."
"What's the CLV difference between customers who buy product X vs. product Y?"
These are questions that would take hours to answer in a spreadsheet. They take seconds when AI has access to your order data.
And if you've connected Klaviyo, you can go further:
"Do customers from my welcome flow have a higher CLV than those from paid ads?"
"What's the CLV of customers who opened more than 5 emails in their first month?"
This is where CLV stops being a vanity metric and starts driving real decisions — because you can finally see what creates high-value customers, not just what their average order looks like.
What to Do Once You Know Your CLV
Knowing your CLV is only useful if it changes how you operate. Here are the four highest-impact actions:
1. Set Your Customer Acquisition Cost (CAC) Ceiling
If your CLV is £130, you know you can profitably spend up to £130 to acquire a customer (though you'd want margin — a common target is CLV:CAC ratio of 3:1, meaning you'd aim to spend under £43 per acquisition).
Most merchants set ad budgets based on first-order ROAS. That's why they underspend on channels that drive repeat buyers (email, organic search) and overspend on channels that drive one-time buyers (impulse social ads).
2. Identify Your VIP Segment
Your top 10% of customers likely account for 40–60% of your revenue. Once you know who they are, you can:
- Create a VIP loyalty tier or early-access programme
- Exclude them from blanket discount campaigns (they'll buy at full price)
- Study what they have in common — acquisition source, first product, geography
3. Fix Your Retention Problem (If You Have One)
If your average customer only orders once, your CLV is basically your AOV. That's a sign your product, post-purchase experience, or email marketing isn't doing enough to bring people back.
Check your Klaviyo flow performance — is your post-purchase sequence actually driving second orders? If not, that's the highest-leverage thing to fix.
4. Rethink Your Discount Strategy
Discounts that acquire low-CLV customers are a net loss. If you can see that customers who used a 30% discount code have half the CLV of full-price customers, you might decide to stop running those promotions entirely — even if they drive short-term revenue.
CLV Benchmarks by Industry
How does your CLV compare? Here are rough benchmarks for e-commerce:
| Category | Typical CLV Range | Typical Purchase Frequency | |----------|------------------|--------------------------| | Fashion & Apparel | £80–£250 | 2–4 orders/year | | Health & Beauty | £100–£400 | 3–6 orders/year | | Food & Beverage | £50–£200 | 4–12 orders/year | | Home & Garden | £60–£180 | 1–2 orders/year | | Pet Supplies | £120–£350 | 3–6 orders/year | | Supplements | £150–£500 | 4–8 orders/year |
If your CLV is well below these ranges, it usually means either your repeat purchase rate is low (retention problem) or your AOV is low (pricing or bundling problem). Both are fixable — but only once you know the number.
FAQ
What's the difference between CLV and LTV?
They're the same thing. CLV (Customer Lifetime Value) and LTV (Lifetime Value) are used interchangeably. Some people use CLTV as well. They all refer to the total expected revenue from a customer over their relationship with your business.
Can I calculate CLV if my store is new?
You can estimate it using the simple formula, but your numbers will be less reliable with under 6 months of data. Focus on AOV and repeat purchase rate first — those are the building blocks of CLV, and they're meaningful even with a few months of orders.
Should I calculate CLV on revenue or profit?
Revenue-based CLV is simpler and more common. Profit-based CLV (subtracting COGS, shipping, and returns) is more accurate but requires more data. Start with revenue, and move to profit-based once you have your margins tracked — tools like Xero connected to AI can help with this.
How often should I recalculate CLV?
Monthly is ideal for most stores. Quarterly at minimum. Your CLV changes as you add products, adjust pricing, run campaigns, and improve retention. If you're using an AI tool connected to your data, you don't need to recalculate manually — just ask the question again and you'll get the latest number.
What's a good CLV:CAC ratio?
A 3:1 ratio is the commonly cited target — meaning your CLV should be at least three times your customer acquisition cost. Below 1:1 means you're losing money on every customer. Above 5:1 might mean you're underinvesting in growth and could afford to acquire more aggressively.