Lead quality audit template for contractor renewals

Use a lead quality audit template to trace one record from provider delivery to final contractor disposition. Summary totals are not enough. If the office reports “bad leads” without the original fields, attempt logs, qualification reason and remedy decision, a renewal meeting cannot separate source failure from contractor-process failure.

Use the downloadable CSV for a fixed provider cohort. Keep the original export unchanged, work in a copy, and restrict access because the file can contain homeowner contact and permission records.

Download the lead quality audit template

Download the contractor lead-quality audit CSV. The file contains headers only. It does not include fictional homeowner data, default scores or manufactured benchmarks.

The template groups fields around five questions:

1. What did the provider deliver?
2. What source and permission evidence was supplied?
3. What did the contractor’s contact process do?
4. Did the homeowner and project meet the written scope?
5. What appointment, estimate, sale or replacement outcome followed?

The CSV is a log, not a legal-compliance certificate or a CRM replacement. Ask counsel which permission and contact records your actual campaigns must retain. Keep access, retention and deletion aligned with the company’s approved process.

Freeze the audit cohort before reviewing quality

Name the cohort at the top of the working sheet before changing any status. A useful cohort holds these dimensions steady:

• provider and purchased product;
• trade and accepted services;
• territory or ZIP set;
• delivery start and end timestamps;
• distribution rule;
• qualification owner;
• replacement-policy version;
• the date or event at which outcomes are mature enough for review.

Split the cohort when a material term changed. A new territory, intake form, buying unit, qualification process or remedy can alter what “quality” means. Blending old and new conditions may hide whether the change helped.

Do not remove records before the audit starts. Every delivered record belongs in the source denominator, including duplicates, invalid contact data, outside-scope requests, unreachable homeowners, canceled estimates and later replacements. Classification comes after preservation.

Assign a reviewer who did not work every record when possible. The reviewer’s job is not to relabel a weak result as provider failure or contractor failure. It is to connect each status to evidence and mark unknown when the evidence cannot decide.

Preserve provider fields and permission evidence separately

Copy the provider record as supplied before adding contractor conclusions. The template includes provider ID, delivery time, trade, requested service, property ZIP, source page or campaign, permission reference, permission timestamp and distribution rule.

These fields answer different questions:

The provider consent checklist owns the questions to ask before buying. This audit records the evidence received after delivery. It does not determine whether a contact method is lawful.

The Federal Trade Commission’s Telemarketing Sales Rule guidance provides federal business guidance, including Do Not Call procedures. Its application depends on the campaign and facts. Use qualified counsel for the actual calling and messaging process, applicable exemptions and state requirements.

Separate technical attempts from a human conversation

Do not use one “contacted” field for every phone outcome. Preserve the raw system status, then separately record whether a two-way homeowner conversation occurred.

Twilio’s call-resource documentation, for example, distinguishes busy, no-answer and failed. It also explains that a completed call can reflect a person, voicemail or an automated menu. That makes a completed technical call different from a reached homeowner. Map the labels used by your own phone system instead of assuming they mean the same thing.

The template therefore keeps:

• first available to sales;
• assigned owner;
• first attempt time and channel;
• first attempt raw status;
• later-attempt summary;
• human-reached time;
• stop-request time.

A task created is not an attempt completed. A voicemail is not a human conversation. A stop request is not a no-answer result and should move into the approved suppression process. Unknown should remain unknown when the call evidence is missing.

Salesforce’s lead-management overview describes the role of a CRM in consolidating profile and engagement information for reporting. Software can preserve evidence, but only if the team records the event consistently and does not overwrite the raw status with a later conclusion.

Record qualification as a decision with a reason

Qualification begins after a person is reached. Keep the status and reason separate:

The qualified-lead definition owns the broader stage boundary. The audit should not mark a homeowner unqualified merely because the estimate did not sell. Price, trust, timing, technical findings and another quote can affect a later decision after the purchased scope was met.

Write reason codes before reviewing the cohort. If reviewers create a new phrase for every record, the sheet cannot show a repeated mismatch. Keep a note for nuance, but use a stable status for analysis.

Reconcile appointment, estimate and sold-job outcomes

Lead quality does not stop at qualification, but later outcomes need their own owners. The template records appointment status, estimate status and sold-job status without treating any one of them as proof of the earlier stage.

Reconcile source and CRM records in order:

Delivered record
-> usable contact data
-> reached homeowner
-> qualified opportunity
-> appointment booked
-> appointment held
-> estimate issued
-> sold job

Not every contractor process needs every stage. Preserve the ones the company actually uses and document skipped events. An emergency service request may not follow the same estimate path as a planned remodel.

Keep sold-job status in the operational audit and join financial results in the controlled finance system. The contractor lead ROI calculator provides the separate worksheet for acquisition cost, gross profit and return. Do not widen access to revenue or gross profit merely to complete a quality review.

Audit replacement requests without erasing the original delivery

Record replacement-request date, reason, evidence and provider decision on the original row. When a replacement arrives, give it a new row and its own provider ID. Link it back to the original in notes.

This prevents three reporting errors:

• deleting the original and understating delivered workload;
• counting one replacement as both a refund and another paid record;
• treating a requested remedy as an approved remedy.

Use the provider’s written eligibility terms. Unreachable, not qualified, outside scope, duplicate and invalid contact data are not interchangeable. A weak sales result is not automatically a bad lead. The audit should show whether the record conformed to the purchased definition and how the stated remedy was applied.

Review denied and approved requests separately. A repeated denial may indicate missing evidence, missed submission timing, a misunderstood policy or a genuine gap between the contractor’s preferred definition and the product purchased.

Calculate lead-quality rates from named denominators

Every rate needs a numerator, denominator and cohort. Keep the underlying counts beside it.

Usable-data rate = usable records / delivered records

Reached-homeowner rate = reached homeowners / usable records

Qualification rate after reach = qualified opportunities / reached homeowners

Held-estimate rate = held estimates / qualified opportunities

Sold-job rate on delivery = sold jobs / delivered records

Approved-replacement rate = approved replacements / replacement requests

These rates answer different questions. Do not compare one provider’s qualification rate after reach with another provider’s sold-job rate on delivery. Do not remove invalid or unreachable records from the delivered denominator simply because another stage uses a narrower denominator.

The lead-to-sale benchmark guide explains why stage definitions matter. This audit does not supply a universal target. Compare like cohorts from your business, keep the record count visible and identify open outcomes that have not matured.

Turn the audit into a renewal decision

Bring the provider export, phone log, CRM activities, appointment records, replacement decisions and completed audit to one review. Then choose the action that matches the evidence:

Do not turn one unusual record into a provider verdict. Also do not let a small cohort excuse a clear contractual mismatch. The evidence should determine whether the problem is observable now or needs a larger mature cohort.

Apply the audit to theBuildd handoff

theBuildd sends leads by text and email within 10 minutes for agreed US residential home-improvement trades and ZIP codes. Your team performs qualification. There is one buyer per lead through theBuildd. The homeowner may still seek other quotes independently.

The audit should preserve delivery evidence, source and permission references supplied for the record, contractor attempts, qualification, later outcomes and any replacement request. Leads meeting the applicable bad-lead criteria are replaced rather than refunded. Results are not guaranteed.

Review current pricing and terms only after the office agrees on status definitions and evidence ownership. If one-buyer delivery fits the audited process, request a trade-and-ZIP conversation. Bring the blank template to that conversation and ask which fields and remedy evidence will be available before buying.