Daily Dealership Dashboard: Metrics Every Dealer Needs

lead">A focused daily dashboard gives owners and managers the minimum numbers they need to act, not every vanity metric. Pick 8 KPIs, automate their capture, set 2–3 escalation rules, and run a 10-minute morning huddle to remove friction from daily decisions.

Why a tight daily dashboard matters

Dealers moving 20–200 cars per month don’t have time for long reports. You need one screen that tells you: are we selling enough today, is recon blocking sales, and which cars are at risk of long aging. A tight dashboard turns questions into immediate actions: price change, promo, pull for wholesale, or extra outreach.

The 8 KPIs to show every day

Limit the dashboard to eight numbers. Each should be trackable in real time and drive a single action.

1) Units sold (last 7 days / month-to-date)

Why: sales velocity. How to use it: compare 7-day to the same weekday last week and month-to-date to plan staffing and floor moves. Target ranges: small dealers (20–50/month) watch for 1–3 units/day; larger (100–200/month) aim 4–8 units/day.

2) Retail gross per unit (GP/unit, last 7 days)

Why: profitability. Formula: total retail gross / units sold. Action: if GP/unit falls below your minimum (set by model year or segment), tighten finance add-ons or push higher-margin units into rotation.

3) Average days-to-sell (inventory days)

Why: inventory health. Formula: (sum of days-on-lot for sold units) / units sold. Target: 14–30 days depending on market and price point. If average rises by >20% week-over-week, trigger price review for the top 10% oldest units.

4) Lot count by aging bucket

Why: identifies concentration of risk. Use buckets: 0–14, 15–30, 31–60, 61+. Action: for 31–60+ units, schedule immediate price drops, local promos, or wholesale targets. Maintain a single-list of vehicles for weekly wholesale consideration.

5) Recon pipeline (units in recon / average recon days)

Why: stuck recon creates artificial aging. Display number of units currently in recon and their average days. If recon days exceed your target by >2 days, escalate to your shop lead and consider swapping priorities; use the inspection/recon matrix in your reconciliation plan for targets. See our standard inspection matrix guide for recon day targets.

6) Leads: open leads and first-response time (median)

Why: lead decay is fast. Track open leads and median first-response time. Target: under 15 minutes for inbound chats/calls, under 60 minutes for email. If median response exceeds targets for a day, move closer to 1-touch follow-up staffing or auto-assign tasks.

7) Appointments & test-drive conversion

Why: pipeline quality. Display appointments scheduled (next 48 hours) and percent converting to test drives. Target conversion: 40–60% of appointments to test drives; 20–35% of test drives to sale depending on inventory. Low conversion suggests poor lead qualification or poor lot presentation.

8) Marketing cost per sale (7-day rolling)

Why: ROI. Formula: marketing spend credited to sold units / units sold. Use channel tagging in your CRM so you can see which platforms push the most cost-effective deals. If CPLs creep up, reallocate spend or test a creative change for 7 days before deciding.

Dashboard layout and visual rules

Keep layout simple: single-row KPIs across the top, a pipeline table in the middle, and exceptions (aged units, stalled recon, overdue leads) at the bottom. Use color sparingly: green = within target, amber = warning, red = action required.

Example panel order

• Top row: Units sold (7d / MTD), GP/unit, Days-to-sell
• Middle: Leads open / median response, Appointments next 48h / conversion
• Right column: Recon pipeline (units & avg days), Marketing CPL
• Bottom: Exception lists — top 10 oldest units, recon holds >7 days, leads >24h

Escalation rules: what to automate

Set 2–3 simple rules that create tasks or alerts automatically. Examples that work in practice:

• Any vehicle hitting 31 days: auto-create a price-review task for manager and sales lead within 24 hours.
• Recon days > target +2: escalate to shop lead with an 8-hour SLA to comment.
• Lead first-response median > target: add temporary phone/chat coverage that day and notify sales manager.

Daily routine tied to the dashboard

Turn the dashboard into a daily operating rhythm. A consistent routine prevents firefighting.

8:45–9:00 — quick morning review (owner/manager)

Scan the 8 KPIs. If anything is red, note it and call a focused 10-minute huddle.

9:00–9:10 — 10-minute huddle with floor, sales lead, and shop

Cover three things: top risk vehicle(s) and action, recon blockers, and staffing for appointments that day. Assign one owner per action and set a 24-hour follow-up.

End-of-day — short closeout

Record the day’s actuals (units sold, GP/unit), update notes on exceptions, and publish a single-line summary to your team chat: 1) wins, 2) top risk, 3) required help tomorrow.

Data hygiene and implementation tips

• Automate capture where possible. Your DMS or CRM should feed live numbers; reduce manual entry to keep the dashboard current.
• Standardize definitions: what counts as a lead, how you tag marketing channels, how you record recon days. Without consistent definitions the numbers lie.
• Start with a 7-day baseline. Don’t set irrevocable thresholds on day one. Watch the metrics for a week to understand natural variance, then set targets.
• Limit ad-hoc rows. If a metric isn’t used to decide an action within a week, remove it.

Tools and integrations

Most dealers can build a working dashboard using their DMS + spreadsheet or a lightweight BI tool. If you want an integrated view that ties inventory, recon, and leads into one screen, look for a platform that syncs DMS, CRM, and marketplace feeds. See feature notes on integration and automation in the product feature list for ideas.

For recon-specific targets and how they affect days-to-sell, our standard inspection matrix guide shows recon-day targets and common bottlenecks.

Common objections and how to handle them

"We already know which cars are slow" — knowing and documenting are different. Put it on the dashboard so action happens consistently. "The dashboard takes time to maintain" — automation and strict definitions cut maintenance to 5–10 minutes daily.

What to do this week

• Pick the 8 KPIs above and define one clear target for each (use a 7-day baseline if unsure).
• Create the dashboard in your DMS or a single spreadsheet; automate data pulls where possible.
• Set three escalation rules (aged 31 days, recon breach, slow lead response) and assign owners.
• Run a 10-minute morning huddle for five business days and record the difference in decisions made.

If you want a reference on recon timing and inspection priorities while you build the dashboard, review our recon matrix write-up in the guides.