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: ^[1] | ^[2] | ^[3]

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

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)

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 ^[2]
• Claude token management and the summarize-to-continue technique — see ^[4]
• For the broader client context — see ^[1]