← Back to blog

Sales Funnel Leakage Analysis for Franchise Dealerships

November 12, 2026
Sales Funnel Leakage Analysis for Franchise Dealerships

Sales funnel leakage analysis for a dealership means measuring, stage by stage, how many captured leads and shoppers fail to move from first inquiry to a sold vehicle, then finding out why. The work has four parts: define the stages, count who reaches each one, split the results by source, time and person, and fix the earliest and largest gap first. Done well, it shows whether your problem is lead volume or what happens to leads after they arrive.

That difference matters for budget. Many stores respond to a soft month by buying more leads. If the leads you already paid for are leaking after they arrive, more volume raises cost per sale and leaves the cause untouched.

Autoroiq
autoroiq.com
See Where Marketing Spend Falls Short
AutoROIQ provides independent analysis of dealership marketing performance, helping leaders make clearer decisions about where their budgets are working.
Visit

TL;DR

  • Funnel leakage is lost opportunity after a lead is captured. It is a process problem, not a lead generation problem.
  • Measure four transitions separately: lead to contact, contact to appointment, appointment to show, show to sold. A single blended close rate hides the leak.
  • Segment every transition by lead source, time of day and salesperson before you draw conclusions.
  • Fix upstream stages first. Improvements at contact and appointment multiply everything below them.
  • Judge progress by cost per sale and stage conversion rates, not lead counts.

Table of Contents

What leakage means for a franchise dealership

Lead leakage is the loss of sales opportunities after a lead has entered your systems. Common causes are slow follow-up, duplicate records, fragmented channels and missed handoffs between tools and teams, as Swiftex describes it. The shopper was interested. Something in your process let the opportunity go.

Funnel drop-off is the broader measurement. It describes the share of people who leave between any two stages, including people who were never a good fit. Leakage is the part of that drop-off you could have prevented. A shopper who buys elsewhere because the vehicle was not what they wanted is drop-off. A shopper who submitted a price request and heard back two days later is leakage.

The distinction also separates two views of the same sales process. A pipeline view is seller-centric: it tracks deals and team activity. A funnel view is customer-centric and asks why you are losing potential buyers at a particular stage, as Carboo frames it. Leakage analysis lives in the funnel view, and it needs both views of the data to work.

Define the stages before you measure anything

Most dealership funnels are drawn too coarsely. "Lead" and "sold" are not stages, they are the two ends. In between, you need transitions that someone owns and that a report can count.

A workable franchise dealership funnel uses four measurable transitions:

  1. Lead to contact: a real two-way conversation, not an attempted call or an auto-responder.
  2. Contact to appointment set: a confirmed time, not a vague intention to visit.
  3. Appointment set to shown: the customer arrives.
  4. Shown to sold: the deal closes, including the desk and finance steps.

This four-step structure follows the lead-to-sold breakdown from Dealership Accelerator, and it fits how stores actually assign responsibility: BDC or internet team for the first two, sales floor for the last two.

Above those sits the marketing side. Research typically begins online long before a lead form is filled, so awareness and interest stages carry their own measures: website traffic, bounce rate, vehicle detail page engagement and quote request volume. BizzyCar's funnel outline pairs each of the traditional stages with KPIs of this kind. Keep the upstream marketing stages in the model so you can tell whether a weak result is a traffic problem or a handling problem.

A definition discipline matters here. Digital Dealer's campaign audit guidance recommends separating attempts from two-way conversations, requested follow-ups from confirmed appointments, and noting that an appointment set should not automatically count as a show. It also calls for isolating duplicates, wrong numbers, opt-outs and unresolved outcomes. If those records sit inside your denominator, every rate downstream is distorted.

Combine the data that traces a shopper from source to sale

Leakage is rarely visible in one system. The ad platform knows the click. The website analytics know the page views. The CRM knows the lead status. The phone system knows whether anyone picked up. The DMS knows the deal. Tracing one shopper across all five is the core of the analysis.

At minimum, combine:

  • Marketing source data: channel, campaign, vendor and spend by month.
  • Lead records: timestamp, source, lead type (form, call, chat, walk-in), and vehicle of interest.
  • Handling data: first response time, number and type of attempts, who handled it, and whether the customer replied.
  • Appointment data: when it was set, who set it, whether it was confirmed, and whether the customer arrived.
  • Deal data: sold or lost, gross, and the reason code for lost deals if your team records one.

Funnel math needs only three attributes on each record: who did something, what they did and when. Metabase's funnel guide says as much about raw event data. In a dealership, "who" must be a stable customer or lead ID that survives a handoff from the BDC to the floor. If your records break at that handoff, you have already found one leak.

Source attribution is the second dependency. If calls and showroom visits are credited to "direct" or to whichever vendor reported them first, your by-source results will mislead you. Our guides on lead source attribution for dealerships and lead quality metrics cover how to set that up so stage results can be tied to the dollars behind each channel.

Calculate conversion and drop-off between stages

The calculation itself is simple: count how many reach each step, then divide each step by the one before it. Metabase's method gives both a step-by-step rate and a rate from the start of the funnel. You need both. The step rate shows where the leak is. The from-start rate shows what it costs you overall.

For a dealership, the formulas look like this:

StageFormula
Contact rateLeads contacted ÷ leads received
Appointment set rateAppointments set ÷ leads contacted
Show rateAppointments kept ÷ appointments set
Close rateVehicles sold ÷ appointments kept
Drop-off at a stage1 minus that stage's conversion rate

A worked example

The numbers below are an illustration, not a benchmark. Suppose a store receives 1,000 internet leads in a month.

StageCountStep rateDrop-off
Leads received1,000n/an/a
Contacted70070%30%
Appointments set28040%60%
Appointments shown18265%35%
Sold36about 20%about 80%

Overall, 3.6% of leads became sales. A manager looking only at that number would conclude the leads are poor. The stage view says something different. Three hundred leads never reached a conversation. Of the 280 appointments, 98 never showed. Each of those is a process question the store can answer, and none of them is a question about the ad vendor.

This is why a blended "lead close rate" is a weak diagnostic. It tells you the size of the loss and nothing about where it happened.

Add time to the count. Measure how long each transition takes as well as what share of leads moves through it. Time-in-stage is an early warning: a lead that sits uncontacted for hours has usually already leaked, even if it appears in the "contacted" column later.

Where dealership prospects drop out

The pattern repeats across stores. Shoppers engage and never schedule. They schedule and never show. They test drive and stall at financing. Deals also die at the desk, when sessions run long and end without an offer, and after the offer, when it never converts.

Five common dealership sales funnel drop-off points

Follow-up is the most common single cause. Urban Science's defection research, reported by Digital Dealer, found that dealership teams on average close 25% of showroom leads within 30 days while another 20% defect. The same report says dealers can raise conversion on future leads by extending and strengthening follow-up with in-market shoppers who have not yet purchased.

Phone is a second blind spot. At a 2026 industry discussion covered by AM Online, a UK marketing executive said visibility breaks down where intent peaks, when customers move from online research to phone calls or visits, and cited about 9% of calls going unanswered across the sector. That figure comes from the UK market, so measure your own answer rate rather than assuming it applies. Calls are the closest thing to a raised hand, and they are often the least measured lead type.

Three kinds of leak, three different fixes

Not every leak has the same remedy. Writing for Auto Success Online, Steve Baylis separates three types:

  • Coverage leaks: the customer showed up or reached out when nobody was available.
  • Handoff leaks: the customer was handled well at one point and then dropped before the next step.
  • Quality leaks: the customer was handled badly enough to leave.

His point is that training does not fix a coverage leak and more coverage does not fix a quality leak. Matching the fix to the leak type avoids spending money on the wrong solution. An after-hours lead that never gets a reply needs coverage or automation. A lead that gets a great first call and then no appointment confirmation has a handoff problem. A lead who is contacted and leaves frustrated has a quality problem that belongs in coaching.

Segment the funnel to find the cause

Once you have stage rates, break each one down. A blended funnel hides almost everything, and segmentation is where leakage analysis earns its keep. Cut every transition by:

  • Lead source: one vendor may deliver strong contact rates and weak show rates, which points to expectation-setting in the ad or the appointment process.
  • Time of day and day of week: after-hours and weekend leads often convert differently from weekday leads for reasons unrelated to lead quality.
  • Salesperson or BDC agent: large spreads between people on the same lead type point to handling, not demand.
  • Lead type: form, phone, chat, third-party and walk-in behave like different funnels.
  • Vehicle type: new, used, and certified inventory often have different timelines.

Read the pattern. If every source underperforms at the same stage, the cause is systemic and internal. If one source underperforms at every stage, you may have a lead quality or attribution problem. If one person underperforms across sources, it is a coaching or workload issue. Our overview of how dealerships measure lead source quality goes deeper on the second case.

Show rate deserves its own look. Many stores treat missed appointments as a fact of life. They are a measurable step with owners and fixes, covered in our piece on appointment show rate. The same applies to the BDC, where a persistent gap between internet and floor performance is common, as we explain in the BDC conversion gap.

Prioritize fixes upstream first

With several leaks identified, resist fixing the loudest one. Work in funnel order: contact rate, then appointment rate, then show rate, then close rate. An improvement at the top multiplies everything beneath it. Strong closing skills cannot rescue a store that never reaches half its leads.

A practical sequence:

  1. Rank leaks by recoverable sales. For each stage, estimate how many more sales you would get if the stage reached a realistic target, such as your own best-performing month or best-performing source. Use your own data as the benchmark.
  2. Classify each leak as coverage, handoff or quality, and assign an owner.
  3. Change one thing at a time where you can. If you change the response process, the appointment script and the CRM rules in the same week, you cannot tell which one worked.
  4. Run the change long enough to cover several weeks of leads, including a few weekends, then compare stage rates before and after.
  5. Hold vendor spend steady during the test, so channel changes do not muddy the result.

Be careful about buying volume while you do this. Digital Dealer's reporting on Urban Science notes that without an understanding of why existing leads did not convert, buying more leads tends to raise costs without touching the root cause. Daily defection data helps separate lead quality issues from sales process breakdowns.

For the money side, pair stage results with cost. Cost per lead and cost per sale often tell opposite stories about the same vendor. A channel with a low cost per lead can carry a high cost per sale if its leads leak at the contact or show stage.

Metrics executives should watch

An executive dashboard for leakage should be short. Eight to ten numbers, reviewed on the same schedule, are enough:

  • Contact rate and median time to first contact, by source and by hour band
  • Appointment set rate
  • Show rate
  • Close rate from shown appointments
  • Unanswered call rate
  • Cost per sale by source and vendor
  • Lead-to-sale conversion from the start of the funnel
  • Share of sales with a traceable source

The last item is easy to skip and costly to ignore. If a large share of sales cannot be tied to a marketing source, every ROI figure rests on a guess.

Lead counts, impressions and click volume should sit lower on the page. As one dealer marketing leader put it in the AM Online coverage, marketing leaders need to own demand flow end to end and move from vanity metrics to long-term revenue impact. In practice that means reporting that ties spend to sold units, as covered in our guide to dealership ROI reporting. When a vendor's report and your CRM disagree, a 90-day sales match analysis compares the vendor's claimed results with actual sold records.

Your CRM sets the ceiling on this work. If it cannot hold a persistent lead ID, log every contact attempt or report on time in stage, the analysis will be manual and slow. Our look at what executives need to know about dealership CRMs covers the reporting questions to ask.

Our perspective

Most dealerships we see are not short on reports. They have too many of them. The ad vendor reports leads, the CRM reports appointments, the DMS reports deals, and none of the three agrees on which marketing dollar produced which sale.

Leakage analysis fails when it is done inside one of those silos. A vendor has no reason to examine what happens to its leads after delivery. A sales manager is rarely positioned to question the lead source mix. An independent view across the whole path is the only way to say whether a weak month came from the marketing, the handling or the follow-up.

That is why we do not sell advertising, manage campaigns or take vendor commissions. Our analysis has no ad budget to protect. We build scorecards that connect spend, stage conversion and sold units, so leadership can see which vendors and channels are earning their cost and where the funnel is losing buyers the store already paid to attract.

The most useful outcome of this work is usually not a bigger budget or a smaller one. It is a defensible answer to the question every general manager eventually asks: where is the money going, and what do we do about it?

AutoROIQ

Get an independent read on your funnel

If your vendor reports, CRM and sales numbers do not reconcile, a stage-by-stage analysis is the quickest way to see which leaks are costing you sales. Our Marketing Intelligence Review evaluates your vendors and marketing channels independently and gives leadership clear, executive-level recommendations. Ongoing strategic advisory is available for stores that want the scorecards maintained and acted on over time.

Autoroiq

Learn how the review and advisory work on our FAQ page, or start from the AutoROIQ home page.

FAQ

How is funnel leakage different from a lead generation problem?

Lead generation is about how many inquiries arrive. Leakage happens after capture, when a real inquiry fails to convert because of process or system gaps rather than lack of interest. If contact, appointment and show rates are weak, adding volume usually adds cost without adding proportional sales.

How often should a dealership run a funnel leakage analysis?

Review the core stage rates monthly, with weekly checks on contact rate and response time, which move fastest. Run a deeper segmented analysis by source, hour and person each quarter, or whenever you change a vendor, CRM rule or staffing model.

What is a good conversion rate at each stage?

Published benchmarks vary by brand, market and lead type, and many come from vendors with their own interests. A more reliable standard is your own best-performing source, time band or team over several months. Close the gap to that internal best first.

Can small dealerships do this without special software?

Yes, if the CRM exports lead status, timestamps and source. A spreadsheet can calculate step rates and splits. The harder part is data quality: consistent lead IDs, honest appointment and show statuses, and sold units matched back to a source.

Who should own the analysis?

Someone with no stake in the result for any single stage. Marketing, the BDC and the floor each see only part of the path, and each has reasons to read the numbers favorably. Many stores assign it to the general manager or bring in an independent reviewer.

Sources