A freight visibility dashboard measures whether eligible shipments have usable tracking information, whether teams respond to exceptions and whether verified deliveries meet their commitments. Define the shipment group, required events, time window and reporting cutoff before calculating a KPI. Report missing information separately from a confirmed transport delay: a milestone that has not reached the tracking feed does not, by itself, prove the shipment is late.
Choose the modes, services, branches and shipment states included in the report. Specify which milestones each workflow requires and when those milestones become due. An active shipment should not be counted as missing a delivery event that is not yet expected.
Use a consistent reporting time zone and show the period start, period end and data cutoff beside every dashboard. A reporting period selects the relevant shipments or events; the cutoff determines which updates were available when the report was produced.
| KPI | Formula | Unit and denominator |
|---|---|---|
| Due-milestone coverage | Required milestones received by the cutoff ÷ required milestones due by the cutoff × 100 | Milestone level. Count only events required for eligible shipments and due by the cutoff |
| Active-shipment freshness | Eligible active shipments with a usable update inside the defined freshness window ÷ eligible active shipments at the cutoff × 100 | Shipment level. State the window, such as 24 hours, and adjust it to the service and source |
| Exception assignment coverage | Exceptions created in the period and assigned by the cutoff ÷ exceptions created in the period × 100 | Case level. Include unassigned cases in the denominator |
| Assignment time | Elapsed time from case creation to accepted ownership for assigned cases | Hours per assigned case. Report the median and observation count; show unassigned cases separately |
| Resolution time | Elapsed time from case creation to confirmed resolution for cases resolved in the period | Hours per resolved case. Show the open backlog separately so unresolved cases cannot disappear from the result |
| Open-case age | Elapsed time from case creation to the reporting cutoff for each case still open | Hours or days per open case. Show median, oldest case and count by owner or exception type |
| Delivery outcome coverage | Deliveries with a verified actual delivery time ÷ eligible deliveries due in the period × 100 | Shipment level. Reveals how much of the due cohort has a known outcome |
| On-time delivery | Verified deliveries meeting the agreed delivery commitment ÷ due deliveries with a verified actual delivery time × 100 | Shipment level. State the commitment and date basis; publish alongside delivery outcome coverage |
A milestone-level percentage and a shipment-level percentage answer different questions. For example, one shipment may have several required milestones. Do not describe 90% milestone coverage as “90% of shipments on time.”
An event can occur on time but reach the tracking feed later. Store event time and receipt time where available.
Investigate the source or connection when information is delayed. Assign an operational response when a shipment delay is confirmed. Both problems matter, but they require different action.
Store the event time and the time the update entered your system where both are available. A vessel arrival may have happened on schedule even when its tracking message arrived late. Investigate late receipt as a data issue; investigate a verified late event as a transport issue.
For each report, record:
Review these exclusions and incomplete records beside the headline percentage. If no eligible denominator exists, show “n.a.” rather than 0%.
In a hypothetical report, 100 milestones are due and 90 have been received. Coverage is 90%. This does not mean 90% of shipments are on time: several milestones may belong to one shipment, and received events can report delays.
Do not substitute an easy data metric for a different service outcome.
Show the metric definition, cut-off and owner beside the result. Let reviewers inspect its underlying records.
Review old open cases alongside resolved-case averages. Otherwise the dashboard can appear faster while difficult cases remain unresolved.
Use median and a high percentile for response times where the sample supports them, and state the number of observations.
Visibility KPIs begin with a shipment, milestone or operational exception. Sales KPIs begin with an enquiry or quote opportunity. Keep quote response time, quote follow-up, win rate and quote-to-book conversion in the freight sales and quoting KPI guide. Use this page for tracking coverage, update freshness, exception handling and verified delivery performance.
End each review with an assigned action: repair a feed, clarify a milestone, resolve an old case or correct ownership.
Explore the Operations Tower for task coordination and TMS integration for connected data. Confirm available reports in your implementation; these definitions are a measurement framework, not a list of guaranteed built-in dashboards.
No. Check whether the event occurred and whether its message arrived late. Record a confirmed transport delay separately from a missing or delayed data update.
Milestone coverage counts required events due by the cutoff. Shipment freshness counts active shipments with a usable update inside a stated time window.
They have no confirmed resolution time yet. Report the resolved-case duration together with the number and age of open cases.
Show delivery outcome coverage for the full due cohort. Calculate on-time delivery among verified outcomes and display both figures together so missing outcomes remain visible.
Related Articles