Classic Auto Group — Response Time & Lead Dashboard

Greater Cleveland, Ohio  ·  May 2026  ·  16 Dealerships  ·  10 Daily Reports  ·  99 Graded Leads

MTD LIVE
Month-to-Date Snapshot (as of May 23)

Top 5 Recommended Actions

Prioritized by impact on appointment conversion and lead quality — based on 10 days of trend data

1

Classic Chevrolet: Establish Dedicated Weekend Internet Lead Coverage

A new and alarming pattern emerged in the May 22–23 data: Chevrolet’s response time spiked to 11.5 min on Friday May 22 and 9.0 min on Saturday May 23 — With 529 MTD leads (the most in the group), a structured weekend coverage plan is the highest-leverage single change available to this store.

2

Classic Hyundai: Address Response Time and Conversion Rate as Separate Issues

Hyundai has the second-highest lead volume (431 MTD leads) and the group’s worst conversion rate at 12.8%. On May 23, response time reached 9.45 minutes These are distinct gaps requiring distinct solutions: weekend staffing for response time, and process coaching for weekday conversion quality. On May 18, they took 19 leads and set zero appointments with a 0.53-min RT, indicating the conversion gap is independent of speed.

3

Classic Lexus: Sustain Response Time Gains and Rebuild Video Consistency

After a 17.9-min response time on May 21, Lexus recovered to 1.7 min (May 22) and 2.75 min (May 23) MTD conversion has moved from a high of 47% earlier in the month to 39.0% as of May 23. The RT fixes are working; now the focus should shift to sustaining video send consistency (they sent 0 videos on May 21) and converting the pipeline they’ve already built.

4

Classic Chevrolet: Conversion Rate Improvement Represents the Largest Volume Opportunity

Chevrolet converts at 17.0% MTD on 529 leads. Classic Westside Mazda converts at 45.3%. If Chevrolet simply matched the group average of ~25%, that would represent roughly 42 additional appointments this month. First-response quality and follow-up cadence are the primary variables — both are addressable through targeted coaching.

5

Classic Toyota: Process Consistency Makes This Store Ready for Conversion Coaching

Toyota has grown to 401 MTD leads — third highest in the group — while improving their MTD conversion from 23.6% on May 11 to 22.4% as of May 23. Their RT has been mostly under 3 min since the early-month 16.7-min spike. With the process baseline in place, this store is well-positioned to move conversion toward 30%+ through video adoption and follow-up coaching.

Average Response Time — Daily Trend by Store

Target: under 3 minutes. Red dashed line = 3-minute threshold. Hover for exact values.

Daily Appointments Set

All stores combined — select a store above to isolate

MTD Appointment Conversion Rate by Store

% of total MTD leads that resulted in a set appointment (as of May 21)

Daily Lead Volume

Working hours vs. after-hours breakdown

Daily Video Send Rate

Videos sent per day. Values above 100% mean multiple videos per lead — good practice.

MTD Lead Accumulation — All Stores

Cumulative month-to-date leads per store. Shows which stores are building pipeline fastest.

Lead Pressure Analysis

Lead Pressure Heatmap — Store × Day

Each cell shows a store’s lead volume relative to its own 10-day average. Deep red = unusually high volume; blue = light day. RT flag (⚠) marks days above 3-minute target.

Pressure vs. Performance — All 160 Store-Days

X = daily leads · Y = conversion rate · Bubble size = response time (larger = slower). Each color is one store. Hover any bubble for details.

Sales Process Grading — 99 Evaluated Leads · Apr 28 – May 18, 2026

Average Grade Score by Store

Score 0–100. Green = A (≥90) · Blue = B (80–89) · Yellow = C (70–79) · Orange = D (60–69) · Red = F (<60). 18 weighted criteria per lead.

Top Failure Areas — Weighted by Criterion Importance

% of graded leads scoring zero on each criterion. Hover for full question text and weight.

Grade Score vs. MTD Conversion — Store-Level Correlation

Calculating correlation…

X = avg grade score · Y = MTD conversion % · Bubble size = avg response time. Larger bubbles = slower RT.

Salesperson Leaderboard — All Graded Reps

Sorted by average grade score. Score reflects response quality, phone follow-up, appointment setting & pricing.

Store Scorecard — May MTD Summary

Ranked by MTD appointment conversion rate. Color coding: Green ≥ 35% · Yellow 25–35% · Orange 15–25% · Red < 15%

# Store MTD Leads MTD Appts Conversion Avg Response Time Avg Daily Videos Trend
Classic Auto Group  ·  Greater Cleveland, OH  ·  Daily Data: May 11–23, 2026  ·  Grades: Apr 28–May 18, 2026 Dashboard generated by Claude · Updated each time new spreadsheets are added