Service Operations & Client Journey
Synthetic operational dashboard • 18-month referral window • SQL-first analytical workflow
Referrals
3,968
Referral → Intake
85.3%
Referral → Service
66.8%
Avg. Days to Service
12.03
Referral funnel
Referred3,968
Completed intake3,384 · 85.3%
Received service2,652 · 66.8%
Conversion is calculated from referral records, not from completed cases only.
Operational quality
Service SLA among served75.0%
No-show rate16.6%
Cancellation rate8.8%
Goals-met closure58.1%
Referral channel performance
| Channel | Referrals | Intake rate | Service rate | Avg. days to service |
|---|---|---|---|---|
| Partner Referral | 1,633 | 90.2% | 71.0% | 12.21 |
| Self Referral | 1,146 | 80.7% | 65.3% | 11.75 |
| Walk-In | 494 | 87.6% | 64.4% | 11.43 |
| Hotline | 695 | 79.6% | 61.3% | 12.46 |
Repeat-service behavior
Repeat referrals27.0%
Multi-program clients20.9%
Repeat service38.6%
Latest 3-mo service conversion66.6%
Latest month
Month2026-06
Referrals217
Service conversion67.7%
Avg. days to service12.34
Management actions
Investigate referral-channel drop-offHotlineLowest referral-to-service conversion at 61.3%.
Review lower-performing site/program combinationsHousing SupportWest and Central rank at the bottom of service conversion.
Monitor appointment friction16.6%No-show rate warrants routine operational monitoring.
Track trend stability66.6%Latest rolling 3-month service conversion provides a steadier management signal.
These are analytical follow-up priorities derived from the synthetic scenario, not recommendations for a real organization.
Selected site/program rankings
| Rank | Site | Program | Service rate | Avg. days | No-show rate |
|---|---|---|---|---|---|
| 1 | Central | Benefits | 71.5% | 11.49 | 16.5% |
| 2 | North | Benefits | 71.4% | 11.52 | 15.2% |
| 3 | West | Benefits | 71.0% | 12.07 | 18.8% |
| 16 | West | Housing Support | 59.2% | 12.20 | 16.7% |
| 15 | Central | Housing Support | 59.9% | 12.53 | 17.5% |
| 14 | Central | Employment | 62.0% | 12.59 | 17.4% |
Shows the top three and bottom three combinations by referral-to-service conversion.
All data are synthetic. This dashboard demonstrates operational analytics and stakeholder reporting, not real program performance.
View repository
· Executive summary
· KPI dictionary