Order lines as stored
Every row HomeFed - Live Otay Ranch wvid'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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Meta | Meta | Meta Display & Video Ads | 52630, 52654 | 125549, 125635 | yes | yes |
2026-04-01 → 2026-09-30 2026-06-16 → 2026-09-30 |
268,160 | ||
| PPC | PPC | Pay-Per-Click Ads | 52630, 52654 | 125552, 125639 | yes | yes |
2026-04-01 → 2026-09-30 2026-06-16 → 2026-09-30 |
$3,948.00 $19,992 total |
||
| Performance Max | Performance Max | Performance Max Ads | 52654 | 125651 | yes | yes | 2026-06-16 → 2026-09-30 |
$10,560 total |
||
| TikTok | TikTok | TikTok Display & Video Ads | 52630, 52654 | 125551, 125638 | yes | yes |
2026-04-01 → 2026-09-30 2026-06-22 → 2026-09-30 |
261,120 | ||
| Video | Video | Video Ads | 52630, 52654 | 125550, 125637 | CANCELED | yes |
2026-04-01 → 2026-09-30 2026-04-01 → 2026-09-30 |
259,259 |
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.