How should a D2C founder think about customer lifetime value and cohorts?
Customer lifetime value and cohort analysis explained for Indian D2C founders, with a simple way to calculate them from CRM data and use them in decisions.
Anadoris Digital · · 4 min read

Lifetime value, often shortened to LTV, is one of the most quoted and most misused numbers in D2C. A single blended figure, calculated once and repeated in pitch decks, tells you very little. Used properly, with cohorts and margin, it becomes one of the most practical tools a founder has for deciding how much to spend on acquisition and where.
This guide explains the concepts in plain terms and shows how to build a simple version from the order data already in your CRM or store. It uses no industry benchmarks, because your own data is the only reliable comparison.
What lifetime value really means
Lifetime value is the total value a customer brings over their relationship with you. For decisions, the useful version is not revenue but contribution: what is left after product cost, shipping, payment fees, packaging, returns and discounts. A customer who places many orders with deep discounts and frequent returns may be worth less than one who buys twice at full price.
In practice, ‘lifetime’ is too long and uncertain to measure. Most small brands look at value over fixed windows, such as the first three, six and twelve months after the first order, which are easier to compare and act on.
What a cohort is and why it matters
A cohort is a group of customers who share a starting point, usually the month of their first order. Tracking cohorts separately shows whether customers acquired recently behave better or worse than earlier ones. A blended average hides this: a brand can look healthy overall while each new cohort repeats less than the one before.
- By first-order month: shows whether customer quality is improving over time.
- By first-order source: shows which channels bring customers who come back.
- By first product: shows which entry products lead to repeat purchase.
- By first-order discount: shows whether heavy launch offers attract one-time buyers.
How to build a simple cohort table
Export orders with customer identifier, order date, net value and, if possible, a margin estimate per order. Assign each customer to the month of their first order. Then, for each cohort, calculate the cumulative contribution per customer at month one, three, six and twelve. Lay this out as a table with cohorts as rows and months since first order as columns.
Reading across a row shows how one cohort’s value builds up. Reading down a column shows whether newer cohorts reach the same value at the same age as older ones. Both views are useful; the second is often the more worrying, and the more actionable.
Keep the first version rough. Average product cost per order, an average shipping and packaging cost, payment fees as a simple rate and a deduction for returns are enough to start. The aim is consistency across cohorts, not accounting precision, and you can refine the estimates once the habit of reviewing cohorts is in place.
Where the CRM helps
Cohort analysis depends on knowing that two orders belong to the same customer. Duplicate records, guest checkouts and unlinked WhatsApp orders all make repeat customers look like new ones, which understates lifetime value and hides the effect of retention work. A CRM with clean, deduplicated customer records and first-order source stored on each customer is what makes cohort tables trustworthy.
The CRM also lets you act on what the table shows. If customers who start with a particular product repeat more, you can build a journey that introduces that product to other first-time buyers. If a channel’s cohorts fade quickly, you can test a stronger post-purchase journey for those customers before cutting spend, and see in later cohorts whether it worked.
Using LTV in real decisions
- Acquisition spend: compare what you pay to acquire a customer from each channel with that channel’s cohort contribution over a realistic window.
- Entry products: promote products whose buyers repeat more, even if their first order is smaller.
- Discount policy: check whether customers acquired on deep discounts ever return at full price.
- Retention work: see whether repeat-purchase journeys change the shape of new cohorts.
- Cash planning: understand how long it takes a cohort to pay back its acquisition cost.
Common mistakes
- Using revenue instead of contribution margin.
- Calculating one blended LTV and never splitting it by cohort.
- Projecting long lifetimes from a few months of data.
- Ignoring returns, cancellations and COD refusals.
- Mixing wholesale buyers with D2C shoppers in the same figures.
- Counting marketplace orders that cannot be linked to the same customer.
Margin estimates per order are often approximate for small brands. That is fine for comparing cohorts, as long as the same method is used consistently and assumptions are written down.
Where to start
- Export at least twelve months of orders with customer number, date and net value.
- Estimate contribution per order using simple averages for cost, shipping and fees.
- Build a cohort table by first-order month for three, six and twelve months.
- Add a second table by first-order source.
- Review it monthly and move the calculation into your CRM or reporting tool once the method is settled.
Anadoris Digital can set up cohort and lifetime value reporting from your CRM and order data so it refreshes on its own.
Related service: CRM Solutions · More on this topic: CRM Solutions articles
