Lead time is two timestamps your record system already holds
Every appointment has the moment it was created and the moment it started, and lead time is the second minus the first, in days. The export needs both timestamps, the treatment, the provider, the source if the system records one, and whether the visit was completed. A reschedule needs one rule, from the original booking or from the last change, and the sheet says which. Cancellations and no-shows stay out of this read and go into the no-show guide instead.
The distribution tells you what the average hides
An average lead of twelve days can describe a practice where half the book fills the same week and the other half books a month out. The front desk needs to know which half is which. Read the median, the share booked within two days, and the share booked more than thirty days ahead. The short end decides how many slots to hold open this week; the long end decides how far out the comeback message has to land.
Cut it by treatment, by provider, by day and by source
| Cut | A short lead says | A long lead says | What the front desk does with it |
|---|---|---|---|
| By treatment | Decided on impulse or on a flare-up; the slot has to exist that week | Planned around a cycle or an event | Hold short-lead slots open for the impulse treatments; book the cyclical ones at the chair |
| By provider | Dana's book fills late and is open to whoever calls | Dana's book fills a month out and new patients get the other provider | Route new callers to the provider with the short lead; protect the long-lead book from reschedules |
| By day and hour | Weekday mornings fill in the last two days | Saturdays and evenings fill three weeks out | Open the waitlist on the long-lead days first; where a deposit goes, with terms counsel has read, the long-lead slots come first |
| By source | Ad and social leads book for this week or not at all | Returning patients and referrals book the next cycle | Answer the ad lead in minutes with a time this week; send the comeback message before the long window closes |
| New against returning | A first visit is booked close to the decision | A returning visit is booked from the chair or from the reminder | Measure the two apart; one number for both tells the desk nothing it can use |
What the spread tells the front desk
- Slots to hold: if a quarter of neurotoxin visits, tox from here on, were booked inside two days, a quarter of this week's tox capacity stays open on Monday morning.
- Next available: Priya reads the lead time by provider before quoting a date, so the caller who wants Dana hears the honest wait and the open alternative in one sentence.
- Waitlist and deposit: long-lead slots are worth both, because a cancellation there is a slot that took three weeks to fill. Confirm deposit terms with counsel.
- Reminder timing: a visit booked a month out needs the confirmation near the visit; a same-week booking needs the reminder the night before.
What the spread tells the comeback calendar
The comeback message has to arrive before the patient would book on their own, by at least the lead time they show. If your tox patients book two weeks ahead and the interval your medical director plans around is three months, the message lands at ten weeks, not at twelve. The interval and the lead time come from the same export, read per patient, and together they place the message on the day it will be acted on.
A worked example, labeled illustrative
Say the export shows a median lead of sixteen days for Dana's tox patients in this illustrative example. One visit in five in this example was booked inside two days and one in ten more than six weeks out. The new provider's tox median in the same example is three days with nothing booked beyond two weeks. The front desk now knows two things: Dana's book needs the waitlist and the early comeback message, and the new provider's book is where this week's callers go. Say laser sessions show a median of twenty-one days and almost no short-lead bookings: those are booked at the chair, so an open laser slot this week is a cancellation. Replace every figure with your own.
How to pull it on Monday
- Export twelve months of appointments with created timestamp, start timestamp, treatment, provider, source and status; keep completed visits.
- Add a column for lead time in days, and one for the day and hour the booking was made.
- Build four pivots: median lead by treatment, provider, day of the visit and source, each with the share inside two days and beyond thirty.
- Count next week's open slots by provider against the short-lead share; the gap is what to hold or what to fill.
The weekly read, in ten minutes
- Bookings made last week and their lead time: a growing short end means the phone and the ads are working; a shrinking one means the book is filling from the chair.
- Share of next week already booked, by provider, against the same week last year.
- Open slots in the next fourteen days against the short-lead share; hold what the export says will fill and push the comeback message at the rest.
- A provider whose lead time moved more than a week either way: a conversation, not a trend, until it repeats.
What to do next
NorthCore's Fill the calendar solution books the short-lead caller into the calendar you already run, and Time the comeback places the message by each patient's own interval and lead time. Both are scoped in writing and covered by the promise on this site: results in 90 days, or we keep working until you have them.
