Order lines as stored
Every row Conserva Irrigation Crystal Coast, NC'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 | Connected TV Ads | 51090, 51906 | 120160, 123245 | CANCELED | yes |
2026-03-01 → 2026-10-31 2026-03-01 → 2026-10-31 |
88,888 | ||
| Mobile Conquesting | Mobile Conquesting | Mobile Conquesting Display & Video Ads | 51090, 51906, 52273 | 120429, 123248, 124371 | yes | yes |
2026-03-01 → 2026-10-31 2026-03-01 → 2026-10-31 2026-03-01 → 2026-10-31 |
329,411 | ||
| YouTube | YouTube | YouTube+ Video Ads | 51090, 51906 | 120157, 123242 | CANCELED | yes |
2026-03-01 → 2026-10-31 2026-03-01 → 2026-10-31 |
88,888 |
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.