Why is our no-show rate 22%?
- Files
- 3
- Rows
- 26,066
- Checks passed
- 21
Unrecovered no-shows
11.4%
Median lead time
24.00
Unfilled slot value
$340,000
What went in
Jan 5 – Jun 30
- Project
- Appointment book: January to June
- Subject
- Customers
- Rows
- 26,066
Source files
- appointments_jan_jun.csv14,206 rows
- clinician_rota.xlsx18 rows
- reminder_log.csv11,842 rows
The finished example
Demonstration data we built, not a customer's file.
Rendered by the same components that render your own projects.
The 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.
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
Ranked by how many subjects they share with this project.
Customers · 24,680 rows
5,510 people were stored as 6,214 records, depressing reported retention by 10.9 points.
Why does donor retention look worse than it is?
Customers · 1,857 rows
The apparent 0.42-point gap fell to 0.07 once partial responses were included.
Is the difference between customer groups real?
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.