Report QA

Cycle / Bone and Joint / Order lines
build 2026.08.26-80 · a446bbe

Order lines as stored

Every row Bone and Joint'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 53518 128517, 128647, 130816 yes yes 2026-04-02 → 2026-12-31
2026-05-18 → 2026-12-31
2026-07-01 → 2026-12-31
134,400
Display Display Display Ads 53518 128501 yes yes 2026-05-18 → 2026-12-31 85,000
Meta Meta Meta Display & Video Ads 53518 128505 yes yes 2026-05-18 → 2026-12-31 66,000
Mobile Conquesting Mobile Conquesting Mobile Conquesting Display & Video Ads 53518 128504 CANCELED yes 2026-05-01 → 2026-12-31 50,000
PPC PPC Pay-Per-Click Ads 53518 128502 yes yes 2026-05-18 → 2026-12-31 $1,960.00
$15,680 total
Social Mirror Social Mirror Social Mirror Ads 53518 128507 yes yes 2026-05-18 → 2026-12-31 50,000
Video CTV, Video CTV + Video Ads 53518 128517, 128647, 130816 yes yes 2026-04-02 → 2026-12-31
2026-05-18 → 2026-12-31
2026-07-01 → 2026-12-31

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.