{"checked":14,"matched":14,"mismatch_count":0,"mismatches":[],"items":[{"label":"overview:total_cost","displayed_value":2917.13,"rederived_value":2917.13,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":5796.32,"rederived_value":5796.32,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_cost","displayed_value":3101.0,"rederived_value":3101.0,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":5333.41,"rederived_value":5333.41,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"placement:cost","displayed_value":2234.26,"rederived_value":2234.26,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":339.16,"rederived_value":339.16,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":335.05,"rederived_value":335.05,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":7.86,"rederived_value":7.86,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"waste:never_converted_waste","displayed_value":1428.21,"rederived_value":1428.21,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"waste:sb_never_converted_waste","displayed_value":896.1,"rederived_value":896.1,"matched":true,"delta":0.0,"source":"file:/opt/ppc-command-center/data/amazon/canmar/sb-weekly/2026-06-18/search-terms.json","error":null},{"label":"harvest:total_search_term_cost","displayed_value":2917.52,"rederived_value":2917.52,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"oos:total_cost","displayed_value":2256.54,"rederived_value":2256.54,"matched":true,"delta":0.0,"source":"postgres:ads.sp_advertised_products","error":null},{"label":"profit:total_cost","displayed_value":2917.13,"rederived_value":2917.13,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"profit:total_sales","displayed_value":5796.32,"rederived_value":5796.32,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null}],"tolerance":0.02,"account":"canmar","modules":[{"module":"overview","status":"ok","error":null},{"module":"placement","status":"ok","error":null},{"module":"waste","status":"ok","error":"showing top 200 of 464 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 (70 days old) -- OOS flags may be out of date"},{"module":"profit","status":"stale","error":"ExpandFi cache is 69d old (>10d) -- true-net-profit is STALE."}],"composites":[{"label":"harvest:harvestable_sales","displayed_value":2929.66,"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":2929.66,"params":{"account":"canmar","snapshot_date":"2026-08-30","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":606.6,"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":606.6,"params":{"account":"canmar","snapshot_date":"2026-08-30","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}