Why patients were missing appointments, and what fixed it
The question
Two clinics were running a 14.7% no-show rate and losing about $22,000 a month in unused slots. The standing theory was that younger patients and longer drives explained it.
What I did
Cleaned 18 months of scheduling data, 22,400 appointments, into one table with reminder history attached. Tested age, distance, insurance type, appointment type, day of week, lead time and reminder timing. Age and distance explained almost nothing. Lead time and reminder timing explained a lot: appointments booked more than 21 days out with a single reminder were missed nearly three times as often.
What changed
I recommended two reminders, 48 hours and 4 hours before, for any appointment booked more than two weeks ahead. Operations piloted it in two clinics that September.
One reminder Two reminders
What I would do differently: I spent my first two weeks building a dashboard nobody had asked for. The analysis that mattered was a single notebook and one chart.