Order lines as stored
Every row Chesapeake Baysox'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 | 53538, 54366 | 131218, 132712 | CANCELED | yes |
2026-06-01 → 2026-08-31 2026-07-01 → 2026-08-31 |
125,000 | ||
| Performance Max | Performance Max | Performance Max Ads | 53538, 54366 | 131220, 132711 | CANCELED | yes |
2026-06-01 → 2026-08-31 2026-07-01 → 2026-08-31 |
$15,000 total |
||
| Social Mirror | Social Mirror | Social Mirror Ads | 53538 | 128587 | yes | yes | 2026-04-06 → 2026-09-05 | 333,333 | ||
| Social Mirror CTV | Social Mirror CTV | Social Mirror CTV Ads | 53538, 54366 | 131222, 134338 | CANCELED | yes |
2026-06-01 → 2026-08-31 2026-07-23 → 2026-08-31 |
81,988 |
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.