Drain and Sewer Marketing Reports: Measure Qualified Leads and Won Jobs
A drain and sewer marketing report should separate raw contacts, unique inquiries, qualified leads, inspections, estimates, accepted work, and completed jobs. Compare drain and sewer paths separately, preserve acquisition cohorts when jobs close later, and show unresolved outcomes. Use actual spending and contribution data rather than treating phone calls or proposal value as revenue.
A single cost-per-lead figure cannot describe both a routine clearing booking and an inspection that may later support a sewer proposal. The steps, capacity, and timing differ. This guide provides a worked hypothetical worksheet for plumbing business owners. None of its counts, spending amounts, or rates are industry benchmarks or Plumbing Partners client results.
Which decisions should a drain sewer marketing report support?
Start with the decisions the owner needs to make: whether acquisition is producing suitable requests, whether the office can handle them, where work stalls, and whether completed jobs justify the spending. Those questions require different denominators. They should not be compressed into an unlabeled conversion rate.
The drain cleaning marketing framework emphasizes fit and booked service. The sewer repair marketing framework includes assessment, findings review, and estimating. Keep separate rows for those paths even when they share an advertising account or an intake team.
Agree the reporting cutoff, spending basis, source attribution rule, and outcome definitions before collecting totals. “Won” might mean accepted work in your business, while “completed” means delivered service. Record both explicitly. An accepted sewer proposal is not collected cash, and a paid inspection is not a completed repair.
What belongs in the source-to-job worksheet?
Keep an inquiry-level register behind the summary. Include an anonymous reporting ID, inquiry date, original source, service path, qualification state, stage dates, owner, next action, and final outcome. Link relevant job and invoice identifiers inside the secure operational system. Public or shared marketing reports do not need customer names or private property details.
Use one inquiry for a distinct request and attach repeated contacts to it. If an assessed drain request becomes a sewer opportunity, preserve the parent inquiry and record a linked path change. Do not add both as newly acquired leads in the combined total. The worksheet below uses separate cohorts with no crossover solely to keep the example readable.
| Measure | Drain cohort | Sewer cohort |
|---|---|---|
| Acquisition media spend | $2,400 | $3,000 |
| Raw contacts | 60 | 40 |
| Duplicate contacts | 12 | 10 |
| Unique inquiries | 48 | 30 |
| Qualified inquiries | 30 | 18 |
| Not qualified | 12 | 8 |
| Qualification pending | 6 | 4 |
| Visits or inspections booked | 24 drain visits | 15 inspections |
| Visits or inspections completed | 21 drain jobs | 12 inspections |
| Repair estimates delivered | Not applicable to this example | 8 |
| Repair estimates accepted | Not applicable to this example | 3 |
| Repairs completed | Not applicable to this example | 2 |
Reconcile the rows rather than assuming every difference is a loss. The drain cohort has three booked visits not yet complete: two future appointments and one cancellation in this illustration. Of six qualified drain inquiries that did not book, four declined the offered appointment and two remain undecided. Qualification and booking remain distinct.
The sewer cohort has three booked inspections not completed: two scheduled later and one cancelled. Of 12 completed inspections, eight support delivered estimates, three have no repair recommendation, and one awaits further review. Of eight estimates, three are accepted, two declined, and three pending. Of three acceptances, one repair remains scheduled for later.
These reconciliation notes matter as much as the totals. Without them, a reader might label every uncompleted inspection a lost opportunity or assume five of eight estimates failed. In reality, some work is still open and some correctly requires no repair proposal.
How do you calculate each cost and conversion rate?
Use the same spending basis and the same inquiry cohort in each calculation. The general lead-cost framework introduces spending divided by leads. This worksheet extends it by specifying exactly which stage is in the denominator and whether the outcome is mature enough to compare.
- Drain cost per raw contact: $2,400 ÷ 60 = $40.
- Drain cost per unique inquiry: $2,400 ÷ 48 = $50.
- Drain cost per qualified inquiry: $2,400 ÷ 30 = $80.
- Drain cost per booked visit: $2,400 ÷ 24 = $100.
- Drain cost per completed job so far: $2,400 ÷ 21 = about $114.29.
- Sewer cost per qualified inquiry: $3,000 ÷ 18 = about $166.67.
- Sewer cost per completed inspection: $3,000 ÷ 12 = $250.
- Sewer cost per delivered repair estimate: $3,000 ÷ 8 = $375.
- Sewer cost per accepted repair estimate so far: $3,000 ÷ 3 = $1,000.
The drain qualified-to-booked rate is 24 ÷ 30, or 80%. The sewer delivered-estimate acceptance rate at this cutoff is 3 ÷ 8, or 37.5%. Neither is a universal close rate. Their denominators differ, and the sewer cohort still has three undecided estimates.
If a denominator is zero, display “not calculable” with the zero count, not a zero acquisition cost. If qualification is incomplete, show the pending count. Do not remove the spending associated with irrelevant inquiries merely because those inquiries are excluded from qualified leads.
Should drain and sewer share a cost-per-lead target?
Not by default. Different service paths can support different acquisition costs, estimating effort, delivery requirements, and timing. Use your actual completed-work economics and capacity rather than adopting the hypothetical figures above as targets. A higher-cost inquiry can be viable, but an expensive downstream proposal is not proof of profitability.
Specify whether the report shows media-only cost or fully loaded acquisition cost. Media spend is useful for campaign comparison. Agency fees, creative costs, tracking tools, and relevant acquisition labor may also matter to the business decision. Show those costs separately and use a consistent allocation rule rather than quietly changing the numerator.
Contribution is revenue minus the defined variable costs of delivering the work, before any costs your definition explicitly excludes. Have the owner or finance lead agree the treatment of labor, materials, equipment, travel, subcontracting, and refunds. Do not label gross invoice value as profit or subtract the same expense twice.
In a separate hypothetical calculation, $10,000 of completed-job revenue less $6,500 of specified delivery costs leaves $3,500 contribution before acquisition and other overhead. Subtracting $2,400 media spend leaves $1,100 before remaining costs. That is not net profit, and it is not evidence that the sample drain cohort produced that revenue.
How do you report sewer jobs that close in later months?
Keep two views. An activity report shows inspections, estimates, acceptances, and completed jobs occurring during the month. A cohort report follows inquiries first received in a defined month through later outcomes. The first helps manage current workload; the second helps assess what acquisition ultimately produced.
If an inquiry arrives in Month A and its repair is accepted in Month B, Month B's activity report includes the acceptance. Month A's cohort report also updates to include the downstream outcome. These are two views of one event, not two wins to add together.
Freeze a dated snapshot and retain a later refreshed view. Compare cohorts at similar elapsed ages where possible. A cohort observed for seven days should not be judged against one observed for three months without a clear warning. There is no universal maturity window established here; inspect your actual decision history.
Preserve the source using your call-attribution records and the linked CRM opportunity history. Separate original acquisition source from later assisting contacts. Leave unknown sources visible rather than distributing them across channels to make a report look complete.
Why might platform conversions differ from the office report?
Platforms and operational records can use different definitions, attribution rules, and timing. Google Ads' website call-tracking documentation, accessed October 6, 2026, describes counting calls above a configured minimum duration. That event does not itself establish service fit, booking, or a completed job.
Google's offline-conversion guidance, accessed October 6, 2026, explains how later offline outcomes can be measured after clicks or calls. Implementation requires current setup and privacy checks. It is not a reason to assume every accepted estimate has already reached the advertising account.
Reconcile differences with labeled categories: repeat contacts, unsupported requests, unlinked outcomes, attribution timing, missing identifiers, and unresolved qualification. Do not force totals to match by deleting legitimate records. Keep the operational source of truth for delivered work even when platform attribution is incomplete.
What should the owner review before changing the budget?
Check data quality first: duplicates, missing outcomes, inconsistent stage names, and source gaps. Then inspect capacity. A campaign can bring suitable inquiries that cannot book because equipment or estimating time is unavailable. Increasing acquisition before resolving that constraint may increase workload without improving completed work.
Review losses by reason and cohort, not only channel. Price declined, unsupported work, no capacity, customer deferred, and no response each imply a different question. Small counts are unstable; show the underlying numbers and avoid declaring a winner from one unusually large job.
Agree one next action with an owner and review date. It might be clarifying an offer, correcting source capture, accepting a handoff more reliably, or limiting acquisition while capacity is constrained. Document concurrent changes. A report should support a decision without pretending an observed change proves causation.
Keep this homeowner-lead report separate from Plumbing Partners' own content results. For the agency, relevant outcomes are inquiries from plumbing businesses seeking marketing help. A homeowner reading an article or requesting a drain repair is not automatically a qualified agency prospect.
Related reading
FAQ
Should every call appear as a new lead?
No. Keep raw contacts for workload and reconciliation, then deduplicate distinct service requests. Repeat calls about the same issue belong to one inquiry. A different new request can create another inquiry under your documented rule.
Can inspection income be reported as sewer repair revenue?
No. Show inspection and repair income separately, even when they share an originating inquiry. This preserves the difference between delivered assessment work and a later repair decision. Reconcile any credits using actual invoice records.
What should we report when no jobs have closed?
Show spending, current stage counts, open cases, and elapsed time. Cost per won job is not calculable when the count is zero. Investigate the records without inventing future revenue to make the report look positive.
Should we compare this month's spending with all jobs completed this month?
That can be an activity view, but it may mix jobs acquired in earlier periods with current acquisition spending. Use a cohort view to assess the later outcomes of a particular inquiry period. Label both views and never sum their overlapping wins.
Does a lower cost per lead mean better marketing?
Not by itself. Check qualification, booking, completion, contribution, capacity, and data quality. Lower-cost contacts can still be unsuitable, while higher-cost inquiries may or may not justify their expense through completed work.
Request a free marketing audit focused on drain and sewer reporting definitions, source continuity, and the difference between inquiries, accepted work, and completed jobs.
