Measuring filled slots: how to track cancellation recovery
Most practices can tell you how many cancellations they had last month. Very few can tell you how many of those slots were filled again, by whom, and what they were worth. That second number is the one that measures recovery. Without it, every effort to fill openings is a guess.
- The core metric is the fill rate: refilled slots divided by refillable slots that opened.
- Define "refillable" up front, for example cancellations with at least two hours' notice.
- Log every opening and its outcome, with source and dollar value, so recovery is itemized rather than estimated.
- Pair fill rate with time to first offer and dollars recovered to see both speed and value.
Why counting cancellations isn't enough
A cancellation report tells you how many slots opened. It doesn't tell you whether anything happened next. Two practices with 50 cancellations a month can be in very different positions: one refills 35 of them, the other refills 8.
Measuring filled slots also protects you from a common trap. When a team works hard to fill openings but nobody counts the results, the work is invisible, and it's the first thing dropped on a busy day. A number on the wall changes that.
Define your terms
Before you count, write down three definitions:
- Opened slot: a booked appointment time freed by a patient cancellation, reschedule or no-show.
- Refillable slot: an opened slot with enough notice to realistically fill, for example at least two hours before the start time. No-shows are usually not refillable, but you can still count them for the rebooking metric.
- Filled slot: a refillable slot later booked with a patient who arrived and was seen. Booked but no-showed again doesn't count.
The metrics that matter
- Fill rate = filled slots / refillable slots x 100. The headline number.
- Time to first offer = minutes from when a cancellation was received to when the slot was first offered to another patient. Speed drives fill rate.
- Fill source mix = share of fills from your short-notice list, from moving patients up, from overdue patients, or from new callers.
- Dollars recovered = the sum of the visit value of every filled slot.
- No-show rebook rate = share of no-shows rebooked within seven days. A companion metric for slots that couldn't be refilled.
A simple weekly log
You don't need special software to start. A spreadsheet with one row per opened slot works. Columns: date and time of the slot, provider, visit type, time notice was received, refillable yes or no, time first offered, filled yes or no, fill source, and visit value.
At the end of each week, total it. Here is an illustrative week for a single-location practice:
Opened slots: 22. Refillable: 16. Filled: 10. Fill rate: 10 / 16 = 62.5%. Median time to first offer: 35 minutes. Fill sources: 6 from the short-notice list, 3 moved up from later appointments, 1 overdue patient. At an average visit value of $160, dollars recovered: $1,600.
Over a quarter, those weekly lines become a trend you can manage.
Who owns the number
A metric without an owner drifts. Give one person, often the front-desk lead or office manager, responsibility for the weekly total. Their job isn't to fill every slot personally. It's to make sure every opening is logged, every refillable slot gets an offer, and the week's numbers are shared at a regular huddle.
Keep the huddle short. Three numbers on a whiteboard or a shared screen are enough: fill rate, median time to first offer and dollars recovered, each next to last week's figure. Then one question: what got in the way of the slots we didn't fill? The answers, such as a voicemail box nobody checked until noon or a stale list, become next week's fixes.
Celebrate the dollars. When a team sees that their quick offers brought back $1,600 in a week, filling openings stops feeling like extra work and starts feeling like part of the job.
Getting the data from your schedule
Much of the log can come from your schedule export, if statuses and timestamps are recorded consistently. The tricky part is linking a fill to the cancellation it replaced. Two habits make it easy: note in the booking comments that an appointment filled a cancelled slot, and record the cancellation time when it's received, not at the end of the day.
Watch for double counting. If a patient is moved up from Thursday to Tuesday, the Tuesday slot is filled, and Thursday becomes a new opened slot. Count each slot once, at its final outcome.
Reading the numbers
Low fill rate with slow time to first offer points to process: cancellations sit in a voicemail or inbox too long. Low fill rate with fast offers points to the list: candidates are stale or poorly matched. A fill source mix dominated by one channel suggests the others are underused.
And always look at dollars recovered. A fill rate is a percentage; dollars are what a practice owner can compare against the cost of staff time or a recovery tool. If your process recovers $6,000 a month, that's the benchmark any change has to beat.
Every filled slot, itemized
DocsMD detects openings from the schedule export your EHR already produces, offers them to patients who want an earlier visit, and records the result. Every recovered visit is itemized in a weekly report with the patient, date, action and dollar amount, and the Recovery Guarantee is simple: at least two times your monthly fee recovered every month, or the next month is free. See how the loop works.
Questions
What is a good fill rate for cancelled appointments?
It depends on your notice window, visit types and patient base. Measure your own baseline for a month, then aim to raise it with faster offers and a better-matched short-notice list.
Should no-shows count in the fill rate?
Usually not, since a no-show gives no notice. Track them separately with a no-show rebook rate.
How do we calculate dollars recovered?
Add the visit value of each filled slot where the patient arrived and was seen. Use collected revenue per visit rather than billed charges.
What if a filled slot also no-shows?
Don't count it as filled. Count only refilled slots where the patient was actually seen.