Classic Auto Group — Response Time & Lead Dashboard
Greater Cleveland, Ohio · May 2026 · 16 Dealerships · 10 Daily Reports · 99 Graded Leads
🎯 Top 5 Prescriptive Actions
Prioritized by impact on appointment conversion and lead quality — based on 8 days of trend data
Classic Chevrolet Has Developed a Weekend RT Crisis
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 — after being mostly under 3 min all week. Weekend staffing is clearly the culprit. With 529 MTD leads (the most in the group), every minute above the 3-min threshold costs conversions at scale. Assign a dedicated weekend internet lead handler immediately.
Classic Hyundai’s RT Spiked on Saturday — Compounding a Conversion Problem
Hyundai has the second-highest lead volume (431 MTD leads) and the group’s worst conversion rate at 12.8%. On May 23, their response time hit 9.45 minutes — a new spike on top of a pre-existing conversion gap. Two separate problems now need two separate fixes: weekend staffing for RT, and scripting/coaching for weekday conversion quality. On May 18, they took 19 leads and set zero appointments with a perfectly fine 0.53-min RT, confirming the conversation quality issue is independent of speed.
Classic Lexus Response Time Is Improving — But Not Consistently
After the disastrous 17.9-min spike on May 21, Lexus recovered to 1.7 min (May 22) and 2.75 min (May 23) — a genuine improvement worth acknowledging. However their MTD conversion has drifted down from a peak of 47% early 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.
Classic Chevrolet’s Conversion Rate Remains the Core Volume Problem
Even setting aside the weekend RT spikes, Chevrolet converts at only 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. The RT fix will help, but the deeper issue is first-response quality and follow-up cadence — coachable behaviors that need direct intervention now.
Classic Toyota Is the Group’s Quiet Riser — Worth Watching and Supporting
Toyota has quietly climbed 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. They’re the most improved store over the 10-day window and represent the best opportunity to coach toward Westside Mazda-level conversion (45%+) since their process fundamentals are now mostly sound. Targeted video adoption coaching could push them over 30%.
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 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.
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 |
|---|