Report QA

Cycle / Sonoma County Fair / Order lines
build 2026.08.26-74 · f89b7d4

Order lines as stored

Every row Sonoma County Fair'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 54481 133932, 133938 yes yes 2026-07-15 → 2026-08-15
2026-07-15 → 2026-08-15
104,838
Meta Meta Meta Display & Video Ads 54481 131674, 133941, 133942, 133943, 133944 yes yes 2026-05-27 → 2026-07-31
2026-07-16 → 2026-08-07
2026-07-16 → 2026-08-14
2026-07-16 → 2026-08-14
2026-07-17 → 2026-08-15
351,850
Mobile Conquesting Mobile Conquesting Mobile Conquesting Display & Video Ads 54481 133935, 133936 yes yes 2026-07-15 → 2026-08-15
2026-07-21 → 2026-08-15
294,117
Social Mirror Social Mirror Social Mirror Ads 54481 133931, 133939 yes yes 2026-07-15 → 2026-08-15
2026-07-15 → 2026-08-15
355,614
TikTok TikTok TikTok Display & Video Ads 54481 133929 yes yes 2026-07-15 → 2026-08-15 222,222
Video CTV, Video Amazon Premium CTV + Video Ads 54481 133932, 133938 yes yes 2026-07-15 → 2026-08-15
2026-07-15 → 2026-08-15
YouTube YouTube YouTube+ Video Ads 54481 133930 yes yes 2026-07-15 → 2026-08-15 142,857

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.