Order lines as stored
Every row Meadowbrook Apartments - Lawrence'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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Live Chat | Live Chat | Live Chat | 46197, 52452 | 105338, 125069 | yes | yes |
2025-04-16 → 2027-03-31 2026-04-01 → 2027-03-31 |
|||
| Meta | Meta | Meta Display & Video Ads | 46197, 52452 | 105240, 125068 | yes | yes |
2025-04-22 → 2027-03-31 2026-04-01 → 2027-03-31 |
206,666 | ||
| Performance Max | Performance Max | Performance Max Ads | 54037 | 130173 | PAUSED | yes | 2026-06-19 → 2026-10-15 |
$6,000 total |
||
| Social Mirror | Social Mirror | Social Mirror Ads | 54037 | 132279 | yes | yes | 2026-06-23 → 2026-10-15 | 88,235 | ||
| TikTok | TikTok | TikTok Display & Video Ads | 52452, 54037 | 125067, 132278 | CANCELED | yes |
2026-04-01 → 2027-03-31 2026-06-15 → 2026-09-15 |
140,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.