Order lines as stored
Every row Sonoma County 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| CTV | CTV, Video | Amazon Premium CTV + Video Ads | 54481 | 133932, 133938 | yes | yes |
2026-07-15 → 2026-08-15 2026-07-15 → 2026-08-15 |
104,838 | ||
| Meta | Meta | Meta Display & Video Ads | 54481 | 131674, 133941, 133942, 133943, 133944 | yes | yes |
2026-05-27 → 2026-07-31 2026-07-16 → 2026-08-07 2026-07-16 → 2026-08-14 2026-07-16 → 2026-08-14 2026-07-17 → 2026-08-15 |
351,850 | ||
| Mobile Conquesting | Mobile Conquesting | Mobile Conquesting Display & Video Ads | 54481 | 133935, 133936 | yes | yes |
2026-07-15 → 2026-08-15 2026-07-21 → 2026-08-15 |
294,117 | ||
| Social Mirror | Social Mirror | Social Mirror Ads | 54481 | 133931, 133939 | yes | yes |
2026-07-15 → 2026-08-15 2026-07-15 → 2026-08-15 |
355,614 | ||
| TikTok | TikTok | TikTok Display & Video Ads | 54481 | 133929 | yes | yes | 2026-07-15 → 2026-08-15 | 222,222 | ||
| Video | CTV, Video | Amazon Premium CTV + Video Ads | 54481 | 133932, 133938 | yes | yes |
2026-07-15 → 2026-08-15 2026-07-15 → 2026-08-15 |
|||
| YouTube | YouTube | YouTube+ Video Ads | 54481 | 133930 | yes | yes | 2026-07-15 → 2026-08-15 | 142,857 |
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.