=== Report 1: Carrier transit performance, Q4 2025 (complete) (written by Grace) === Engineer's note: Grouped by carrier name across all tenants/merchants (the request was carrier-level, not merchant-level); transit_days computed in fractional days then rounded, so avg/median/p90 reflect exact hour-level transit not just whole days. As requested, pct_delivered and pct_within_3_days for carriers with many late-December shipments may be understated due to the 2025-12-31 data cutoff (right-censoring), not necessarily worse carrier performance. REPORT: Carrier transit performance, Q4 2025 (complete) QUESTION: Across every carrier, how did transit time and reliability hold up in the peak quarter, and how much volume does each carrier actually carry? carrier | shipments_shipped | shipments_delivered | avg_transit_days | median_transit_days | p90_transit_days | pct_within_3_days | pct_delivered | share_of_q4_shipments_pct ---------------------+-------------------+---------------------+------------------+---------------------+------------------+-------------------+---------------+-------------------------- Strombogen Kurier | 905 | 877 | 2.14 | 2.04 | 3.23 | 80.7 | 96.9 | 12.3 Liberty Ground | 854 | 830 | 2.29 | 2.08 | 3.76 | 78.2 | 97.2 | 11.6 Lowlands Express | 853 | 816 | 3.70 | 3.16 | 6.18 | 44.6 | 95.7 | 11.6 Albion Parcel | 794 | 779 | 6.57 | 3.30 | 17.10 | 43.4 | 98.1 | 10.8 Trailhead Express | 706 | 687 | 2.41 | 2.09 | 3.92 | 73.2 | 97.3 | 9.6 Landfall Freight | 676 | 648 | 5.15 | 4.90 | 8.01 | 13.6 | 95.9 | 9.2 Alpenpaket | 628 | 620 | 2.19 | 2.09 | 3.25 | 79.4 | 98.7 | 8.5 Kennet Freight | 453 | 442 | 2.04 | 2.01 | 3.10 | 86.9 | 97.6 | 6.2 Skerrylane Logistics | 401 | 393 | 2.67 | 2.22 | 4.34 | 66.7 | 98.0 | 5.5 Polder Post | 320 | 310 | 2.51 | 2.17 | 4.21 | 71.6 | 96.9 | 4.3 Prairie Line Express | 291 | 284 | 2.57 | 2.28 | 3.99 | 67.6 | 97.6 | 4.0 Regent Parcels | 277 | 268 | 2.20 | 2.08 | 3.29 | 81.0 | 96.8 | 3.8 Gallia Colis | 109 | 105 | 2.80 | 2.09 | 5.12 | 68.6 | 96.3 | 1.5 Liffey Couriers | 90 | 89 | 2.48 | 2.11 | 4.10 | 66.3 | 98.9 | 1.2 (14 rows) === Report 2: Albion Parcel transit performance by month, 2025 (written by Felix) === Engineer's note: transit_days = delivered_at - shipped_at in days, computed only over the delivered subset per month (shipments_shipped counts all Albion Parcel shipments shipped that month regardless of delivery). As flagged in the request, pct_delivered for the last 1-2 weeks of December will read artificially low because of the 2025-12-31 data cutoff (deliveries still in transit at cutoff aren't yet recorded). REPORT: Albion Parcel transit performance by month, 2025 QUESTION: Exactly when did Albion Parcel's transit time break down, how bad did it get, and had it recovered by year-end? month | shipments_shipped | shipments_delivered | avg_transit_days | median_transit_days | p90_transit_days | pct_within_3_days | pct_delivered --------+-------------------+---------------------+------------------+---------------------+------------------+-------------------+-------------- 2025-01 | 259 | 259 | 2.00 | 1.98 | 3.05 | 86.9 | 100.0 2025-02 | 177 | 177 | 2.06 | 2.09 | 3.12 | 86.4 | 100.0 2025-03 | 204 | 204 | 2.15 | 2.07 | 3.22 | 81.4 | 100.0 2025-04 | 203 | 203 | 2.36 | 2.12 | 3.76 | 76.8 | 100.0 2025-05 | 197 | 197 | 2.41 | 2.23 | 3.79 | 70.6 | 100.0 2025-06 | 210 | 210 | 2.35 | 2.17 | 3.92 | 74.8 | 100.0 2025-07 | 218 | 218 | 2.23 | 2.07 | 3.29 | 80.7 | 100.0 2025-08 | 194 | 194 | 2.15 | 2.08 | 3.12 | 83.5 | 100.0 2025-09 | 220 | 220 | 2.20 | 2.11 | 3.18 | 79.1 | 100.0 2025-10 | 247 | 247 | 2.39 | 2.19 | 3.31 | 75.7 | 100.0 2025-11 | 287 | 287 | 7.51 | 6.91 | 16.83 | 28.2 | 100.0 2025-12 | 260 | 245 | 9.69 | 7.14 | 20.69 | 28.6 | 94.2 (12 rows) === Report 3: Carrier mix for best vs worst performing merchants, 2025 (written by Bea) === Engineer's note: avg_transit_days and pct_within_3_days are computed over the delivered subset only (shipments with a non-null delivered_at), as specified; tenants/carriers with zero delivered shipments show 0 for both rather than null. share_of_tenant_shipments_pct uses each tenant's total 2025 shipment count (all carriers) as the denominator. REPORT: Carrier mix for best vs worst performing merchants, 2025 QUESTION: Do the merchants with the worst delivery reliability simply ship disproportionately with the weaker carriers? tenant_name | performance_group | carrier | shipments_count | share_of_tenant_shipments_pct | avg_transit_days | pct_within_3_days ----------------------+-------------------+----------------------+-----------------+-------------------------------+------------------+------------------ Chocolaterie Mireille | worst | Landfall Freight | 38 | 38.0 | 3.86 | 43.2 Chocolaterie Mireille | worst | Lowlands Express | 32 | 32.0 | 3.0 | 59.4 Chocolaterie Mireille | worst | Gallia Colis | 30 | 30.0 | 2.63 | 76.7 Grind Collective | worst | Albion Parcel | 515 | 47.1 | 3.12 | 80.7 Grind Collective | worst | Kennet Freight | 222 | 20.3 | 1.97 | 88.7 Grind Collective | worst | Regent Parcels | 187 | 17.1 | 1.91 | 94.0 Grind Collective | worst | Landfall Freight | 109 | 10.0 | 6.27 | 19.4 Grind Collective | worst | Lowlands Express | 61 | 5.6 | 6.98 | 11.7 Kayak Corner | worst | Albion Parcel | 38 | 37.6 | 4.45 | 84.2 Kayak Corner | worst | Kennet Freight | 21 | 20.8 | 2.05 | 81.0 Kayak Corner | worst | Landfall Freight | 19 | 18.8 | 3.42 | 42.1 Kayak Corner | worst | Regent Parcels | 13 | 12.9 | 1.38 | 100.0 Kayak Corner | worst | Lowlands Express | 10 | 9.9 | 3.9 | 50.0 Kettle & Key | worst | Polder Post | 26 | 44.1 | 2.04 | 92.0 Kettle & Key | worst | Landfall Freight | 18 | 30.5 | 4.22 | 27.8 Kettle & Key | worst | Lowlands Express | 15 | 25.4 | 2.4 | 80.0 Polder Packaging | worst | Lowlands Express | 27 | 49.1 | 2.85 | 74.1 Polder Packaging | worst | Polder Post | 18 | 32.7 | 2.39 | 72.2 Polder Packaging | worst | Landfall Freight | 10 | 18.2 | 4.0 | 50.0 Purrfect Pantry | worst | Skerrylane Logistics | 46 | 62.2 | 2.07 | 87.0 Purrfect Pantry | worst | Lowlands Express | 17 | 23.0 | 8.12 | 0.0 Purrfect Pantry | worst | Landfall Freight | 11 | 14.9 | 9.27 | 0.0 Sourdough Club | worst | Liffey Couriers | 142 | 46.4 | 2.2 | 87.3 Sourdough Club | worst | Albion Parcel | 76 | 24.8 | 3.0 | 85.1 Sourdough Club | worst | Landfall Freight | 52 | 17.0 | 4.84 | 35.3 Sourdough Club | worst | Lowlands Express | 36 | 11.8 | 4.91 | 28.6 Spice Route Box | worst | Lowlands Express | 360 | 47.2 | 2.11 | 83.2 Spice Route Box | worst | Polder Post | 311 | 40.8 | 2.21 | 83.5 Spice Route Box | worst | Landfall Freight | 92 | 12.1 | 3.85 | 42.4 Studio Vrij | worst | Lowlands Express | 347 | 58.1 | 2.04 | 87.8 Studio Vrij | worst | Polder Post | 188 | 31.5 | 2.21 | 83.2 Studio Vrij | worst | Landfall Freight | 62 | 10.4 | 3.82 | 33.3 Thistlecombe | worst | Albion Parcel | 29 | 33.3 | 5.0 | 65.5 Thistlecombe | worst | Kennet Freight | 22 | 25.3 | 2.48 | 76.2 Thistlecombe | worst | Landfall Freight | 20 | 23.0 | 6.0 | 15.0 Thistlecombe | worst | Regent Parcels | 10 | 11.5 | 2.2 | 80.0 Thistlecombe | worst | Lowlands Express | 6 | 6.9 | 6.83 | 33.3 Brennquell Kaffee | best | Strombogen Kurier | 2050 | 49.7 | 1.73 | 96.7 Brennquell Kaffee | best | Alpenpaket | 1368 | 33.1 | 1.72 | 96.3 Brennquell Kaffee | best | Landfall Freight | 409 | 9.9 | 3.76 | 42.7 Brennquell Kaffee | best | Lowlands Express | 300 | 7.3 | 3.89 | 40.1 Cragsley Outfitters | best | Liberty Ground | 1634 | 46.9 | 1.71 | 95.4 Cragsley Outfitters | best | Trailhead Express | 1253 | 36.0 | 1.92 | 89.7 Cragsley Outfitters | best | Prairie Line Express | 511 | 14.7 | 2.0 | 88.8 Cragsley Outfitters | best | Landfall Freight | 85 | 2.4 | 3.71 | 44.6 Feather & Fin | best | Liberty Ground | 108 | 50.0 | 1.81 | 94.4 Feather & Fin | best | Trailhead Express | 79 | 36.6 | 1.64 | 94.9 Feather & Fin | best | Prairie Line Express | 29 | 13.4 | 2.14 | 89.3 Honeycomb Larder | best | Liberty Ground | 248 | 41.1 | 1.69 | 95.9 Honeycomb Larder | best | Trailhead Express | 246 | 40.7 | 2.0 | 88.0 (73 rows, first 50 printed)