Report QA

Cycle / Hansel Auto Group / Order lines
build 2026.08.26-74 · f89b7d4

Order lines as stored

Every row Hansel Auto Group'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.

ProductWould beRaw name on the order OrderLine itemsLive Ran in 2026-07Flights Impressions
a month
Budget
a month
Ad spend
CTV CTV, Video Amazon Premium CTV + Video Ads 51685, 53553, 53556, 53560 122340, 128623, 128627, 128643 yes yes 2026-04-06 → 2027-03-31
2026-04-07 → 2027-03-31
2026-06-28 → 2026-07-05
2026-06-29 → 2026-07-05
100,806
Video CTV, Video Amazon Premium CTV + Video Ads 51685, 53553, 53556, 53560 122340, 128623, 128627, 128643 yes yes 2026-04-06 → 2027-03-31
2026-04-07 → 2027-03-31
2026-06-28 → 2026-07-05
2026-06-29 → 2026-07-05
YouTube YouTube YouTube+ Video Ads 51685, 53553, 53559, 53560 122357, 128624, 128631, 128644 yes yes 2026-04-06 → 2027-03-31
2026-05-01 → 2027-03-31
2026-06-28 → 2026-07-05
2026-06-29 → 2026-07-05
172,617

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.