Manager data quality
Clean, structured, and reconciled.
This report checks the product catalog, category placements, promotional offers, Costco comparison layers, and remaining proof gates from the current data files.
92 score8,739 products18,825 placements482 excludedpass statusin-progress audit
Manager snapshot
raw products9,221
brand products8,739
promo rows716
placement gap0
Brand filter audit
Raw rows reconcile to surfaced brand rows.
raw catalog9,221 source-backed rows
surfaced8,739 brand-actionable rows
excluded482 rows without reliable brand signal
reconciledyes
Summer BBQ Starts Here95 rowsProduce & Meat & Seafoodcommodity_or_service_category: 95not surfaced
Bread & Sandwiches42 rowsT&T Bakerycommodity_or_service_category: 42not surfaced
Pork40 rowsMeat & Seafoodcommodity_or_service_category: 40not surfaced
Beef36 rowsMeat & Seafoodcommodity_or_service_category: 36not surfaced
Fruiting Vegetables33 rowsFruits & Vegetablescommodity_or_service_category: 33not surfaced
Leafy & Root Vegetables33 rowsFruits & Vegetablescommodity_or_service_category: 33not surfaced
Birthday Cakes19 rowsT&T Bakerycommodity_or_service_category: 19not surfaced
Chicken & Poultry15 rowsMeat & Seafoodcommodity_or_service_category: 15not surfaced
Completion audit
Requirement proof map.
proven6/9 requirements
partial3 proof gates need stronger evidence
boundaryTrue observed price trends require a second dated T&T crawl, Costco USA final item price extraction remains partial, and cross-retailer matches remain review-only until package evidence agrees.
Use Office Hours QA, debate, and autoresearch to challenge the logic, QA the system, and improve it.provendirect-commandqa:office-hours, qa:debate, qa:autoresearch, truth QA, manager E2E QA, and data-quality report generation are wired and currently passing.ready
Promotional offer data must be captured as structured first-class data.provensource-backed-artifact775 raw promotional rows, 716 branded promotional rows, 1,018 timed promotion signals, 713 bounded windows.Use future crawls to close open windows when the source exposes new end dates.
The product catalog must be broader than a sample and preserve category crawl breadth.provensource-backed-artifact9,221 raw products, 8,739 branded products, 195/213 selected leaf categories with rows, 18,825 exact category placements, 0 placement gap.ready
Items without a clear brand must not be surfaced in brand intelligence.provenrow-contract482 no-brand rows excluded and reconciled; 8,739 surfaced rows carry clear brand signals.ready
The manager journey must prove data is clean, structured, reconciled, and exposed across UI/API/MCP.provenmulti-surface-contractQuality score 92/100, 12/12 dataset contracts passing, 8/8 provenance layers passing, 0 placement gap.ready
Price trend must be shown without inventing multi-date observed movement.partialtruth-boundary8,742 products have baseline observations across 1 observed date; 0 rows are ready for true observed trend.Run a second dated T&T crawl before labeling true observed rising, falling, or flat movement.
Costco Canada can be added only with warehouse, delivery, and Same-day price layers separated.provenbounded-source-layer25 Costco Canada Business Centre warehouse rows and 4 Same-day delivery rows captured with separate CAD price layers.Add more postal codes and warehouse shelf observations before treating Same-day delivery prices as local shelf prices.
Costco USA can be added only without claiming final item price where only savings are captured.partialbounded-source-layer129 Costco USA Business Delivery savings rows captured; 5 product-detail pages reachable, 5 price API probes credential-blocked, 0 final item prices captured.Capture product-detail or location/cart pricing before surfacing final USA item prices.
Cross-retailer comparison must only promote rows when matching evidence is strong.partialconservative-review957,610 T&T-to-Costco pairs reviewed, 191 brand-compatible pairs, 0 promoted safe matches, 29 review-only near matches.Promote comparison rows only after brand, product tokens, and package evidence agree.
Manager readiness
What is proven, partial, or still waiting.
Use Office Hours QA, debate, and autoresearch to challenge the logic and improve the system.provenqa:office-hours, qa:debate, qa:autoresearch, truth QA, and manager E2E QA are wired into package scripts and current validation.readyoffice_hours_debate_autoresearch
Capture promotional offer data as a structured first-class layer.proven775 raw promotional rows, 716 branded offer rows, 7 offer signal types, 1,018 dated signals.Use later crawls to close open-ended price-drop and flyer-category windows.promotional_offer_data
Capture the broader product catalog, not a small sample.proven9,221 raw rows, 8,739 surfaced branded rows, 195/213 selected leaf categories with rows, 18,825 exact category placements.Repeat the crawl on schedule to catch new, removed, and changed products.extensive_product_catalog
Do not surface items without a clear brand.proven482 no-brand rows excluded and reconciled; 8,739 surfaced rows have brand signals.readybrand_actionable_only
Give a manager an E2E view that proves data is clean, structured, and reconciled.proven12/12 dataset contracts pass; 8/8 provenance layers pass; placement gap is 0.readymanager_clean_structured_full
Show price trend without inventing multi-date movement.partial8,742 products have baseline observations across 1 observed date; 0 rows are ready for true observed trend.Run a second dated crawl before labeling true observed rising, falling, or flat movement.price_trend
Add Costco Canada comparison data while keeping warehouse, delivery, and Same-day prices separate.proven25 Costco Canada Business Centre warehouse rows and 4 Same-day delivery rows are captured with separate CAD price layers.Add more postal codes and warehouse shelf observations before treating Same-day delivery prices as local shelf prices.costco_canada
Add Costco USA after Canada without claiming final item price where only savings are captured.partial129 Costco USA Business Delivery savings rows captured; 5 product-detail pages reachable, 5 price API probes credential-blocked, 0 final item prices captured.Capture product-detail or location/cart pricing before showing final USA item prices.costco_usa
Compare retailers only when product matching is safe.partial957,610 T&T-to-Costco pairs reviewed; 0 safe matches promoted; 29 near matches kept review-only.Promote comparison rows only after brand, product tokens, and package evidence agree.retailer_matching
Provenance coverage
Every layer shows where it came from.
T&T product catalog6/6 pass8,739 rowstntsupermarket.com (8,739)2026-06-29
T&T exact category placements4/4 pass18,825 rowstntsupermarket.com (18,825)2026-06-29
T&T promotional offers4/4 pass716 rowstntsupermarket.com (716)2026-06-29
Brand filter exclusions4/4 pass482 rowstntsupermarket.com (482)2026-06-29
Costco Canada warehouse offers4/4 pass25 rowscostcobusinesscentre.ca (25)offer source
Costco Canada Same-day delivery offers5/5 pass4 rowssameday.costco.ca (4)2026-06-29
Costco USA savings rows4/4 pass129 rowscostcobusinessdelivery.com (129)offer source
Costco USA price readiness audit4/4 pass5 rowscostcobusinessdelivery.com (5)2026-06-29
Checks
Quality gates
T&T product rows are source-backedPASS8,739 surfaced productstnt_source_backed_products2026-06-29
No-brand rows are excluded from surfaced intelligencePASS482 no-brand rows excluded and reconciledbrand_filtering2026-06-29
Category placements are exact and reconcile with category capturesPASS18,825 exact placements, 0 gapexact_placements2026-06-29
Catalog coverage is broad and explicitPASS195/213 selected categories with rowscatalog_coverage2026-06-29
Promotional offers are structured and brand-filteredPASS716 branded promotional rowspromotional_offers2026-06-29
Promotion windows are extracted where source dates existPASS702 offers with timing, 713 bounded windowspromotion_windows2026-06-29
No fallback price rows are surfacedPASS0 fallback price rowsfallback_prices2026-06-29
Costco layers keep price types separatePASS25 Canada warehouse rows, 4 Canada Same-day rows, 129 USA savings rows, 5 USA price probescostco_boundaries2026-06-29
Retailer matching is audited before comparisonPASS957,610 pairs reviewed, 0 promoted, 29 review-onlyretailer_matching_audit2026-06-29
Price history baseline exists, but multi-date trend is pendingPASS8,742 baseline rows, 1 observed date, 0 observed trend rowsprice_history_baseline2026-06-29
Source, timestamp, price, and image provenance is explicitPASS8/8 source layers with field-level coverageprovenance_coverage2026-06-29
Dataset contracts are completePASS12/12 contracts passdataset_contracts2026-06-29
Data contracts
Required fields by dataset
T&T surfaced productsPASS8,739 rows0 missing12 fields
T&T exact placementsPASS18,825 rows0 missing9 fields
T&T promotional offersPASS716 rows0 missing10 fields
T&T promotion windowsPASS1,018 rows0 missing11 fields
Brand filter exclusionsPASS482 rows0 missing9 fields
T&T catalog coverage categoriesPASS213 rows0 missing7 fields
Costco Canada warehouse offersPASS25 rows0 missing11 fields
Costco Canada Same-day delivery offersPASS4 rows0 missing18 fields
Costco USA savings rowsPASS129 rows0 missing11 fields
Costco USA price readiness auditPASS5 rows0 missing18 fields
Retailer matching review candidatesPASS29 rows0 missing11 fields
T&T price history auditPASS8,742 rows0 missing14 fields
Remaining proof gates
What still needs stronger evidence
nextRun a second dated T&T crawl on a later date for true observed price movement.
nextAdd richer T&T flyer/date metadata when a durable source exposes exact flyer windows.
nextExpand Costco Canada Same-day to more postal codes and compare only within the labeled delivery-price layer.
nextCapture conservative Costco USA product-detail or location pricing before surfacing final item prices.
nextJoin retailer rows only after SKU/name/package matching avoids false positives.