Report QA

Cycle / Service One Credit Union / Order lines
build 2026.08.26-74 · f89b7d4

Order lines as stored

Every row Service One Credit Union'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 52753 125966, 125969 yes yes 2026-04-15 → 2027-03-31
2026-04-15 → 2027-03-31
105,594
DOOH DOOH Digital Out-Of-Home (DOOH) Display & Video Ads 52753 125999 yes yes 2026-04-15 → 2027-03-31 33,333
Meta Meta Meta Lead Display & Video Ads 52753 126007, 126397 yes yes 2026-03-15 → 2027-02-28
2026-05-29 → 2027-04-30
85,000
PPC PPC Pay-Per-Click Ads 52750, 52761 125962, 125992 yes yes 2026-03-01 → 2026-08-31
2026-06-01 → 2026-11-30
$1,750.00
$10,500 total
SEO SEO SEO 52761 125994 CANCELED yes 2026-03-01 → 2026-08-31
Social Mirror Social Mirror Social Mirror Ads 52753 126004 CANCELED yes 2026-03-15 → 2027-02-28 102,941
Video CTV, Video Amazon Premium CTV + Video Ads 52753 125966, 125970 yes yes 2026-04-15 → 2027-03-31
2026-04-15 → 2027-03-31
19,259
YouTube YouTube YouTube+ Video Ads 52753 126008 yes yes 2026-04-15 → 2027-03-31 62,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.