{"checked":13,"matched":13,"mismatch_count":0,"mismatches":[],"items":[{"label":"overview:total_cost","displayed_value":21796.16,"rederived_value":21796.16,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":39420.07,"rederived_value":39420.07,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_cost","displayed_value":23010.01,"rederived_value":23010.01,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"overview:total_sales","displayed_value":39757.18,"rederived_value":39757.18,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"placement:cost","displayed_value":10433.87,"rederived_value":10433.87,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":7016.72,"rederived_value":7016.72,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":4257.94,"rederived_value":4257.94,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"placement:cost","displayed_value":56.67,"rederived_value":56.67,"matched":true,"delta":0.0,"source":"postgres:ads.sp_placements","error":null},{"label":"waste:never_converted_waste","displayed_value":8995.56,"rederived_value":8995.56,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"harvest:total_search_term_cost","displayed_value":21617.21,"rederived_value":21617.21,"matched":true,"delta":0.0,"source":"postgres:ads.sp_search_terms","error":null},{"label":"oos:total_cost","displayed_value":7628.82,"rederived_value":7628.82,"matched":true,"delta":0.0,"source":"postgres:ads.sp_advertised_products","error":null},{"label":"profit:total_cost","displayed_value":21796.16,"rederived_value":21796.16,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null},{"label":"profit:total_sales","displayed_value":39420.07,"rederived_value":39420.07,"matched":true,"delta":0.0,"source":"postgres:ads.sp_campaigns","error":null}],"tolerance":0.02,"account":"mess","modules":[{"module":"overview","status":"ok","error":null},{"module":"placement","status":"ok","error":null},{"module":"waste","status":"ok","error":"SB waste unavailable: no sb-weekly snapshots for account 'mess' at /opt/ppc-command-center/data/amazon/mess/sb-weekly (SP-only this account) | showing top 200 of 3036 waste terms by cost; summary counts + /audit totals reflect the full set"},{"module":"harvest","status":"ok","error":"exact set is Postgres-only (no sb-weekly keyword export (no sb-weekly snapshots for account 'mess' at /opt/ppc-command-center/data/amazon/mess/sb-weekly))"},{"module":"oos","status":"stale","error":"FBA inventory snapshot is 2026-06-22 (60 days old) -- OOS flags may be out of date"},{"module":"profit","status":"stale","error":"ExpandFi cache is 60d old (>10d) -- true-net-profit is STALE."}],"composites":[{"label":"harvest:harvestable_sales","displayed_value":11490.37,"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":11490.37,"params":{"account":"mess","snapshot_date":"2026-08-21","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":1001.2,"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":1001.2,"params":{"account":"mess","snapshot_date":"2026-08-21","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}