{
  "as_of": "2026-11-04",
  "risk_days": 3,
  "summary": {
    "total": 6,
    "late": 2,
    "at_risk": 1,
    "check_number": 1,
    "no_date": 1,
    "on_track": 1,
    "delivered": 0
  },
  "by_carrier": {
    "DHL": 1,
    "UPS": 1,
    "FedEx": 1,
    "unknown": 1,
    "USPS": 2
  },
  "shipments": [
    {
      "row": 4,
      "tracking": "1234567890",
      "carrier": "DHL",
      "carrier_confidence": "medium",
      "item": "Laptops",
      "destination": "Dock B",
      "needed_by": "2026-11-03",
      "days_left": -1,
      "status": "in transit",
      "eta": "",
      "risk": "late",
      "reasons": [
        "needed 1 day(s) ago"
      ],
      "url": "https://www.dhl.com/global-en/home/tracking/tracking-express.html?submit=1&tracking-id=1234567890",
      "notes": ""
    },
    {
      "row": 1,
      "tracking": "1Z999AA10123456784",
      "carrier": "UPS",
      "carrier_confidence": "high",
      "item": "Backdrop",
      "destination": "Dock B",
      "needed_by": "2026-11-10",
      "days_left": 6,
      "status": "in transit",
      "eta": "2026-11-12",
      "risk": "late",
      "reasons": [
        "ETA 2026-11-12 is after needed-by 2026-11-10"
      ],
      "url": "https://www.ups.com/track?tracknum=1Z999AA10123456784",
      "notes": ""
    },
    {
      "row": 2,
      "tracking": "123456789012",
      "carrier": "FedEx",
      "carrier_confidence": "high",
      "item": "T-shirts",
      "destination": "Dock B",
      "needed_by": "2026-11-06",
      "days_left": 2,
      "status": "label created",
      "eta": "",
      "risk": "at risk",
      "reasons": [
        "needed in 2 day(s), status: label created"
      ],
      "url": "https://www.fedex.com/fedextrack/?trknbr=123456789012",
      "notes": ""
    },
    {
      "row": 5,
      "tracking": "NOTANUMBER",
      "carrier": "unknown",
      "carrier_confidence": "low",
      "item": "Banner",
      "destination": "Dock B",
      "needed_by": "2026-11-08",
      "days_left": 4,
      "status": "not checked",
      "eta": "",
      "risk": "check number",
      "reasons": [
        "unknown format; check the number or set the carrier column"
      ],
      "url": "",
      "notes": ""
    },
    {
      "row": 6,
      "tracking": "EC123456789US",
      "carrier": "USPS",
      "carrier_confidence": "high",
      "item": "Flyers",
      "destination": "Hotel",
      "needed_by": "",
      "days_left": null,
      "status": "not checked",
      "eta": "",
      "risk": "no date",
      "reasons": [],
      "url": "https://tools.usps.com/go/TrackConfirmAction?tLabels=EC123456789US",
      "notes": ""
    },
    {
      "row": 3,
      "tracking": "9400100000000000000000",
      "carrier": "USPS",
      "carrier_confidence": "high",
      "item": "Scanners",
      "destination": "Hotel",
      "needed_by": "2026-11-05",
      "days_left": 1,
      "status": "out for delivery",
      "eta": "",
      "risk": "on track",
      "reasons": [],
      "url": "https://tools.usps.com/go/TrackConfirmAction?tLabels=9400100000000000000000",
      "notes": ""
    }
  ]
}