Blog · Board and management reporting · Healthcare
Patient access analytics compares appointment lead times, available slots and attendance from aggregate scheduling reports. Define the appointment and referral cohorts, work the measures, and reconcile the denominators before acting.
Patient access analytics compares appointment waits, available capacity and attendance to find where scheduling needs attention. Build the report from aggregate clinic exports with a separate denominator for each question. A booking lead time, a slot fill rate and a referral conversion rate describe different parts of access and should remain distinct.
Start with three questions: how long newly booked appointments wait, how much released capacity is used, and what happens to eligible referrals. Keep the scope to scheduling operations. These figures do not determine urgency, treatment or the appropriateness of a visit.
The VA's Access to Care site presents appointment wait times and availability by specialty alongside other information. That separation is useful for an internal report too: one clinic-wide average should not hide differences between appointment types. Compare like service groups before ranking locations.
Use medical practice analytics for the separate connection to earned revenue and operating costs. A higher slot fill rate alone does not establish that a practice is financially stronger.
Ask scheduling for aggregate counts by clinic, period and comparable appointment type. Document the following fields before calculating:
| Report | Required fields | Date basis |
|---|---|---|
| Capacity and attendance | Released slots, booked appointments, completed visits, no-shows, cancellations | Appointments due in the reporting period |
| Booking lead time | Newly booked count, summed calendar days from booking to scheduled appointment | Bookings created in the reporting period |
| Referral outcomes | Eligible referrals, booked referrals, closed without booking, still open | Referrals received in a defined cohort, observed at one cutoff |
The attendance and booking cohorts will usually contain different appointments. A visit due this month may have been booked earlier; a booking made this month may be due later. Do not force the counts to match by deleting rows.
No individual records are needed in the comparison file. Have the responsible data owner approve the aggregate export and its level of detail before using it. Preserve definitions with the report so the next month uses the same scope.
This illustrative US clinic group compares equivalent appointment slots in one reporting month. A booked appointment due in the month has exactly one final outcome at cutoff. Earlier cancellations that released capacity for a replacement booking are excluded from this final slot-based reconciliation.
| Clinic | Released slots | Booked appointments | Completed visits | No-shows | Final cancellations |
|---|---|---|---|---|---|
| East | 1,000 | 900 | 810 | 54 | 36 |
| West | 800 | 640 | 576 | 32 | 32 |
| Total | 1,800 | 1,540 | 1,386 | 86 | 68 |
Booking fill rate = Booked appointments / Released slots
Completed capacity rate = Completed visits / Released slots
No-show rate = No-shows / Booked appointments
| Clinic | Booking fill rate | Completed capacity rate | No-show rate |
|---|---|---|---|
| East | 90.0% | 81.0% | 6.0% |
| West | 80.0% | 72.0% | 5.0% |
| Total | 85.6% | 77.0% | 5.6% |
Percentages are rounded to one decimal after calculation. East's no-show rate is 54 / 900 = 6.0%. West has a lower no-show rate but also a lower booking fill rate, so attendance alone does not explain its capacity result.
The outcome proof is 1,386 + 86 + 68 = 1,540. Check each clinic in the same way. Overall booking fill is 1,540 / 1,800 = 85.6%; averaging the two clinic rates would give each clinic equal weight despite different capacity. The broader capacity utilization method explains why the denominator must stay visible.
Use newly created bookings for the lead-time report, regardless of whether their appointment dates fall in the reporting month. The upstream summary must provide the total lead days as well as the count; an average alone cannot be combined correctly across clinics.
| Clinic | Newly booked appointments | Summed lead days | Mean lead time (calendar days) |
|---|---|---|---|
| East | 800 | 6,400 | 8.0 |
| West | 600 | 6,600 | 11.0 |
| Total | 1,400 | 13,000 | 9.3 |
Mean booking lead time = Summed calendar lead days / Newly booked appointments
West's mean is 6,600 / 600 = 11.0 days. The group mean is 13,000 / 1,400 = 9.3 days, rounded to one decimal. Use the unrounded calculation for later comparisons; the weighted average method explains the same principle.
This measure describes people who obtained bookings. It says nothing about requests still waiting to be booked. If the team needs that question answered, request a separate aggregate open-request report with an explicit start event and cutoff. Do not relabel booking lead time as the complete request-to-appointment wait.
For referrals, choose one received cohort and observe every referral at the same reporting cutoff. Include only eligible referrals under a documented operational definition. Categorize each as booked, closed without booking, or still open.
| Clinic | Eligible referrals | Booked by cutoff | Closed without booking | Still open | Booked share |
|---|---|---|---|---|---|
| East | 120 | 90 | 18 | 12 | 75.0% |
| West | 100 | 60 | 20 | 20 | 60.0% |
| Total | 220 | 150 | 38 | 32 | 68.2% |
Booked share is booked referrals / eligible referrals. The combined figure is 150 / 220 = 68.2%, and the category proof is 150 + 38 + 32 = 220. A newer referral cohort naturally has less time to reach an outcome, so compare cohorts at the same elapsed observation point.
West's scheduling manager now has a defined investigation: lower fill, a longer booking lead time and a lower booked referral share. Review offered appointment types, released schedules, referral handling and the reasons recorded for closure. These summaries identify where to ask; they do not establish the cause.
Scheduling owns slot and outcome definitions. The referral team owns eligibility and disposition counts. Clinic operations owns the action list and checks whether the next comparable report changed after an approved process adjustment. Use a capacity planning report to connect validated demand with available sessions.
Bring your aggregate clinic capacity, booking lead-time and referral summaries to Covirage with their cohort definitions. Covirage maps the columns, its tools compute and check the measures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.
See Covirage for healthcare teams for the supporting industry context.
Appointment lead time is the interval between a defined starting event and the appointment date. For a booking-based measure, start at booking creation and count calendar days to the scheduled visit. A request-based measure starts earlier, so label the definition and avoid comparing them directly.
Use the booked appointments included in the report's attendance cohort, with a clear policy for cancellations and rescheduled appointments. This example divides no-shows by all booked appointments due in the period. Other definitions can be useful, but a changed denominator must not masquerade as improved attendance.
Yes. Aggregate summaries can contain released slots, booked and completed counts, no-shows, cancellations and the summed lead days for a defined cohort. Separate referral totals support a referral review. The business analysis does not require names, individual diagnoses or patient-level scheduling records.
No. An average can hide long waits for a subset of appointment types, and a booking cohort excludes requests that never became appointments. Review comparable service groups, open requests and referral outcomes alongside the average. Scheduling measures also do not replace patient experience evidence.