Pull the last 30 paid leads in one sheet
Export the last thirty paid-platform leads into a single sheet with timestamp, source, contact details, stated job, geo, and current disposition. Angi, HomeAdvisor, Local Services Ads, Meta lead-form leads all in one column set. The single sheet is the audit foundation; the platforms cannot produce it and will resist exporting cleanly. The export step is half the work and is the step contractors most often skip.
Score Signal 1 · Source quality
Score each lead against the lead source. Direct phone from a GBP listing scores high. Local Services Ads ranks above HomeAdvisor on average for service-match accuracy, below organic search for intent quality. Aggregator-resold leads score lowest. The source-quality grade is a function of the channel, not of the platform's tag on the lead.
Score Signal 2 · Geo match
Score each lead against the geo signal. In-service-area at address-line scores high. Adjacent-zip with defensible drive scores medium. Out-of-area, regardless of platform billing, scores zero. The geo grade is the first place the audit usually surfaces money the contractor was paying without knowing.
Score Signal 3 · Intent signal
Score each lead against intent. Stated specific job with detail scores high. Generic "looking for a quote" scores medium. Form-filler with no detail or wrong service scores low. The intent grade is what separates a stated buyer from a prospect who filled a form.
Score Signal 4 · Urgency window
Score each lead against urgency. Same-week service requests score high. 30-day windows score medium. Six-months-out exploratory scores low. The urgency grade routes the lead into the right queue (active callback, scheduled follow-up, nurture) and the queue routing is what protects bench time downstream.
Score Signal 5 · Budget signal
Score each lead against budget. Stated budget within service tier scores high. Stated budget below floor scores zero. No budget stated scores medium. The budget grade exposes the leads that closed at zero or lost margin in the historical book and were classed as wins in the platform dispositions.
Score Signal 6 · Decision authority
Score each lead against authority. Owner-occupant decision-maker scores high. One of two spouses scores medium. Renter or referral-from-someone-else scores low. The authority grade exposes the long-quote-no-decision pattern that drains estimator hours.
Score Signal 7 · History pattern
Score each lead against the contractor's own history. First call in this category scores neutral. Third call after two prior bids scores high. Known quote-shopper or known tire-kicker scores zero. The history grade brings the contractor's existing pattern recognition into the scorecard as a signal.
Composite the score and re-grade the thirty
Composite the seven signals into a single 0-100 grade per lead. Re-grade the last thirty. The composite produces the contractor's first honest read on how many of the leads the contractor paid for were actually closeable inventory. Most accounts find the closeable fraction is twenty to forty percent, not the eighty percent the platforms imply through tagging.
Install the scorecard as the operating filter
Move the scorecard from one-time audit to operating filter. Every inbound paid lead gets scored before it gets called back. Below-threshold leads get a templated message, not bench time. Bench time gets allocated to leads above threshold. The dispute-with-platform conversation becomes documented at the moment of scoring, not weeks later from memory. The audit completes; the system stays.