Tracking Your Quote-to-Close Rate: The One Sales Metric Most Service Businesses Never Calculate
Businesses obsess over leads. They watch cost-per-lead, lead volume, enquiry rate — every number that happens before the quote goes out. Then the quote leaves the building and tracking stops, as if the sale closes itself 💖. It doesn't. The gap between "quote sent" and "job won" is where most of the real money either gets made or quietly leaks away, and almost nobody measures it on purpose.
What most businesses get wrong
- Treating "quote sent" as the finish line, then losing track the moment it leaves the outbox.
- Guessing their win rate from gut feel ("we win most of them") — which is almost always higher than the real number.
- Blending every quote into one average instead of breaking it down by lead source, price band or time-to-quote.
- Following up once, or not at all, and labelling a silent client as "they went quiet" rather than "we stopped asking."
Columns: Date Sent | Client/Job | Source | Quote Value | Last Follow-Up | Outcome (Won/Lost/Pending) | Days to Decision | Reason If Lost
The formula (Google Sheets or Excel, assuming Outcome is column F):
=COUNTIF(F:F,"Won")/COUNTIFS(F:F,"<>Pending",F:F,"<>")
That gives you a true close rate, excluding anything still undecided.
The monthly review (four questions, ten minutes):
1. What's this month's close rate vs the trailing three-month average?
2. Which lead source closes highest — and is it the one we're spending the most chasing?
3. What's the average decision time for won quotes vs lost ones?
4. What's the top recorded "reason lost" this month, and is it fixable?
How it works
This metric sits between two other numbers most businesses already track — cost per lead and total revenue — and explains the gap between them. It also splits cleanly into two separate leaks worth measuring on their own: lead-to-quote rate (are enquiries actually making it to a quote?) and quote-to-close rate (are quotes turning into work?). Treating them as one blended number hides which stage is actually broken.
Track by the month the quote was sent, not the month it closed — decisions lag, sometimes by weeks, and cohort tracking (grouping by send date) stops a slow month of closes from looking like a slow month of quoting.
Mistakes to avoid
- Marking a quote "lost" before a reasonable decision window has actually passed.
- Skipping the "reason lost" field — it's the single most useful column in the whole sheet.
- Changing your quote template or pricing mid-period, then comparing rates as if nothing shifted.
- Turning the number into a stick to beat sales staff with, instead of a diagnostic tool everyone uses to get better.
Frequently asked questions
What's a "good" quote-to-close rate?
There's no universal benchmark worth trusting — it varies enormously by price point, industry and how considered the purchase is. Track your own history and improve against it, rather than chasing an industry average that may not apply to your business at all.
Do I need a CRM to do this?
No. A spreadsheet is genuinely fine until quote volume or complexity outgrows it — and most businesses overestimate how soon that happens.
How long should I wait before marking a quote "lost"?
A simple rule: three follow-ups across three to four weeks with no response, then mark it lost and revisit the list quarterly in case circumstances change.
Should I bother tracking quotes that were never followed up at all?
Yes — honestly, this is often where the biggest leak hides. A low close rate is frequently a follow-up problem wearing a pricing problem's clothes.
Keep reading 🤍
I help Gold Coast and Brisbane businesses grow with branding, websites and marketing that actually works.
Work with me ✦