Skip to content
July 11, 2026·4 min read

How to Calculate Your Customer Repeat Rate Without Expensive Software

A simple formula and a notebook-or-spreadsheet method to find out how many customers actually come back — no pricey subscriptions.

Most local business owners know how many new customers they got this month, but have no idea how many came back. And it's the returning customer who brings steady money — without you paying for ads again to win them over. The good news: you don't need any expensive CRM to measure this. You need a formula and a little discipline.

In this article I'll show you exactly how to calculate your repeat rate, with what data, over what period, and how to gather the information without paying a monthly subscription. At the end you'll also get a simple way to read the number, so you know whether you're doing well or leaking somewhere.

What the repeat rate is and why it matters

Your repeat rate tells you what share of your customers buy more than once within a given period. It doesn't tell you how much each spends — it tells you how often people come back to you.

It matters because a returning customer is far cheaper than a new one: no more ad spend, no convincing from scratch, they already trust you. If most customers come once and vanish, you've got a business you constantly have to refill with new faces — exhausting and expensive.

By measuring this number, you see in black and white whether what you do after the first sale (quality, follow-up, a kind word on the way out) actually brings people back. It's a long-term health signal, not just a snapshot figure.

The formula, step by step

The formula is simple:

Repeat rate = (customers who bought at least twice ÷ total unique customers) × 100

The steps:

  • Pick a clear period: a month, a quarter, or a year. Too short misleads you; too long blurs everything together.
  • Count the unique customers in that period (each person once, even if they came five times).
  • Count how many of them bought at least twice.
  • Divide the second number by the first and multiply by 100.

Say in one quarter you had 120 unique customers and 42 of them came at least twice. 42 ÷ 120 = 0.35, meaning a repeat rate of 35% for that quarter. That's it. You don't need more.

How to gather the data for free

You don't need a CRM. You need a list where you can tell it's the same person again. A few options that work anywhere:

  • A booking or receipt notebook: names and phone numbers tell you who's been before.
  • A simple table in Google Sheets or Excel: one column for the customer (name + phone), a column per visit or one column with the date.
  • The history in your booking app or phone contacts, if you already schedule there.

The key is the phone number or email — that's the "fingerprint" you use to recognize a returning customer. Capture it at every sale, even quickly on paper. Once a month you sit down for ten minutes, count, and calculate. It's not glamorous, but it works just as well as software costing hundreds a month.

How to read the number and act on it

The figure itself means nothing until you compare it against yourself. Measure it a few periods in a row and watch the direction: rising, falling, or flat?

  • If it's falling, something after the first sale isn't keeping people close — quality, how they're treated, or simply that they forget about you.
  • If it's rising, whatever you changed recently is worth keeping and amplifying.

What counts as "good" varies enormously by industry: a salon or café should have a high repeat rate; a wedding photographer almost none — and that's normal. So don't compare yourself to figures from the internet; compare against your own last month. Then act on the real cause: a reminder message, a small gesture on the second visit, consistent quality.

Common mistakes and a hand if you want it automated

A few traps many fall into:

  • Mixing new and returning customers into one pile, so the number comes out falsely inflated.
  • Counting visits instead of people — someone who comes ten times is still one person.
  • Changing the period every time, so you can no longer compare.
  • Giving up after one month. The number only means something tracked consistently.

When you reach the point where the notebook no longer cuts it, a website with a booking form or a small customer database does the calculation for you — without expensive subscriptions. At MPO Web Studio we build exactly these kinds of simple, transparent tools, delivered remotely across the country, with a ready-made demo before you pay anything. If you want a hand, message us on WhatsApp and we'll honestly tell you whether you need it or you're fine with Excel.

Frequently asked questions

What period is best for calculating repeat rate?+

It depends on how often people buy from you. For a café or salon, a month or a quarter makes sense. For services people use rarely, take a full year. The rule is to always use the same period, so you can compare properly.

How many customers do I need for the number to mean anything?+

With very few customers, the figure swings a lot from month to month and can mislead you. There's no magic threshold, but the more you have, the steadier it is. Until then, watch the trend over several months, not a single number.

What's the difference between repeat rate and retention rate?+

They're related but not identical. Repeat rate tells you what share of customers bought more than once. Retention usually tracks whether a specific group of customers is still active after a period. For a local business, repeat rate is simpler and enough to start with.

Can I really manage with just Excel, no software?+

Yes, absolutely. A table with names, phone numbers and visit dates is all you need to calculate this month. Paid software only becomes useful once you have too many customers to count by hand or want it all automated — not before.

Free guide

7 mistakes that drive clients away from your website

Leave your email and get the guide right here, instantly. No spam.

By submitting, you agree to the Privacy Policy.
MThe MPO teamWe reply personally

Want to see what your business's website could look like?

Message us on WhatsApp and we'll build you a free demo website with your business name on it. See it first, then decide — no strings attached.

Ask for a free demo websiteWe usually reply within a few minutes