No-show
No-show meaning: what counts as a no-show, and what does not
A no-show is a customer who books an appointment and then neither arrives nor cancels beforehand. It is the most expensive appointment outcome a dealership has, because the lead cost, the appointment set and the held slot are all spent before anyone finds out the appointment failed.
UK service departments often log it as a DNA, short for did not attend. Missed appointment and failed appointment mean the same thing.
What counts as a no-show, and what does not
Most reporting trouble starts here, because four different outcomes get filed under one label:
- A true no-show. No contact, no arrival, slot burned. This is the one worth managing.
- A cancellation. The customer told you in advance. You got the slot back and can resell it. Different problem, different fix.
- A reschedule. Moved before the slot and attended later. The commitment held, the date moved.
- A partial attendance. They arrived late, or someone else arrived on their behalf, or they came in for something other than what was booked.
Separate these at the point of logging, never at the point of reporting. Once they are merged in a CRM field nobody can unpick them, and the weekly meeting ends up discussing a number four times bigger than the actual problem.
How is the no-show rate calculated?
No-show rate equals true no-shows in the period, divided by appointments set in the period, times 100.
Note what this does not equal. No-show rate is not 100 minus your appointment show rate, and treating it that way is one of the most common errors on a dealership dashboard. The gap between the two is made up of cancellations and reschedules, which are recoverable outcomes with completely different causes.
No-show explained: a worked example
A service drive books 240 appointments in a month. 158 customers arrive on the day. 34 cancel with notice, 26 call to move to a later date and then attend, and 22 simply never appear and never make contact.
The true no-show rate is 22 divided by 240, which is 9.2 percent. A report that treats every non-arrival on the day as a no-show prints 34.2 percent instead. That is the difference between a healthy shop with a small confirmation gap and a shop that looks like it has lost control of its diary.
What a no-show actually costs
In sales the visible cost is the lead, but the real cost is the sales slot held for a customer who was never coming while another buyer was told the diary was full. In service it is worse, because a booked slot carries an ordered part, an allocated technician and a bay that stays empty at full fixed cost. Repeat no-shows also drag on CSI, since the customers who miss appointments are usually the ones already drifting away.
Do reminders actually work?
Yes, and the strongest evidence comes from healthcare rather than automotive, where the studies are randomised and the outcome is the same behaviour. A Cochrane review summarised by the American Academy of Family Physicians pooled four randomised trials covering 3,547 participants and found text message reminders improved attendance over no reminder at all, with a risk ratio of 1.10 (95 percent confidence interval 1.03 to 1.17). The same review found text and phone-call reminders performed similarly, while the cost per attended appointment for text was only 55 to 65 percent of the phone call.
A 10 percent relative improvement is real, and it is also modest. Reminders are a floor, not a cure. What they cannot do is give a customer a reason to want to be there.
How no-show rate gets gamed or misread
- Reclassifying after the fact. The advisor marks it a cancellation the next morning because it feels better on the board. The number improves, the slot is still gone.
- Deleting the appointment. The cleanest way to make a no-show disappear, and the reason no-show counts sometimes fall while the diary gets emptier.
- Overbooking to cover it. Double-booking the risky slots hides the rate and creates a waiting room problem instead.
- Counting the reschedule as a new appointment. One customer, two entries in the denominator, an artificially lower rate.
- Reading the average. No-shows cluster hard by slot time, lead source, day of week and days-out from booking. The average almost never points at the cluster.
- Treating it as a customer problem. No-shows correlate with how far ahead the booking was made and how well the customer understood what was going to happen. Both of those are yours to change, and the second one is usually where the follow-up cadence stopped short.
