Weekly call-conversion scorecard
Measure the calls that become real plumbing work—not just the calls that ring.
“Conversion rate” can look impressive or terrible depending on what gets counted. This scorecard gives a small plumbing outfit a low-tech way to separate phone coverage, eligible opportunities, bookings, cancellations, and completed work each week.
The measurement principle
Define the funnel first. Then measure each handoff consistently.
There is no single universal “good plumbing call conversion rate.” A percentage is meaningless until its denominator is defined.
- Total inbound calls are not automatically sales opportunities.
- Spam, vendors, wrong numbers, existing-job callbacks, and out-of-area calls can distort the result.
- Booking is not the same as completed work.
- Cancellations and unresolved bookings remain visible in the funnel.
- Recovered missed callers stay attributed to the recovery path.
01 · Define the funnel
Follow one opportunity from first ring to completed work
Start with five stages that are easy to record. A shop may add stages later, but it should avoid changing definitions from week to week while trying to compare results.
- 01
Inbound calls
Every inbound call in the measurement window.
- 02
Eligible new-business calls
Real prospects whose requests appear potentially serviceable under the outfit’s rules.
- 03
Booked appointments
Appointments actually accepted into the scheduling process.
- 04
Appointments that remain scheduled
Bookings still active after cancellations and other booking failures remain visible.
- 05
Completed jobs
Opportunities that reached the outfit’s consistently defined completed-work endpoint.
02 · Define every category
Make every count mean one specific thing
Write the definitions beside the scorecard. The plumbing outfit’s actual service area, work types, customer mix, and operating policy determine eligibility.
Total inbound calls
Every inbound call during the measurement window.
Counting boundary: Do not automatically use this as the sales-conversion denominator.
- Answered calls
- Missed calls
- Customer and non-customer calls
Eligible new-business call
A caller who appears to be a real prospective customer and whose request is potentially serviceable by the plumbing outfit.
Counting boundary: Define eligibility from the outfit’s own operating rules—not a universal industry definition.
- Inside the service area
- Service type offered
- Residential or commercial fit
- Within operating policy
Ineligible call
A call that is not a serviceable new-business opportunity under the written rules.
Counting boundary: Keep the reason visible so call mix can be reviewed later.
- Spam
- Wrong number
- Vendor solicitation
- Applicant
- Outside service area
- Service not offered
Existing-customer / existing-job call
A call about work, a customer relationship, or an appointment that already exists.
Counting boundary: Keep it separate from new-business conversion unless the outfit deliberately adopts another rule.
- Status update
- Technician callback
- Invoice question
- Warranty question
- Reschedule of existing work
Booked appointment
A real service appointment accepted into the outfit’s scheduling process.
Counting boundary: Do not count a vague callback promise, “we’ll see if someone can call,” duplicate booking, or test record unless the written definition intentionally says otherwise.
- Correct appointment type
- Real date or window
- Accepted into the actual scheduling process
Cancellation
A booking that was created but did not remain scheduled.
Counting boundary: Do not erase it from the funnel. A cancellation explains part of the distance between booking and completion.
- Caller cancellation
- Outfit cancellation
- Booking removed before service
Completed job
A booked opportunity that reached the outfit’s chosen completed-work definition.
Counting boundary: Choose one endpoint and use it consistently rather than switching between operational events.
- Technician visit completed
- Billable work completed
- Invoice created
- Another defined internal endpoint
03 · Special classification rules
Write the edge-case rules before they change the denominator
These calls can be counted several plausible ways. Pick a rule, document it, and keep the unit of measurement stable.
Missed call later recovered
Record the initial miss, whether callback or text recovery occurred, whether the caller qualified, whether it booked, and whether it completed. Credit the result to the recovery path—not a clean first-answer booking.
Reschedule
A reschedule should normally remain one underlying opportunity instead of becoming a second new-business call.
Duplicate calls
Multiple calls about the same opportunity should not automatically inflate the new-business opportunity count.
Multiple jobs from one caller
Choose whether the unit is caller, opportunity, appointment, or completed job. Do not silently mix those units in one rate.
Cancellations
Keep cancellations visible between the booking and completed-work stages.
No-answer / abandoned call
Record it separately instead of guessing that the caller was eligible or treating an unknown call as a lost job.
Unknown / needs review
Use an explicit unknown classification when the record cannot support a clean decision. Repair the log rather than forcing a bad category.
04 · Weekly scorecard
Record the raw counts before calculating a percentage
Use one worksheet each week. The fields work on paper or as spreadsheet columns and do not require paid reporting software.
- 01Week starting
- 02Total inbound calls
- 03Answered calls
- 04Missed calls
- 05Unknown / unclassified calls
- 06Eligible new-business calls
- 07Ineligible calls
- 08Existing-customer / existing-job calls
- 09Eligible calls answered live
- 10Eligible missed calls recovered
- 11Eligible missed calls not recovered
- 12Booked appointments
- 13Bookings later cancelled
- 14Bookings still active / scheduled
- 15Completed jobs
- 16Notes
05 · Core rates
Six formulas, each answering a different question
Keep the raw numerator and denominator beside every rate. If a denominator is zero, record the rate as not applicable rather than inventing a percentage.
Answer rate
A phone-coverage metric—not a sales-conversion metric.
Eligible-call booking rate
The primary booking-conversion metric. Numerator and denominator must cover the same cohort and window.
Live-answer booking rate
Shows what happened to eligible opportunities handled on the first live answer.
Recovered-call booking rate
Keeps recovery performance separate from first-answer performance.
Booking-to-completion rate
Shows how many bookings reached the chosen completed-work endpoint after cancellations and unresolved outcomes.
Eligible-call-to-completed-job rate
Use only when the original eligible-call cohort has had enough time to resolve. There is no universal waiting period.
06 · Cohort timing
A Friday call and a Monday completion can belong to the same opportunity
A simple weekly snapshot can split one opportunity across reporting periods. Choose whether the current report describes activity or follows a cohort, and do not present unrelated weekly totals as a clean conversion funnel.
Activity view
Count events that happened this week
- Calls handled during the week
- Missed calls during the week
- Bookings made during the week
- Cancellations recorded during the week
- Jobs completed during the week
Useful for workload and operations. Not automatically a true call-to-job conversion rate.
Cohort view
Follow the same eligible opportunities
- Start with eligible calls received in one defined period
- Keep those opportunities tied to their original call period
- Follow each through booking, cancellation, active scheduling, and completion
- Calculate conversion only after the cohort is sufficiently resolved for the outfit’s purpose
Better for true conversion measurement. A small shop can add this after starting with the activity view.
07 · Low-tech call log
Give every opportunity one row
Use an internal caller or opportunity ID sufficient to reconnect related events. Keep customer information private and do not publish the log. Add only the information the outfit genuinely needs to classify and follow the opportunity.
- Date
- Time
- Caller / opportunity ID
- Answered or missed
- New business?
- Eligible?
- Ineligibility reason
- Existing-job call?
- Recovered after miss?
- Booked?
- Appointment date
- Cancelled?
- Completed?
- Completion date
- Notes
08 · Fictional arithmetic—not a benchmark
The denominator changes the question, not the quality of the shop
This illustrative week uses simple numbers to show why an unlabeled “conversion rate” is incomplete. None of the percentages below is a target, average, or “good” result.
Bookings as a share of all inbound calls
42 ÷ 100 = 42%Describes bookings relative to every inbound call, including non-opportunities.
Bookings as a share of eligible new-business calls
42 ÷ 60 = 70%Describes booking conversion within the defined eligible-opportunity pool.
Neither percentage is inherently “good.” They answer different questions because the denominators differ.
Fictional continuation
Booking does not erase cancellations or prove completed work
Suppose 6 of the 42 bookings cancel and 30 eventually reach the outfit’s completed-job definition.
- Bookings
- 42
- Later cancelled
- 6
- Completed jobs
- 30
- Eligible-call-to-completed-job rate
- 30 ÷ 60 = 50%
The completed-work calculation is illustrative only and assumes this fictional call cohort had enough time to resolve.
09 · Missed-call recovery attribution
Keep first-answer and recovery outcomes on separate branches
This shows whether phone coverage, recovery, booking, or completion is the larger operational leak instead of blending every booking into one rate.
Answered live
- Booked
- Not booked
Attribute the outcome to the live-answer path.
Missed → recovered
- Booked after recovery
- Not booked after recovery
Preserve both the original miss and the recovery result.
Missed → not recovered
- No confirmed qualification or booking outcome
Do not invent eligibility from an unanswered call.
10 · Diagnose without benchmarks
Look for the stage where the outfit’s own opportunities stop moving
Treat the pattern as a prompt for investigation—not proof of one cause and not a comparison with a generic target.
Many missed calls
Investigate phone coverage and the ownership and timing of recovery.
High eligible-call volume but few bookings
Review intake, service-area rules, scheduling capacity, the handoff process, and callback ownership. Do not jump immediately to a “sales script” diagnosis.
Strong booking count but many cancellations
Investigate expectation setting, scheduling delay, duplicate or incorrect bookings, caller intent, and follow-up.
Bookings remain high but completed work falls
Investigate downstream operations rather than assuming intake caused the change.
Unknown classification is high
Improve call logging before drawing conversion conclusions.
11 · Four-week review
Compare several weeks before reacting to one small sample
Review several weeks together without inventing a statistical minimum. Weather, staffing, call source, and work mix can move a single week. The comparison becomes useful only when each week uses the same definitions.
- Changes in call mix
- Missed-call share
- Eligible-call count
- Booking count
- Cancellation count
- Completed jobs
- Recovered missed calls
- Unknown / unclassified calls
12 · Why there is no universal target here
Published percentages are rarely measuring the same funnel
Vendor and industry reports may provide context, but their numbers can use different sources, populations, and definitions. Spidrr does not tell a small plumbing outfit that one percentage is universally “good.”
- Customer mix
- Business size
- Call source
- Eligibility rules
- Lead quality
- Staffing
- Booked-job definition
- Completed-job definition
- Reporting software
13 · Neutral next-action states
Choose the next measurement or workflow action
Measurement is not clean yet
Too many calls are unknown, duplicated, or inconsistently classified.
Funnel leak is identified
The same stage is repeatedly losing eligible opportunities.
Process is stable enough to compare
Definitions are consistent and the outfit can compare its own weeks, staffing arrangements, or workflow changes.