Reducing unused appointment slots

Dental clinic network

Decision studied

Fill schedules better without spending more on advertising.

The engagement covered eight pilot clinics, where 14% of appointment slots went unused. The choice was between an extra advertising campaign and better appointment scheduling.

Approach

  1. 01

    Frame

    The goal was to make better use of schedules, with an initial budget of $24,000 CAD. The engagement focused on appointment organization, without changing the care provided.

  2. 02

    Investigate

    Schedules, cancellation reasons and response times showed that openings appeared too late to be offered to patients on the waiting list. Results varied from one clinic to another.

  3. 03

    Explain

    Two explanations were examined: demand that was too weak, or a replacement process that was too slow. The existence of a waiting list in several clinics supported the second.

  4. 04

    Build

    We compared more advertising, additional time slots and a process for replacing cancellations, with current operations as the comparison group.

  5. 05

    Test

    The process was tested in two clinics, and two others were tracked for six weeks. The threshold set in advance was a further three-point drop in unused slots, with no increase in complaints. The tested sites went from 14% to 10%, the others from 14% to 13%.

  6. 06

    Decide

    Management extended the process to four more clinics, with a local check before full rollout.

  7. 07

    Steer

    At three months, 26 additional monthly visits were being completed across the network. The projection of 30 remains to be confirmed, and no slots were added beyond planned capacity.

Test results

9%10%11%12%13%14%15%Threshold: 11% (3-point drop)Tested sites14%10%Other sites14%13%
Share of unused time slots before (grey) and after (terracotta) the test. Tested sites go from 14% to 10%, the others from 14% to 13%.

What AI contributed

AI sorted the anonymized cancellation reasons and compared response times across clinics. Teams checked each proposed appointment and the availability of practitioners.

Business model (projection)

The projection assumes 30 additional visits a month and a contribution of $160 per visit after variable costs. New recurring costs amount to $9,600 a year.

Annual projection for this case
Initial investment$24,000 CAD
Annual gains$57,600 CAD
Costs to subtract$9,600 CAD
Net annual gain$48,000 CAD
Simple payback6 months (at steady state)
Prudent scenario$19,200 CAD net, payback in 15 months

Annual projection built from the results of the engagement. It is not a guarantee of performance.

A comparable challenge?

Describe the decision to make and the data available. I will suggest an approach to prepare it and the evidence to gather before deciding.

Let's talk strategy