Hospital Daily Dashboard · run #312
Who was seen, who didn't show and what the payer sent back
Document published by the Squad at the end of the 6:10 AM run, covering this week's outpatient activity and the open billing cycle.
period current week
source api_get_daily_funnel
run #312
01The three fronts at a glance
The official number took roughly 23,000 conversations this month, 78% of which ended without anyone from the team entering the chat. The outpatient schedule published 2,500 slots this week and closed at 86% occupancy. In the open billing cycle, the denial rate sits at 4.1% of billed value, against 9.8% at the start of the cycle.
Closed without the team
78%
of ~23,000 conversations this month
Schedule occupancy
86%
was 74% at the start of the cycle
Denial rate
4.1%
of billed value · cycle target: 3%
02What time the conversation arrives
The front desk works from 7:00 AM to 7:00 PM. Adding up the bands outside that range — overnight, evening and late night — 41% of conversations arrive when there is nobody to answer: 8% + 20% + 13%.
Conversations by time of day — the example week
share of the week's total
8%00–07
14%07–10
17%10–13
16%13–16
12%16–19
20%19–22
13%22–24
Within front-desk hours
Outside front-desk hours
Figure 1 — conversations on the official number by time of day. Within hours: 14% + 17% + 16% + 12% = 59%. Outside: 8% + 20% + 13% = 41%.
03From published slot to completed visit
Of the 2,500 slots published this week, 2,150 were booked — that is the 86% occupancy. Against those bookings, the 24% no-show rate accounts for 516 absences, leaving 1,634 completed visits.
Slots published2,500
Booked2,150
No-shows516
Completed1,634
Figure 2 — the week's funnel. 2,500 published × 86% = 2,150 booked. 2,150 × 24% = 516 no-shows. 2,150 − 516 = 1,634 completed.
04Indicators tracked through the cycle
Indicators tracked by the Squad across the three fronts, with the value at the start of the cycle and the value in the current cycle
| Front |
Indicator |
Start of cycle |
Current cycle |
State |
| Patient service |
Conversations closed without the team |
— |
78% |
on target |
| Patient service |
Handoffs to the front desk |
baseline |
−76% |
on target |
| Schedule |
Outpatient schedule occupancy |
74% |
86% |
on target |
| Schedule |
No-show rate against bookings |
35% |
24% |
above target |
| Revenue |
Denial rate over billed value |
9.8% |
4.1% |
above target |
| Revenue |
Billing submission window |
12 days |
2 days |
on target |
| Revenue |
Batches rejected on technical inconsistency |
14% |
0.8% |
on target |
| Indicators on the dashboard — 2 patient service + 2 schedule + 3 revenue |
7 |
2 above target |
What the manager has to decideThe no-show rate fell from 35% to 24%, but this week's 516 absences are still concentrated in bookings made more than 30 days ahead. Opening those slots to the waiting list with early confirmation is a scheduling decision — the Squad does not rearrange capacity on its own.