How To Calculate Customer Lifetime Value (LTV) For E-commerce Merchants

Customer Lifetime Value (LTV) An estimate of the total value a customer generates for a brand across their relationship, using a specified revenue or profit basis. For e‑commerce merchants, calculating LTV properly requires combining order data with cost inputs (COGS, shipping, returns) and a clear time horizon.

Calculating LTV for online retail differs from subscription businesses because purchase timing is irregular, returns are common, and fulfillment costs can be a large variable. The right method depends on available data and the decision you want to support: high‑level budgeting, channel ROI, or individual customer targeting.

Step‑By‑Step Calculation Methods

Choose one or more methods below based on your needs and data maturity.

• Simple Historical Method: AOV × purchases per period × average customer lifespan (periods). Use this for quick benchmarking when margins are consistent.
• Gross Profit Method: Revenue LTV × average gross margin after direct variable costs (COGS + average shipping + average returns cost). Produces profit‑based LTV useful for unit economics.
• Cohort Retention Method: For each cohort (by acquisition month or channel) calculate repeat purchase rates each period; sum expected future revenue discounted to present value.
• Predictive Individual LTV: Use RFM (recency, frequency, monetary) or probabilistic models (Pareto/NBD, BG/NBD) to forecast purchases per customer and multiply by expected margin.

Data Inputs You Need

Accurate LTV requires these fields from your systems:

• Order History: AOV, timestamped purchases, returns and refunds.
• Cost Data: COGS per SKU, average fulfillment & shipping cost per order, variable overheads tied to orders.
• Customer Identifiers: Persistent IDs to link orders to customers across channels and devices.
• Retention Metrics: Repeat purchase rates, churn timing, subscription cancellations where applicable.

How To Treat Returns, Discounts, And Refunds

Returns materially reduce LTV if not modeled. Best practice:

• Net Revenue Basis: Subtract refunds and return freight reimbursements from revenue before computing AOV.
• Include Handling Costs: Factor in restocking fees, inspection labor, and disposal costs for non‑resellable returns when estimating profit LTV.

Examples For Merchants

Example 1 — Revenue LTV: AOV $60, purchases/year 2.5, lifespan 2.2 years → Revenue LTV = $60 × 2.5 × 2.2 = $330.

Example 2 — Profit LTV: From example 1, average gross margin after COGS = 50%, average fulfillment/returns cost = $25 per order (reduces margin). Estimate adjusted margin: (60 − variable costs) / 60 = 35%. Profit LTV = $330 × 0.35 = $115.5.

Using LTV In Channel And Budget Decisions

Once you have an LTV, compare it to CAC (customer acquisition cost). Common heuristics:

• Target Ratio: Aim for LTV:CAC of 3:1 on a profit basis for sustainable growth, but this varies by business maturity and cash constraints.
• Payback Period: Consider how quickly acquisition costs are recovered (e.g., within 6–12 months) to manage cash flow.

Practical Implementation Tips

Implementation in practice often follows these steps:

• Start With Clean Data: Deduplicate customers, reconcile refunded transactions, and join commerce data with shipping and returns records.
• Run Cohort Analysis: Build LTV by acquisition cohort to see how early customers performed versus recent ones.
• Automate Updates: Recalculate LTV monthly and track trends; store both revenue LTV and profit LTV.
• Use Segmentation: Compute LTV per channel, acquisition campaign, product category, and customer segment to guide spend.

For merchants working with 3PLs or marketplaces, include marketplace fees and 3PL pass‑through costs when computing profit LTV. If using subscription options or replenishment, track churn carefully — small improvements in churn rate can materially increase LTV.

In short, the Customer Lifetime Value (LTV) for e‑commerce merchants is most useful when calculated on a profit basis, segmented by cohort, and updated regularly. It becomes the foundation for CAC targets, fulfillment service decisions, and retention investments.