CASE BRIEFING & SOURCE DOCUMENTATION: The Cost-Per-Click Bleed Stonemill School of Business | Fictional Case Archive Program: Digital Marketing & Growth Strategies (AAS) Course: MKT 130 Paid Search (SEM) & Performance Advertising Student Lead: Travis Keller | Faculty Supervisor: kendra-rowland Date of Case Analysis: 2026-11-12 1. INSTITUTIONAL & CLIENT BACKGROUND A residential HVAC contractor in Mecklenburg County invested $6,200 monthly in Google Ads but booked fewer than three verified replacement jobs per month, yielding an unsustainable customer acquisition cost exceeding $2,000. Travis Keller's search query audit revealed that 68% of ad spend was consumed by broad-match searches for DIY manuals, free thermostat schematics, and competitor customer service phone numbers. The intervention introduced 140 negative keywords, geofenced zip codes within 15 miles, and established dedicated emergency landing pages, cutting acquisition cost to $480 per contract. 2. DIAGNOSTIC PROBLEM STATEMENT High click volume (1,240 clicks/month) with abysmal 1.2% phone conversion rate. Broad-match keywords attracted non-commercial DIY traffic and out-of-territory inquiries. 3. SYSTEMATIC REVISION & CORRECTIVE ACTION Implemented negative keyword library (140 terms), converted core keywords to phrase and exact match, geofenced campaigns strictly to Mecklenburg and northern Union county, and added dynamic call-tracking script. 4. EDUCATIONAL AND COMMERCIAL BOUNDARIES Illustrative advertising analytics simulation. Campaign figures are educational case data; actual ad performance varies based on seasonal market demand. 5. RAW DATASET OVERVIEW See companion dataset 'the-cost-per-click-bleed-records.csv' for detailed tabular records analyzed in this study.