{"checked":14,"matched":14,"mismatch_count":0,"mismatches":[],"items":[{"label":"overview:total_cost","displayed_value":2833.6,"rederived_value":2833.6,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":12252.03,"rederived_value":12252.03,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_cost","displayed_value":2854.59,"rederived_value":2854.59,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":12276.01,"rederived_value":12276.01,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"placement:cost","displayed_value":2144.98,"rederived_value":2144.98,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":373.3,"rederived_value":373.3,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":310.97,"rederived_value":310.97,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":4.35,"rederived_value":4.35,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"waste:never_converted_waste","displayed_value":622.22,"rederived_value":622.22,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"waste:sb_never_converted_waste","displayed_value":994.21,"rederived_value":994.21,"matched":true,"delta":0.0,"source":"file:/opt/ppc-command-center/data/amazon/canmar-ca/sb-weekly/2026-06-19/search-terms.json","error":null},{"label":"harvest:total_search_term_cost","displayed_value":2833.6,"rederived_value":2833.6,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"oos:total_cost","displayed_value":1944.83,"rederived_value":1944.83,"matched":true,"delta":0.0,"source":"postgres:ads.sp_advertised_products","error":null},{"label":"profit:total_cost","displayed_value":2833.6,"rederived_value":2833.6,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"profit:total_sales","displayed_value":12252.03,"rederived_value":12252.03,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null}],"tolerance":0.02,"account":"canmar-ca","modules":[{"module":"overview","status":"ok","error":null},{"module":"placement","status":"ok","error":null},{"module":"waste","status":"ok","error":"catalog (2026-06-22) has 0 ASINs but all titles blank -> portfolio cross-classification disabled, long-tail waste still detected | showing top 200 of 1312 waste terms by cost; summary counts + /audit totals reflect the full set"},{"module":"harvest","status":"ok","error":null},{"module":"oos","status":"stale","error":"FBA inventory snapshot is 2026-06-22 (80 days old) -- OOS flags may be out of date"},{"module":"profit","status":"stale","error":"ExpandFi cache is 79d old (>10d) -- true-net-profit is STALE."}],"composites":[{"label":"harvest:harvestable_sales","displayed_value":2488.77,"source_trace":{"source":"derived:harvest_subset_of_sp_search_terms","query":"Python-side filter of the single-snapshot sp_search_terms pull: converters (MAX(purchases_7d)>0) in BROAD/PHRASE/auto/product-target buckets, term not already an EXACT keyword and not ASIN-shaped; SUM(per-grain sales_7d) over those terms. Composite of the account-wide ads.sp_search_terms anchor trace; not independently re-runnable by the auditor.","raw_value":2488.77,"params":{"account":"canmar-ca","snapshot_date":"2026-09-09","metric":"harvestable_sales","single_snapshot":true,"harvest_filter":"converters_in_non_exact_not_already_exact_not_asin","composite":true}},"note":"composite of an audited anchor; not independently re-runnable"},{"label":"harvest:harvestable_spend","displayed_value":163.89,"source_trace":{"source":"derived:harvest_subset_of_sp_search_terms","query":"Python-side filter of the single-snapshot sp_search_terms pull: converters (MAX(purchases_7d)>0) in BROAD/PHRASE/auto/product-target buckets, term not already an EXACT keyword and not ASIN-shaped; SUM(per-grain cost) over those terms. Composite of the account-wide ads.sp_search_terms anchor trace; not independently re-runnable by the auditor.","raw_value":163.89,"params":{"account":"canmar-ca","snapshot_date":"2026-09-09","metric":"harvestable_spend","single_snapshot":true,"harvest_filter":"converters_in_non_exact_not_already_exact_not_asin","composite":true}},"note":"composite of an audited anchor; not independently re-runnable"}],"composite_count":2,"all_matched":true}