Pull 90 days of search-terms reports
Export ninety days of search-terms reports across every paid campaign. Search terms, not keywords. The search-terms report is where the actual user queries live and where the structural leak first appears in raw form. The pull is the audit's foundation; without it, the rest is opinion.
Sort search terms against the service-area
Sort the search-terms list against the contractor's declared service area. Out-of-area queries are marked as Line 1 leak inventory. Adjacent-area queries are flagged for review. In-area queries pass to the next sort. The sort is mechanical and surfaces the geo-leak fraction in the first hour.
Sort search terms against the service catalog
Sort the remaining list against the contractor's offered services. Service-not-offered queries are marked as Line 2 leak inventory. Off-spec queries (commercial bid against residential contractor) are flagged. In-spec queries pass. The service-match sort exposes the fraction the agency inherited from the wrong match-type defaults.
Identify branded-search clicks
Identify the branded-search clicks the platform is charging for. Queries containing the contractor's business name are the cannibalisation lane. Where organic ranks first for the brand term, the paid spend on that term is Line 3 leak inventory. The identify step requires a brand-term list and a quick organic-rank check.
Audit conversion goals
Pull the conversion goals configured against each campaign. Form-fills, calls under sixty seconds, page views, and PDF downloads counted as conversions are Line 4 leak inventory. Only closed-job or sales-qualified-lead conversions pass the audit. The conversion-goal pass is the most often broken and the most often ignored.
Tally the leak fraction by line
Tally the spend against Line 1, Line 2, Line 3, and Line 4. The four lines compose the leak total. Most accounts show sixty to eighty percent of spend against the four lines combined. The tally is the ledger's headline number.
Map the leak to negative keywords and exclusions
For Line 1 and Line 2, map the leak terms into a negative-keyword list and geo-exclusion ranges. The exclusion list is the install deliverable; it lives in the ad account, not the report. The map is what turns "we found a leak" into "we plugged the leak."
Carve out the branded-search lane
For Line 3, either pause the branded-search campaign entirely or carve a separate brand-defense lane with a single bid cap and a separate budget line. The carve-out separates the brand defense from the prospecting spend. The pause-versus-carve decision is account-dependent and named in the verdict.
Rewrite conversion goals against closed jobs
For Line 4, rewrite the conversion goals against closed jobs or sales-qualified leads, not form-fills. Configure call-tracking with a sixty-second minimum. The conversion-goal hygiene gives the algorithm the right compass and unlocks Smart Bidding to do the work it is supposed to do.
Install the spend-leak ledger as the operating filter
Move the ledger from one-time audit to operating filter. The contractor or the contractor's agency reviews the four lines weekly. New leak inventory gets added; expired leak inventory gets pruned. The ledger is the contract against the spend, not a one-time report.
Reconcile against closed-job revenue
Reconcile the cleaned spend against closed-job revenue across the next sixty days. The cost-per-closed-job, not the cost-per-click, is the operating metric. The reconciliation is the proof the install worked.
Document the spend conversation
Document the spend conversation for the next month's budget review. The four ledger lines, the install moves, the cost-per-closed-job. The documentation is what the contractor uses to defend the spend to the spouse, the partner, the bookkeeper, or the lender.