Funnelytics
Blog/Ecommerce Analytics

How to Calculate LTV:CAC (Free Calculator)

F
Funnelytics Team
Ecommerce analytics
Sep 10, 20267 min read

Blended LTV:CAC is a useful triage number. It is also a liar when your first products and acquisition sources mint different customers.

One cohort pays CAC back in six weeks. Another never does. Your store-wide ratio averages them into a single “looks fine” slide — then you scale the wrong journey and wonder why cash gets tighter while ROAS still screenshots well.

This page is the operator path: run a free LTV:CAC calculator for the ratio and CAC payback, then use a free LTV Profit Map when you need LTV by product, source, and cohort — the journey-level truth blended math cannot see.

Primary tool (live): https://funnelytics.io/tools/ltv-cac-calculator

Want the Map without rebuilding the model? Connect Shopify — get my free maphttps://dashboard.funnelytics.io/register (read-only, ~2 minutes, no credit card, no theme changes). Offer page: https://funnelytics.io/ltv-profit-map-lp


Why AOV × purchases isn’t LTV

The formula everyone pastes into a deck:

Naive “LTV” = AOV × purchases (× lifespan)

That is revenue theater. Three failures show up the moment you manage Shopify cash:

  1. It is revenue, not value. COGS, shipping, payment fees, discounts, and returns sit between that cell and your bank account. Profit-basis LTV is the number acquisition decisions should clear — not the flattering revenue-basis version vendors love.
  2. It ignores the clock. Ten orders over four years is not ten orders in twelve months. CAC payback lives in months of working capital, not “lifetime forever.”
  3. It collapses the mix. A $130 blended store LTV can be a $48 one-and-done trial SKU plus a $310 refill starter. Scale the wrong first product and you scale the wrong customers — while the blended LTV:CAC ratio still looks “healthy.”

So when operators search ltv cac calculator, ltv to cac ratio, or shopify ltv cac, they usually need two layers: (1) a clean ratio + payback on honest inputs, and (2) a cut by first product / source / cohort when the blend starts hiding damage.

For the deeper Shopify LTV framing (windows, contribution, sheet layout), see https://funnelytics.io/blog/shopify-ltv-calculator and https://funnelytics.io/blog/shopify-ltv. This piece stays on the LTV to CAC ratio, CAC payback, the free calculator, and when to graduate to the Map.


LTV:CAC ratio + payback inputs

You need five inputs. Miss margin and you approve unprofitable spend. Miss lifespan and you invent value you have not earned yet.

InputWhat to pull
AOVTotal revenue ÷ total orders (same period)
Orders per customer per yearTotal orders ÷ unique customers over ~12 months. Many non-subscription Shopify stores land ~1.2–2.5
Gross margin %(Revenue − COGS) ÷ revenue. Use contribution margin if you have it
Customer lifespan (years)How long a typical buyer keeps buying. Use 1 for a conservative 12-month view
CACTotal marketing spend ÷ new customers acquired (same period). Fully blended spend — not one channel’s vanity CAC

Formulas operators actually use:

  • Revenue LTV = AOV × orders per customer per year × lifespan
  • Profit LTV = Revenue LTV × gross margin %
  • LTV:CAC (revenue basis) = Revenue LTV ÷ CAC
  • LTV:CAC (profit basis) = Profit LTV ÷ CAC ← use this for decisions
  • CAC payback (months) ≈ (CAC ÷ profit per order) × (12 ÷ orders per year), where profit per order ≈ AOV × margin %

How to read the ratio (industry framing — not a Funnelytics proof claim):

Operators often treat ~3:1 on a profit basis as a common rule-of-thumb for a durable acquisition machine (three dollars of customer profit per dollar of CAC). Below 1:1 on profit, you lose money on every customer — scale makes it worse. Between 1x and ~3x, you can be profitable and still fragile: a CPM spike or refund wave pushes you underwater. Far above 4–5:1 often means you are under-investing in growth if the payback clock and cohort truth still hold. Label that clearly: rule-of-thumb, not a Funnelytics case-study claim.

Payback is the cash lens. A “strong” LTV to CAC ratio with a 14-month payback is not a growth strategy for an inventory business financing stock ahead of demand. Under ~6 months is strong; ~6–12 is workable for many brands; past ~12, growth eats cash faster than customers return it.

Also check first-order profit after CAC (profit per order − CAC). Buying customers at a first-order loss is a legitimate model — only when you actually know repeat behavior instead of hoping the blend will save you.

More free calculators: https://funnelytics.io/tools


Worked example (illustrative — LABEL clearly)

All figures below are ILLUSTRATIVE only. Made-up demo math for the formulas — not Map UI numbers, not a live store export, not calculator accuracy claims, and not Funnelytics proof.

Input / OutputIllustrative value
AOV$80
Orders per customer / year1.8
Gross margin50%
Lifespan1 year
CAC$45
Revenue LTV$144
Profit LTV$72
LTV:CAC (revenue)3.20x ← the flattering version
LTV:CAC (profit)1.60x ← the bank-account version
CAC payback~7.5 months
First-order profit after CAC−$5.00

What the sheet should scream:

  • Revenue-basis ltv to cac ratio can look “fine” while profit-basis ratio is fragile.
  • You are buying at a first-order loss; repeats carry the model — so you must know which products and sources create those repeats.
  • Blended payback of 7.5 months can mask one cohort that pays back in 40 days and another that never clears CAC.

That is why a single store-wide customer lifetime value cac ratio is triage — not truth.

CTA: Done starring at one blended cell? Connect Shopify — get my free maphttps://funnelytics.io/ltv-profit-map-lp → register at https://dashboard.funnelytics.io/register (read-only, ~2 min, no theme changes).


Skip the spreadsheet rebuild. Use the live tool:

https://funnelytics.io/tools/ltv-cac-calculator

What it returns in one pass:

  • Lifetime value — revenue and profit
  • LTV:CAC ratio on both bases (so you see the flattering number and the real one)
  • CAC payback in months
  • First-order profit after CAC

No signup required for the calculator. Run profit-basis math first. If the ratio looks soft, or payback stretches past a year, do not “fix” it by inflating lifespan — fix acquisition mix, offer, and journey.

Related operator reading on Shopify LTV math: https://funnelytics.io/blog/shopify-ltv-calculator · Full LTV overview: https://funnelytics.io/blog/shopify-ltv · Tool hub: https://funnelytics.io/tools

The calculator answers: on blended averages, do we clear? The Map answers: which journeys clear — and which should we stop funding?


When you need source / product / cohort LTV (Map)

Blended LTV is napkin math. In real Shopify stores, LTV can vary widely by which product a customer bought first, which channel they came from, and which month they joined. The average hides exactly what you need: which customers are worth acquiring more of.

Graduate from the ltv cac calculator to journey-level cuts when:

  1. First products diverge. Trial mini vs premium starter can look similar on day-one ROAS and opposite on 90/365-day profit LTV.
  2. Sources diverge. Meta can win volume while email/SMS or brand search wins keepers. Ad dashboards report first-order ROAS; they do not rank sources by true customer lifetime value vs CAC.
  3. Cohorts diverge. Black Friday binge buyers are not the same machine as evergreen cohorts. Comparing them as one blended shopify ltv cac number funds the wrong media plan.
  4. Payback is acceptable on paper but cash is tight. That usually means a subset of journeys is carrying the P&L while another subset is quietly underwater.

Free LTV Profit Map is built for that gap.

Connect Shopify (read-only OAuth). About ~2 minutes. No credit card. No theme changes. Free path is read-only — we do not modify your storefront for the map.

What operators use it for:

  • Hero vs value-draining products — first-purchase SKUs indexed by real 30/90/180/365-day LTV
  • Source-level LTV — which channels mint keepers vs one-and-done buyers
  • Cohorts & repeat behavior — how new-customer LTV trends by month
  • Prioritized next moves — where revenue leaks between ad click, first product, and repeat purchase

Product note (not a hard gate): richest signal usually shows with 24+ months of order history and roughly $1M+ revenue. Younger or smaller stores can still connect; expect thinner cohorts, not a locked door.

Ecom context: https://funnelytics.io/ecom · Map offer: https://funnelytics.io/ltv-profit-map-lp

CTA: Stop managing to blended averages. Connect Shopify — get my free maphttps://dashboard.funnelytics.io/register


Approved proof

Clarity in the customer journey is not a soft metric. Approved results from brands that used Funnelytics to tighten journeys:

  • VIIA Hemp / Bren: +27% AOV
  • Four Sigmatic: +46% AOV
  • ChappyWrap / Jessi Means (optional): +20% mobile CVR

Those are approved journey outcomes — not invented “healthy 3:1” Funnelytics proof, not calculator accuracy claims, and not Map demo figures. Any numbers in the worked example above remain illustrative only.

The industry ~3:1 rule-of-thumb in the ratio section is operator framing, not a Funnelytics case study.


CTA — Map

You now have the operator stack:

  1. Reject AOV × purchases as “LTV.”
  2. Run profit-basis LTV:CAC and CAC payback on honest inputs — live tool: https://funnelytics.io/tools/ltv-cac-calculator
  3. When first products, sources, or cohorts disagree with the blend, stop arguing from one cell.

Connect Shopify — get my free map

https://dashboard.funnelytics.io/register

Prefer the offer page first?

https://funnelytics.io/ltv-profit-map-lp

Read-only. ~2 minutes. No credit card. No theme changes.

Related: Shopify LTV calculator (operator) → https://funnelytics.io/blog/shopify-ltv-calculator · Shopify LTV → https://funnelytics.io/blog/shopify-ltv · Tools → https://funnelytics.io/tools · Ecom → https://funnelytics.io/ecom

Use the ltv cac calculator for the ratio. Use the Map for journey-level truth. Blended LTV:CAC lies when first products and sources differ — measure both, then fund the journeys that actually pay back.

See the profit hiding in your customer journey

Get a free LTV Profit Map for your Shopify store — where revenue leaks, and what to fix first.

Get my free LTV Profit Map