=== Report 1: Carrier transit performance by quarter, 2025 (written by Bea) === Engineer's note: Grain is carrier x calendar quarter of shipped_at, scoped to 2025 shipments; pct_delivered for shipments shipped late in Q4 (esp. December) will understate carrier reliability since delivery may simply not have completed by the 2025-12-31 cutoff -- please flag this caveat next to the Q4 pct_delivered/pct_within_3_days figures rather than reading it as a carrier regression. REPORT: Carrier transit performance by quarter, 2025 QUESTION: Which carriers are consistently fast and dependable, and did any carrier's transit time blow out specifically during peak (Q4)? carrier | quarter | shipments_shipped | shipments_delivered | avg_transit_days | median_transit_days | pct_within_3_days | pct_delivered ---------------------+---------+-------------------+---------------------+------------------+---------------------+-------------------+-------------- Albion Parcel | 2025-Q1 | 640 | 640 | 2.03 | 2.0 | 97.2 | 100.0 Albion Parcel | 2025-Q2 | 610 | 610 | 2.35 | 2.0 | 88.2 | 100.0 Albion Parcel | 2025-Q3 | 632 | 632 | 2.17 | 2.0 | 93.7 | 100.0 Albion Parcel | 2025-Q4 | 794 | 779 | 6.54 | 3.0 | 50.7 | 98.1 Alpenpaket | 2025-Q1 | 507 | 507 | 2.24 | 2.0 | 89.2 | 100.0 Alpenpaket | 2025-Q2 | 444 | 444 | 2.14 | 2.0 | 94.1 | 100.0 Alpenpaket | 2025-Q3 | 443 | 443 | 2.15 | 2.0 | 94.8 | 100.0 Alpenpaket | 2025-Q4 | 628 | 620 | 2.16 | 2.0 | 92.3 | 98.7 Gallia Colis | 2025-Q1 | 40 | 40 | 2.2 | 2.0 | 92.5 | 100.0 Gallia Colis | 2025-Q2 | 53 | 53 | 2.42 | 2.0 | 83.0 | 100.0 Gallia Colis | 2025-Q3 | 82 | 82 | 3.4 | 3.0 | 57.3 | 100.0 Gallia Colis | 2025-Q4 | 109 | 105 | 2.8 | 2.0 | 77.1 | 96.3 Kennet Freight | 2025-Q1 | 138 | 138 | 2.46 | 2.0 | 82.6 | 100.0 Kennet Freight | 2025-Q2 | 148 | 148 | 2.59 | 2.0 | 79.1 | 100.0 Kennet Freight | 2025-Q3 | 170 | 170 | 2.69 | 3.0 | 79.4 | 100.0 Kennet Freight | 2025-Q4 | 453 | 442 | 2.02 | 2.0 | 96.2 | 97.6 Landfall Freight | 2025-Q1 | 433 | 433 | 4.69 | 4.0 | 27.0 | 100.0 Landfall Freight | 2025-Q2 | 382 | 382 | 4.66 | 4.0 | 30.6 | 100.0 Landfall Freight | 2025-Q3 | 415 | 415 | 4.96 | 5.0 | 24.3 | 100.0 Landfall Freight | 2025-Q4 | 676 | 648 | 5.13 | 5.0 | 22.7 | 95.9 Liberty Ground | 2025-Q1 | 459 | 459 | 2.19 | 2.0 | 90.8 | 100.0 Liberty Ground | 2025-Q2 | 514 | 514 | 2.25 | 2.0 | 90.5 | 100.0 Liberty Ground | 2025-Q3 | 516 | 516 | 2.14 | 2.0 | 92.8 | 100.0 Liberty Ground | 2025-Q4 | 854 | 830 | 2.3 | 2.0 | 87.7 | 97.2 Liffey Couriers | 2025-Q1 | 86 | 86 | 2.3 | 2.0 | 83.7 | 100.0 Liffey Couriers | 2025-Q2 | 77 | 77 | 2.9 | 3.0 | 70.1 | 100.0 Liffey Couriers | 2025-Q3 | 70 | 70 | 3.31 | 3.0 | 65.7 | 100.0 Liffey Couriers | 2025-Q4 | 90 | 89 | 2.45 | 2.0 | 82.0 | 98.9 Lowlands Express | 2025-Q1 | 579 | 579 | 3.46 | 3.0 | 61.0 | 100.0 Lowlands Express | 2025-Q2 | 578 | 578 | 3.49 | 3.0 | 57.3 | 100.0 Lowlands Express | 2025-Q3 | 551 | 551 | 3.54 | 3.0 | 59.3 | 100.0 Lowlands Express | 2025-Q4 | 853 | 816 | 3.68 | 3.0 | 55.3 | 95.7 Polder Post | 2025-Q1 | 188 | 188 | 2.63 | 2.0 | 77.7 | 100.0 Polder Post | 2025-Q2 | 185 | 185 | 2.44 | 2.0 | 81.1 | 100.0 Polder Post | 2025-Q3 | 209 | 209 | 2.74 | 3.0 | 77.5 | 100.0 Polder Post | 2025-Q4 | 320 | 310 | 2.49 | 2.0 | 79.7 | 96.9 Prairie Line Express | 2025-Q1 | 146 | 146 | 2.26 | 2.0 | 89.7 | 100.0 Prairie Line Express | 2025-Q2 | 157 | 157 | 2.29 | 2.0 | 89.8 | 100.0 Prairie Line Express | 2025-Q3 | 154 | 154 | 2.97 | 3.0 | 66.9 | 100.0 Prairie Line Express | 2025-Q4 | 291 | 284 | 2.59 | 2.5 | 80.6 | 97.6 Regent Parcels | 2025-Q1 | 174 | 174 | 2.17 | 2.0 | 92.5 | 100.0 Regent Parcels | 2025-Q2 | 160 | 160 | 2.32 | 2.0 | 87.5 | 100.0 Regent Parcels | 2025-Q3 | 187 | 187 | 2.63 | 2.0 | 82.4 | 100.0 Regent Parcels | 2025-Q4 | 277 | 268 | 2.15 | 2.0 | 91.4 | 96.8 Skerrylane Logistics | 2025-Q1 | 239 | 239 | 2.35 | 2.0 | 84.5 | 100.0 Skerrylane Logistics | 2025-Q2 | 238 | 238 | 2.46 | 2.0 | 81.1 | 100.0 Skerrylane Logistics | 2025-Q3 | 246 | 246 | 2.45 | 2.0 | 86.2 | 100.0 Skerrylane Logistics | 2025-Q4 | 401 | 393 | 2.64 | 2.0 | 75.6 | 98.0 Strombogen Kurier | 2025-Q1 | 722 | 722 | 2.15 | 2.0 | 93.8 | 100.0 Strombogen Kurier | 2025-Q2 | 676 | 676 | 2.08 | 2.0 | 94.8 | 100.0 (56 rows, first 50 printed) === Report 2: Fulfillment performance by warehouse, 2025 (written by Grace) === Engineer's note: Warehouses have a single tenant (no cross-tenant sharing in the schema), so warehouse_name alone would be unique, but tenant_name is included as requested for readability. Days are computed as plain calendar-date differences (not fractional/time-of-day), matching DATEDIFF(day, ...) semantics. REPORT: Fulfillment performance by warehouse, 2025 QUESTION: Are there specific fulfillment sites that are consistently slower to process or less reliable on final delivery time? warehouse_name | tenant_name | orders_shipped | avg_processing_days | avg_delivery_days | pct_within_5_days --------------------------------------+-------------------------------+----------------+---------------------+-------------------+------------------ Köln Fulfilment Centre | Brennquell Kaffee | 4071 | 1.03 | 3.55 | 91.7 Atlanta Fulfilment Centre | Cragsley Outfitters | 3219 | 0.79 | 3.2 | 95.2 Reading Fulfilment Centre | Marrowby & Vane | 1529 | 1.02 | 4.13 | 82.5 Manchester Fulfilment Centre | Grind Collective | 1082 | 1.5 | 5.12 | 71.6 Liège Fulfilment Centre | Spice Route Box | 755 | 1.58 | 4.38 | 76.2 Bromley Fulfilment Centre | Petalcourt Beauty | 646 | 1.14 | 5.0 | 77.4 Bromley Fulfilment Centre | Kibblewick | 644 | 1.26 | 4.75 | 77.6 San Francisco Fulfilment Centre | Honeycomb Larder | 592 | 1.22 | 3.59 | 88.5 Den Haag Fulfilment Centre | Studio Vrij | 532 | 2.26 | 4.97 | 69.0 Hamburg Fulfilment Centre | Ampfeld Elektronik | 418 | 1.51 | 3.92 | 84.9 Liverpool Fulfilment Centre | Fennel & Flint | 360 | 1.4 | 5.41 | 72.2 Galway Fulfilment Centre | Ballycorran Industrial Supply | 338 | 1.11 | 4.69 | 73.1 San Francisco Fulfilment Centre | Cinder Peak Sports Co. | 303 | 1.25 | 3.74 | 84.5 Dublin Fulfilment Centre | Sourdough Club | 298 | 1.53 | 5.07 | 69.8 Berlin Fulfilment Centre | Wiesgrund Wohnen | 270 | 1.4 | 4.01 | 84.4 Berlin Fulfilment Centre | Kontor24 Bürobedarf | 258 | 1.09 | 3.55 | 91.1 Amsterdam Fulfilment Centre | Linden & Loom | 237 | 1.58 | 4.21 | 82.7 Dortmund Fulfilment Centre | Gratlinie Outdoor | 212 | 1.44 | 3.93 | 84.0 Houston Fulfilment Centre | Feather & Fin | 207 | 0.98 | 3.4 | 95.2 Amsterdam Fulfilment Centre | Whisker Works | 172 | 1.24 | 3.97 | 82.0 Oslo Fulfilment Centre | OfficeHub Nordic | 163 | 1.12 | 4.1 | 82.8 Paris Fulfilment Centre | Rue Lafayette Studio | 155 | 1.3 | 4.19 | 78.7 San Antonio Fulfilment Centre | Castell Fasteners | 155 | 1.06 | 3.45 | 96.8 Uppsala Fulfilment Centre | Juniper Apothecary | 146 | 1.49 | 4.29 | 74.7 Göteborg Fulfilment Centre | Coastline Interiors | 143 | 1.44 | 4.27 | 79.7 København Fulfilment Centre | Oakhurst Tailoring | 139 | 1.65 | 4.32 | 79.1 Rotterdam Fulfilment Centre | Midland Safety Wear | 139 | 1.19 | 3.96 | 80.6 Nürnberg Fulfilment Centre | Wohnglück | 138 | 1.41 | 3.72 | 93.5 Odense Fulfilment Centre | Nordic Bloom Cosmetics | 132 | 1.2 | 4.28 | 81.1 Uppsala Fulfilment Centre | Velvet Ash | 114 | 1.29 | 4.3 | 76.3 Lund Fulfilment Centre | Saffron & Sage | 113 | 1.23 | 3.93 | 83.2 Köln Fulfilment Centre | Pfotenglück | 111 | 1.3 | 3.5 | 95.5 München Fulfilment Centre | Ostwind Mode | 108 | 1.3 | 3.94 | 79.6 Rotterdam Fulfilment Centre | Ridgeback Gear | 102 | 1.38 | 3.84 | 92.2 Leeds Fulfilment Centre | The Balm Room | 100 | 1.4 | 5.02 | 78.0 Bordeaux Fulfilment Centre | Chocolaterie Mireille | 99 | 1.31 | 4.93 | 64.6 Exeter Fulfilment Centre | Kayak Corner | 96 | 1.42 | 5.25 | 75.0 Zaandam Fulfilment Centre | Sorella Skin | 93 | 1.32 | 4.03 | 82.8 Augsburg Fulfilment Centre | Hautnah | 90 | 1.46 | 4.06 | 82.2 Manchester Fulfilment Centre | Willow & Wren | 90 | 1.4 | 4.72 | 83.3 Houston Fulfilment Centre | Tail Wag Supply | 87 | 1.05 | 3.39 | 93.1 Cambridge Fulfilment Centre | Thistlecombe | 84 | 1.25 | 6.07 | 58.3 Newcastle upon Tyne Fulfilment Centre | Deskline Supplies | 75 | 1.13 | 4.52 | 76.0 Odense Fulfilment Centre | Fell & Fjell | 72 | 1.25 | 4.08 | 80.6 Oslo Fulfilment Centre | Purrfect Pantry | 72 | 1.14 | 6.0 | 58.3 Hannover Fulfilment Centre | Hanse Industriebedarf | 71 | 1.2 | 3.96 | 85.9 Paris Fulfilment Centre | Mirelle | 60 | 1.3 | 3.83 | 88.3 Amsterdam Fulfilment Centre | Ampere & Co. | 56 | 1.29 | 4.29 | 75.0 Amersfoort Fulfilment Centre | Kettle & Key | 55 | 1.29 | 4.55 | 65.5 Liège Fulfilment Centre | Polder Packaging | 55 | 1.13 | 4.49 | 72.7 (50 rows) === Report 3: Order fulfillment stage breakdown, monthly 2025 (written by Felix) === Engineer's note: Scoped to fulfilled orders placed in 2025 with exactly one fulfillment row that has both shipped_at and delivered_at set, per the single-fulfillment simplifying rule. Day diffs use date-level subtraction (whole days); I could not verify in the empty dry-run schema whether avg_total_days materially deviates from avg_processing_days + avg_transit_days, so please sanity-check that once real data runs. REPORT: Order fulfillment stage breakdown, monthly 2025 QUESTION: When total delivery time lengthens (e.g. during peak), is the slowdown in warehouse processing (pick/pack/ship) or in carrier transit? month | orders_qualifying | avg_processing_days | avg_transit_days | avg_total_days | pct_within_5_days_total --------+-------------------+---------------------+------------------+----------------+------------------------ 2025-01 | 1717 | 1.08 | 2.51 | 3.59 | 90.3 2025-02 | 1329 | 1.1 | 2.58 | 3.68 | 89.4 2025-03 | 1545 | 1.13 | 2.69 | 3.82 | 87.1 2025-04 | 1477 | 1.14 | 2.56 | 3.7 | 88.8 2025-05 | 1574 | 1.51 | 2.76 | 4.27 | 80.6 2025-06 | 1419 | 1.21 | 2.63 | 3.84 | 86.3 2025-07 | 1565 | 1.14 | 2.79 | 3.93 | 85.2 2025-08 | 1457 | 1.22 | 2.64 | 3.86 | 87.2 2025-09 | 1611 | 1.18 | 2.87 | 4.05 | 83.2 2025-10 | 1767 | 1.14 | 2.94 | 4.08 | 83.1 2025-11 | 2419 | 1.2 | 3.46 | 4.66 | 78.7 2025-12 | 2653 | 1.16 | 3.07 | 4.24 | 81.1 (12 rows)