How to Calculate LTV for Your Ecommerce Brand (With the Actual Formula)
by Om Rathod
|
8 min read
Aug 24, 2026
Why Most Ecommerce Brands Get LTV Wrong
Ask a founder what their LTV is and you'll usually get a number fast. Ask them which formula produced it, and the confidence drops off a cliff.
That's the actual problem. Most brands pull an LTV figure straight from a Shopify app or an ad platform dashboard, without knowing if it's revenue-based or profit-based, historical or predictive, blended across every channel or specific to one. The number gets treated as gospel anyway, and it ends up driving decisions it was never built to support.
This matters because LTV, not AOV and not ROAS in isolation, is what tells you how much you can actually afford to spend acquiring a customer. A brand with a $40 AOV and a $150 LTV can outspend a competitor with a $60 AOV and a $90 LTV, every time. If you don't know how to calculate LTV for your ecommerce brand correctly, you're setting CAC targets based on a guess.
Here's what we're covering: the actual formula (revenue and profit versions), a worked example with real numbers, and the specific places brands screw up the math without realizing it.
What LTV Actually Means for an Ecommerce Business
Customer lifetime value is the total revenue, or profit, a customer generates over the entire time they buy from you. Not their first order. Not their first year. The whole relationship.
There are two flavors worth separating. Historical LTV looks backward: what did this cohort of customers actually spend, based on data you already have? Predictive LTV looks forward: based on current behavior, what will a new customer likely spend over the next 12, 24, or 36 months? Historical LTV is easier to calculate and harder to argue with. Predictive LTV is more useful for planning, but only as good as the model behind it.
Here's the part most brands skip: LTV isn't one number for your whole business. A customer acquired through a Meta prospecting campaign in Q1 behaves differently than one who came from organic search in Q3. LTV needs to be tied to a specific cohort, a specific acquisition channel, and a specific time window. A single blended LTV sitting on a dashboard is a rounding error dressed up as an insight.
The Basic LTV Formula (and What Each Input Means)
The core formula is simple:
LTV = Average Order Value x Purchase Frequency x Customer Lifespan
Each input is its own small calculation:
Average Order Value (AOV)
Total revenue over a period divided by number of orders in that period
Example: $500,000 in revenue / 7,700 orders = $65 AOV
Purchase Frequency
Number of orders per customer per year
Take total orders in a year divided by total unique customers in that year
Customer Lifespan
The average number of years a customer keeps buying before they churn
Usually estimated from historical repeat-purchase data, or from 1 / churn rate if you're tracking churn monthly or annually
That gives you revenue-based LTV. But revenue isn't what pays for your ad spend, margin is. So the more useful version for spend decisions is:
LTV = (AOV x Purchase Frequency x Gross Margin %) x Customer Lifespan
Gross margin strips out cost of goods, so what's left is the actual profit a customer contributes. A brand with fat margins can justify a much higher CAC than a brand with thin ones, even if their revenue LTV numbers look identical. If you're comparing your LTV to your CAC and skipping the margin adjustment, you're comparing the wrong two things.
Step-by-Step: Calculating LTV With Real Numbers
Let's run this with a hypothetical DTC brand: $65 AOV, 3.2 orders per customer per year, 2.5 year average customer lifespan.
Revenue-based LTV: $65 x 3.2 x 2.5 = $520
That's the total revenue this brand can expect from an average customer over their full relationship with the brand. Looks solid at a glance.
Now adjust for a 60% gross margin, which is realistic for a lot of physical product DTC brands after COGS, shipping, and packaging.
Profit-based LTV: $65 x 3.2 x 0.60 = $124.80 in profit per year, x 2.5 years lifespan = $312
That's a $208 gap between the two numbers. If this brand is comparing a $250 target CAC against the $520 revenue LTV, spend looks comfortably sustainable, roughly 2x. Compare that same $250 CAC against the $312 profit LTV, and the margin of safety shrinks to about 1.25x. That's a very different risk profile, and it's the difference between a brand that scales spend confidently and one that scales itself into a cash crunch six months later.
This is the exact reason "just check your LTV to CAC ratio" advice is close to useless without specifying which LTV you're using.
Where LTV Calculations Break Down
A few patterns show up constantly once you start digging into how brands actually calculate this.
Mixing revenue LTV with profit-based CAC comparisons. This is the mistake from the example above, and it's the single biggest reason acquisition spend looks more sustainable on paper than it is in the bank account.
Using one blended LTV across every channel. A customer acquired via a branded search ad and a customer acquired via a cold TikTok video are not the same customer. Blending them into one LTV number hides which channels are actually worth scaling and which ones are quietly underwater.
Ignoring churn and repeat-rate drift. Lifespan assumptions calculated a year ago go stale fast, especially after a pricing change, a subscription launch, or a shift in the acquisition mix. A brand that leaned harder into paid social in the last two quarters will likely see lifespan compress, since paid-acquired customers tend to churn faster than organic ones. Recalculate every 6 to 12 months, not once and forget it.
Relying on lifetime-to-date revenue in Shopify or GA4 without normalizing for cohort age. A customer acquired 3 years ago will naturally show more lifetime revenue than one acquired 3 months ago, purely because they've had more time to buy. If you don't normalize for how long each cohort has actually been active, your LTV trend line will look like it's climbing even when nothing about customer behavior has actually changed.
This kind of cohort-level nuance is exactly why raw platform dashboards fall short. If you want a clean reference for how metrics like LTV, AOV, and churn should actually be defined and calculated, our data dictionary walks through the definitions we use across the platform.
How to Improve LTV Once You Know the Number
Once you've got a real, segmented LTV, three levers move it.
Purchase frequency. Retention flows, replenishment reminders, and subscription options are the fastest way to get customers buying again sooner. A brand selling a consumable with a 45-day usage cycle but no reminder flow at day 40 is leaving frequency on the table for free.
AOV. Bundling and post-purchase upsells lift AOV without touching your price list. Just raising prices can work too, but it risks conversion rate, where a $10 bundle add-on usually doesn't.
Lifespan. This one takes actual investigation. Pull your repeat-purchase curve and find the exact order number where customers drop off, second order, third order, wherever it is. Fix the experience at that specific point (a delivery issue, a product mismatch, a lack of follow-up) and lifespan moves more than any blanket loyalty program will.
Here's the part that ties it all together: once LTV moves, your acceptable CAC should move with it. Improving LTV without revisiting your CAC targets means you're leaving spend headroom on the table that your competitors are happy to take.
Automating LTV Tracking Instead of Rebuilding Spreadsheets Every Month
The manual version of this looks like: export orders from Shopify, pull spend by channel from three or four ad platforms, match them up in a spreadsheet, recalculate margin by hand, and hope nobody changed a UTM naming convention last month. It's slow, it's error-prone, and by the time it's done, it's already describing last month instead of this one.
A unified data layer fixes the matching problem at the source. Trivas's BI reporting runs on Amazon Redshift and keeps order data, margin, and ad spend connected across Shopify, Amazon, and your ad platforms, so AOV, purchase frequency, and margin stay linked to the right cohort automatically instead of getting reassembled by hand every reporting cycle.
The forward-looking piece matters too. Historical LTV tells you what happened. Forecasting and simulation tools can project LTV forward based on how current cohorts are actually trending, so you're planning spend against where the business is headed, not just where it's been.
Bring LTV Into One Dashboard
The formula isn't complicated: AOV x purchase frequency x lifespan for revenue, with gross margin folded in for the number that actually matters when you're setting a CAC target. What's complicated is keeping it accurate.
LTV calculated once, treated as static, and left unsegmented by channel or cohort will quietly mislead every acquisition decision built on top of it. Knowing how to calculate LTV for your ecommerce brand is only half the job. The other half is keeping it current enough to trust.
If you'd rather see LTV broken out by cohort and channel automatically than rebuild the spreadsheet again next month, talk to a founder at Trivas about how it works for brands your size.
Revenue growth leader and co-founder driving Trivas's commercial strategy. Om has led the product vision and execution from scratch. With a strong background in SaaS sales and GTM strategy, Om bridges product innovation with real-world customer needs.
Continue Reading
explore more insights
Omnichannel Analytics for Australian Ecommerce: One Dashboard for Shopify, Amazon, and Ads
3 min read
The Complete CLV Calculation Framework
3 min read
Essential Features Checklist for ROAS Tracking Software
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
