Order lines as stored
Every row Farmington'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 | CTV + Video Ads | 48058 | 132217, 132387, 132389, 133347 | yes | yes |
2026-06-09 → 2026-08-31 2026-06-16 → 2026-08-31 2026-06-16 → 2026-08-31 2026-07-06 → 2026-09-30 |
205,554 | ||
| Display | Display | Geo-Framing Display Ads | 48058, 54763 | 132476, 133348 | yes | yes |
2026-06-26 → 2026-07-31 2026-07-06 → 2026-09-30 |
251,111 | ||
| Mobile Conquesting | Mobile Conquesting | Mobile Conquesting Event/Political Display & Video Ads | 48058, 54763 | 132386, 134724 | yes | yes |
2026-06-11 → 2026-07-11 2026-07-30 → 2026-09-02 |
160,000 | ||
| Social Mirror | Social Mirror | Social Mirror Ads | 48058 | 132216, 132218, 132388, 132390, 132687, 133350 | yes | yes |
2026-06-09 → 2026-07-31 2026-06-09 → 2026-08-31 2026-06-15 → 2026-08-31 2026-06-18 → 2026-07-04 2026-07-06 → 2026-08-31 2026-07-06 → 2026-09-30 |
640,978 | ||
| Video | CTV, Video | CTV + Video Ads | 48058 | 132217, 132387, 132389, 133347 | yes | yes |
2026-06-09 → 2026-08-31 2026-06-16 → 2026-08-31 2026-06-16 → 2026-08-31 2026-07-06 → 2026-09-30 |
|||
| YouTube | YouTube | YouTube+ Video Ads | 48058 | 112716, 124228, 133352 | yes | yes |
2026-02-01 → 2026-07-09 2026-03-01 → 2026-07-06 2026-07-06 → 2026-09-30 |
137,500 |
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.