Customer acquisition is getting more expensive across e-commerce, and the “ad cost versus basket value” calculation increasingly only just breaks even. Escaping this trap requires changing the unit: instead of asking what an order costs, ask what a customer is worth over time. This guide shows how to calculate LTV from shop orders, how to read cohorts and retention, and how the LTV to CAC ratio brings order to budget decisions.
Definition
What customer LTV is and how to calculate it
Working definition
LTV (lifetime value) is the total value of a single customer’s orders over a chosen time horizon, calculated from shop order data linked to the customer. The starting version measures revenue; the mature version measures margin, because margin is what pays the bills.
Two decisions must be made explicitly and written down: the horizon (12 months is a sensible start for most shops) and the measure (revenue or margin). The margin variant requires the purchase price per product in your data, covered in more detail in the guide to margin in e-commerce.
And one technical point: LTV is calculated from shop system orders (customer = account or email), not from web analytics. Cookies do not survive for months and do not link devices, so GA4 describes sessions very well but cannot hold a customer’s identity for a year. It is the same principle that limits how far ad costs can be linked to specific sales, described in the guide to conversions and attribution.
Customer view
Customer timeline: purchases, gaps and silence
A single customer seen over time looks different from how they appear in a transaction report. An example from a natural cosmetics shop (illustrative data):
12 months of one customer · paid ordersnatural cosmetics · illustrative data
This customer’s LTV(12m): €125 against a first basket of €22.25. A campaign judged on the first transaction saw a “weak” order; the customer view over time shows a value more than five times higher. The silence after M9, in turn, is a signal for win-back activity before the customer disappears for good.
Cohort view
Cohorts and retention: a heatmap of returns
A single customer is an anecdote; a cohort is a measurement. A cohort = customers who made their first purchase in the same month. Tracking what share of each cohort places another order in subsequent months reveals the quality of the customers being acquired (illustrative data):
Share of cohort placing another order in the monththe darker, the more returns
The July cohort returns at half the rate. Customers acquired during a deep sale bought once and disappeared: cheap CAC, low LTV. This pattern is visible only in cohorts; an average monthly retention figure would hide it.
Safety check
LTV to CAC: a safety check for budget decisions
CAC (customer acquisition cost) is acquisition spend divided by the number of new customers. Set against LTV, it gives a single ratio that turns the “is advertising expensive?” debate into a calculation:
Below 1: you lose money on every new customer. Around 1–2: acquisition pays back barely and late. Clearly higher: there is room to scale budgets. The thresholds depend on margin and the repeat purchase rate in your category, so treat them as a framework for discussion and calculate your own values on your own cohorts.
The costliest mistake
Judging campaigns solely on the first order cuts off entry products. A product with a low basket value and a “weak” ROAS can attract customers who come back for years. Before switching off a campaign, check the LTV of customers whose first purchase was the product it promotes, not just the value of their first baskets.
Methodological note: LTV describes past cohorts, while decisions concern future ones. Changes to the product range, prices or service quality alter the repeat purchase rate, so LTV should be refreshed regularly and read alongside the retention trend, not treated as a fixed company constant. All figures in the examples are illustrative.
DataOrganizer
How DataOrganizer calculates LTV from shop orders
DataOrganizer builds each customer’s history from the shop system’s orders and uses it to calculate LTV over a chosen horizon, cohort retention, customer segments, and first and repeat purchase products. Combined with ad spend, it answers a question that ad platforms cannot:
Entry products by customer value (12 months):
| First purchase product | Customers | Avg. first basket | Avg. 12m LTV | Return for 2nd purchase |
|---|---|---|---|---|
| Miniatures set (starter) | 512 | €19 | €121.50 | 46% |
| Moisturising cream 50 ml | 640 | €26 | €103 | 38% |
| Vitamin C serum | 388 | €37.25 | €73.50 | 22% |
The starter has the lowest first basket and the highest customer value: 46% of buyers return. The serum is the opposite: a high basket, rare returns. If you judge campaigns by first transaction ROAS, you promote the serum and choke the starter, which is exactly the reverse of what value over time suggests.
Key takeaway
LTV changes the unit of account from the order to the customer. Cohorts show acquisition quality, the LTV/CAC ratio defines the room to scale, and entry products get the valuation they deserve.
FAQ
Frequently asked questions about LTV in e-commerce
What is LTV and how do you calculate it?
It is the total value of a customer’s orders over a chosen horizon. The starter version: the sum of paid orders in the 12 months after the first purchase, averaged per cohort. The mature version calculates margin instead of revenue, because two customer groups with the same revenue can leave different profit.
How does LTV differ from AOV?
AOV describes a transaction; LTV describes a customer over time. A product with a low AOV can build high-LTV customers (they return), while a high-AOV product can attract one-off buyers. Acquisition decisions based only on first transaction metrics systematically confuse these two cases.
Why calculate LTV from orders rather than GA4?
Because it requires a customer identity that stays stable for months. The shop system links orders to an account or email address; web analytics relies on cookies, which expire and do not connect devices. GA4 is for in-session behaviour; orders are for value over time.
What should the LTV to CAC ratio be?
Below 1, you pay extra for acquisition; around 1–2, it pays back barely and late; clearly higher, there is room to scale. The thresholds depend on margin and the repeat purchase rate in the category, so they are a framework for discussion; the key is that the numerator is margin-based and over an explicit horizon.
How does DataOrganizer calculate LTV and cohorts?
From the shop system’s order history: LTV over a chosen horizon, month-by-month cohort retention, customer segments, and first versus repeat purchase products. Combined with total ad spend, it gives the LTV to CAC ratio for the shop as a whole, and the AI assistant shows which first purchase products attract the customers with the highest value over time.
Cheat sheet for the whole guide
Calculating customer value in three steps
1. Calculate LTV from orders, over an explicit horizon. Customer = account or e-mail in the shop system; 12 months to start with; margin instead of revenue as soon as you have purchase prices in the data.
2. Read cohorts instead of averages. The share of returning customers month by month shows the quality of acquisition; cohorts from promotions and from full price are often two different businesses.
3. Decide using the LTV/CAC ratio and entry products. Scale where customer lifetime value justifies the cost of acquisition. DataOrganizer calculates all of this from connected orders and ad spend, so the answer to “which customers are really worth acquiring” takes a single question.
DataOrganizer · customer lifetime value
Connect your shop system and ad platforms: LTV, cohort retention and entry products meet acquisition costs. Demo account available instantly; you pay only for connected sources.