The forecasting problem

Most dealership principals and GMs know their monthly unit sales number. Many can tell you their average price and gross profit. But ask a sales manager which of today’s text threads will convert to a deal in 30 days, and you’ll likely get a shrug.

This is the core forecasting gap in subprime operations. Without reliable metrics linking daily rep activity to closed deals, you’re managing backwards—reacting to numbers rather than predicting them.

The good news: there are leading indicators buried in your rep-level data. Not all activity is created equal, and not all metrics have the same relationship to a closed deal. Understanding which ones matter—and at what volume—gives you visibility into your pipeline 60, 90, even 120 days out.

Activity metrics: raw volume is not enough

Every dealership tracks calls and texts. Most track appointments. Few understand which of these actually correlate to sales.

Here’s the operational reality in most shops: a rep can make 40 calls a day and close two deals a month. Another rep might make 20 calls and close three. The first looks busier. The second is more efficient. Volume alone tells you nothing.

What matters is the quality and intentionality of that activity. A text sent at random to a tire-kicker in your database is different from a text to someone who showed up to your lot last week or clicked an ad two days ago.

The first split to track: inbound vs. outbound activity. Inbound calls and texts (prospects coming to you) convert at higher rates than cold outbound work. This doesn’t mean outbound is worthless; it means you need different conversion assumptions for each channel.

In many dealerships, inbound activity converts to an appointment at a 40-50% rate. Outbound, depending on list quality and messaging, might sit at 15-25%. If your rep sends 100 texts a day and gets 15 positive responses, that’s different from 15 responses on 50 texts.

The metric that matters: appointment rate by channel. Track calls-to-appointment and text-to-appointment separately. This ratio, measured daily or weekly per rep, is your first real leading indicator.

Appointments: quality vs. attendance

Appointments scheduled are not appointments kept.

A 70% show rate is not the same as a 90% show rate. This is where many GMs lose visibility. A rep might book 15 appointments a week and show 70% (10.5 shows). Another might book 12 and show 90% (10.8 shows). Same floor traffic, different discipline.

The metric that matters: show rate, tracked per rep. This is usually higher in subprime than prime operations because your buyers are more motivated (fewer alternatives elsewhere), but it still varies by rep and by how appointments are set.

Reps who use confirmation texts or calls (touch the appointment again 24 hours before) see higher show rates. This is operational, not mysterious.

Where you see real predictive power: if a rep’s show rate drops suddenly from 85% to 65%, your pipeline 2-3 weeks out is weaker than the numbers suggest. That’s a red flag to address in real time.

Shows: the first sales moment

Not every show becomes an appointment. Some customers browse, talk, and leave without sitting down. Some sit with a manager but don’t move toward a deal.

The metric that matters: show-to-sit rate, or show-to-serious-conversation rate. How many floor customers actually make it to a substantive desk talk with a manager or finance person.

In many dealerships, this rate sits between 60-80%. It’s driven by lot quality, greeting, initial walk-around, and whether you have inventory the customer actually wants to discuss.

A rep might show 10 customers and get sits with 6. That’s a 60% conversion. If that rate drops to 40% (4 sits out of 10 shows), your next two weeks of deals will suffer, assuming all else is equal.

Track this rate by rep and by day. Sudden dips often correlate to inventory issues, pricing problems, or a rep losing momentum.

Sits to test drives: the second sales moment

Not every sit results in a test drive. Some customers arrive skeptical, get scared by pricing, or find the vehicle isn’t what they imagined.

The metric that matters: sit-to-test-drive rate. This is closer to a true buying signal.

A sit where someone listens to your offer but walks away is different from a sit where they get in the car. In many dealerships, 70-85% of sits turn into test drives when inventory and pricing are reasonable.

If your average sit-to-test-drive rate is 75% and it drops to 50% one week, something’s broken. Either your vehicles aren’t matching customer expectations, your manager is not presenting value clearly, or your pricing is out of step.

This metric is especially useful because it’s early enough to fix in real time. If you see the rate falling Monday through Wednesday, you can adjust messaging, pricing, or lot focus before Friday’s numbers crater.

Test drives to deal progression: the closing funnel

A test drive is a strong signal. Most customers who test drive are seriously considering.

The metric that matters: test-drive-to-deal rate. How many test drives result in a customer returning with an offer discussion, application submission, or trade appraisal in motion.

In healthy subprime operations, this rate is often 50-70%. Some customers test drive and need time to think, or they’re shopping competitors. Some have credit fears. Some are just curious.

But if a rep shows 6 customers, sits 5, drives 4, and closes 1, that’s a 25% test-drive-to-close rate. If that rate holds and your monthly shows average 80 (10 per week), you’re forecasting around 20 units from that one rep.

This is testable. Build a 30-day rolling average for each rep. When it trends up or down consistently, you have advance warning of deal volume changes.

Building a predictive pipeline

The strongest forecasting model uses a waterfall: track each stage and the conversion rate between stages.

As an illustrative example (not a guarantee of results): if Rep A averages:

• 150 calls per week, 20% appointment rate (30 appointments)
• 85% show rate (25.5 shows)
• 70% sit rate (17.85 sits)
• 80% test-drive rate (14.28 drives)
• 60% deal progression rate (8.57 deals moving forward)

And your typical sales cycle from deal progression to close is 10-14 days, you have a rough forecast of 8-9 deals per rep per month from today’s activity, assuming the conversion rates hold.

If you have 5 reps and all track similarly, you’re forecasting 40-45 units in 30 days from today’s active pipeline. That’s far more useful than “we’ll see how it goes.”

Using the forecast

Once you have these numbers, the management levers become clear.

If your forecast is $15k under target, you know whether the problem is top-of-funnel (not enough calls), middle-funnel (low show rates or sit rates), or back-end (deals aren’t closing). Each point of failure has different fixes.

Low appointment rates suggest messaging or lead quality issues. Low show rates suggest your appointment-setting process isn’t convincing. Low sit rates suggest lot greeting or inventory matching problems. Low test-drive rates suggest pricing or manager presentations. Low deal progression suggests application, approval, or trade issues.

By tracking these ratios daily or weekly, you shift from guesswork to diagnosis. You can also identify which reps are strong at which stage—some excel at getting sits, others at moving deals forward—and adjust roles or coaching accordingly.

The data infrastructure

You don’t need exotic tools. A Google Sheet with daily entries for calls, appointments, shows, sits, drives, and deals per rep will work. Trend it weekly. Add a calculation for each conversion rate.

Better dealerships use CRM data if their system captures it automatically. Worst case, you ask reps to log it honestly at end of day. It takes five minutes.

The investment is small. The forecasting gain is real.