Why is our no-show rate 22%?
The 22.4% rate combined three different events; the unrecovered no-show rate was 11.4%.
What went in
- Files
- 3
- Rows
- 26,066
- Period
- Jan 5 – Jun 30
- Verification
- 21 checks passed
Source files
- appointments_jan_jun.csv14,206 rows
- clinician_rota.xlsx18 rows
- reminder_log.csv11,842 rows
What came back
- 11.4%
- 24.00
- $340,000
The finished project
appointments_jan_jun.csv
14,206 rowsCheckedThe no-show rate is not 22%, and what remains is caused by your own booking horizon.
The 22.4% figure the practice reports adds three unlike events together: appointments nobody attended, late cancellations whose slot was re-filled, and changes the clinic made itself. Separated, the unrecovered rate is 11.4%. Almost all of it sits in appointments booked more than a month ahead, which miss at 3.9 times the rate of appointments booked within a week — and the overbooking used to absorb missed appointments is what pushes routine bookings out that far.
11.4%Unrecovered no-shows+0.8pp
78.0%Slot utilisation−2.1pp
24.00Median lead time+26.3%
How far ahead it was booked predicts whether anyone comes
3.9× the rate of an appointment booked this week
- 01The 22.4% rate adds three different events together.
- 02Appointments booked over a month ahead miss at 3.9 times the rate.
- 03Overbooking to cover no-shows is manufacturing the next ones.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.