The Cost-Per-Click Bleed
How an HVAC contractor in Mecklenburg County eliminated $6,200 in wasted monthly broad-match Google Ads spend, slashing customer acquisition cost from $2,000+ down to $480.
Initial Problem & Campaign Waste
In September 2026, a 14-technician residential heating and air conditioning contractor approached the Stonemill Analytics Studio for diagnostic help. The business was allocating $6,200 per month to Google Ads campaigns managed via automated smart bidding. Despite generating over 1,240 clicks monthly, the campaign produced fewer than three verified HVAC system replacement contracts.
The effective Customer Acquisition Cost (CAC) exceeded $2,066 per booked job, eroding the contractor's gross margin. Inbound phone calls were overwhelming office dispatchers with non-commercial inquiries, warranty claims for brands the shop did not service, and homeowners looking for free technical advice.
Baseline Campaign Performance
- Monthly Ad Spend: $6,200.00
- Monthly Click Volume: 1,240 Clicks ($5.00 Avg CPC)
- Qualified Inbound Leads: 15 Phone Inquiries (1.2% Conv Rate)
- Closed System Replacements: 3 Contracts / Month
- Customer Acquisition Cost: $2,066.67 per Job
The Studio Diagnostic: Search Query Log Audit
Student investigator Travis Keller ingested 90 days of Google Ads Search Term Reports into the Analytics Studio SQL sandbox. A granular token frequency analysis revealed three critical failure points:
1. Broad Match Bleed
Broad match bidding on terms like furnace repair matched search queries such as "how to light furnace pilot light yourself" and "free Coleman furnace repair manual PDF". 42% of total clicks had zero commercial purchase intent.
2. Competitor Brand Hijack
Competitor name keywords triggered high-cost clicks from frustrated existing customers looking for competitor phone numbers, resulting in immediate 10-second site bounces.
3. Geographic Overreach
Default campaign location settings targeted "people interested in Charlotte", drawing clicks from Raleigh, Columbia SC, and out-of-state vacationers researching North Carolina properties.
The Corrective Performance Strategy
Under faculty direction, Travis restructured the Google Ads account architecture according to Stonemill's strict Search Engine Marketing framework:
- 140-Term Negative Keyword Scrub: Applied universal negative lists eliminating "DIY", "manual", "parts", "schematic", "career", "salary", and non-serviced manufacturer brand names.
- Exact & Phrase Match Migration: Converted 100% of generic broad match keywords to high-intent phrase match (e.g.,
"emergency ac repair charlotte") and exact match. - Strict Geofencing: Restricted bid radii exclusively to Mecklenburg and northern Union County zip codes within a 15-mile service dispatch perimeter.
- Dynamic Call Tracking & Dedicated Landing Pages: Designed high-converting mobile landing pages featuring click-to-call buttons and 24/7 dispatch emergency badges.
Post-Intervention Results (Month 2)
- Monthly Budget Retained: $4,800.00 (Savings: $1,400)
- High-Intent Clicks: 620 Clicks (Waste Eliminated)
- Conversion Rate: 8.4% (Up from 1.2%)
- Closed Replacements: 10 Contracts / Month
- New Customer Acquisition Cost: $480.00 per Contract (-76.8%)
Case Study Source Files & Datasets
Download the authentic case documentation and query record logs compiled during this investigation.
Educational Boundary Notice: Illustrative advertising analytics simulation. Campaign figures are educational case data; actual ad performance varies based on seasonal market demand.