Report QA

Cycle / Farmington / Order lines
build 2026.08.26-75 · 439c450

Order lines as stored

Every row Farmington'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 CTV + Video Ads 48058 132217, 132387, 132389, 133347 yes yes 2026-06-09 → 2026-08-31
2026-06-16 → 2026-08-31
2026-06-16 → 2026-08-31
2026-07-06 → 2026-09-30
205,554
Display Display Geo-Framing Display Ads 48058, 54763 132476, 133348 yes yes 2026-06-26 → 2026-07-31
2026-07-06 → 2026-09-30
251,111
Mobile Conquesting Mobile Conquesting Mobile Conquesting Event/Political Display & Video Ads 48058, 54763 132386, 134724 yes yes 2026-06-11 → 2026-07-11
2026-07-30 → 2026-09-02
160,000
Social Mirror Social Mirror Social Mirror Ads 48058 132216, 132218, 132388, 132390, 132687, 133350 yes yes 2026-06-09 → 2026-07-31
2026-06-09 → 2026-08-31
2026-06-15 → 2026-08-31
2026-06-18 → 2026-07-04
2026-07-06 → 2026-08-31
2026-07-06 → 2026-09-30
640,978
Video CTV, Video CTV + Video Ads 48058 132217, 132387, 132389, 133347 yes yes 2026-06-09 → 2026-08-31
2026-06-16 → 2026-08-31
2026-06-16 → 2026-08-31
2026-07-06 → 2026-09-30
YouTube YouTube YouTube+ Video Ads 48058 112716, 124228, 133352 yes yes 2026-02-01 → 2026-07-09
2026-03-01 → 2026-07-06
2026-07-06 → 2026-09-30
137,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.