Calculate Churn Rate: Measure Customer Loss in Your Shop
Every week regulars disappear without you noticing. Churn rate makes the invisible measurable.
Churn rate shows you how many customers your shop loses silently in a month. The problem: attrition hurts only after it's already happened. Nobody announces they're leaving. Here you get the formula, a worked example for a café, and a plan to spot attrition before it hits your revenue.
What is churn rate and why it matters
Churn is the word for customer attrition. Churn rate shows what share of your active customers didn't come back in a given period.
It's the mirror image of customer retention rate. If you keep 85 percent of your customers, your churn is 15 percent.
Large companies with subscriptions measure churn closely. Every cancellation is visible. In a shop there's no cancellation. A guest simply stops coming without you noticing. That's exactly why this metric is so valuable for small businesses: it makes the invisible measurable.
The formula: how to calculate churn rate
Churn rate = lost customers in period ÷ active customers at start of period × 100
For the calculation to work, you need three definitions:
- Time period: Month or quarter. Shorter than a month is too noisy for shops.
- Definition of active: A customer is active if they visited at least once during the time window.
- Definition of lost: A customer is lost if they haven't come back longer than your time window.
The time window depends on your industry. A café guest who doesn't come for 30 days is probably gone. A barber customer who doesn't come for 30 days is completely normal. Their cycle is six to eight weeks.
Rule of thumb: Set the window to about 1.5 times the normal visit interval.
Example calculation: churn rate in a café
A café runs a digital stamp card. On June 1st, 240 cards were active (scanned at least once in May). In June, 204 of those 240 cards were scanned again. 36 cards had no scans all month.
The calculation:
Churn rate June = 36 ÷ 240 × 100 = 15 percent
So the café lost 15 percent of its regular customer base in June.
New customers who came for the first time in June don't appear in this calculation. They belong in the new customer count, not in churn.
Now it gets interesting when you translate the number to euros. Say an active guest spends an average of €18 per month (four visits at €4.50 each). Then those 36 lost guests cost you €648 in monthly revenue. Permanently, until they're replaced.
How much a single customer is worth over their entire lifetime as a customer is calculated in the article on Customer Lifetime Value.
Why 15 percent monthly churn is more dangerous than it sounds
15 percent per month sounds harmless. Over twelve months it means: without new arrivals, less than one-fifth of your regulars today will remain.
The table below shows how different monthly rates add up if no new customers arrive:
| Churn per month | Remaining customers after 6 months | Remaining customers after 12 months |
|---|---|---|
| 5 percent | around 74 percent | around 54 percent |
| 10 percent | around 53 percent | around 28 percent |
| 15 percent | around 38 percent | around 14 percent |
| 20 percent | around 26 percent | around 7 percent |
These numbers are pure math, not a forecast for your shop. But they show: every percentage point less churn has a big impact. You need far fewer new customers to maintain the same regular customer base.
And winning new customers costs much more time and money than keeping regulars.
Self-test: do you spot attrition early enough?
- You know which regulars haven't been in longer than usual.
- You see whether a guest comes back after their first visit.
- You can react before a customer leaves for good.
- You know whether a price increase drives customers away.
- You spot whether a specific segment (e.g., lunch guests) is declining.
If you answered no to more than two points, you're probably losing regulars without noticing.
Early warning signs: how to spot attrition before it happens
Churn rate is a rear-view metric. It tells you what happened last month. To react sooner, watch for early warning signs:
1. Visit intervals get longer. A guest who came every five days and now takes ten days off is a candidate. A dashboard with timestamps per scan shows this immediately.
2. The card stays half full. Seven of ten stamps, then nothing. This is exactly where a friendly nudge pays off because the reward is so close.
3. A specific segment drops off. If almost only lunch guests disappear, something may have changed in the neighborhood. Maybe a new food shop opened.
4. After a price increase. Watch churn especially closely in the two months after.
With paper stamp cards you see none of this. With a digital card in Wallet you see each customer's last visit and can react automatically. A win-back message after 14 days without a scan reaches the guest on their lock screen before they're gone for good.
How to set up such a reactivation campaign is covered in the article Win Back Inactive Customers.
Three mistakes when measuring churn rate
Mistake 1: counting new customers. Someone who came for the first time in the period can't have churned yet. Count only customers who were already active at the start of the period.
Mistake 2: time window too short. If a café guest counts as lost after just ten days, you get a way-too-high churn rate. You react to guests who were simply on vacation.
Mistake 3: only looking at the total. A 12 percent churn could be 5 percent among regulars and 40 percent among first-time visitors. The second number is the real problem. It needs a different solution: a better second visit.
Set up measurement in 15 minutes
You don't need a spreadsheet if your stamp card is digital.
Set your time window (café: 30 days, barber: 90 days). On the first of the month, note the number of active cards. On the first of the next month, check how many of those cards had no scans since then. That ratio is your churn rate.
By the third month you'll see a trend. If the rate rises, look for the cause in your segments. If it falls, your retention is working.
To check whether a single measure really caused the change, use a control group. Otherwise you'll end up taking credit for nice weather.
What happens if you do nothing
Without measurement, you only notice attrition when revenue drops. By then it's too late for win-back. Customers are already regulars somewhere else.
You replace lost regulars with expensive new customer ads instead of stopping attrition. That costs more time and money than an automatic win-back message.
You don't know whether a price increase, menu change, or new competitor is driving customers away. You react blind.
Conclusion
Churn rate is the most honest metric for small shops. It shows what revenue still hides. Calculate it monthly, adjust the time window to your industry, and especially watch for early warning signs in individual customers.
With a digital stamp card you have the data automatically. Including a win-back message before the guest leaves for good. With stampa you start free, up to 100 active customers and no credit card needed.