How to calculate your no-show rate, and what to do with it
The formula, the denominator most people get wrong, the four splits that turn an average into an action, and what a no-show actually costs once you count the gap as well as the slot.
Sohail Safdar · · 6 min read
Most businesses know roughly what their no-show rate is and can do nothing with it, because a single average is not an instruction. The useful version takes about twenty minutes to produce and comes with a fix attached.
The formula, and the denominator that matters
No-show rate = no-shows ÷ appointments still booked at their start time
Use a month at least. A week is too noisy for any business booking fewer than a few hundred appointments.
The denominator is where this usually goes wrong. Dividing by every appointment ever created includes the ones cancelled four days ahead, which were never at risk, and which you had a real chance to refill. Including them makes the rate look better and, worse, makes it insensitive: a month where cancellations rise and no-shows rise together can produce an unchanged rate.
Count what was still on the calendar when the clock reached the appointment. That is the population that could have turned up.
Four things that distort it
Counting cancellations as no-shows. Track late cancellations, meaning inside your notice window, as their own number. They have a different cause and a different fix, and a business with a high late-cancellation rate and a low no-show rate has a policy problem rather than a reminder problem.
Counting a no-show you then recovered. If somebody missed the appointment and rebooked the same week, it was still a no-show: the slot went unused. Record it, and record the recovery separately, because the recovery rate is the number that tells you whether following up works.
Forgetting who never got a reminder. If some of your customers never agreed to be texted, compare their rate against everybody else's. That difference is the value of reminders in your business, measured on your business, which is worth more than any published figure.
Averaging across wildly different services. A 20-minute check and a three-hour colour do not belong in one number, and if your mix shifts between quarters the rate moves without anything changing.
The four splits that turn it into an action
A 9% average is not actionable. These are.
By service. Long and expensive services behave differently from routine ones, and first visits behave differently from repeats. One service carrying the whole rate is the most common finding and the easiest to fix.
By lead time. Appointments booked five weeks out no-show more than appointments booked this week, reliably, because more life happens in five weeks. If your rate is concentrated in long lead times, the fix is a reminder closer to the date rather than a stricter policy.
By booking source. Self-booked online, booked by phone, booked from a text. These differ, and not always in the direction people expect: a customer who booked themselves at 11pm chose the slot deliberately, while one who was offered a time on the phone may have accepted the only one going.
By day and time. Monday mornings and Friday afternoons have their own patterns, and so does the first appointment of the day.
One more if you have the data: by customer history. First-timers against regulars. This is the split that tells you whether a deposit policy should apply to everybody or only to new bookings.
Match the fix to the pattern
| What the split shows | The fix that matches it |
|---|---|
| High for first visits | A day-before reminder with directions, parking and what to bring. First-timers no-show partly because arriving is harder than they expected |
| High for long lead times | A second reminder closer to the date, and a one-tap way to move it |
| Concentrated in one service | A deposit for that service only, rather than a policy for everyone |
| High on one day or one slot | Look at what is different about it before changing anything: the first appointment of the day often fails for a reason about you, not them |
| High among customers with no reminder consent | Ask for consent at every booking, as an unticked box |
| High among repeat offenders | A deposit to rebook after two misses, which protects the schedule without penalising everybody |
The general rule: a reminder fixes forgetting and a policy fixes not caring. Using a policy on a forgetting problem makes customers resent you for something that was not deliberate, and using a reminder on a not-caring problem does nothing at all.
What it costs, with the arithmetic shown
Count the margin, not the price, and then add the gap.
Take a two-hour service at $180 with roughly half of that as margin after product and the practitioner's time. The missed appointment costs the $90 margin. But the two-hour hole at 10am on a Tuesday is also two hours of somebody's wage against no revenue, and it is nearly unfillable at the notice you got, which is none.
So the honest figure is the lost margin plus the cost of the idle time, and for long services the second part is the larger. That is also why the fix for long services is usually a deposit and the fix for short ones is usually a reminder: the economics are genuinely different, not just the inconvenience.
Run it on your own numbers. The answer differs enormously between a 20-minute appointment and a half-day one, which is precisely why a single industry benchmark cannot help you.
What good looks like
Not a number. Anything you find quoted as an industry average is somebody else's mix of services, lead times and customers, and comparing against it will either worry you unnecessarily or reassure you wrongly.
The comparisons that mean something:
- Your own last quarter. A falling rate is good news whatever its level.
- Your own best service against your worst. That gap is the size of the opportunity.
- Your reminded customers against your unreminded ones. That gap is the value of fixing consent collection.
Two things not to do
Overbooking. It works for airlines because they have thousands of seats a day and a statistical distribution. A practice with eight slots and a 9% rate that overbooks is buying a guaranteed angry customer at some point in exchange for an average gain, and the angry customer is the one who posts about it.
Charging a fee you cannot collect. A no-show fee with no card on file is a warning rather than a policy, and a policy everybody knows is unenforced teaches customers that none of your policies are real. Cancellation policy examples covers what is enforceable.
In Frontiva
An appointment can be marked as a no-show on the bookings screen, and the button only appears once the start time has passed, because a no-show is a thing that happened rather than a prediction. The full appointment history records who marked it and when, alongside who booked it and who moved it.
appointment_no_show is also an automation trigger, so a missed appointment can start a follow-up on its own: a message that offers a rebooking rather than a reprimand is the version that recovers the customer.
24-hour and 2-hour SMS reminders are armed at the moment the appointment is created, and they go only to customers who agreed, with nothing back-filled, so an appointment booked before consent was recorded shows a "no consent" skip rather than silently sending nothing. That skip is useful here: it is the list that tells you where your consent collection is leaking. Analytics reports appointments booked against the previous period, and reducing no-shows with appointment reminders covers the reminder side in detail.