Skip to content

Data Warehouse Team — Start Here

Who this is for: Ray Nawara's team building SavvyDealerDataWarehouse (Rails multi-AI-agent system for dealership analytics).

Your mission overlap with Adam's portfolio: Adam has built the data sources, scraping pipelines, and analyst persona prompts that your warehouse should ingest. Your job is the unified multi-agent analytics layer that synthesizes all of it for dealers.

Before you build a new pipeline, check whether it already exists. Extend over rebuild.

The critical handoff

1. savvy-batch-analyst-prompts — This is the persona seed for your agents

  • 5 v4 prompts (Sales / BDC / Marketing / Inventory / Executive Synthesizer)
  • Markdown + observational style, calibrated on real dealer-review calls (Spinach corpus)
  • Design philosophy: dealer trust lifecycle, 20-min call target, conclusion-first not journey-first, personas REPLACE Adam not assist him
  • Includes PHASE2_WAREHOUSE_WORK.md with Adam's recommended warehouse integration path + CASE_FOR_CHANGE.md

Action: read all 7 files in C:/Users/adam/savvy-batch-analyst-prompts/ before seeding analyst agents in the warehouse.

2. SavvyDealerDataWarehouse-context — Shared context bridge

Adam maintains a cached context of your Rails repo (schemas, services, jobs, models, persona seeds). Keep this in sync — it's how both sides stay aligned when Adam's prompts evolve and your pipeline evolves in parallel.

Data sources Adam already built — ingest these, don't rebuild

Source What you get Refresh cadence
Savvy API Vehicle inventory by site ID + incentives per VIN. sellingPrice is authoritative. Never scrape Google Sheets. Real-time
savvydealer-inventory-tracker Multi-dealer inventory w/ hash-based change detection (Playwright) Daily cron
lease-scraper Ford + Nissan lease offers, 4 dealers live, MF/RV logic On rate release
dealership-intel 7K+ Ford / 2K Honda / 1.2K Kia / Nissan / Mitsubishi dealers + staff contacts Periodic
competitive-dashboard Competitor pricing + inventory scores, cross-scraper model normalization Daily
vehicle-features Canonical vehicle specs + features DB Ongoing
incentive-matcher Dealer vs factory incentive comparison Per program
nissan-stickers Monroney PDFs by VIN (pattern is extensible to other brands) Daily cron
powersports-data 15+ OEM powersports specs / pricing / images Per scrape
rv-catalog 65 RV manufacturers, models, floorplans Wave-based
gm-scraper GM/Chevy parts catalog (4 SimplePart domains) Ongoing
Thunder-Bob R&R ERA DMS data extraction Per integration
ai-crm QuickBooks + dealer financial state (MRR, expenses) Real-time via webhook

Infrastructure already in place

What we explicitly want from the warehouse

  1. Cross-source joins that Adam's individual scrapers can't do alone (e.g., "for every dealer in dealership-intel, pull their inventory velocity from savvydealer-inventory-tracker and their ad spend from ai-crm").
  2. Persona-driven batch reports consuming savvy-batch-analyst-prompts — generate Sales / BDC / Marketing / Inventory + Executive Synthesis per dealer, per week.
  3. Historical snapshots so competitive trends can be measured over time (competitive-dashboard captures "now"; warehouse captures the timeline).

What we DON'T want

  • ❌ New scrapers for dealer inventory, leases, OEM specs, or dealer directories — those exist.
  • ❌ A second canonical inventory API — Savvy API is it. Read from Savvy API; never re-scrape.
  • ❌ Duplicate persona prompts. Adam's v4 is calibrated on real calls. Extend via savvy-batch-analyst-prompts/.
  • ❌ A separate webhook contract system — use integration-standards.
  1. This page.
  2. savvy-batch-analyst-prompts 1-pager → then the 7 files in C:/Users/adam/savvy-batch-analyst-prompts/.
  3. Savvy API 1-pager → Adam will share credentials.
  4. integration-standards 1-pager → for contracts you'll need to honor.
  5. competitive-dashboard 1-pager → see how Adam's scoring pipeline works today.
  6. The full Inventory "What NOT to duplicate" section.

Questions: Adam (support@savvydealer.com).