Order lines as stored
Every row Gravenstein Apple Fair's 2026-07 report is judged against - not the summary a finding prints, the actual rows. Would be is what today's code would map the raw product name to; where that differs from Product, the row was written by an older import and that is the whole answer.
| Product | Would be | Raw name on the order | Order | Line items | Live | Ran in 2026-07 | Flights | Impressions a month |
Budget a month |
Ad spend |
|---|---|---|---|---|---|---|---|---|---|---|
| Display | Display | Display Ads | 55081 | 133491 | yes | yes | 2026-07-15 → 2026-08-08 | 166,666 | ||
| Meta | Meta | Meta Display & Video Ads | 55081, 55085 | 133489, 133490, 133502, 133504 | yes | yes |
2026-07-06 → 2026-08-08 2026-07-06 → 2026-08-08 2026-07-20 → 2026-08-08 2026-07-20 → 2026-08-08 |
388,887 | ||
| TikTok | TikTok | TikTok Display & Video Ads | 55081, 55085 | 133499, 133505 | yes | yes |
2026-07-10 → 2026-08-08 2026-07-10 → 2026-08-08 |
148,148 | ||
| YouTube | YouTube | YouTube+ Video Ads | 55081 | 133494 | yes | yes | 2026-07-15 → 2026-08-08 | 71,428 |
Flights: none recorded means the row predates build 42, which is when each order's own window started being kept. Until it is re-read, the period test falls back to the merged span and a gap between two flights is invisible.