What is LTV:CAC ratio and why does it matter?

LTV:CAC ratio compares customer lifetime value to customer acquisition cost. A ratio at or above 3:1 is generally considered healthy: customers generate 3x more revenue than it cost to acquire them. Below 1:1 means the unit economics are negative.

What data do I need to provide?

At minimum: customer email (or ID), order date, and order revenue per row. Optionally: order ID and acquisition source. More history yields tighter cohort comparisons. Six months of data is the practical minimum for meaningful 90-day LTV.

How is LTV calculated?

LTV is the cumulative revenue from a customer within a fixed window (30, 60, 90, 180, or 365 days from first purchase), summed across the cohort and divided by cohort size. The tool reports each window so you can see the curve, not just a single number.

What is a cohort analysis?

Cohort analysis groups customers by acquisition period (typically month) and tracks each group's behavior over time. Comparing cohorts surfaces trends: are newer cohorts spending more or less, retaining better or worse, generating higher or lower LTV.

How accurate are the LTV projections?

Projections fit a decay curve to your observed data. With six or more months of history, accuracy is typically within 15 to 20 percent. Newer cohorts have wider confidence bands because there is less observed data to fit against.

Yes. One use per day with no signup, three per day with a free account, unlimited with Pro. Order data uploaded for analysis is not retained beyond the session.

IndexSee which brands AI assistants actually recommend.Who AI actually recommends.See all

Map LTV by acquisition cohort.

Connect Shopify, upload your order export, or type rows manually. Builds cumulative LTV curves per acquisition cohort, compares cohorts side-by-side, and flags outliers.

FelixForecasting

Industry

Analysis window

Cohort grouping

Avg CAC (opt)

Drop your orders CSV here, or click to upload

Required: Customer Email, Order Date, Revenue

Shopify orders CSV auto-detected

Shopify: Orders → Export → CSV for best results

Aggregates orders by customer email, groups customers into cohorts by acquisition month (or week / quarter), and computes cumulative revenue per customer at 30 / 60 / 90 / 180 / 365 days. Repeat rate, AOV, and retention curves derive from the same aggregate. Outlier cohorts are flagged when their LTV deviates >1 standard deviation from the portfolio mean.

Cohort value builds on acquisition that works. The full growth audit runs seven checks against your live store, including tracking hygiene, catalogue health, your landing page, schema markup and whether ChatGPT and Claude name you.

Run the free growth audit