Programmatic SEO Competitor Spy

Reverse-engineer how competitors do programmatic SEO.

How to use it

  1. Hit Copy the whole skill.
  2. Claude: ⋯ → Download .md, then Customize → Skills → Add → Upload skill.
    ChatGPT: make a Project and paste it into Instructions.
    Neither? Paste it at the top of a new chat — it works for that chat.
  3. Describe your job in plain words. The AI follows the skill from there.
Claude Code — installs the whole folder, not just SKILL.md
npx degit gooseworks-ai/goose-skills/skills/seo/composites/programmatic-seo-spy#main ~/.claude/skills/programmatic-seo-spy

For one project only, change the path to .claude/skills/programmatic-seo-spy.

Not working?
  • Check which app you pasted it into — the steps above name the right one.
  • Some skills need the paid tier of Claude or ChatGPT.
Step-by-step guide with screenshots · Ask in the forum

Paste into Claude, ChatGPT or Cursor.

Show the full text284 lines
programmatic-seo-spy/SKILL.md284 lines11.6 KBpushed 96d agoRawView on GitHub

Programmatic SEO Competitor Spy

Before building your own programmatic SEO pages, know what your competitors are already doing. This skill crawls competitor sitemaps, detects which URL patterns are programmatic, estimates which ones actually drive traffic, assesses template quality, and finds the gaps they're missing.

Core principle: The best pSEO strategy starts with competitive intelligence. If 3 competitors have /vs/ pages and none have /for-{industry}/ pages, that's a signal. This skill turns competitor site structures into strategic intelligence.

When to Use

  • "What programmatic SEO are competitors doing?"
  • "Reverse-engineer competitor SEO pages"
  • "Which pSEO patterns actually work in our space?"
  • "Find pSEO gaps our competitors are missing"
  • "Analyze competitor URL structure for SEO patterns"

Tool Enhancement (Optional)

This skill works with existing capabilities but is dramatically better with domain analytics data that shows actual traffic per URL pattern.

Agent Prompt to User

"I can analyze competitor site structures with our existing crawling tools. For the most accurate results — especially knowing which patterns actually drive traffic vs. just existing — I'd recommend connecting a domain analytics API."

Recommended: DataForSEO (pay-per-use, ~$0.02-0.05 per domain analysis)

  • Sign up at dataforseo.com → get API login + password
  • Set DATAFORSEO_LOGIN and DATAFORSEO_PASSWORD env vars

Alternatives that also work:

  • SEMrush API (if you have a subscription) → set SEMRUSH_API_KEY
  • Ahrefs API (if you have a subscription) → set AHREFS_API_TOKEN
  • SimilarWeb API (if you have access) → set SIMILARWEB_API_KEY

"Want to use one of these, or should I proceed with baseline mode? Baseline will detect patterns and assess template quality, but traffic estimates will be inferred rather than measured."

Mode Selection

  • Enhanced mode — Domain analytics API provides organic keywords and estimated traffic per URL. Enables confident "this pattern drives X traffic" conclusions. Can show which specific pages within a pattern rank well.
  • Baseline mode — Uses site-content-catalog for URL crawling, seo-domain-analyzer for domain-level metrics, web_search for spot-checking rankings. Pattern detection is equally good. Traffic attribution is directional, based on page count × domain authority × keyword indicators.

Phase 0: Intake

  1. Competitors — 1-5 competitor URLs to analyze
  2. Your product URL — So we can compare coverage
  3. Category — What market/category are these competitors in?
  4. Specific interest? — Looking for anything specific (vs/ pages, integrations, etc.) or full analysis?
  5. Tool preference — Enhanced mode with domain analytics API, or baseline? (see Tool Enhancement above)

Phase 1: Sitemap Crawl

For each competitor, run site-content-catalog:

python3 skills/site-content-catalog/scripts/catalog_content.py \
  --url "<competitor_url>" \
  --output json

Collect:

  • All URLs from sitemap and internal crawl
  • Page titles
  • URL structure/hierarchy
  • Last modified dates (if available)

Phase 2: Pattern Detection

2A: URL Clustering

Group URLs by structural patterns using regex matching:

Pattern Regex Example URLs Category
/vs/.* or /compare/.* /vs/competitor-a, /vs/competitor-b Comparison
/integrations?/.* /integrations/slack, /integrations/hubspot Integration
/for-.* or /solutions/.* /for-startups, /for-enterprise Vertical
/use-cases?/.* /use-cases/project-management Use case
/alternatives?(-to)?/.* /alternatives/competitor-a Alternatives
/templates?/.* or /examples?/.* /templates/invoice, /templates/proposal Templates
/glossary/.* or /what-is/.* /glossary/term-a, /what-is/crm Glossary
/tools?/.* or `/calculat(or e)/.*` /tools/roi-calculator
/blog/.* (exclude from pSEO) /blog/how-to-x Editorial (not pSEO)

For each detected pattern:

  • Page count — How many pages follow this pattern?
  • Data axis — What varies per page? (competitor name, tool name, industry, etc.)
  • URL consistency — Are URLs cleanly structured or messy?
  • Coverage completeness — Have they covered the obvious variations?

2B: Programmatic vs. Editorial Classification

Not every URL pattern is programmatic. Classify each cluster:

  • Programmatic — Clearly templated: consistent URL structure, similar page titles following a pattern, high page count, structured content
  • Semi-programmatic — Template with heavy manual customization
  • Editorial — Individually written, no template pattern
  • Auto-generated — Thin/low-quality programmatic (tag pages, archive pages)

Focus analysis on Programmatic and Semi-programmatic clusters only.

Phase 3: Traffic & Performance Analysis

Enhanced Mode (DataForSEO / SEMrush / Ahrefs)

For each competitor domain, pull organic keywords data:

# DataForSEO example
POST /v3/dataforseo_labs/google/ranked_keywords/live
{
  "target": "competitor.com",
  "filters": [
    ["ranked_serp_element.serp_item.url", "contains", "/vs/"]
  ]
}

Per pattern cluster:

  • Total ranking keywords across all pages in the pattern
  • Estimated monthly organic traffic to the pattern
  • Average ranking position for pages in this pattern
  • Top-performing pages within the pattern (which variations rank best?)
  • Keyword difficulty distribution (are they targeting easy or hard keywords?)

Baseline Mode

Estimate traffic indicators:

  • Run seo-domain-analyzer for overall domain metrics
  • Spot-check 3-5 pages per pattern via web_search — do they appear in top 10?
  • Check if pages are indexed (site:competitor.com/vs/)
  • Infer relative traffic: pattern page count × indexation rate × domain authority proxy
  • Note: these are directional estimates, not exact numbers

Phase 4: Template Quality Assessment

For each programmatic pattern, fetch 3-5 sample pages via fetch_webpage:

# Pick pages from the pattern — one high-variation, one low-variation, one middle

Evaluate template quality on:

Dimension Score 1-5 What to Look For
Content depth Word count, sections, detail level
Unique value per page Does each page offer something you can't get from the template alone?
Data richness Tables, comparisons, stats, screenshots
Freshness signals Updated dates, current pricing, recent reviews
Internal linking Links to related pages, hub structure
CTA integration Contextual CTAs vs. generic banners
Schema markup Structured data, FAQ schema, review schema

Quality tiers:

  • 4-5 avg: Well-executed pSEO — hard to beat without significant differentiation
  • 3-4 avg: Decent but improvable — opportunity to out-template them
  • 1-3 avg: Thin/low-quality — easy to dominate with better content

Phase 5: Gap Analysis

5A: Pattern Coverage Matrix

Pattern Type Competitor A Competitor B Competitor C You Gap?
vs/ comparisons 25 pages ★★★★ 10 pages ★★★ 0 0 ✓ A leads
integrations/ 40 pages ★★★ 60 pages ★★★★ 20 pages ★★ 0 ✓ B leads
for-{industry}/ 0 0 8 pages ★★ 0 ✓ Wide open
alternatives/ 5 pages ★★★ 0 0 0 ✓ Lightly competed
glossary/ 100 pages ★★ 0 50 pages ★★★ 0 ⚠️ Volume play

5B: Variation Gaps

Within each pattern competitors use, find missing variations:

  • Competitors they haven't written vs/ pages for
  • Integrations they support but haven't built pages for
  • Industries they serve but haven't targeted
  • These are your quick-win entries

5C: Pattern White Space

Entire pattern types no competitor has built:

  • Highest opportunity — no one to outrank, first-mover advantage
  • Validate search demand exists (Phase 1D of programmatic-seo-planner)

5D: Quality Gaps

Patterns where competitors have pages but they're low quality:

  • Thin content (< 500 words, no unique data)
  • Outdated (old screenshots, wrong pricing)
  • Missing schema markup
  • No visual differentiation between pages
  • These are "out-template" opportunities

Phase 6: Output

# Programmatic SEO Competitive Landscape — [Category] — [DATE]

## Competitors Analyzed
- [Competitor A] — [domain metrics, total pages crawled]
- [Competitor B] — [domain metrics, total pages crawled]
- [Competitor C] — [domain metrics, total pages crawled]

## Executive Summary
- [N] programmatic patterns detected across [M] competitors
- Strongest competitor pSEO: [Competitor X] with [pattern] ([N] pages, [quality])
- Biggest opportunity: [pattern type] — [reasoning]
- Quick wins: [N] variation gaps in existing competitor patterns

---

## Pattern-by-Pattern Analysis

### Pattern: [vs/ Comparisons]
**Who's doing it:** [Competitor A (25 pages, ★★★★), Competitor B (10 pages, ★★★)]
**Traffic estimate:** [X monthly visits across pattern] (enhanced) / [directional estimate] (baseline)
**Template quality:** [summary of strengths/weaknesses]
**Top-performing pages:** [specific pages that rank well]
**Variation gaps:** [competitors/variations they're missing]
**Your opportunity:** [specific recommendation]

### Pattern: [integrations/]
...

---

## Opportunity Ranking

| Priority | Pattern | Opportunity Type | Effort | Expected Impact |
|----------|---------|-----------------|--------|----------------|
| P0 | [pattern] | White space — no competitors | Medium | High |
| P0 | [pattern] | Quality gap — beat weak templates | Low | Medium |
| P1 | [pattern] | Variation gap — fill missing pages | Low | Medium |
| P2 | [pattern] | Head-to-head — outrank strong competitor | High | High |

---

## Recommended Action Plan

1. **Immediate (Week 1-2):** Build [pattern] — [rationale]
2. **Short-term (Month 1):** Build [pattern] — [rationale]
3. **Medium-term (Month 2-3):** Build [pattern] — [rationale]

---

## Raw Data
[Link to crawl data, pattern clusters, sample pages analyzed]

Save to the current working directory or wherever the user prefers.

Cost

Component Cost
Site catalog per competitor (Apify) ~$0.05-0.10
SEO domain analyzer per competitor ~$0.10-0.20
Page fetches (3-5 per pattern × N patterns) ~$0.01-0.05
DataForSEO domain analytics (enhanced) ~$0.10-0.50 per competitor
Analysis Free (LLM reasoning)
Total (baseline, 3 competitors) ~$0.50-1.00
Total (enhanced, 3 competitors) ~$0.80-2.00

Tools Required

  • Apify API tokenAPIFY_API_TOKEN env var
  • Upstream skills: site-content-catalog, seo-domain-analyzer, fetch_webpage
  • Optional (enhanced): DataForSEO (DATAFORSEO_LOGIN + DATAFORSEO_PASSWORD), SEMrush (SEMRUSH_API_KEY), Ahrefs (AHREFS_API_TOKEN), or SimilarWeb (SIMILARWEB_API_KEY)

Trigger Phrases

  • "What pSEO are competitors doing?"
  • "Reverse-engineer competitor programmatic pages"
  • "Analyze competitor URL structure"
  • "Find pSEO gaps in our space"
  • "What comparison pages do competitors have?"
1---
2name: programmatic-seo-spy
3description: >
4 Reverse-engineer how competitors do programmatic SEO. Detects URL pattern clusters
5 (vs/, integrations/, for-{industry}/), estimates page count per pattern, analyzes
6 template quality, infers which patterns actually drive traffic, and identifies gaps
7 you can exploit. Outputs a competitive pSEO landscape report.
8tags: [seo]
9---
10 
11# Programmatic SEO Competitor Spy
12 
13Before building your own programmatic SEO pages, know what your competitors are already doing. This skill crawls competitor sitemaps, detects which URL patterns are programmatic, estimates which ones actually drive traffic, assesses template quality, and finds the gaps they're missing.
14 
15**Core principle:** The best pSEO strategy starts with competitive intelligence. If 3 competitors have /vs/ pages and none have /for-{industry}/ pages, that's a signal. This skill turns competitor site structures into strategic intelligence.
16 
17## When to Use
18 
19- "What programmatic SEO are competitors doing?"
20- "Reverse-engineer competitor SEO pages"
21- "Which pSEO patterns actually work in our space?"
22- "Find pSEO gaps our competitors are missing"
23- "Analyze competitor URL structure for SEO patterns"
24 
25## Tool Enhancement (Optional)
26 
27This skill works with existing capabilities but is dramatically better with domain analytics data that shows actual traffic per URL pattern.
28 
29### Agent Prompt to User
30 
31> "I can analyze competitor site structures with our existing crawling tools. For the most accurate results — especially knowing which patterns actually drive traffic vs. just existing — I'd recommend connecting a domain analytics API."
32>
33> **Recommended: DataForSEO** (pay-per-use, ~$0.02-0.05 per domain analysis)
34> - Sign up at dataforseo.com → get API login + password
35> - Set `DATAFORSEO_LOGIN` and `DATAFORSEO_PASSWORD` env vars
36>
37> **Alternatives that also work:**
38> - **SEMrush API** (if you have a subscription) → set `SEMRUSH_API_KEY`
39> - **Ahrefs API** (if you have a subscription) → set `AHREFS_API_TOKEN`
40> - **SimilarWeb API** (if you have access) → set `SIMILARWEB_API_KEY`
41>
42> "Want to use one of these, or should I proceed with baseline mode? Baseline will detect patterns and assess template quality, but traffic estimates will be inferred rather than measured."
43 
44### Mode Selection
45 
46- **Enhanced mode** — Domain analytics API provides organic keywords and estimated traffic per URL. Enables confident "this pattern drives X traffic" conclusions. Can show which specific pages within a pattern rank well.
47- **Baseline mode** — Uses `site-content-catalog` for URL crawling, `seo-domain-analyzer` for domain-level metrics, `web_search` for spot-checking rankings. Pattern detection is equally good. Traffic attribution is directional, based on page count × domain authority × keyword indicators.
48 
49## Phase 0: Intake
50 
511. **Competitors** — 1-5 competitor URLs to analyze
522. **Your product URL** — So we can compare coverage
533. **Category** — What market/category are these competitors in?
544. **Specific interest?** — Looking for anything specific (vs/ pages, integrations, etc.) or full analysis?
555. **Tool preference** — Enhanced mode with domain analytics API, or baseline? (see Tool Enhancement above)
56 
57## Phase 1: Sitemap Crawl
58 
59For each competitor, run `site-content-catalog`:
60 
61```bash
62python3 skills/site-content-catalog/scripts/catalog_content.py \
63 --url "<competitor_url>" \
64 --output json
65```
66 
67Collect:
68- All URLs from sitemap and internal crawl
69- Page titles
70- URL structure/hierarchy
71- Last modified dates (if available)
72 
73## Phase 2: Pattern Detection
74 
75### 2A: URL Clustering
76 
77Group URLs by structural patterns using regex matching:
78 
79| Pattern Regex | Example URLs | Category |
80|--------------|-------------|----------|
81| `/vs/.*` or `/compare/.*` | /vs/competitor-a, /vs/competitor-b | Comparison |
82| `/integrations?/.*` | /integrations/slack, /integrations/hubspot | Integration |
83| `/for-.*` or `/solutions/.*` | /for-startups, /for-enterprise | Vertical |
84| `/use-cases?/.*` | /use-cases/project-management | Use case |
85| `/alternatives?(-to)?/.*` | /alternatives/competitor-a | Alternatives |
86| `/templates?/.*` or `/examples?/.*` | /templates/invoice, /templates/proposal | Templates |
87| `/glossary/.*` or `/what-is/.*` | /glossary/term-a, /what-is/crm | Glossary |
88| `/tools?/.*` or `/calculat(or|e)/.*` | /tools/roi-calculator | Tools |
89| `/blog/.*` (exclude from pSEO) | /blog/how-to-x | Editorial (not pSEO) |
90 
91For each detected pattern:
92- **Page count** — How many pages follow this pattern?
93- **Data axis** — What varies per page? (competitor name, tool name, industry, etc.)
94- **URL consistency** — Are URLs cleanly structured or messy?
95- **Coverage completeness** — Have they covered the obvious variations?
96 
97### 2B: Programmatic vs. Editorial Classification
98 
99Not every URL pattern is programmatic. Classify each cluster:
100 
101- **Programmatic** — Clearly templated: consistent URL structure, similar page titles following a pattern, high page count, structured content
102- **Semi-programmatic** — Template with heavy manual customization
103- **Editorial** — Individually written, no template pattern
104- **Auto-generated** — Thin/low-quality programmatic (tag pages, archive pages)
105 
106Focus analysis on Programmatic and Semi-programmatic clusters only.
107 
108## Phase 3: Traffic & Performance Analysis
109 
110### Enhanced Mode (DataForSEO / SEMrush / Ahrefs)
111 
112For each competitor domain, pull organic keywords data:
113 
114```
115# DataForSEO example
116POST /v3/dataforseo_labs/google/ranked_keywords/live
117{
118 "target": "competitor.com",
119 "filters": [
120 ["ranked_serp_element.serp_item.url", "contains", "/vs/"]
121 ]
122}
123```
124 
125Per pattern cluster:
126- **Total ranking keywords** across all pages in the pattern
127- **Estimated monthly organic traffic** to the pattern
128- **Average ranking position** for pages in this pattern
129- **Top-performing pages** within the pattern (which variations rank best?)
130- **Keyword difficulty** distribution (are they targeting easy or hard keywords?)
131 
132### Baseline Mode
133 
134Estimate traffic indicators:
135- Run `seo-domain-analyzer` for overall domain metrics
136- Spot-check 3-5 pages per pattern via `web_search` — do they appear in top 10?
137- Check if pages are indexed (site:competitor.com/vs/)
138- Infer relative traffic: pattern page count × indexation rate × domain authority proxy
139- Note: these are directional estimates, not exact numbers
140 
141## Phase 4: Template Quality Assessment
142 
143For each programmatic pattern, fetch 3-5 sample pages via `fetch_webpage`:
144 
145```bash
146# Pick pages from the pattern — one high-variation, one low-variation, one middle
147```
148 
149Evaluate template quality on:
150 
151| Dimension | Score 1-5 | What to Look For |
152|-----------|-----------|-----------------|
153| **Content depth** | | Word count, sections, detail level |
154| **Unique value per page** | | Does each page offer something you can't get from the template alone? |
155| **Data richness** | | Tables, comparisons, stats, screenshots |
156| **Freshness signals** | | Updated dates, current pricing, recent reviews |
157| **Internal linking** | | Links to related pages, hub structure |
158| **CTA integration** | | Contextual CTAs vs. generic banners |
159| **Schema markup** | | Structured data, FAQ schema, review schema |
160 
161**Quality tiers:**
162- **4-5 avg:** Well-executed pSEO — hard to beat without significant differentiation
163- **3-4 avg:** Decent but improvable — opportunity to out-template them
164- **1-3 avg:** Thin/low-quality — easy to dominate with better content
165 
166## Phase 5: Gap Analysis
167 
168### 5A: Pattern Coverage Matrix
169 
170| Pattern Type | Competitor A | Competitor B | Competitor C | You | Gap? |
171|-------------|-------------|-------------|-------------|-----|------|
172| vs/ comparisons | 25 pages ★★★★ | 10 pages ★★★ | 0 | 0 | ✓ A leads |
173| integrations/ | 40 pages ★★★ | 60 pages ★★★★ | 20 pages ★★ | 0 | ✓ B leads |
174| for-{industry}/ | 0 | 0 | 8 pages ★★ | 0 | ✓ Wide open |
175| alternatives/ | 5 pages ★★★ | 0 | 0 | 0 | ✓ Lightly competed |
176| glossary/ | 100 pages ★★ | 0 | 50 pages ★★★ | 0 | ⚠️ Volume play |
177 
178### 5B: Variation Gaps
179 
180Within each pattern competitors use, find missing variations:
181- Competitors they haven't written vs/ pages for
182- Integrations they support but haven't built pages for
183- Industries they serve but haven't targeted
184- These are your quick-win entries
185 
186### 5C: Pattern White Space
187 
188Entire pattern types no competitor has built:
189- Highest opportunity — no one to outrank, first-mover advantage
190- Validate search demand exists (Phase 1D of programmatic-seo-planner)
191 
192### 5D: Quality Gaps
193 
194Patterns where competitors have pages but they're low quality:
195- Thin content (< 500 words, no unique data)
196- Outdated (old screenshots, wrong pricing)
197- Missing schema markup
198- No visual differentiation between pages
199- These are "out-template" opportunities
200 
201## Phase 6: Output
202 
203```markdown
204# Programmatic SEO Competitive Landscape — [Category] — [DATE]
205 
206## Competitors Analyzed
207- [Competitor A] — [domain metrics, total pages crawled]
208- [Competitor B] — [domain metrics, total pages crawled]
209- [Competitor C] — [domain metrics, total pages crawled]
210 
211## Executive Summary
212- [N] programmatic patterns detected across [M] competitors
213- Strongest competitor pSEO: [Competitor X] with [pattern] ([N] pages, [quality])
214- Biggest opportunity: [pattern type] — [reasoning]
215- Quick wins: [N] variation gaps in existing competitor patterns
216 
217---
218 
219## Pattern-by-Pattern Analysis
220 
221### Pattern: [vs/ Comparisons]
222**Who's doing it:** [Competitor A (25 pages, ★★★★), Competitor B (10 pages, ★★★)]
223**Traffic estimate:** [X monthly visits across pattern] (enhanced) / [directional estimate] (baseline)
224**Template quality:** [summary of strengths/weaknesses]
225**Top-performing pages:** [specific pages that rank well]
226**Variation gaps:** [competitors/variations they're missing]
227**Your opportunity:** [specific recommendation]
228 
229### Pattern: [integrations/]
230...
231 
232---
233 
234## Opportunity Ranking
235 
236| Priority | Pattern | Opportunity Type | Effort | Expected Impact |
237|----------|---------|-----------------|--------|----------------|
238| P0 | [pattern] | White space — no competitors | Medium | High |
239| P0 | [pattern] | Quality gap — beat weak templates | Low | Medium |
240| P1 | [pattern] | Variation gap — fill missing pages | Low | Medium |
241| P2 | [pattern] | Head-to-head — outrank strong competitor | High | High |
242 
243---
244 
245## Recommended Action Plan
246 
2471. **Immediate (Week 1-2):** Build [pattern] — [rationale]
2482. **Short-term (Month 1):** Build [pattern] — [rationale]
2493. **Medium-term (Month 2-3):** Build [pattern] — [rationale]
250 
251---
252 
253## Raw Data
254[Link to crawl data, pattern clusters, sample pages analyzed]
255```
256 
257Save to the current working directory or wherever the user prefers.
258 
259## Cost
260 
261| Component | Cost |
262|-----------|------|
263| Site catalog per competitor (Apify) | ~$0.05-0.10 |
264| SEO domain analyzer per competitor | ~$0.10-0.20 |
265| Page fetches (3-5 per pattern × N patterns) | ~$0.01-0.05 |
266| DataForSEO domain analytics (enhanced) | ~$0.10-0.50 per competitor |
267| Analysis | Free (LLM reasoning) |
268| **Total (baseline, 3 competitors)** | **~$0.50-1.00** |
269| **Total (enhanced, 3 competitors)** | **~$0.80-2.00** |
270 
271## Tools Required
272 
273- **Apify API token**`APIFY_API_TOKEN` env var
274- **Upstream skills:** `site-content-catalog`, `seo-domain-analyzer`, `fetch_webpage`
275- **Optional (enhanced):** DataForSEO (`DATAFORSEO_LOGIN` + `DATAFORSEO_PASSWORD`), SEMrush (`SEMRUSH_API_KEY`), Ahrefs (`AHREFS_API_TOKEN`), or SimilarWeb (`SIMILARWEB_API_KEY`)
276 
277## Trigger Phrases
278 
279- "What pSEO are competitors doing?"
280- "Reverse-engineer competitor programmatic pages"
281- "Analyze competitor URL structure"
282- "Find pSEO gaps in our space"
283- "What comparison pages do competitors have?"
284 

Discussion

Alternatives

Also in SEO & keywords