Ecommerce Customer Lifetime Value Calculator: The Formula, Worked Example, and LTV:CAC Framework

Most store owners obsess over the cost of getting a new customer and barely think about what that customer is actually worth. That single blind spot is why so many profitable-looking stores quietly bleed cash. An ecommerce customer lifetime value calculator flips the script: instead of guessing how much you can spend on ads, you calculate exactly how much each customer earns you over their entire relationship with your brand—then you back into a sustainable acquisition budget from there.

This guide gives you a working framework, not just theory. You'll get the core LTV formula, a margin-adjusted version, a step-by-step worked example with copy-ready tables, the famous LTV:CAC ratio, and concrete tactics to push your numbers up. By the end, you'll be able to build your own ecommerce customer lifetime value calculator in a spreadsheet and know what the output actually means.

What Customer Lifetime Value Actually Measures

Customer lifetime value (CLV, often shortened to LTV) is the total amount of money a customer spends with your store across the entire time they remain a customer. It's not one order. It's every order, from their first purchase to their last.

Think of it this way: a customer who buys a $40 phone case once is worth far less than a customer who comes back four times a year for three years. Same first order, wildly different value. LTV is the metric that captures that difference.

Why LTV Beats Single-Order Thinking

When you only look at the first order, every customer looks identical. When you look at lifetime value, your best customers separate from the pack. This changes everything about how you spend:

• You can outbid competitors on ads because you know the customer is worth more than one order.
• You stop over-rewarding one-time buyers and start investing in repeat purchasers.
• You forecast revenue based on the customers you already have, not just new ones you hope to acquire.

According to Shopify's breakdown of CLV, lifetime value is one of the clearest signals of long-term business health—because it rewards retention, not just reach.

Revenue LTV vs. Profit LTV

There are two flavors of LTV, and mixing them up will wreck your math. Revenue LTV is total spend. Profit LTV (also called margin-adjusted LTV) is total spend multiplied by your gross margin—the money you actually keep.

A customer who spends $720 with you over their lifetime at a 40% gross margin is only worth $288 in actual profit. When you compare LTV to acquisition cost, you almost always want profit LTV. We'll cover both below.

The Core Ecommerce Customer Lifetime Value Formula

Here's the formula that powers any ecommerce customer lifetime value calculator. Commit it to memory:

LTV = Average Order Value × Purchase Frequency × Customer Lifespan

That's the revenue version. The margin-adjusted version, which is the one most founders should use, adds one term:

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

Three inputs do the heavy lifting. Get these right and your calculator is accurate. Get them wrong and you're building on sand.

Breaking Down the Three Inputs

Average Order Value (AOV) is total revenue divided by total number of orders. If your store did $130,000 across 2,000 orders, your AOV is $65.

Purchase Frequency is total orders divided by total unique customers over the same period. If those 2,000 orders came from 800 customers in a year, your annual purchase frequency is 2.5.

Customer Lifespan is the average number of years a customer keeps buying. For most ecommerce brands this lands between 2 and 3 years. If you don't have years of data yet, start with a conservative estimate and refine it as cohorts mature.

Where People Get the Inputs Wrong

The most common error is calculating purchase frequency and lifespan over mismatched time windows. If your frequency is "per year," your lifespan must be "in years." Mixing a monthly frequency with a yearly lifespan inflates LTV by 12x and makes your whole calculator lie to you.

The second common error is using sitewide AOV when your customer segments behave very differently. If you sell both $15 accessories and $300 bundles, a blended AOV hides reality. Segmenting—covered in our Shopify customer segmentation strategy guide—gives you far more honest numbers.

Step-by-Step Worked Example (Copy This Table)

Let's build a full ecommerce customer lifetime value calculation from raw store data. Imagine a Shopify apparel store called Northbound. Here's their last 12 months of data.

Step 1: Gather Your Raw Numbers

Step 2: Calculate the Three Core Inputs

Step 3: Run Both LTV Versions

So a Northbound customer is worth $450 in revenue and $202.50 in actual profit over three years. That profit number is the one you'll use to set acquisition budgets in the next section.

Notice how much smaller the profit figure is. If Northbound had been planning ad spend against the $450 number, they'd have been spending nearly double what the business could actually support. Always run profit LTV before you set a CAC ceiling. For help nailing down that gross margin input, our Shopify profit margin calculator guide walks through COGS, fees, and shipping.

The LTV:CAC Ratio and the 3:1 Rule

Knowing LTV in isolation is interesting. Comparing it to your customer acquisition cost (CAC) is what makes it actionable. CAC is everything you spend to win a customer—ad spend, agency fees, discounts, affiliate payouts—divided by the number of new customers acquired.

What a Healthy Ratio Looks Like

The widely cited benchmark is 3:1: for every $1 you spend acquiring a customer, you want at least $3 in lifetime value back. As Eightx explains in its LTV:CAC guide, at a 3:1 ratio roughly one-third of revenue covers acquisition, one-third covers cost of goods and operations, and one-third becomes profit and growth.

Here's how to read your ratio:

That last row surprises people. A ratio that's too high often means you're leaving growth on the table—you could afford to acquire more customers and aren't.

Don't Forget Payback Period

The ratio tells you if a customer is profitable. Payback period tells you when. It's the number of months it takes to recover your CAC from a customer's gross profit. For most direct-to-consumer brands, a healthy payback period is 6 to 12 months, per Foundry CRO's benchmark data.

Why it matters: a $200 CAC with a 3-month payback is far healthier than a $50 CAC with a 12-month payback, because cash comes back faster and funds your next round of acquisition. Cash flow, not just the ratio, decides whether you can keep growing.

A Quick CAC Worked Example

Back to Northbound. Their profit LTV is $202.50. If their CAC is $65:

$202.50 ÷ $65 = 3.1:1 LTV:CAC ✅

That's right in the healthy zone. If CAC crept up to $100, the ratio would fall to ~2:1—a signal to either lower acquisition costs or raise LTV before scaling spend.

Simple vs. Predictive LTV: Which Should You Use?

The formula above is what analysts call historical or simple LTV. It looks backward at what customers have already done. It's perfect for getting started and for stores without years of data. But it has a limitation: it treats the past as a perfect predictor of the future.

When Simple LTV Is Enough

Use the simple formula when you're early-stage, when you need a fast directional number, or when you're setting a rough CAC ceiling. It's transparent, easy to audit, and good enough for most decisions in your first couple of years. Ninety percent of stores should start here.

When You Need Predictive LTV

Predictive LTV uses statistical models (often probabilistic models like BG/NBD, or machine learning) to forecast what a new customer will be worth based on early behavior signals. It shines when your customer base is large and varied, or when acquisition channels produce very different cohorts.

This is where cohort analysis matters. A customer acquired during a Black Friday discount blitz often has lower lifetime value than one acquired through organic search, even if their first order looks identical. Predictive models catch that; a single blended historical number doesn't.

Tracking LTV by Cohort

A practical middle ground is cohort LTV: group customers by the month they first bought, then track their cumulative spend over time. After about 12 months of observed cohort data, you can project forward with real confidence instead of relying on a formula alone. Update your cohorts monthly so you spot shifts—like a recent cohort retaining worse than older ones—before they become expensive surprises. You'll find more reporting tactics across our analytics and data articles.

Concrete Tactics to Increase Customer Lifetime Value

Calculating LTV is step one. Growing it is where the money is. Because LTV is the product of three multiplied inputs, lifting any single input lifts the whole result. Here's where to focus.

Increase Purchase Frequency and Lifespan (Retention)

Retention is the highest-leverage LTV lever there is. Classic Bain & Company research found that a 5% increase in customer retention can boost profits by 25% to 95%—and a Harvard Business Review analysis reached similar conclusions about keeping the right customers. Small retention gains compound dramatically because they stretch lifespan and frequency at the same time.

Tactical moves that work:

• Post-purchase email and SMS flows that re-engage buyers at the right intervals.
• Replenishment reminders for consumables timed to run-out dates.
• Win-back campaigns for customers who've gone quiet.

Our deep dive on retention strategies that reduce churn covers the full playbook.

Raise Average Order Value

Every extra dollar in AOV flows straight through all three lifetime purchases. Proven levers include:

• Bundling complementary products at a slight discount.
• Free-shipping thresholds set just above your current AOV.
• Smart upsells and cross-sells at checkout and post-purchase.

Pricing structure feeds directly into AOV, and our guide to ecommerce pricing strategy for new stores shows how to set price points that lift order value without killing conversion.

Build Loyalty That Compounds

Loyalty programs nudge all three inputs at once: they pull customers back (frequency), keep them around longer (lifespan), and encourage bigger baskets to hit reward tiers (AOV). The best programs reward behavior you actually want—repeat purchases and referrals—rather than just handing out blanket discounts. See our walkthrough on building a loyalty program for ecommerce for structures that pay for themselves.

Common Mistakes When Calculating LTV

Even with the right formula, it's easy to produce a number that misleads you. Watch for these.

Mismatched Time Windows

As noted earlier, this is the number-one error. If purchase frequency is measured per year, customer lifespan must be in years. Mixing monthly and yearly units silently multiplies your LTV by 12. Always state the time unit explicitly in your spreadsheet.

Using Revenue LTV for Budget Decisions

Revenue LTV looks great and tempts you to overspend on acquisition. Always convert to profit LTV before setting a CAC ceiling. The Northbound example dropped from $450 to $202.50 the moment we applied margin—a difference that decides whether your ad spend is sustainable or suicidal.

Ignoring Segmentation

A single blended LTV averages your $15 accessory buyers with your $300 bundle buyers, hiding the customers who actually drive your business. Calculate LTV by segment so you know which customers deserve more acquisition investment and which to stop over-rewarding.

Forgetting to Update

LTV is not a set-it-and-forget-it number. Acquisition channels shift, retention drifts, and costs change. Recalculate quarterly at minimum, and refresh cohort data monthly if you can.

Build Your Own Calculator: A Quick Checklist

You now have everything you need to build a working ecommerce customer lifetime value calculator in a spreadsheet. Here's the minimum it should contain:

Three output cells then do the work: Revenue LTV, Profit LTV, and LTV:CAC ratio. Add a payback-period cell and you've got a dashboard that tells you, at a glance, whether your acquisition engine is healthy.

Frequently Asked Questions

What is a good customer lifetime value for an ecommerce store?

There's no universal "good" number—it depends entirely on your margins and CAC. The better question is your LTV:CAC ratio, where roughly 3:1 is the healthy benchmark. A store with a $200 LTV and a $65 CAC is healthier than a store with a $1,000 LTV and a $500 CAC.

How do I calculate LTV without years of historical data?

Start with the simple formula using whatever data you have, and estimate customer lifespan conservatively (1 to 2 years is a safe early assumption). As cohorts mature past 12 months, replace estimates with observed retention data. A rough number you act on beats a perfect number you never calculate.

Should I use revenue LTV or profit LTV?

Use profit LTV (margin-adjusted) for any decision involving money you'll spend—especially acquisition budgets. Use revenue LTV only when you specifically want to understand top-line customer spend. When in doubt, default to profit LTV.

How often should I recalculate customer lifetime value?

Recalculate your headline LTV at least quarterly, and refresh cohort data monthly if your volume supports it. Acquisition channels, retention, and costs all shift over time, and a stale LTV leads to stale spending decisions.

What's the difference between LTV and CAC?

LTV is what a customer is worth to you over their lifetime. CAC is what it costs to acquire them. LTV is the value coming in; CAC is the cost going out. The ratio between them tells you whether your growth is sustainable.

Get the LTV Calculator Spreadsheet

Customer lifetime value is the metric that turns guesswork into a budget. Once you know what a customer is truly worth—after margin—you can set acquisition spend with confidence, prioritize retention, and stop overpaying for one-time buyers. The ecommerce customer lifetime value calculator framework in this guide is the foundation; the only thing left is to plug in your numbers.

Want the plug-and-play version? Join the Let's Talk Shop newsletter and we'll send you the ready-to-use LTV calculator spreadsheet—pre-built with the formulas, margin adjustment, LTV:CAC ratio, and payback period from this article, so you can drop in your store's data and get answers in minutes.

What's your current LTV:CAC ratio—and is it closer to 3:1 or somewhere you'd rather not admit?

About Talk Shop

The Talk Shop team — insights from our community of Shopify developers, merchants, and experts.