--- title: Exterior Renovations — Service Page Content Optimization type: article created: '2026-04-05' updated: '2026-04-05' source_docs: - raw/2025-11-13-weekly-call-w-ben-101521557.md tags: - seo - content-strategy - local-seo - exterior-renovations - service-pages - ahrefs - google-search-console - claude - ai-workflow layer: 2 client_source: null industry_context: null transferable: true --- # Exterior Renovations — Service Page Content Optimization ## Overview Exterior Renovations' website has a critical content misalignment: organic traffic is driven almost entirely by blog posts (Tyvek, LVL beams, copper gutters) while core service pages — Roofing, Siding, Decks, Windows — generate almost no traffic. The service pages exist but carry thin content with no local keyword targeting. This article documents the diagnosis, the rewrite strategy, and the AI-assisted workflow used to generate optimized page briefs. See also: [[wiki/clients/exterior-renovations/_index]] | [[wiki/knowledge/seo/local-seo-gmb-setup]] | [[wiki/knowledge/ai-workflows/claude-projects-for-client-seo]] --- ## Diagnosis ### Content Misalignment (GSC + Ahrefs Evidence) - **Domain Rating:** 2.3 — extremely low authority - **Organic Keywords:** ~370 - **Top traffic pages:** Blog posts (Tyvek wrap, LVL beams, copper gutters), not service pages - **Service pages (Roofing, Siding, Decks, Windows):** Minimal to zero organic traffic - **Current word count on service pages:** ~200 words (observed on Roofing page during call) - **Conclusion:** The site is not optimized for its primary revenue-generating services ### What's Missing on Service Pages | Element | Current State | Target State | |---|---|---| | Word count | ~200 words | 800–1,000+ words | | H1 | Generic (no location) | Includes "Madison" or "Madison, Wisconsin" | | H2/H3 hierarchy | Minimal | Full hierarchy with keyword-rich headings | | Local relevance | None | Wisconsin, Dane County, Madison throughout | | FAQ section | Absent | Present (targets question-based queries) | | Schema markup | None | Local Business + Service schema | | Trust signals | Basic | Expanded (certifications, local tenure, reviews) | --- ## Rewrite Strategy ### Core Principle: Local Keyword Saturation Every service page should target the pattern **`[Service] + Madison, Wisconsin`** as its primary keyword. The H1, meta title, and opening paragraph should all include the city. Secondary mentions of "Wisconsin," "Dane County," and neighborhood-level references reinforce local relevance throughout the body. **Target keywords by page:** - Roofing → *Roofing Contractor in Madison, Wisconsin* - Siding → *Expert Siding in Madison* - Windows → *Window Replacement in Madison* - Decks → *Deck Installation Madison, Wisconsin* ### Page Structure Template Each rewritten service page should follow this structure: 1. **H1** — Primary keyword (e.g., *Roofing Contractor in Madison, Wisconsin*) 2. **Intro paragraph** — 100–150 words, keyword-rich, local context 3. **H2: [Service] Repair and Replacement** — Core service description - H3 subheadings for service variants (e.g., storm damage, full replacement, repair) - Bullet list of included services 4. **H2: Why Choose [Company Name]** — Trust signals, local tenure, certifications - H3s for specific differentiators 5. **Image** — With alt text including location + service keyword 6. **H2: Our Process** — Optional but valuable for E-E-A-T 7. **FAQ Section** — 4–6 questions matching common search queries (see below) 8. **CTA** — Free estimate form or phone number ### FAQ Guidance FAQs are high-value for local SEO because they directly match question-based queries. Each service page should include 4–6 FAQs. Example questions for Roofing: - *How much does roof replacement cost in Madison, Wisconsin?* - *Does homeowner's insurance cover storm damage roof repair?* - *How long does a roof replacement take?* - *What roofing materials work best in Wisconsin's climate?* - *Is [Company Name] licensed and insured in Wisconsin?* --- ## AI-Assisted Brief Generation Workflow This workflow was demonstrated live during the call using Claude and Google Search Console exports. ### Step 1: Export Source Data - **Google Search Console:** Export 3-month query report → download as CSV → open in Google Sheets → export as PDF - **Ahrefs:** Export Organic Keywords report (includes volume, CPC, position) → same PDF process - **SpyFu:** Generate domain overview report → download PDF directly > **Why PDF?** Claude handles PDF uploads more reliably than raw CSV or Google Sheets files. Convert all exports before uploading. ### Step 2: Create a Claude Project 1. In Claude, navigate to **Projects** → **Create Project** 2. Name it: *Exterior Renovations* 3. Add project instructions describing the client context: - Who the client is and what they do - Their service area (Madison, WI / Dane County) - Current SEO challenges - Our goal (improve local organic rankings for service pages) 4. Upload all exported PDFs as knowledge files > The project persists across sessions. You don't need to re-upload data or re-explain context each time you start a new chat within the project. ### Step 3: Generate the Content Brief Within the project, prompt Claude to generate a full service page. Example prompt: > *"Using the GSC and Ahrefs data provided, write a fully optimized service page for [Roofing] targeting the keyword 'Roofing Contractor in Madison, Wisconsin.' Include a proper H1/H2/H3 hierarchy, local keyword density, a FAQ section, and a CTA. The page should be 800–1,000 words."* Claude will reference the uploaded keyword data to inform heading choices, FAQ topics, and keyword placement. ### Step 4: Review the Output The AI-generated brief will include: - Full heading hierarchy with Madison/Wisconsin keywords embedded - Body copy with local references (Dane County, Wisconsin climate, etc.) - FAQ section targeting question-based queries - Meta title and description suggestions - A comparison of current vs. proposed page (word count, structure, local relevance) Review for accuracy and brand voice. The content is a starting point — not final copy. ### Step 5: Send to Developer Once reviewed and approved by the client: 1. Have the developer create a **draft page** (e.g., `/new-roofing`) — not live yet 2. Share the draft link with the client for approval 3. On approval, make the draft the live page Use a ClickUp task to track each page through this workflow. --- ## Pages to Rewrite (Priority Order) | Page | Target Keyword | Status | |---|---|---| | Roofing | Roofing Contractor in Madison, Wisconsin | Brief generated (call demo) | | Siding | Expert Siding in Madison | Pending | | Windows | Window Replacement in Madison | Pending | | Decks | Deck Installation Madison, Wisconsin | Pending | --- ## Action Items - [ ] Export GSC 3-month query report → convert to PDF → upload to Claude project (@Ben) - [ ] Export Ahrefs Organic Keywords report → convert to PDF → upload to Claude project (@Ben) - [ ] Generate content briefs for all four service pages using Claude project (@Ben) - [ ] Send briefs to client for review (@Ben) - [ ] Create ClickUp tasks for developer to implement approved pages (@Ben) - [ ] Share Claude "Exterior Renovations" project link with Ben (@Mark) ✓ done during call --- ## Related Notes - Local SEO (GMB map pack absence) is a parallel priority — see [[wiki/knowledge/seo/local-seo-gmb-setup]] - Claude token management and the summarize-to-continue technique — see [[wiki/knowledge/ai-workflows/claude-chat-token-management]] - For the broader client context — see [[wiki/clients/exterior-renovations/_index]]