Order lines as stored
Every row IBEW Local 401'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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Display | Display | Display Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121532, 121534, 121555, 121557, 127135, 127137, 127142, 127144, 127145, 127152, 127154, 127161 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 |
2,400,000 | ||
| Meta | Meta | Meta Display & Video Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121527, 121552, 127128, 127129, 127133, 127139 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 |
1,875,000 | ||
| Mobile Conquesting | Mobile Conquesting | Mobile Conquesting Display & Video Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121530, 121553, 127130, 127131, 127136, 127143 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 |
2,400,000 | ||
| PPC | PPC | Pay-Per-Click Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121531, 121554, 127132, 127134, 127140, 127147 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 |
$10,500.00 $126,000 total |
||
| Social Mirror | Social Mirror | Social Mirror Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121533, 121556, 127138, 127141, 127149, 127157 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 |
529,410 | ||
| YouTube | YouTube | YouTube+ Video Ads | 51484, 51491, 53141, 53143, 53144, 53145 | 121540, 121541, 121558, 121559, 127148, 127150, 127153, 127155, 127158, 127163, 127166, 127168 | yes | yes |
2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-01 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 2026-01-23 → 2026-12-31 |
412,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.