CEP Insight
Track & Trace pilot evaluation worksheet

CEP Insight editorial worksheet for a defined batch, route and service. Record metric definitions, counts, unavailable evidence and agreed acceptance conditions before drawing conclusions. Review ticks document work completed; they do not establish supplier performance or certification. The worksheet records evidence; the separate calculator computes rates from entered counts.

Pilot reference / version: ____________________
Reviewer: ____________________
Review date: ____________________
Route · carrier product · observation period: ____________________
Selection rule / review cutoff: ____________________

[ ] 1. Define participating systems, authorized data, shipment selection, route, service and observation cutoff. Identify completed, open and returned shipments.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 2. List expected milestones already due at the cutoff and their basis. Record valid attributable milestones, duplicates counted once, missing records and uncertain identifier mappings. Retain both numerator and denominator.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 3. Define the timestamp pair for latency: application first receipt minus event time, with aligned time zones. Record usable pairs, missing timestamps and negative differences; missing data is not zero latency.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 4. State the sample size and calculation method for any timing summary or percentile. Record the polling schedule and exclusions; distinguish receipt delay from transport duration.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 5. Freeze the prediction version at the agreed decision point. Record issue time, predicted date or window, timezone, matching actual-delivery evidence and tolerance before scoring.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 6. Record eligible shipment count, shipments with the required frozen estimate, evaluable estimates and hits within tolerance. Report estimate availability separately from evaluability and hit rate; explain missing estimates and delivery evidence.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 7. Define exception acknowledgement, first useful action and closure events. Record their times and cases still open at the cutoff; a documented closure does not necessarily mean successful delivery.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

[ ] 8. Record agreed thresholds, evidence gaps, reviewer and acceptance decision. For conditional acceptance, name the outstanding evidence, responsible person and next review. Limit conclusions to the recorded scope.
Evidence: ____________________
Responsible owner: ____________________
Open questions / next action: ____________________

Metric definitions · numerators / denominators · unavailable data: ____________________
Acceptance conditions / unresolved evidence: ____________________
Decision · responsible reviewer · next review: ____________________

Track & Trace pilot evaluation: coverage, latency and delivery estimates
https://cepinsight.com/en/articles/track-trace-pilot-coverage-latency-estimates