· 11 min read

Customer Retention Rate Formula (and Churn) for D2C (2026)

The customer retention rate formula and churn rate formula for D2C brands, with a rupee worked example, sheet-ready formulas and how to define churn.

Customer retention rate formula for D2C brands: end customers minus new customers, divided by start customers, with churn defined by inactivity

Updated October 2026.

The customer retention rate formula is ((E minus N) ÷ S) × 100, where S is customers at the start of a period, E is customers at the end and N is new customers won during it. Churn rate is 100 minus that number. For a D2C brand, the hard part isn't the maths. It's deciding who counts as a customer at the end, because nobody on a store ever presses cancel.

I work out retention this way for the brands I run CRM for as a retention agency, and I used the same logic on repeat orders at HealthifyStore. This page is the formulas. For what a good number looks like by category, read my repeat purchase rate benchmarks.

Customer retention rate formula

The standard formula comes from subscription businesses, and it holds for stores too once you define "customer" properly.

Customer retention rate = ((E minus N) ÷ S) × 100

  • S is the number of active customers on the first day of the period.
  • E is the number of active customers on the last day.
  • N is the number of new customers acquired during the period.

You subtract N because new customers were never in the group you started with. Leaving them in measures growth, not retention.

A worked example in rupees

Say a skincare brand counts a customer as active if they've ordered in the last 180 days.

  • On 1 July it has 10,000 active customers (S).
  • Between 1 July and 30 September it wins 4,000 new customers (N).
  • On 30 September it has 11,200 active customers (E).

Retention rate = ((11,200 minus 4,000) ÷ 10,000) × 100 = 72%.

So 7,200 of the original 10,000 are still active, and 2,800 lapsed. Churn rate for the quarter is 28%.

Now put rupees on it. Say an active customer of this brand spends about ₹3,000 a year. The 2,800 who lapsed took about ₹84 lakh of yearly revenue with them. Lift retention from 72% to 77% and you keep 500 more customers, which is about ₹15 lakh a year in revenue you didn't have to buy again with ads. Run that through margin, not just revenue, using CM1, CM2 and CM3, because a retained customer you keep with a 30% coupon is worth far less than one who came back on their own.

Customer churn rate formula, and why new customers break it

Churn rate = ((S minus (E minus N)) ÷ S) × 100, which is the same as 100 minus the retention rate.

In the example, that's ((10,000 minus 7,200) ÷ 10,000) × 100 = 28%.

The common mistake is to skip N. Someone takes the end count over the start count, gets 11,200 ÷ 10,000 = 112%, and reports "retention above 100%, churn negative". The business grew, so the number looks great. Meanwhile 2,800 customers quietly left.

This is why "churn is 1 minus retention" is only true when retention was worked out with new customers removed. Most templates online skip that step, because they were written for SaaS teams with a fixed contract base.

The same trap shows up on dashboards. When a brand cuts acquisition, its share of orders from returning customers rises, even if nothing about loyalty changed. Fewer new customers simply means less dilution. Always read retention next to how many new customers came in that period.

How to define churn when there's no cancel button

A subscription has a cancel event. A store doesn't. A customer who hasn't ordered in four months might be lost, or might just not need you yet. So for repeat-purchase brands, churn has to be defined by inactivity, measured against how often your customers actually buy.

The rule I use is simple. A customer is lapsed once they've gone two to three times your median gap between orders without buying again.

To set that, I measure the gap between orders, order by order. I split customers by order number and look at order one, the gap from order one to two, order two, the gap from order two to three, and so on. In a D2C brand I worked with, the gap was about 40 days from the first order to the second, and about 28 days from the second to the third. Customers who came back once came back faster the next time.

That changes the churn threshold. With a 40-day median gap, a first-time buyer is lapsed somewhere between 80 and 120 days. A customer on their third order is lapsed sooner. At HealthifyStore, which sold protein and supplements that run out, the median gap to a second order was a little over three weeks and most second orders landed within the first month. A refill brand's lapse line sits much closer than a cookware brand's.

There's one more thing I check before trusting any retention number. I look at total audience versus reachable audience. If your WhatsApp and email only reach 20 of every 100 customers, your cohort is effectively a fifth of its size, and a low retention rate may be a delivery problem, not a loyalty problem. Check reachability by channel before you rewrite a single message.

Churn for subscriptions vs repeat-purchase brands

Item Subscription brand Repeat-purchase brand
What churn is A cancelled or unrenewed plan No order within the lapse window
When you know On the cancel or renewal date Only after the window passes
Formula base Subscribers at the start Active customers at the start
Main lever Renewal and save offers The next order, on time

If you run both, such as a store that also sells a monthly plan, measure them separately. Mixing a cancel-based churn with an inactivity-based one gives you a number that describes nobody.

Retention rate vs repeat purchase rate vs repeat order share

These get swapped in decks all the time. Each answers a different question.

Metric Question it answers Formula
Customer retention rate Of the customers I started with, how many are still active? (E minus N) ÷ S
Churn rate Of the customers I started with, how many lapsed? 1 minus retention rate
Repeat purchase rate Of my customers, how many have bought more than once? Customers with 2+ orders ÷ all customers
Repeat order share Of this period's orders, how many came from returning customers? Returning orders ÷ all orders

Retention and churn follow a fixed starting group. Repeat purchase rate is the cleanest for D2C when you measure it by cohort, and you can work yours out with the repeat purchase rate calculator. Repeat order share is the easiest to pull and the easiest to fool, because it moves with ad spend. For the deeper version of the cohort method, see my guide to cohort analysis.

How to pick the retention window

The window decides the number, so choose it from how often your customers need you, then never change it when comparing.

Category Typical repeat Window I'd use
Protein, supplements, coffee, pet food Refill every few weeks 90 days
Skincare, haircare, personal care Refill every one to three months 180 days
Cookware, jewellery, home, electronics The next product, not the same one 365 days

Compare like with like. A 90-day retention rate this quarter against last year's same quarter tells you something. Your 90-day number against another brand's annual one tells you nothing. That's also why published benchmarks contradict each other. Most don't state the window, and many mix SaaS and ecommerce.

Sheet-ready formulas for Excel and Google Sheets

Set up two tabs. Orders has one row per order with customer ID in column A and order date in column B. Customers has one row per customer with the ID in column A. These work in Google Sheets and Excel 365.

Customer retention rate (cells: B2 = start, B3 = end, B4 = new)
=(B3-B4)/B2

Churn rate
=1-((B3-B4)/B2)

Days since last order (Customers tab, row 2)
=TODAY()-MAXIFS(Orders!B:B,Orders!A:A,A2)

Gap from order 1 to order 2, in days
=IFERROR(SMALL(FILTER(Orders!B:B,Orders!A:A=A2),2)-SMALL(FILTER(Orders!B:B,Orders!A:A=A2),1),"")

Median gap (gaps in column D)
=MEDIAN(D:D)

Lapsed flag (days since last order in C2, median gap in $H$1)
=IF(C2>2.5*$H$1,"Lapsed","Active")

Repeat purchase rate (order count per customer in column E)
=COUNTIF(E:E,">=2")/COUNTA(A2:A)

Format the retention and churn cells as percentages. If you also multiply by 100, the sheet will show 7200% instead of 72%, a mistake I've seen in more than one template.

Retention rate myths worth correcting

Myth What's true
Churn is 1 minus (end customers ÷ start customers) That ignores new customers, so a growing brand can show negative churn while losing thousands of buyers
Keeping a customer is 5x (or 5 to 25x) cheaper than winning one There's no single original study behind this figure, and it varies by category and channel
A 5% lift in retention raises profit 25% to 95% for any business Bain's line is about profit, not revenue, and its example is financial services
A rising returning share means retention improved It also rises when acquisition falls, with no change in loyalty
There's one good retention rate It depends on your category, your window and whether you sell refills or one-time products

Sources: Fred Reichheld's Bain brief, Prescription for cutting costs, which says that in financial services "a 5% increase in customer retention produces more than a 25% increase in profit".

What is a good customer retention rate?

There isn't one number that travels across categories. Klaviyo puts a good repeat purchase rate at roughly 20% to 30%, without fixing a period, and a refill brand should sit above a cookware brand on any window. The better benchmark is your own cohort, same window, this year against last.

Sources: Klaviyo's glossary page on what a good repeat purchase rate is, checked October 2026. Category ranges are in my benchmarks post, linked at the top of this page.

What to do when your retention rate is low

Fix in the order the customer moves. Most of the loss sits between the first and second order, so start there.

  1. Check the pipe first. Confirm how many customers you can actually reach on WhatsApp, email and SMS. A low reachable audience makes every other fix look weak.
  2. Make the first week count. A post-purchase flow that explains the why and the how of the product sets up order two.
  3. Time the next order to the gap. For refills, remind a few days before the product runs out, allowing for delivery time. For one-time products, cross-sell the next item in the range. My replenishment and cross-sell guide covers both.
  4. Segment by recency and value. An RFM analysis tells you who is drifting before they cross your lapse line.
  5. Win back the lapsed. Once someone passes two to three times the median gap, move them into win-back campaigns with a reason to return, not just a bigger coupon.
  6. Automate what works. Map each entry product to what it leads to, then turn that into journeys. That's how we set up the journeys at the brands I work with. My retention marketing guide shows how the pieces fit.

Where I fit

Most brands I speak to can't tell me their retention rate, because nobody has decided what "active" means for their category. Compound Lab is a retention agency, and setting that definition, then building the journeys that move it, is the job. Book a 30-minute call and we'll work out your lapse window and your real retention rate together.

FAQ

What is a good customer retention rate? There's no single good rate, because it depends on your category and the window you measure. Klaviyo puts a good repeat purchase rate at about 20% to 30%, and refill brands should sit higher than durable brands. The most useful comparison is your own cohort over the same window, year on year.

How do you calculate customer retention rate? Take the customers you had at the end of the period, subtract the new customers you won during it, divide by the customers you had at the start, and multiply by 100. For example, (11,200 minus 4,000) ÷ 10,000 gives a 72% retention rate.

What is the churn rate formula? Churn rate is the customers you started with minus those still active at the end (excluding new customers), divided by the starting customers, times 100. It equals 100 minus a correctly calculated retention rate. For D2C brands, a customer counts as churned once they go two to three times the median gap between orders without buying.

What is the difference between churn and retention? Retention is the share of your starting customers who are still active at the end of a period, and churn is the share who lapsed. Together they add up to 100% when new customers are left out of the calculation.

What is the customer retention rate formula in Excel? With start customers in B2, end customers in B3 and new customers in B4, use =(B3-B4)/B2 and format the cell as a percentage. Don't also multiply by 100, or the sheet will show 7200% instead of 72%.

What is a good churn rate for ecommerce? Ecommerce churn has no cancel event, so it depends on how you define a lapsed customer and the window you use. Define lapsed as two to three times your median gap between orders, then compare your churn rate against your own previous periods rather than SaaS benchmarks. If you want help setting that definition, Compound Lab offers a 30-minute consultation.

What does 80% retention rate mean? It means 80 of every 100 customers you had at the start of the period were still customers at the end, not counting anyone new. For a repeat-purchase brand, define "still a customer" as having bought within your lapse window, or the number means little.

What does a 5% churn rate mean? It means you lost 5 of every 100 customers in the period. A monthly 5% compounds, so it's far worse than it sounds over a year. In D2C, check how you defined a lost customer before comparing your number with anyone else's.

What is the KPI for customer retention? The core retention KPIs for D2C are repeat purchase rate, the gap between orders, returning customers' share of orders, churn defined by inactivity, and LTV on margin. Read them together; any one alone can mislead.


Not sure what your real retention rate is? Book a 30-minute call.

Next postLTV:CAC Ratio for D2C: Formula, Payback, ₹ Example (2026)

Your customers already paid once. Make them pay again.

Book a Consultation