CAC vs LTV Ratio in Ecommerce: How to Calculate It and What Counts as Good
by Om Rathod
|
8 min read
Aug 24, 2026
Most DTC dashboards show you CAC in one widget and LTV in another. Different cards, different corners of the screen, sometimes different tabs entirely. Nobody reads them as a ratio every week, even though that ratio is the actual answer to "is this business working."
This post covers the definitions, the formula, what benchmarks actually mean, and the calculation mistakes that quietly wreck the number. It's not a pitch. Before you pick a tool to track your CAC vs LTV ratio in ecommerce, you should understand what the number is actually telling you, and where it lies.
What CAC Actually Means (and What Most Spreadsheets Get Wrong)
CAC is total sales and marketing spend divided by new customers acquired in a given period. That's it. Simple on paper, messy in practice.
The most common mistake: teams calculate CAC using only ad spend. Meta spend plus Google spend, divided by new customers, done. But that ignores agency retainers, creative production, freelancer fees, the tools stack you're paying for to run campaigns. Fully-loaded CAC includes all of it. Leave those costs out and your CAC looks 20-30% cheaper than it really is, which makes your ratio look better than it is too.
You also need to separate blended CAC from paid CAC. Blended CAC includes every acquisition channel, paid, organic, referral, email. Paid CAC isolates the money you spent on ads. Early on these two numbers are close. Once organic and referral traffic scale (which happens as brand recognition grows), the gap widens, and if you're only looking at paid CAC you'll think growth is more expensive than it actually is.
Then there's attribution. Meta says it drove the sale. Google says it drove the sale. GA4 has a third opinion. Check each platform in isolation and you'll double count some conversions and miss others entirely, which understates true CAC across the board. This is exactly the kind of gap BI reporting built on unified data is meant to close, since it pulls ad platforms, Shopify, and GA4 into one source instead of three conflicting ones.
What LTV Actually Means (and Why 12-Month LTV Isn't the Whole Story)
LTV is average order value times purchase frequency times average customer lifespan. Straightforward formula, but the inputs matter a lot.
Here's the honest version: calculate it on gross margin, not revenue. A customer who generates $500 in revenue but only $150 in margin is worth $150 to your business, not $500. Revenue-based LTV inflates the number and makes your ratio look healthier than your bank account agrees with.
There's also a difference between historical LTV and predictive LTV. Historical LTV is what already happened, actual purchase data from actual cohorts. Predictive LTV is modeled, using early cohort behavior to project forward. Predictive is more useful for decision-making, but it's only as good as the model behind it, so treat early predictive numbers with some skepticism until you have real data to check them against.
The timeframe problem trips up more brands than it should. A lot of dashboards default to a 90-day LTV window because it's easy to calculate. But if you're a subscription brand, or your average customer buys again on a 6 or 9 month cycle, a 90-day window catches almost none of that repeat behavior. Your LTV looks anemic, your ratio looks bad, and neither reflects reality.
The LTV:CAC Formula and How to Calculate It Step by Step
The formula itself is simple: LTV divided by CAC, expressed as a ratio like 3:1.
Say your CAC is $120 and your LTV is $360. Divide 360 by 120 and you get 3, so your ratio is 3:1. For every dollar spent acquiring a customer, you get three dollars back over their lifetime.
Now factor in margin. If that $360 LTV is revenue-based and your margin is 40%, the real LTV is $144. Divide $144 by $120 and your ratio drops to 1.2:1. Same customer, same spend, wildly different picture depending on whether margin is baked in. This is the single most common reason two people at the same company argue about whether the business is healthy: one is looking at revenue LTV, the other margin LTV.
The most accurate way to calculate this isn't a single blended snapshot for the whole business. It's cohort-based: group customers by the month they were acquired, track their CAC and LTV separately, and watch how each cohort's ratio matures over time. A blended number smooths over channel shifts and seasonality that a cohort view catches immediately.
What's a Good LTV:CAC Ratio for Ecommerce
The 3:1 benchmark gets cited constantly, and it comes from SaaS unit economics, not ecommerce. In SaaS, where margins are high and churn is the main variable, 3:1 is a reasonable floor for a sustainable business.
Ecommerce runs differently. Margins are thinner, repeat purchase behavior varies wildly by category, and a lot of brands operate healthily in the 2:1 to 4:1 range depending on their product type and repurchase cycle. A skincare or supplements brand with strong repeat rates might comfortably sit at 4:1. A brand selling a durable good people buy once every three years might be fine at 2:1, because the entire model isn't built on repeat revenue anyway.
A ratio above 5:1 isn't automatically a win, either. It often means you're leaving growth on the table, under-spending on acquisition relative to how much margin each customer generates. If your ratio is 6:1 and you have the cash to spend, that's usually a signal to lean harder into acquisition, not a badge of efficiency.
Brands under 18 months old should expect a lower ratio almost by default. Acquisition costs show up immediately, LTV data takes months or years to mature. Don't panic if your early ratio looks thin, panic if it's not trending upward as your cohorts age.
Why the Ratio Breaks Down: Common Calculation Mistakes
A few mistakes show up over and over, and they all point the same direction: they make the ratio look better than the business actually is.
Mixing revenue-based LTV with fully-loaded CAC. This is the most common one. Fully-loaded CAC (all costs) divided by revenue LTV (not margin-adjusted) inflates the ratio artificially. You end up comparing an honest cost number to a dishonest value number.
Using a short LTV window on a long repurchase cycle. Covered above, but worth repeating: a 30 or 90-day window on a business where customers reorder every 4-6 months will always understate LTV, no matter how loyal those customers actually are.
Ignoring channel-level differences. Blended CAC hides a lot. TikTok CAC might run $180 while your email and SEO-driven CAC sits at $40. Blend those together and you lose the information that actually tells you where to spend the next dollar.
Not updating the ratio as CAC creeps up. Ad costs rise quarter over quarter almost everywhere. A ratio calculated once in Q1 and never revisited will drift out of date fast, usually in the wrong direction.
How to Actually Improve Your Ratio
On the CAC side, the levers are pretty well known: creative testing to cut wasted spend, shifting budget toward channels with lower acquisition cost, tightening retargeting so you're not repeatedly paying to re-convince people who already converted.
On the LTV side, the bigger wins usually come from repeat purchase behavior. Subscription or replenishment programs, post-purchase email and SMS flows that bring people back for a second order, bundling that raises average order value without raising acquisition cost at all.
The real unlock, though, is tracking the ratio by cohort and channel every month instead of glancing at it quarterly. Drift is easy to catch early and hard to catch late. A CAC that creeps up 8% a quarter feels invisible in the moment but compounds into a real problem by month nine.
Most teams calculating this today are doing it manually, pulling numbers from Shopify, ad platforms, and GA4 into a spreadsheet and hoping the exports match up. That's exactly where the mistakes from the last section creep in: a wrong margin assumption here, a stale export there, and the ratio quietly stops meaning anything. Forecasting and simulation tools that pull cohort data automatically remove most of that manual error, since the inputs are consistent every time instead of re-assembled by hand each month.
Where to Go From Here
The ratio is only ever as good as the CAC and LTV feeding into it. Get the inputs wrong, margin left out, wrong window, blended numbers hiding channel reality, and the ratio will tell you a story that isn't true.
If you're a founder who'd rather have CAC and LTV calculated automatically from unified ad, Shopify, and GA4 data instead of stitched together in a spreadsheet each month, that's the kind of reporting Trivas is built around. Worth a look if you're tired of reconciling three exports before you can trust a single number.
And if you want the exact definitions we use for every metric mentioned here, margin, blended CAC, cohort LTV, the data dictionary spells it out plainly.
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
Trivas Customer Success Stories: Real Results From Real Ecommerce Brands
3 min read
Building Investor-Ready Ecommerce Analytics: 6 Must-Haves
3 min read
Sophisticated Segmentation and Personalization Analytics
.d53b12e5.png&w=3840&q=75 "Trivas.ai")
