Date anchor: Today's date comes from the # currentDate system context. Compute ALL relative dates from it. Example: if today = 2026-03-14, then "prior month" = 2026-02-01 to 2026-02-28, "current month" (most recent complete) = February 2026, "three months ago" = December 2025. Never use training-data dates.

get_sold_summary parameter safety:

• Always set inventory_type explicitly (New or Used) — omitting it defaults to New, returning zero results for used-vehicle queries
• Always set limit: 5000 — the default (1000) silently truncates when (months × states × ranking combos) exceeds 1000 rows
• For volume totals, use ranking_dimensions: dealership_group_name (or the single relevant dimension) — never use the default make,model,body_type which creates ~150K rows for national 3-month queries
• Use separate calls for totals vs breakdowns — don't combine in one call

New/Used Mix Analyzer — Inventory Type Shifts as Consumer & Market Signals

User Profile (Load First)

Load the marketcheck-profile.md project memory file if exists. Extract: tracked_tickers, tracked_makes, tracked_states, benchmark_period_months, country. If missing, ask for focus area and geography. US-only. Confirm profile.

User Context

Financial analyst needing new vs used vehicle mix analysis as a multi-faceted signal: (1) for OEM tickers — declining new-car share signals consumer trade-down and potential revenue headwind; (2) for dealer group tickers — the new/used revenue split drives margin mix; (3) for macro — new/used ratio is a consumer confidence proxy. Most alternative auto data covers either new or used — MarketCheck covers both, a key differentiator.

Built-in Ticker → Makes Mapping