LiftSignals is live. Every plan starts with a 30-day free trial — no credit card required. Start free →
Free tool · coming soon

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.

PREVIEW · EXAMPLE NUMBERS

Coming soon
1,000
1,070
350
Churn rate28%

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.

01

Customers kept1,070 at the end − 350 new

720

02

Retention rate720 ÷ 1,000 at the start

72%

03

Customers lost1,000 − 720

280

04

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.

AB
1Customers at start1000
2Customers at end1070
3New customers350
4Retention rate=(B2-B3)/B1
5Churn 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.