Logistics KPI Dashboard: The 15 Metrics That Actually Matter

Logistics KPI Dashboard: The 15 Metrics That Actually Matter

A logistics KPI dashboard is only as good as the metrics it shows. Most dashboards are either too sparse (just location + ETA) or too cluttered (40 metrics no one acts on). The right dashboard shows fewer metrics, each tied to a decision or action.

The 5 Core SLA Metrics

1. On-Time Performance (OTP) — % of shipments delivered on or before committed ETA. Formula: (on-time deliveries ÷ total deliveries) × 100. Target: >95% primary distribution, >99% express. View: daily, rolling 7-day, rolling 30-day.

2. OTIF (On Time In Full) — % delivered on time AND with complete quantity. Standard in FMCG and retail. Target: >98% for primary FMCG distribution.

3. SLA Breach Rate — % of total shipments that missed their SLA window. Target: <5%. Drill-down by carrier, lane, exception type.

4. At-Risk Shipment Rate — % of active shipments currently flagged as at-risk of breach. Real-time metric. Target: <3%. Action trigger: >10% = something systemic is wrong.

5. Breach Prevention Rate — Of all shipments flagged at-risk, what % were resolved before breach? Target: >60%. Measures whether exception management is actually working.

The 4 Exception Management Metrics

6. Open Exception Count (by Severity) — How many P1/P2/P3 exceptions are currently unresolved? P1 target: 0 open for more than 30 minutes. P2 target: resolved within 2 hours.

7. Exception Resolution Rate — % of exceptions raised in the last 24 hours that have been closed. Target: >85% within 24 hours.

8. Mean Time to Detect (MTTD) — Average time between an exception occurring and system detection. Target: <15 minutes.

9. Mean Time to Resolve (MTTR) — Average time between detection and resolution. Target: <2 hours for P1/P2.

The 4 Carrier Performance Metrics

10. OTP by Carrier — Performance compared against carrier's 30-day average. Action trigger: drop >5 percentage points.

11. Exception Rate by Carrier — Exceptions per 100 trips. Action trigger: >3× industry average needs a performance plan.

12. Driver Response Rate — % of exception calls where driver responded within 30 minutes. Target: >80%.

13. Repeat Exception Rate — Same carrier, lane, or driver recurring within 30 days. Target: <10%.

The 2 Operational Efficiency Metrics

14. Detention Time (Average) — Average vehicle waiting time at origin and destination beyond free window. Target: <2 hours average. Track by plant/warehouse and customer.

15. TAT vs. Target — Actual trip duration vs. planned duration by lane. Consistently positive variance = real delay problem. Consistently negative variance = ETAs are too optimistic.

Dashboard Design Principles

Exception-first layout — The top of the dashboard shows exception queue, not total shipment count. A dashboard that leads with a map is a tracking tool, not a control tower.

Real-time vs. periodic — Exception metrics (open count, MTTD) must be real-time. SLA metrics (OTP, breach rate) can be daily.

Role-based views — Dispatcher: trip-level detail and exception queue. Ops manager: exception patterns, carrier performance, TAT variance. VP/Head: OTP trend, OTIF, breach rate, detention time.

Drill-down from every number — Every metric links to underlying trips, carriers, or lanes. A number without a drill-down is a report, not a tool.

How Cruise's KPI Dashboard Works

Cruise's dashboard: live exception queue (P1/P2/P3) front and centre; OTP, breach rate, and at-risk count updated in real time; carrier performance panel showing OTP today vs. 30-day average; detention time by plant/warehouse live; Vedika call status (calls initiated, connected, resolved); 7-day SLA breach trend.

Every number on the screen changes what someone does in the next hour.