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

Etsy Customer Lifetime Value Estimator

The Etsy Customer Lifetime Value Estimator projects the gross profit contributed by an average customer across the expected buying relationship. It uses average order value, purchase frequency, gross margin, and customer lifespan, then optionally subtracts acquisition cost to show value after customer acquisition.

The estimate is useful for setting marketing limits, evaluating repeat-purchase programs, and comparing buyer segments. It is not a promise of future behavior. Use historical data from a consistent cohort where possible, and keep the lifespan unit aligned with the purchase-frequency period.

Customer economics

$
orders
%
years
$
Result
—
gross-profit lifetime value after CAC
Lifetime revenue—
Gross-profit LTV—
Acquisition cost—
LTV / CAC—
Annual gross profit—

1. Enter average order value
Use customer revenue divided by completed orders for a representative period.

2. Estimate annual order frequency
Enter the average number of purchases made by one customer each year.

3. Use gross margin
Enter the share of sales remaining after variable product and fulfillment costs.

4. Set the expected lifespan
Estimate how many years the average customer remains active.

5. Add acquisition cost
Enter CAC to view lifetime gross profit after the cost of winning the customer.

Lifetime revenue = Average order value × Orders per customer per year × Customer lifespan Gross-profit LTV = Lifetime revenue × Gross margin % LTV after acquisition = Gross-profit LTV − Customer acquisition cost

This is a simple historical-average model. It does not discount future cash flows and assumes frequency and margin remain constant throughout the customer lifespan.

What the result means

The main result estimates lifetime gross profit remaining after acquisition cost.

Segment customers when buying patterns vary substantially; one storewide average can hide important differences.

Given: Average order value is $52, customers place 2.4 orders per year, gross margin is 58%, lifespan is 3 years, and CAC is $15.

Calculation: Lifetime revenue = $52 × 2.4 × 3 = $374.40. Gross-profit LTV = $374.40 × 0.58 = $217.15. After CAC = $217.15 − $15 = $202.15.

Result: Estimated gross-profit lifetime value after acquisition is $202.15 per customer.

Should average order value include shipping and tax?

Use the same revenue definition across all inputs and reports. Many sellers exclude collected tax and pass-through shipping when analyzing merchandise economics.

How do I estimate customer lifespan?

Use cohort data when available, measuring the active period from first to last purchase. For a newer shop, test several plausible lifespan scenarios.

Why use gross margin instead of revenue alone?

Revenue does not account for variable costs. Applying gross margin makes the estimate more useful for acquisition and retention decisions.

What if customers buy irregularly?

Use an average annual frequency across a sufficiently large customer group. Separate one-time buyers and loyal buyers when their behavior differs sharply.

Is LTV the same as future cash flow?

Not in this model. It is an undiscounted estimate based on constant averages and does not model timing, churn curves, or the time value of money.