Report QA

Cycle / W and L Subaru / Order lines
build 2026.08.26-74 · f89b7d4

Order lines as stored

Every row W and L Subaru'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
Display Display Display Ads 14885 74364 yes yes 2023-10-03 → 2026-12-31 150,000
Mobile Conquesting Mobile Conquesting Mobile Conquesting Display & Video Ads 14885 27920, 27923 yes yes 2020-08-10 → 2026-12-31
2020-08-10 → 2026-12-31
200,000
Online Audio Online Audio Online Audio Ads 48365 114244 yes yes 2025-09-05 → 2026-12-31 30,000
Social Mirror Social Mirror Social Mirror Ads 14885 34574 yes yes 2021-02-11 → 2026-12-31 33,333
TikTok TikTok TikTok Display & Video Ads 14885 132231 yes yes 2026-06-10 → 2026-08-31 60,000
Video Video Video Ads 14885 27921 yes yes 2020-08-10 → 2026-12-31 60,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.