Building A Dealer KPI Dashboard: 7 Numbers Every Sales Manager Should Track Daily

Most used-car operations track far too many numbers and act on far too few. The monthly P&L lands on the 8th of the following month, which is roughly 38 days too late to influence the cars sitting on the lot today. The DMS produces twenty-page reports that nobody reads beyond page two. The CRM dashboard shows pipeline metrics that flatter the team without measuring the business. The dealers who run consistently strong margins don't have more dashboards — they have shorter ones. A single page, seven numbers, looked at every morning. Each number has a clear threshold for action, and each threshold triggers a known response. This article walks through the seven numbers, why they matter more than the alternatives, and how to wire them into a daily routine that actually changes decisions. ## Why Daily, And Why Seven The case for daily review isn't about working harder. It's about catching problems while they're still cheap to fix. A pricing error caught on day 3 costs €100 to correct; the same error caught on day 21 costs €600 plus a discount that bruises a customer relationship. A leak in your lead-handling caught Monday morning costs Tuesday's training session; the same leak caught at month-end costs you the month. Seven is the number because seven is what a manager can hold in mind without a tool. Anything longer becomes a report you read once a week and forget. The discipline of compressing the dashboard down to seven forces the question: *which numbers actually drive my decisions today?* ## The Seven Numbers ### 1. Inventory Aging Buckets What it is: count of vehicles in stock by days-on-lot, in four buckets — 0–30 days, 31–60, 61–90, and 90+. Tracked as a count and as a percentage of total stock. Why it matters: aging inventory is the single largest hidden cost in most used-car operations. Floorplan interest, depreciation, and forgone reinvestment compound silently. The 90+ bucket is the most expensive money you didn't know you were spending. Action thresholds: aim for at most 5% of stock in 90+, at most 18% combined in 61–90 and 90+. When the 90+ bucket grows two days in a row, the manager personally reviews each car and either re-prices, relocates, or wholesales. No exceptions. ### 2. Days-To-Sell, Rolling 30-Day Median What it is: the median number of days each retail-sold car spent on lot, calculated across the most recent 30 sales. Why it matters: this is your real velocity metric. Average days-to-sell is misleading because one 200-day stale car distorts the number. The median tells you what's normal for your operation right now, which is what you need to spot drift. Action thresholds: every operation has a baseline — most European used-car operations sit at 28–42 days median. When the rolling median moves more than 4 days from your baseline in either direction, ask why. Slower means a pricing or sourcing problem. Faster means you may be leaving margin on the table. ### 3. Front-End Margin Per Unit, Rolling 30 Sales What it is: average gross margin (sale price minus all-in cost including reconditioning) on the most recent 30 retail sales, expressed in euros per unit. Why it matters: this is the number management often replaces with "total gross", which lets a strong volume month hide a margin problem. Per-unit forces honesty. If margin is sliding while volume is stable, the dealership is buying or pricing wrong, and the symptom shows up here long before it shows up in the P&L. Action thresholds: set a baseline based on your last six months. A drop of more than 8% versus baseline triggers a margin review — pull the bottom 10 units by margin and identify the pattern. Almost always, three or four cars explain most of the drop. ### 4. Lead-To-Test-Drive Conversion What it is: of the leads received in the last seven days that were qualified (real buyer, real budget, real timeline), what percentage came in for a test drive? Why it matters: this is where the sales process either works or doesn't. Pricing problems show up as low lead volume; process problems show up as low conversion from lead to drive. Most dealers can't tell which one is broken because they only track total leads. Action thresholds: a healthy used-car operation runs at 22–35% on this metric depending on segment. Below 18% for two weeks in a row is a process or response-time problem — usually first-response time over 30 minutes. Above 40% sustained means lead qualification is being done, which is good. ### 5. Test-Drive-To-Sale Conversion What it is: of the customers who took a test drive in the last 30 days, what percentage bought a car (any car, not necessarily the one they drove)? Why it matters: test-drives are expensive — they consume salesperson time, fuel, and lot logistics. The conversion rate from drive to sale is the cleanest measure of whether your sales team can close. It's also the metric most resistant to manipulation because the inputs are physical and visible. Action thresholds: 30–45% is the band most strong operations sit in. Below 25% sustained means either inventory mismatch (the cars on the lot aren't the cars buyers want) or a closing weakness. Above 50% sustained either means excellent sales execution or insufficiently aggressive lead acquisition. ### 6. Average Asking-Price Discount At Sale What it is: the average gap between original asking price and final sale price, on retail sales in the last 30 days. Why it matters: a small, stable discount means your pricing is calibrated. A growing discount means you're consistently asking too much, and the market is correcting you in negotiation. A discount of zero is also a warning — it usually means you're pricing too low and leaving margin behind. Action thresholds: most healthy operations sit between 1.5% and 4.0% average discount. Above 5% means systematic over-pricing — re-price the bottom quartile of stock. Below 1% means under-pricing — the next 10 cars should be listed €300–€500 higher and the metric watched. ### 7. Stock-To-Sales Ratio (Months Of Supply) What it is: current stock count divided by trailing 30-day sales count, expressed in months. A dealership with 120 cars in stock and 60 sales last month has a 2.0 stock-to-sales ratio. Why it matters: this is your cash-flow safety metric. Too low and you'll run out of inventory mid-month and lose sales you could have made. Too high and floorplan interest plus aging risk will eat margin you can't recover. It's also the cleanest single signal that you need to either ramp sourcing or stop sourcing. Action thresholds: most independent used-car operations target 1.8–2.4 months of supply. Above 2.6 means slow sourcing or speed up sales — usually means a price cut on the slowest 15%. Below 1.6 means accelerate sourcing — start tomorrow, not next week. ## How To Wire These Into A Daily Routine The dashboard only works as a daily routine. Recommended setup: Each morning at the same time — most managers pick 8:30am, before the showroom opens — spend 10 minutes on the seven numbers. Use a single page; whether it's a spreadsheet, a printout from your DMS, or a feed from a market data tool like Carindex, doesn't matter as long as it's the same page every day. Note any number that has crossed its action threshold. Decide on the action before the morning meeting. Communicate the action to the team in the morning meeting. Review the same numbers tomorrow. Two practical refinements. First, keep one column on the page for the trailing-7-day trend on each number — flat, up, down. The trend often matters more than the level. A margin number sliding three days in a row is a problem even if it hasn't crossed the threshold yet. Second, never review the dashboard alone. The fastest way to fix a number is for two people to look at it together — manager and used-car buyer, or manager and sales lead. Two pairs of eyes catch patterns one pair will miss. ## What To Leave Off The Dashboard A useful exercise is naming what isn't on the seven. Total revenue isn't on the dashboard — it's an output, not a driver. Number of leads isn't on the dashboard — lead volume without conversion data is misleading. Customer satisfaction scores aren't on the dashboard — they belong on a weekly review, not daily, because they don't move fast enough to act on. Website traffic, phone calls answered, and inventory photos uploaded all live elsewhere. The dashboard is for the seven numbers that, if any of them moves, you change behaviour today. Everything else belongs on a different cadence. ## Common Failure Modes Three patterns show up in dealerships that try this and abandon it within a quarter. The first is **threshold drift**. The thresholds get loosened the moment they're inconvenient. "We'll let the 90+ bucket run a bit higher this month — it's a slow season." That single decision converts the dashboard from a tool into decoration. Hold the thresholds; if they're genuinely wrong, change them deliberately, in writing, with a reason. The second is **measuring without acting**. Numbers without thresholds are wallpaper. Every metric in this dashboard has a defined response when it crosses its line. Without that response defined in advance, the morning routine becomes a ritual of looking and not doing. The third is **delegating the dashboard**. The general manager or used-car manager looks at the seven numbers personally. The moment it's delegated to an analyst whose job is to "fill it in", the connection between number and decision breaks. ## Actionable Takeaways Build the page this week. Use whatever tooling you already have — a spreadsheet works fine for the first quarter while you're calibrating thresholds. Set the seven thresholds based on your trailing 6-month baselines, not on industry averages. Look at the seven numbers every morning for a month. At the end of the month, you'll know which two or three numbers actually drove your decisions; tighten those, loosen the rest, and run it for another quarter. The dealers who pull ahead of their peers don't have access to better data than the rest of the market. They have the discipline to look at the same seven numbers, every morning, and to act on what they see. The dashboard is the cheapest and most boring competitive advantage in the business — which is exactly why most operations never build one.