Identify High-Value Unscheduled Cases for Targeted Outreach
DentalSuite Team7 min read
Identify High-Value Unscheduled Cases for Targeted Outreach
Unscheduled treatment sits on the schedule and in the treatment plan ledger as missed revenue until someone turns it into an appointment. To identify high-value unscheduled cases and focus outreach where it actually recovers dollars, rank each open item by expected recovered production — the product of the procedure’s estimated production and its schedule-conversion probability. That single metric tells the front desk and the clinical lead which patients to call first each morning.
How to identify high-value unscheduled cases
Two inputs create an operational ranking: an expected production figure for the procedure and a conversion-probability score for the patient + procedure combination. Expected recovered production = expected production × conversion probability. Use that number to sort your daily call list and to pick the top 5–10 items to discuss in the morning huddle.
Estimated production: use the fee the practice expects to post if the case schedules and completes. If the fee is dependent on insurance, use the patient’s estimated portion plus the scheduled production to avoid inflating expectations. If the practice hasn’t posted a fee, run a quick reconciliation process before calculating (see reconcile-posted-production-daily-close-unbilled-work).
Conversion probability: score each unscheduled case on the factors that affect whether a patient will schedule and keep the appointment. Combine these into a single probability number between 0 and 1. Common components to include:
- Time since treatment plan was presented (recency). Older plans convert at lower rates. Use bands: 0–14 days, 15–60, 61–180, 181+ and assign decay weights.
- Financial readiness: outstanding balances, whether pre-authorizations or payment arrangements exist, and whether a prepayment or deposit is required.
- Appointment availability: days/times available for the specific provider and procedure. If schedule gaps exist in the immediate 7–14 day window, conversion probability rises.
- Care complexity and chair-time: longer/more complex procedures need double-confirmation and often have lower conversion probability in the short term.
- Insurance status: whether authorization is required or insurance confirmation is pending. Pending issues reduce short-term conversion probability; prioritized insurance follow-up can increase it (see prioritize-insurance-follow-ups-daily-cut-aged-claims).
- Patient behavior history: prior cancellations, no-shows, responsiveness to reminders, and recall history. Use a simple multiplier for repeat no-shows.
- Provider utilization and preferences: if the procedure requires a specific provider who is currently overscheduled, conversion probability drops unless additional capacity is created.
Convert those components into a formula the front desk can use. Example (illustrative): base probability 0.6 × recency multiplier 0.8 × financial readiness 0.9 × availability 0.7 = 0.302. Multiply 0.302 by the estimated production to get expected recovered production (for example, $1,200 × 0.302 ≈ $362). Rank daily lists by that result.
Daily workflow to identify high-value unscheduled cases and act
Turn ranking into a routine the team runs every business day. A consistent process keeps the work small and repeatable and ensures the front desk focuses on the best opportunities first.
- Data pull each morning: generate a list of unscheduled procedures that have an approved plan. Include estimated production, date plan presented, patient balance, insurance authorization status, appointment-type required, and last contact date.
- Score and rank: apply the probability multipliers and compute expected recovered production for each row. Sort descending and flag the top 25 items (or top 10 if the practice is small).
- Create a call list: the front desk prints or exports the top 25 into a single call file sorted by expected recovered production. Include a one-line reason for priority (e.g., high production + open week slot).
- Morning huddle: review the top 5 items from the list. Confirm availability, assign owner for outreach, and note any operational blocks (missing pre-auth, outstanding balance, provider unavailable).
- Outreach execution: place outreach calls/texts/emails in order, starting with the highest expected recovered production. Use a short script that states the benefit, proposed time windows, and any financial options. Record the result: scheduled, callback, declined, needs insurance follow-up, or unable to contact.
- Post-call actions: for cases needing insurance follow-up or financial counseling, create tasks assigned to the staff member with a deadline of 24–48 hours. If the case books, update the schedule and mark it as recovered in the daily log. If a callback is promised, move the case to a follow-up queue with a timeout.
- Daily metrics and accountability: the office manager or practice owner reviews the top 25 list’s outcomes at day end and records conversion rate and recovered dollars for the day. Include this in the morning huddle as a KPI (see metrics below).
Assign roles clearly. The front desk owns calls. The clinical lead owns confirming chair-time and any clinical scheduling constraints. The office manager validates numbers and reviews the daily outcomes.
Which KPIs to track so the work scales
Track these numbers daily and report weekly to spot trends and friction points:
- Daily recovered dollars from the unscheduled-case call list (sum of estimated production for newly scheduled cases).
- Conversion rate (scheduled outcomes ÷ total outreach attempts) for the ranked list. Track by band (top 10, top 25, remainder).
- Calls per hour and recovered dollars per hour for the front-desk staff running outreach. That shows if the activity is hitting capacity or needs reallocation.
- Primary failure reasons for non-conversion: financial hold, no appointment availability, insurance authorization, or patient declined. Use these to adjust probability multipliers and to prioritize process fixes.
- Provider utilization: proportion of newly scheduled procedures that fit into existing capacity vs. require overtime or extra shifts. If high-value cases repeatedly require capacity changes, consider adjusting provider schedules or adding dedicated blocks.
Scripts and operational notes for front-desk calls
Keep outreach short and outcome-focused. A script should contain: patient identifier, proposed appointment windows, any deposit or payment options, and the next step if they want to pause. Train staff on three outcomes and how to record them: scheduled, call-back with availability, or needs follow-up (insurance/finance/clinical). Avoid long clinical explanations — the goal is scheduling.
If a patient asks about finances, staff should be able to pull the patient’s estimated portion immediately and offer payment options. If the answer requires a financial counselor, escalate the call to that person or set a 24-hour follow-up task.
How to improve the ranking over time
The ranking formula is a living artifact. Update it on a fixed cadence and use the daily results to refine coefficients.
- Weekly review: reconcile scheduled cases from the call list against posted production to verify your estimated production figures (see reconcile-posted-production-daily-close-unbilled-work and Unbilled Procedures Reconciliation Process for Daily Closure).
- Refine probabilities: every two weeks, compare predicted conversion probability to actual conversions for different bands (recency, financial readiness, provider availability). Adjust multipliers where predictions diverge from reality.
- Address systemic blockers: if insurance authorization or aged claims regularly reduce conversion probability, coordinate with the insurance follow-up team and link to prioritize-insurance-follow-ups-daily-cut-aged-claims.
- Scale staffing: if recovered dollars per hour fall below an acceptable threshold, reassign the task to a higher-performing staff member or dedicate specific times each day to outreach. Document time-on-task and recovered production to build the business case.
Over time, the practice will identify which combinations of factors predict scheduling success. The goal is not perfect prediction but consistent prioritization that focuses limited outreach time on the best revenue opportunities.
FAQ
What data fields do we need to calculate expected recovered production?
You need the estimated production for the procedure, date treatment plan was presented, patient outstanding balance, insurance authorization status, appointment-type and provider required, last patient contact, and basic behavior history (no-shows/cancellations). If any of these are missing, assign a data-completion task before ranking.
Our practice-management system doesn’t provide conversion probability. What then?
Start with simple banded multipliers applied manually or in a spreadsheet. Use recency bands and binary flags for insurance or outstanding balance. You can refine to a weighted formula as you collect outcomes. The important step is using the ranked list to drive daily action, not waiting for perfect automation.
How often should we update the scoring formula?
Review outcomes weekly and update multipliers every two weeks initially. Once multipliers stabilize, move to monthly reviews unless conversion patterns change rapidly.
How do we account for provider capacity when ranking cases?
Include an availability multiplier: if the required provider has open blocks in the next 7–14 days, give the case a higher multiplier. If not, lower the probability or tag the case for scheduling into a different provider or into a new block to avoid repeated failures.
Daily discipline in ranking and outreach turns a backlog of plans into recoverable production. The mechanics are straightforward: estimate production, estimate conversion probability, multiply, sort, call. The work you do in the morning will shape the week’s schedule and the next month’s cash flow.
If the practice already runs weekly recovery activities, this approach nests into that cadence: use the daily ranking to feed the weekly recovery playbook and the unbilled-procedures reconciliation process so fewer cases age into difficult-to-collect work (see weekly-production-recovery-playbook-recovering-missed-revenue).