toolbox
Home / Online Selling & Retail / Shopify Customer Lifetime Value Estimator

Shopify Customer Lifetime Value Estimator

The Shopify Customer Lifetime Value Estimator projects the contribution profit produced by an average customer over the expected relationship. It uses average order value, purchase frequency, gross or contribution margin, retention period, and customer service cost to create a practical CLV estimate.

The result can be compared with customer acquisition cost to judge growth efficiency and payback potential. Because lifetime value is sensitive to retention assumptions, the calculator also displays estimated lifetime orders and revenue so merchants can review whether the forecast is operationally plausible.

Customer economics

$
orders
%
years
$
$
Result
—
Estimated contribution CLV
Estimated lifetime orders—
Estimated lifetime revenue—
CLV after CAC—
CLV to CAC ratio—

1. Enter average order value
Use net merchandise revenue per order for the customer segment being analyzed.

2. Estimate annual purchase frequency
Divide annual orders from the segment by the number of active customers.

3. Use contribution margin
Enter the percentage remaining after product and other variable order costs.

4. Set retention period and service cost
Estimate how long the average customer remains active and the annual support or loyalty cost.

5. Compare CLV with CAC
Use the ratio and net value to evaluate acquisition economics, while testing conservative retention assumptions.

Formula:

Contribution CLV = (Average order value × Orders per year × Retention years × Contribution margin) − (Annual service cost × Retention years)

CLV after CAC subtracts acquisition cost. This is a simple undiscounted model and assumes average behavior remains stable over the retention period.

What the result means

Contribution CLV estimates the cumulative variable profit from an average customer before acquisition cost.

For long retention periods or complex cohorts, consider discounted cash flow and cohort-specific retention curves.

Given: Average order value $72, 3.2 orders per year, 42% contribution margin, 2.5 years of retention, $8 annual service cost, and $40 CAC.

Calculation: Lifetime orders = 3.2 × 2.5 = 8. Lifetime revenue = $72 × 8 = $576. Contribution before service = $576 × 42% = $241.92. Service cost = $8 × 2.5 = $20. CLV = $241.92 − $20 = $221.92. CLV after CAC = $221.92 − $40 = $181.92.

Result: Estimated contribution CLV = $221.92.

The model expects the average customer to generate $181.92 after recovering acquisition cost.

Should CLV use revenue or profit?

Profit-based CLV is usually more useful for acquisition decisions because revenue alone ignores product and fulfillment costs.

How do I estimate retention years?

Use cohort data when available. A simple approximation can be based on the average active span between first and last purchase, adjusted for customers who are still active.

Why is this called an estimate?

Future purchase frequency, margin, and retention can change. Small shifts in those assumptions can materially affect lifetime value.

Should CAC be included in the main CLV?

The main result shows contribution CLV before CAC, while a separate output subtracts CAC. Keeping both figures visible supports clearer comparisons.

Can I use this for subscriptions?

Yes, but a subscription-specific model using churn, recurring margin, and discounting may be more precise when billing is regular.