Order lines as stored
Every row Tennessee Water and Air Technology'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 | Amazon Premium Display Ads | 51323, 51724 | 129259, 131067, 131200, 133634 | yes | yes |
2026-05-01 → 2026-12-31 2026-06-01 → 2026-12-31 2026-06-10 → 2026-07-06 2026-07-07 → 2026-07-29 |
171,666 | ||
| Live Chat | Live Chat | Live Chat | 51724 | 122583, 131057 | CANCELED | yes |
2026-02-01 → 2026-07-31 2026-06-01 → 2026-12-31 |
|||
| Meta | Meta | Meta Display & Video Ads | 51323, 51724 | 131065, 131199 | CANCELED | yes |
2026-06-01 → 2026-12-31 2026-07-01 → 2026-12-31 |
80,000 | ||
| Mobile Conquesting | Mobile Conquesting | Mobile Conquesting Display & Video Ads | 51724 | 122655 | CANCELED | yes | 2026-02-01 → 2026-07-31 | 100,000 | ||
| PPC | PPC | Pay-Per-Click Ads | 51323, 51724 | 122586, 131063, 131197 | yes | yes |
2026-02-01 → 2026-07-31 2026-06-01 → 2026-12-31 2026-06-24 → 2026-07-29 |
$3,850.00 $17,500 total |
||
| Performance Max | Performance Max | Performance Max Ads | 51323, 51724 | 122590, 128044 | yes | yes |
2026-02-01 → 2026-07-31 2026-05-01 → 2026-08-01 |
$18,000 total |
||
| SEO | SEO | SEO | 51724 | 127866 | CANCELED | yes | 2026-07-01 → 2026-12-31 | |||
| Social Mirror | Social Mirror | Social Mirror Ads | 51724 | 122588 | CANCELED | yes | 2026-02-01 → 2026-07-31 | 75,000 | ||
| Video | CTV, Video | Amazon Premium CTV + Video Ads | 51323, 51724 | 131067, 131200, 133634 | yes | yes |
2026-06-01 → 2026-12-31 2026-06-10 → 2026-07-06 2026-07-07 → 2026-07-29 |
|||
| YouTube | YouTube | YouTube+ Video Ads | 51724 | 122591 | CANCELED | yes | 2026-02-01 → 2026-07-31 | 50,000 |
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.