Full Keyword Database: View all 40,847 keywords with search, filter, and sort -- every keyword from all 4 SEMRush clusters merged into one searchable, filterable command center. Includes volume, KD, CPC, intent, and cluster for each keyword. All 40,847 keywords from the original SEMRush exports are now live and weaponized.
One page = two jobs. Every service page we build serves both Google Ads (paid traffic converting now) and Google organic (free traffic forever). The same URL does both. Audrey designs one template. Kalen writes the copy. Robert builds the pages and connects the ads. The menu grows as pages go live.
| Subcluster | Keywords | Volume/mo | Avg KD | Page Status |
|---|---|---|---|---|
| Sewer Camera Inspection | 329 | 190,380 | 17.4 | NO PAGE |
| Sewer Cleanout | 258 | 184,720 | 14.2 | NEEDS BLOG |
| Sewer Smell | 757 | 126,100 | 14.3 | NEEDS BLOG |
| Sewer Line Replacement | 148 | 76,600 | 15.4 | NEEDS CONTENT |
| Trenchless Repair | 301 | 73,470 | 12.6 | HAS PAGE |
| Tree Roots | 285 | 39,850 | 16.5 | NEEDS BLOG |
| Sewer Repair General | 77 | 34,110 | 14.7 | HAS PAGE |
| Sewer Repair Cost | 194 | 30,370 | 10.7 | HAS PAGE |
| Drain Cleaning (overlap) | 10 | 620 | 12.5 | NEEDS PAGE |
| Sewer Backup | 2 | 280 | 13.5 | NEEDS BLOG |
| Keyword | Volume/mo | KD | CPC | Intent |
|---|---|---|---|---|
| drain camera | 74,000 | 37 | $3.37 | Money |
| sewer line clean out | 60,500 | 13 | $18.00 | Money |
| drain cleanout | 60,500 | 22 | $20.00 | Money |
| sewer inspection camera near me | 18,100 | 36 | $15.99 | Money |
| sewer camera near me | 14,800 | 29 | $9.19 | Money |
| drain camera near me | 6,600 | 38 | $15.38 | Money |
| plumbing camera inspection near me | 5,400 | 20 | $15.27 | Money |
| plumbing camera near me | 5,400 | 14 | $10.88 | Money |
| sewer scope near me | 4,400 | 15 | $21.88 | Money |
| sewer camera inspection near me | 3,600 | 24 | $15.99 | Money |
| Keyword | Volume/mo | KD | CPC |
|---|---|---|---|
| drain cleaning | 165,000 | 52 | $11.74 |
| drain cleaning near me | 165,000 | 26 | $20.97 |
| hydro jetting near me | 74,000 | 27 | $21.66 |
| clogged drain service | 60,500 | 27 | $29.80 |
| sewer line cleaning | 60,500 | 23 | $19.62 |
| hydrojet drain cleaning | 60,500 | 14 | $15.95 |
| main drain cleaning | 49,500 | 28 | $17.58 |
| hydro jetting sewer line | 49,500 | 20 | $18.84 |
| drain cleaning companies near me | 40,500 | 59 | $23.66 |
| emergency drain service | 40,500 | 40 | $34.61 |
| Keyword | Volume/mo | KD | CPC |
|---|---|---|---|
| plumber | 550,000 | 67 | $25.12 |
| plumber near me | 450,000 | 53 | $22.00 |
| plumbers near me | 246,000 | 63 | $22.00 |
| emergency plumber | 165,000 | 46 | $34.35 |
| emergency plumber near me | 135,000 | 23 | $25.97 |
| emergency plumbing | 135,000 | 49 | $34.35 |
| water heater replacement near me | 135,000 | 58 | $16.51 |
| emergency plumbing near me | 110,000 | 46 | $25.97 |
| plumbing repair near me | 110,000 | 52 | $26.37 |
| plumbing services near me | 110,000 | 30 | $22.65 |
Critical Gap: BSP has NO dedicated /emergency-plumbing/ page. The current campaign spends $50/day sending traffic to the generic /plumbing-services/ page. A dedicated page with emergency-specific content would dramatically improve conversion rates. "Emergency plumber near me" alone is 135,000 searches/month at KD 23 (easy).
| Keyword | Volume/mo | KD | CPC |
|---|---|---|---|
| water heater replacement | 246,000 | 55 | $13.29 |
| tankless water heater | 135,000 | 41 | $1.62 |
| water heater replacement near me | 135,000 | 58 | $16.51 |
| water heater | 110,000 | 63 | $3.43 |
| hot water heater replacement | 90,500 | 50 | $11.64 |
| hot water heater | 74,000 | 57 | $2.85 |
| water heater installation near me | 74,000 | 50 | $17.08 |
| hot water heater repair | 74,000 | 42 | $24.07 |
| electric water heater | 40,500 | 37 | $1.52 |
| tankless water heater installation | 40,500 | 37 | $8.92 |
| gas water heater | 33,100 | 33 | $2.12 |
Red = no page exists. Yellow = page needs content. Green = page exists.
Hub and Spoke Model (iQuanti SEO Framework). Each service category has a pillar page (hub) that links to specific service pages (spokes). Blog posts target informational keywords and link back to service pages. This structure tells Google: "Bright Side Plumbing is THE authority on [topic] in Kansas City."
40,847 keywords mapped across 4 clusters from SEMRush
Audrey template + Kalen copy = new service page on callbrightside.com
Google Ads keywords map to the new page (not homepage)
Real conversions from real pages. Offline conversion data feeds back to Google.
The dual-job principle: Every new page immediately starts working two jobs. Google Ads drives paid clicks to it today (instant revenue). Google organic starts indexing it and ranking it for free traffic tomorrow (compounding revenue). The same URL. The same content. Two revenue streams.
50-60 depth pages, not 624 thin ones. Each page gets real content from Kalen, real design from Audrey, and targets a real subcluster of keywords. Quality over quantity. Google penalizes thin doorway pages but rewards genuine local content.
Audrey designs ONE service page template. Robert fills content for each new page. Kalen writes and reviews all service copy. Consistent brand, efficient production.
Each high-value service gets location variants: /sewer-repair-overland-park/, /sewer-repair-olathe/, /sewer-repair-lenexa/. Targets "near me" and city-specific searches.
Each service page gets 2-3 supporting blog posts targeting informational keywords. "Sewer smell in house" blog links to /sewer-repair/. Authority compounds.
| Page Type | Target | Count | Keywords | Role |
|---|---|---|---|---|
| Service Pages | Money keywords | 10-12 new | High CPC, transactional | Convert paid + organic traffic to calls |
| Geo Pages | City + service | 20-30 new | "[service] [city]" patterns | Dominate local pack for each city |
| Blog Posts | Informational keywords | 15-20 new | How-to, cost guides, symptoms | Build topical authority, support service pages |
| Comparison Pages | Decision funnel | 5-8 new | "vs" keywords, cost comparisons | Capture researching buyers (Renovation Rachel) |
Audrey designs the master service page template. This one template gets reused for every service page going forward. Includes hero section, service details, CTA blocks, FAQ schema, and photo placements. Robert sends the brief with data from this document.
Biggest gap in the sewer cluster: 190,380 monthly searches, zero BSP pages. Kalen writes the copy. Robert builds the page using Audrey's template. Google Ads sewer campaign gets 329 keywords pointing to this URL. Add to menu under Sewer dropdown.
Two pages, same template. Sewer cleanout (184K/mo) and sewer line replacement (76K/mo, existing generic page gets real content). Combined: 406 keywords, 261K monthly searches. Menu grows.
Emergency plumbing is the biggest single gap: 165K/mo with no dedicated page. Water heater replacement is the highest-volume single keyword across all clusters (246K/mo). Both get new menu categories. Ads campaigns update to point here.
One new service or geo page per week. Menu grows as pages go live. Priority order: /hydro-jetting/, /tankless-water-heater/, /clogged-drain/, then geo pages (/sewer-repair-overland-park/, /sewer-repair-olathe/, etc.). Blog posts fill in informational gaps between service page launches. Compound growth: every page adds permanent organic traffic.
Bottom Line: 40,847 keywords across 19.7M monthly searches. BSP currently has pages targeting a tiny fraction. Every week we build one new page, we capture another slice of this market permanently. The ads pay for themselves immediately (15x ROAS on sewer alone). The organic traffic compounds forever at zero marginal cost. Competitors who are not building this moat right now will be paying for every single click in 12 months while BSP gets them for free.
2,976 sewer keywords mapped. 1.1M monthly searches. BSP ranks for 2 of them. Here is the plan to own them all.
Content → Organic → Quality Score → Cheaper Ads → More Content. The cycle compounds.
Every service page serves BOTH paid (Google Ads) and organic (SEO). One URL. One page. Two revenue streams.
Google Ads points to the page. Converts paid clicks into booked calls. Quality Score improves because the landing page matches the keyword.
Google ranks the same page for SEO. Free traffic. Free calls. Forever. The page earns its keep for years without a single ad dollar.
4 pillar hubs with dedicated spoke pages. Each hub builds topical authority. Each spoke captures long-tail volume.
A $20M/year company vs. the team that outbuilt them.
Real numbers from ServiceTitan. Not projections. Not guesses. Math.
Ads drive calls NOW. Content builds the moat that drives calls FOREVER.
Each new page captures organic traffic = free calls that never stop. The ads fund the content. The content reduces the ad costs. The cycle feeds itself.
One design. All pages. Authority compounds week over week.
The KC plumbing market. Who has what. And what NONE of them have.
The data-to-content-to-ads loop. GCLID tracking. Offline conversion import. AI receptionist. Revenue-optimized Smart Bidding. A complete intelligence system that traces every ad dollar to every invoice.
Nobody else in Kansas City has this.Every plumber in KC guesses. BSP weaponizes the scientific method. Every dollar is a hypothesis. Every campaign is an experiment. Every week produces data that makes next week smarter.
| # | Experiment | Status | Impact/yr |
|---|---|---|---|
| 1 | GCLID Attribution -> Smart Bidding -> CPL $200 to $150 | LIVE | +$350K |
| 2 | Chris Fresh 3-Option Framework -> close rate 35% to 45% | TRAINING | +$581K |
| 3 | Review Velocity 5/week -> 500+ reviews -> organic +25% | BASELINE | +$375K |
| 4 | Affluent ZIP Targeting -> double Stephanie pipeline | PLANNED | +$700K |
| 5 | LCP Under 2.5s -> mobile conversion +15% | IN PROGRESS | +$189K |
| 6 | ST Web Scheduler -> online bookings with GCLID | LIVE | +$72K |
| 7 | GA4 Cleanup -> Smart Bidding recalibrates -> 2-3x leads | IN PROGRESS | +$68K |