
ETA Accuracy & Exception Management to Improve OTD
N.B. Validate KPI data sources and timing with Analytics. If tips or commissions coexist, clarify interaction rules and local regulations.
📄 Prompt Template
Build a diagnostics pack to improve On-Time Delivery (OTD) to [OTD_Target] using data from [TMS_Source] and [TelematicsSource] for [Regions] over [Timeframe]. Calculate ETA accuracy (MAE, MAPE), identify recurrent exception types (weather, capacity, customs, address quality), and design proactive alerts that reduce surprise failures.
Output format:
ETA Accuracy Table by lane and carrier with error metrics and bias (early/late).
Exception Taxonomy & Frequency (Markdown table).
Alerting Ruleset with triggers, recipients, and expected CSAT impact (bps).
Dashboard Spec (widgets, filters, SLAs) for dispatchers and customer service.
Pilot Plan (2-week) with KPIs: OTD, ETA accuracy, and First-Attempt Success.
Include data quality checks (GPS ping gaps, time-zone normalization).