📞 At-Risk Couriers — Callable List
What "at risk" means
🟡 Medium risk (Level 1)
Scheduled hours have been declining for 3+ consecutive weeks. The courier is gradually reducing their commitment — worth a proactive check-in before they disengage further.
🟠 High risk (Level 2)
No shifts booked for the next 14 days. The 14-day window accounts for holidays and short sickness. If they haven't booked after that window, they may be disengaging.
🔴 Critical (Level 3)
Both signals present — declining scheduled hours AND no upcoming bookings. Highest churn risk. Call them first.
Signals use scheduled hours from Monday snapshots (courier_schedule_per_courier), not worked hours. A courier can be at-risk while still currently active if their future booking behaviour is changing.
| Courier | Activity | Risk | Reason(s) | Last Scheduled | Contact | Vehicle | Tier |
|---|
| Courier | Activity | Engagement | Vehicle | Tier | Tasks (60d) | Total Shifts | Hrs/wk | Tasks / hr | vs Median | 8-wk trend | 6-wk hrs | Problem Rate | 1st-Time Rate | Problems | Speed Score | Perf. | Reliability | Score |
|---|
📍 Distance Trends — Avg km/Shift (Last 8 Weeks)
| Courier | Total km/shift | Productive km | Empty km | Empty % | This wk Δ | Empty % Δ | 8-wk trend |
|---|