Churn rate calculator
A free customer churn rate calculator for online stores is coming soon. Meanwhile, here’s the churn rate formula, its partner the retention rate formula, a worked example and a spreadsheet you can use right now.
One email when it launches. No newsletter.
The formula
The customer churn rate formula.
Churn rate = customers lost ÷ customers at the start
Retention rate = (end − new) ÷ start
- Customers at the start
- Active customers on the first day of the period.
- Customers at the end
- Active customers on the last day of the period.
- New customers
- First-time customers acquired during the period. They’re removed so growth doesn’t hide losses.
- Customers lost
- Start − (end − new). In ecommerce, “lost” means no order within their expected window.
Worked example
Customer churn rate, step by step.
Illustrative six-month period for the same store used across our site.
Customers kept1,070 at the end − 350 new
720
Retention rate720 ÷ 1,000 at the start
72%
Customers lost1,000 − 720
280
Churn rate280 ÷ 1,000
28%
Use it today
The churn rate formula in a spreadsheet.
Fill in column B for any period: a month, a quarter or a year.
| A | B | |
|---|---|---|
| 1 | Customers at start | 1000 |
| 2 | Customers at end | 1070 |
| 3 | New customers | 350 |
| 4 | Retention rate | =(B2-B3)/B1 |
| 5 | Churn rate | =1-B4 |
Works the same in Excel and Google Sheets. Formulas in orange.
Where the simple version breaks
Why a churn rate alone can’t save a customer.
It arrives after they’re gone
A churn rate counts customers who already left. By the time it moves, the chance to win them back has passed.
“Lost” is fuzzy in ecommerce
Nobody cancels a store. Whether someone churned depends on how long you wait, so the rate changes with the cut-off you pick.
It treats every customer the same
Losing 280 one-time buyers and losing 280 regulars give the same percentage and very different revenue.
LiftSignals predicts which customers are about to stop buying, measured against each one’s own rhythm. Customer churn prediction →
FAQ · churn rate calculator
Churn rate calculator questions, answered.
What’s the difference between churn rate and retention rate?
They’re two sides of the same number: retention is the share of starting customers you kept, churn is the share you lost. Together they add up to 100%.
Why subtract new customers from the end count?
Otherwise strong acquisition can hide losses. A store can grow its customer count while losing a third of its existing customers.
What counts as a churned customer for an online store?
Usually a customer with no order within a set window, such as 180 days. A better test is no order well past their own usual gap between orders.
When will the churn rate calculator launch?
Soon. Leave your email above and we’ll send a single note when it’s ready.
Should I measure churn monthly or yearly?
Use a period longer than your typical reorder cycle. For most stores, quarterly or yearly gives a steadier number than monthly.
MORE FREE TOOLS ON THE WAY
Coming soon
CLV calculator →
Predict what a customer is worth over their lifetime.
Coming soon
RFM analysis tool →
Score customers on recency, frequency and spend.
Coming soon
LTV:CAC calculator →
Is each customer worth what you paid for them?
Coming soon
Holdout sample size calculator →
How many customers a fair test needs.
See who’s about to churn, not just how many did.
LiftSignals scores churn risk for every customer, nightly. 30 days free.