AI-Powered CLV Calculator

CLV = Net AOV × Observed Frequency × Margin × Lifetime

📊

Drop your Shopify CSV here

Export a Shopify report with the columns listed below

Choose File

Required columns in your CSV

Customer email

Identifies each customer

Month (or Year / Week / Day)

Time dimension for frequency and cohorts

Orders

Number of orders per period

Net sales

Revenue after discounts and returns

Recommended columns

Gross sales

Revenue before discounts

Discounts

Discount amounts applied

Average order value

AOV per period

Quantity returned

Items returned per period

Recommended date ranges

All time – Best for lifetime and cohort analysis

Last 12 months – Best for annual CLV

Last 3 years – Good balance of depth and recency

Last 90 days – Quick snapshot

New File

Overview RFM Segments Cohorts Top Customers Settings

I started building websites in 1998 as a freelancer, but in 2000, I jumped into ecommerce using OS Commerce… THE platform at the time.

Back then, almost nobody in ecommerce talked about Customer Lifetime Value.

The internet was still young, ecommerce was still rudimentary, and most store owners were just trying to figure out how to ship a package without losing money.

But a Spaniard agency I worked with at the time asked me a question that changed everything for me… “How much is a customer actually worth for us?”

I had no answer.

So I opened Microsoft Excel and started playing with numbers.
That was the very first version of my CLV Calculator.
A simple spreadsheet, a few formulas, and a lot of guessing.

26 years later… I am still calculating CLV. The formula has evolved. 

The tools have evolved… and now, with the help of AI, I built the most powerful version yet.

But here is the important part: your data never leaves your browser. 

Everything happens on your side.
No uploads.
No servers.
No risk.

Let me show you.

AI-Powered CLV Calculator and CLV Formula

These days… AI is exploding. Everyone started uploading their customer databases to ChatGPT and Claude and Gemini and a dozen other tools, without thinking about privacy or ethics.

That is not the best… everybody is uploading personal information under privacy protection policies, into AIs platforms.

Think about it… it’s not good AT ALL!

So I built this… an AI-Powered CLV Calculator that runs entirely in your browser.

No uploads.

No data leaks.

No ethical compromises.

Just your Shopify CSV and the formula I have been polishing since 2000.

What is CLV, really?

Customer Lifetime Value is the total revenue (or profit) you expect to earn from one customer during the entire time they buy from you.

It is not how much they spent last month. It is not how much they will spend next year. It is the whole picture, across their entire relationship with your brand.

If your CLV is $169, that means the average customer who walks into your store will eventually leave $169 in your pocket before they disappear.

Why does that matter?

Because if you do not know your CLV, you do not know how much you can spend on ads to acquire a new customer.

You do not know if your retention is working.

You do not know if your discounts are killing you.

CLV is the most important number in ecommerce… and almost nobody calculates it correctly.

The best CLV formula in 2026

After 27 years of trial and error, this is the formula I trust:

Looks simple, right? It is.

The complexity is not in the formula… it is in how each variable is calculated.

Let me break each one down with real numbers, using a hypothetical skincare ecommerce as an example.

Imagine a skincare brand selling moisturizers, serums, and cleansers at an average price of $40 per product.

They have been running on Shopify for 4 years.

About 12,000 customers in their database.

Here is how each variable works.

Variable 1: Net AOV (Average Order Value)

Net AOV is the real revenue you keep per order, after discounts and returns are taken out.

In my skincare example, let’s say the customers placed 30,000 orders total. The Gross Sales were $1,500,000. The Discounts given were $150,000. The Returns were $50,000.

Net Revenue = $1,500,000 − $150,000 − $50,000 = $1,300,000

Net AOV = $1,300,000 / 30,000 = $43.33

This is much more accurate than using “Gross AOV” or “Average Order Value” as Shopify shows it. Because a customer who pays $50 and returns half of it… did not actually pay $50.

Shopify, thankfully, gives you the “Net sales” column in the Sales by Customer report.
So the calculator uses that directly when available.
No assumptions.
No guesses.

Variable 2: Observed Frequency

This is where my formula breaks from the classic one.

The old formula uses “Frequency” as a generic number, like “customers buy 2 times per year on average.” 

That number is often pulled out of thin air.

Observed Frequency is calculated per customer, using their real purchase history:

With a minimum of 1 year to avoid inflating new customers.

Why the minimum?
Because if a customer bought twice in their first week with you, the math would say they buy 104 times per year (52 weeks × 2). That is obviously not realistic.

So if their account is less than 1 year old, we use 1 year as the floor.

Example from the skincare brand:

• Customer A: 8 orders, first purchase 4 years ago → 8 / 4 = 2 orders per year
• Customer B: 3 orders, first purchase 6 months ago → 3 / 1 (minimum) = 3 orders per year
• Customer C: 1 order, first purchase 3 years ago → 1 / 3 = 0.33 orders per year

Each customer gets their own honest frequency number, based on their actual behavior. No averages pulled from a hat.

Variable 3: Margin

This is your profit margin as a decimal.

If your products cost you $20 to produce and you sell them for $50, your margin is approximately 60%, or 0.60 as a decimal.

Most skincare brands run between 50% and 70% margin.

Apparel runs between 40% and 60%. Electronics, much lower.

If you do not know your margin… use 1. That means your CLV will represent revenue, not profit. Still useful, but not the same thing.

In the calculator, you set this manually in Settings. Shopify cannot give you this number because it does not know your COGS (Cost Of Goods Sold).

Variable 4: Customer Lifetime

This is the most interesting one… and the one I struggled with the most for years.

Customer Lifetime is how many years your average customer stays active with your brand before disappearing.

The classic approach is to guess. “Our customers stay with us for about 2 years.” Maybe. Maybe not. Probably wrong.

My approach is to calculate it from your data:

Which means we first need to calculate Churn Rate.

The Churn Rate calculation

Churn Rate is the percentage of customers who had a chance to come back… and did not.

Here is how the calculator does it:

The “12 months” window is important. Because a customer who bought yesterday cannot be considered “churned” yet. They have not had time to come back. So we only count customers who had at least 12 months to return.

Back to the skincare brand. The export covers 4 years (2022-2026). The calculator finds:

• 7,000 eligible customers (their first purchase was before May 2025)
• Of those, 5,250 did not buy anything in the last 12 months (between May 2025 and May 2026)

Churn Rate = 5,250 / 7,000 = 75%

Customer Lifetime = 1 / 0.75 = 1.33 years

That means the average customer stays active with this skincare brand for about 1 year and 4 months before disappearing.

Honest. Calculated. Defensible.

Putting it all together

Now we can calculate the CLV for the skincare brand:

$43.33 × 2 × 0.60 × 1.33CLV = $69.16

The average customer at this skincare brand is worth $69.16 in profit over their entire relationship with the store.

If their CAC (Customer Acquisition Cost) is $25, the CLV:CAC ratio is 2.77x. That is healthy but not great. The industry benchmark is 3x or higher.

If their CAC is $40, the ratio drops to 1.73x. That is a problem. They are spending too much to acquire customers who are not worth enough.

That is the power of CLV. It turns gut feeling into math.

How my CLV Calculator works in 2026

Let me walk you through what the calculator actually does once you upload your CSV.

Step 1: It reads your Shopify export

You go to Analytics → Reports in Shopify and create a custom report with these columns:

• Customer email (required)
• Month (or Year, Week, Day, Quarter)
• Orders (required)
• Net sales (highly recommended)
• Gross sales (recommended)
• Discounts (recommended)
• Average order value (recommended)
• Quantity returned (optional)

Export the report as CSV. That is your input file.

Set the date range to All time for the most accurate CLV. The calculator can handle Last 12 months, Last 3 years, or any range you pick, but the longer the history, the better the calculation.

Step 2: It detects your format automatically

The calculator recognizes two Shopify formats:

• Sales by Customer (aggregated, the one I just described)
• Orders Export (order-by-order, with exact timestamps)

It picks the right parser for your file. You do not need to choose anything.

Step 3: It calculates everything in your browser

Here is the part that matters… your CSV never leaves your computer.

This is SUPER IMPORTANT these days!

The calculator runs as a static HTML file with vanilla JavaScript. 

It uses PapaParse to read the CSV and Chart.js to draw the charts. Both libraries are loaded from a public CDN, with integrity hashes for security.

But your data? Stays in your browser memory.
When you close the tab, it is gone.

No server.
No database.
No upload.
No risk.

This is the part I am most proud of. Because in 2026, with everyone uploading sensitive data to AI tools without thinking, this is the responsible way to build a CLV Calculator.

Step 4: You get a full dashboard

Once you upload your CSV, the calculator shows you:

• CLV: The headline number
• Customer Lifetime: Auto-calculated from churn
• Churn Rate: Calculated from your real customer behavior
• CLV: CAC Ratio: If you enter your CAC in Settings
• Net AOV: Revenue per order, after discounts and returns
• First Order Concentration: How much of your CLV comes from the first order
• Observed Frequency: Purchases per customer per year
• Repeat Rate: Percentage of customers who bought more than once
• Discount Intensity: How much you discount as a % of pre-discount revenue
• Returned Items: Total items returned across all customers
• CLV Distribution chart: How your customers spread across value ranges
• RFM Segments: 11 customer segments (Champions, Loyal, At Risk, Lost, etc.)
• Cohort Survival: Retention curves by acquisition month
• Top Customers: The most valuable customers in your store
• CSV exports: Download any segment or the top customers as a CSV

All of that, from a single Shopify export.

The 11 RFM Segments

RFM stands for Recency, Frequency, Monetary. 

It is one of the oldest customer segmentation models in marketing, and still one of the best.

The calculator scores each customer from 1 to 5 on each dimension, then combines the scores to assign them to one of 11 segments:

Each segment can be exported to CSV with one click. So if you want to send a re-engagement email to your “At Risk” customers… you have the list in 5 seconds.

Cohort Survival Analysis

Cohorts are groups of customers acquired in the same month.

The calculator shows you, for each cohort:

• Repeat Rate: What percentage came back at least once
• Retained 3 months: Survived 90 days
• Retained 6 months: Survived 180 days
• Retained 12 months: Survived 365 days

If your acquisition quality is dropping over time, cohort survival will show it clearly. A healthy ecommerce shows steady or improving cohorts. A struggling one shows declining cohorts.

This is a metric most store owners never look at. They should.

Why this calculator is different

Every CLV calculator I have seen online has one of three problems:

1. It asks you to manually enter your AOV, Frequency, Margin, and Customer Lifetime.
   That defeats the purpose. If I have to calculate everything myself, what is the calculator for?
    
2. It uses outdated formulas.
   Specifically, the “Frequency × Lifetime” trap that inflates CLV for short-term repeat buyers. A customer who buys 3 times in their first month gets projected to 36 purchases per year. Wrong.
    
3. It asks you to upload your data to their server.
   Which means your customer database… your most valuable asset… is now sitting on someone else’s hard drive. Serious mistake!

My calculator solves all three:

• It auto-calculates everything from your Shopify CSV.
  You just upload the file.
   
• It uses the formula I refined for 27 years, with safeguards against the classic frequency trap.
   
• It runs 100% in your browser.
  Your data never leaves your machine.

How to interpret the results

Once you get your dashboard, here are the conversations I have with my clients:

If your CLV is high but Repeat Rate is low… your top customers are carrying you.
Lose 2 or 3 of them and you are in trouble.
Diversify.

If your Churn Rate is above 80%… your retention is bleeding.
Focus on email marketing, loyalty programs, post-purchase flows.

If your First Order Concentration is above 70%… more than two-thirds of your customer value comes from the very first purchase.
You are essentially transactional.
Retention is your biggest opportunity.

If your Discount Intensity is above 25%… you are discount-dependent.
Your “real” CLV is lower than it looks because you are buying every sale.

If your CLV:CAC ratio is below 1.5x… you are losing money on customer acquisition.
Pause your ads, fix the funnel, or you will go broke.

If your CLV:CAC ratio is above 5x… you are leaving money on the table.
You can spend more on ads and still be profitable.

The dashboard tells you all of this in seconds. 

What I just spent 27 years learning… you get for free.

Every version was a step forward. Every version was built because the previous one was not good enough.

This 2026 version is the most powerful one I have ever built… and it is yours, for free.

Frequently Asked Questions

Is my data safe?

Yes. 100000000000% safe.
The calculator runs entirely in your browser.
Your CSV is read by JavaScript and processed in your computer’s memory.
Nothing is uploaded anywhere.
When you close the tab, the data is gone.

Does it work with non-Shopify stores?

The current version is built specifically for Shopify exports (Sales by Customer and Orders Export).
If you are on WooCommerce, BigCommerce, or Magento, you can still use it if you export your data in a compatible format.
I am planning to add direct support for other platforms in future versions.

What if I do not know my CAC or Margin?

Margin defaults to 1, which means your CLV will represent revenue instead of profit. CAC is optional. If you do not enter it, you just will not see the CLV:CAC ratio. Everything else still works.

How long should my date range be?

The longer, the better. All time is ideal.
The calculator needs at least 12 months of data to calculate Churn Rate and Customer Lifetime accurately.
If your export is shorter than 12 months, Customer Lifetime defaults to 1 year and you will see a notice.

Can I export the segments?

Yes. Each RFM segment has an “Export CSV” button. So does the Top Customers tab.
You can export Top 20, Top 50, or Top 100 customers with one click.

Will you update it again?

100% sure. Every couple of years/months I rebuild this tool from scratch with what I learned.
The next big jump I am exploring is a probabilistic model called BG/NBD (the same model Amazon and Netflix use).
But that is for a future version.
The current one is solid for 99% of Shopify brands.

One last thing

If you have been calculating CLV with a spreadsheet, a guess, or a “Frequency × Lifetime × AOV” napkin formula… you are leaving money on the table.

CLV is not a vanity metric. It is the foundation of every smart decision you will make in ecommerce. How much to spend on ads. Which customers to keep. Which products to push. When to discount. When to walk away.

In my experience… brands that know their real CLV make better decisions. Period.

This calculator is the most honest version of the formula I can build right now. After 27 years. With AI helping me make it faster and cleaner than ever before.

Use it. Share it. Tell me what you find.

And if you want me to look at your numbers with you… you know where to find me.

A note about your data and how this calculator works

This CLV Calculator runs 100% in your web browser. When you upload your Shopify CSV file, the file is read and processed locally on your own device. We do not see, store, transmit, or have access to your customer data at any moment. Nothing is uploaded to FJ Solutions servers, to Klaviyo, or to any third party. When you close the browser tab, the data is gone from memory.
The only personal information we collect through this resource is your name and email, which you provide voluntarily when requesting the calculator file. We use that information to send you the calculator and occasional ecommerce insights. You can unsubscribe at any time. For full details, see our Privacy Policy at fjsolutions.com/privacy-policy.
You are responsible for the data you process with this calculator. The CSV you upload may contain personal information of your customers, which is subject to your own privacy policy, your terms of service, and the data protection laws that apply to your business (such as GDPR, CCPA, or others). FJ Solutions is not a data processor or controller of your customer data when you use this tool.
The calculator is provided “as is” for informational and analytical purposes. While we have polished this formula over 27 years and built the tool with care, the results are estimates based on the data you provide. We do not guarantee specific business outcomes from using the calculator. For complete terms of use, see fjsolutions.com/terms-conditions.
If you have questions about this tool, the formula, or how your data is handled, contact us at fjsolutions.com/contact-us.