Order lines as stored
Every row Memorial Hospital'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 | 40042 | 121972 | yes | yes | 2026-01-16 → 2026-12-31 | 66,666 | ||
| Native Display | Native Display | Native Display Ads | 4701 | 40711 | yes | yes | 2021-08-11 → 2026-12-31 | 150,000 | ||
| Online Audio | Online Audio | Online Audio Ads | 4701, 54013 | 129986, 78445 | yes | yes |
2024-01-03 → 2026-12-31 2026-05-01 → 2026-07-31 |
60,000 | ||
| Social Mirror | Social Mirror | Social Mirror Ads | 4701 | 78415 | yes | yes | 2024-01-03 → 2026-12-31 | 66,666 | ||
| Video | CTV, Video | CTV + Video Ads | 40042 | 121972 | yes | yes | 2026-01-16 → 2026-12-31 |
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.