P5: Market Intelligence Report Generator

Build an automated Market Intelligence Report generator that queries StoreLeads + BigQuery data to produce PDF/HTML reports for logistics companies. Report structure: 1. Executive Summary — market size, growth trends, key findings 2. Store Analysis — filter by industry/region/product type, show store counts, avg revenue 3. Product Classification — top HTS chapters, duty rate distribution 4. Competitive Landscape — vendor concentration, market share estimates 5. Opportunity Matrix — stores without customs broker, high duty exposure targets 6. Recommendations — specific stores to target, estimated revenue per prospect Data sources: - BigQuery: c8_intel.product_patterns (10.5M patterns), c8_intel.stores_enriched (1.3M stores) - BigQuery: c8_intel.vendinn_profiles (vendor intelligence) - BigQuery: c8_trade_ref.hts_tariffs (tariff rates) Output format: HTML template (convertible to PDF via wkhtmltopdf or Puppeteer) Pricing: $2,500-5,000 per report (Revenue Stream #23) Output: Python script + HTML template Target: c8_platform/intelligence/report_generator.py