You spent the money to make the phone ring. You paid for the lead, ran the campaign, staffed the BDC. A customer said yes to a time. And then, roughly half the time at a lot of stores, they don't show, and the deal you already paid to create walks to the dealer down the road who confirmed better. The appointment funnel is the most expensive leak in the building precisely because the cost is already sunk before the leak happens.

What makes it worse is how few stores actually measure it. They count appointments set, because that feels like progress, and they count units, because that's the board. The middle, set to show and show to close, is where the real story lives, and it's usually invisible. You can't fix a show-rate problem you've never put a number on.

The good news: this funnel is all ratios, and ratios are coachable. Let's define the benchmarks that matter and what each one is telling you.

The three ratios that define the funnel

There are only three conversions worth obsessing over between "set" and "sold," and each one fails for different reasons.

  • Set-to-show. Of the appointments booked, how many walked in? This is the big leak. A reasonable working target is 60 to 70 percent on confirmed appointments; many stores live closer to 50 percent because they confirm poorly or set soft appointments. Anything under half means you're booking appointments that were never real.
  • Show-to-write. Of the customers who showed, how many sat down and got numbers? You want most shows to become write-ups. Call 70 to 80 percent a solid bar. A low number here usually means the salesperson isn't controlling the visit.
  • Show-to-close. Of the shows, how many bought? On confirmed appointment traffic, 40 to 50 percent is a strong working target. Appointment customers close far better than random ups, which is the whole reason the funnel matters.

Run the math end to end. Say the BDC sets 100 appointments. At a 60 percent show rate, 60 walk in. At a 45 percent show-to-close, you deliver 27 units. Now lift the show rate to 70 percent with better confirmation, same 100 appointments, same closing skill, and you show 70 and deliver about 31. Four extra units from a single ratio, with zero additional leads bought. That is the cheapest gross in the store.

Set-to-show is mostly a confirmation problem

When show rate is bad, managers blame the customer. "People are flaky." Some are. But most no-shows are appointments that were soft when they were set or never properly confirmed, and both of those are inside your control.

A real appointment has a specific time the customer committed to, a reason to come in beyond "looking" (a specific vehicle, a trade number, a promised figure), and at least one confirmation touch between the set and the visit. A soft appointment is "yeah, I'll swing by Saturday." Those were never going to show, and counting them inflates your set number while tanking your show rate.

Track the gap between same-day-set and future-set appointments, too. An appointment for two hours from now shows at a much higher rate than one set five days out. The further out the set, the more confirmation work it needs. A confirmation call the day before and a text the morning of is a reasonable standard. If a rep's set count is high but their show rate is low, you don't have a closing problem yet. You have a confirmation problem, and it's upstream of everything.

A high set rate with a low show rate isn't a busy salesperson. It's a rep manufacturing appointments that were never going to happen.

Watch the ratios by person, not just by store

A store-wide show rate is a useful headline and a useless coaching tool. The average hides the spread, and the spread is where you make money.

Break every ratio out by rep and by lead source. You'll routinely find two salespeople pulling from the same lead pool with a 20-point gap in show rate. Same leads, same store, same inventory. The difference is the confirmation work and the value they built on the setting call. That gap is pure coaching opportunity, and you can only see it per person.

Source matters just as much. Internet leads, phone ups, and floor be-backs show at very different rates, and lumping them together gives you a blended number that describes no actual customer. A 50 percent show rate might be a great internet number and a terrible be-back number hiding inside one average. Segment it, or you're coaching a ghost.

Tie the funnel to a daily commitment

The reason this funnel stays broken at most stores is that nobody owns a daily number in it. Units are monthly. Appointments are the thing that happens today, and they should be reported today.

Make appointments set and appointments shown a daily commitment for the people who own them. Reported at end of shift, the funnel becomes live: you see on Tuesday that confirmations slipped, instead of discovering it in the month-end unit count when the customers are already gone. The daily cadence is what converts a vague "our show rate could be better" into "your show rate dropped Tuesday and we're fixing the confirmation call today."

Do this Monday

  1. 1Pull last month's appointments set, shown, and closed, by rep and by lead source, not just store-wide.
  2. 2Compute set-to-show, show-to-write, and show-to-close for each, and flag anyone well under the working targets (60 to 70 percent show, 40 to 50 percent show-to-close).
  3. 3For low show rates, audit the confirmation process. Is there a real confirmation touch the day before and the day of?
  4. 4Make appointments set and shown a daily reported number for the people who own the funnel.
  5. 5Pick the single worst ratio on the team and coach that one thing this week.

The takeaway

Every appointment represents money you've already spent. When a confirmed customer doesn't show, you don't lose a chance, you lose a deal you already paid to create. The set-to-show funnel is the highest-leverage, cheapest gross in the store, and it's almost entirely a function of how your people work, not how customers behave. Your salespeople and your BDC are your biggest investment. Measuring this funnel by person, every day, is how you make sure that investment actually walks through the door.