Programmatic SEO Analysis & Planning
Build and audit SEO pages generated at scale from structured data sources.
Enforces quality gates to prevent thin content penalties and index bloat.
When to Use
- Use when the user wants programmatic SEO planning or review.
- Use when designing templates, data-driven pages, or scalable URL systems.
- Use when preventing thin content and index bloat across large page sets.
Data Source Assessment
Evaluate the data powering programmatic pages:
- CSV/JSON files: Row count, column uniqueness, missing values
- API endpoints: Response structure, data freshness, rate limits
- Database queries: Record count, field completeness, update frequency
- Data quality checks:
- Each record must have enough unique attributes to generate distinct content
- Flag duplicate or near-duplicate records (>80% field overlap)
- Verify data freshness; stale data produces stale pages
Template Engine Planning
Design templates that produce unique, valuable pages:
- Variable injection points: Title, H1, body sections, meta description, schema
- Content blocks: Static (shared across pages) vs dynamic (unique per page)
- Conditional logic: Show/hide sections based on data availability
- Supplementary content: Related items, contextual tips, user-generated content
- Template review checklist:
- Each page must read as a standalone, valuable resource
- No "mad-libs" patterns (just swapping city/product names in identical text)
- Dynamic sections must add genuine information, not just keyword variations
URL Pattern Strategy
Common Patterns
/tools/[tool-name]: Tool/product directory pages
/[city]/[service]: Location + service pages
/integrations/[platform]: Integration landing pages
/glossary/[term]: Definition/reference pages
/templates/[template-name]: Downloadable template pages
URL Rules
- Lowercase, hyphenated slugs derived from data
- Logical hierarchy reflecting site architecture
- No duplicate slugs; enforce uniqueness at generation time
- Keep URLs under 100 characters
- No query parameters for primary content URLs
- Consistent trailing slash usage (match existing site pattern)
Internal Linking Automation
- Hub/spoke model: Category hub pages linking to individual programmatic pages
- Related items: Auto-link to 3-5 related pages based on data attributes
- Breadcrumbs: Generate BreadcrumbList schema from URL hierarchy
- Cross-linking: Link between programmatic pages sharing attributes (same category, same city, same feature)
- Anchor text: Use descriptive, varied anchor text. Avoid exact-match keyword repetition
- Link density: 3-5 internal links per 1000 words (match seo-content guidelines)
Thin Content Safeguards
Quality Gates
| Metric |
Threshold |
Action |
| Pages without content review |
100+ |
⚠️ WARNING: require content audit before publishing |
| Pages without justification |
500+ |
🛑 HARD STOP: require explicit user approval and thin content audit |
| Unique content per page |
<40% |
❌ Flag as thin content (likely penalty risk) |
| Word count per page |
<300 |
⚠️ Flag for review (may lack sufficient value) |
Scaled Content Abuse: Enforcement Context (2025-2026)
Google's Scaled Content Abuse policy (introduced March 2024) saw major enforcement escalation in 2025:
- June 2025: Wave of manual actions targeting websites with AI-generated content at scale
- August 2025: SpamBrain spam update enhanced pattern detection for AI-generated link schemes and content farms
- Result: Google reported 45% reduction in low-quality, unoriginal content in search results post-March 2024 enforcement
Enhanced quality gates for programmatic pages:
- Content differentiation: ≥30-40% of content must be genuinely unique between any two programmatic pages (not just city/keyword string replacement)
- Human review: Minimum 5-10% sample review of generated pages before publishing
- Progressive rollout: Publish in batches of 50-100 pages. Monitor indexing and rankings for 2-4 weeks before expanding. Never publish 500+ programmatic pages simultaneously without explicit quality review.
- Standalone value test: Each page should pass: "Would this page be worth publishing even if no other similar pages existed?"
- Site reputation abuse: If publishing programmatic content under a high-authority domain (not your own), this may trigger site reputation abuse penalties. Google began enforcing this aggressively in November 2024.
Recommendation: The WARNING gate at <40% unique content remains appropriate. Consider a HARD STOP at <30% unique content to prevent scaled content abuse risk.
Safe Programmatic Pages (OK at scale)
✅ Integration pages (with real setup docs, API details, screenshots)
✅ Template/tool pages (with downloadable content, usage instructions)
✅ Glossary pages (200+ word definitions with examples, related terms)
✅ Product pages (unique specs, reviews, comparison data)
✅ Data-driven pages (unique statistics, charts, analysis per record)
Penalty Risk (avoid at scale)
❌ Location pages with only city name swapped in identical text
❌ "Best [tool] for [industry]" without industry-specific value
❌ "[Competitor] alternative" without real comparison data
❌ AI-generated pages without human review and unique value-add
❌ Pages where >60% of content is shared template boilerplate
Uniqueness Calculation
Unique content % = (words unique to this page) / (total words on page) × 100
Measure against all other pages in the programmatic set. Shared headers, footers, and navigation are excluded from the calculation. Template boilerplate text IS included.
Canonical Strategy
- Every programmatic page must have a self-referencing canonical tag
- Parameter variations (sort, filter, pagination) canonical to the base URL
- Paginated series: canonical to page 1 or use rel=next/prev
- If programmatic pages overlap with manual pages, the manual page is canonical
- No canonical to a different domain unless intentional cross-domain setup
Sitemap Integration
- Auto-generate sitemap entries for all programmatic pages
- Split at 50,000 URLs per sitemap file (protocol limit)
- Use sitemap index if multiple sitemap files needed
<lastmod> reflects actual data update timestamp (not generation time)
- Exclude noindexed programmatic pages from sitemap
- Register sitemap in robots.txt
- Update sitemap dynamically as new records are added to data source
Index Bloat Prevention
- Noindex low-value pages: Pages that don't meet quality gates
- Pagination: Noindex paginated results beyond page 1 (or use rel=next/prev)
- Faceted navigation: Noindex filtered views, canonical to base category
- Crawl budget: For sites with >10k programmatic pages, monitor crawl stats in Search Console
- Thin page consolidation: Merge records with insufficient data into aggregated pages
- Regular audits: Monthly review of indexed page count vs intended count
Output
Programmatic SEO Score: XX/100
Assessment Summary
| Category |
Status |
Score |
| Data Quality |
✅/⚠️/❌ |
XX/100 |
| Template Uniqueness |
✅/⚠️/❌ |
XX/100 |
| URL Structure |
✅/⚠️/❌ |
XX/100 |
| Internal Linking |
✅/⚠️/❌ |
XX/100 |
| Thin Content Risk |
✅/⚠️/❌ |
XX/100 |
| Index Management |
✅/⚠️/❌ |
XX/100 |
Critical Issues (fix immediately)
High Priority (fix within 1 week)
Medium Priority (fix within 1 month)
Low Priority (backlog)
Recommendations
- Data source improvements
- Template modifications
- URL pattern adjustments
- Quality gate compliance actions
Error Handling
| Scenario |
Action |
| URL unreachable |
Report connection error with status code. Suggest verifying URL accessibility and checking for authentication requirements. |
| No programmatic pages detected |
Inform user that no template-generated or data-driven page patterns were found. Suggest checking if pages use client-side rendering or if the URL points to the correct section. |
| Thin content threshold exceeded |
Trigger quality gate warning. Report the unique content percentage and flag pages below 40% uniqueness. Require user acknowledgment before proceeding. |
| Quality gate violation |
Halt analysis at the HARD STOP threshold (500+ pages without justification or <30% unique content). Present findings and require explicit user approval to continue. |
Limitations
- Use this skill only when the task clearly matches the scope described above.
- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.
Source: sickn33/agentic-awesome-skills → skills/seo-programmatic/SKILL.md
Also appears in: sickn33/agentic-awesome-skills/plugins/agentic-awesome-skills/skills/seo-programmatic/SKILL.md, sickn33/agentic-awesome-skills/plugins/agentic-awesome-skills-claude/skills/seo-programmatic/SKILL.md
1---2name: seo-programmatic3description: "Plan and audit programmatic SEO pages generated at scale from structured data. Use when designing templates, URL systems, internal linking, quality gates, and index-bloat safeguards for pages at scale."4allowed-tools: "Read Grep Glob Bash WebFetch Write"5category: marketing-and-growth6source_repo: sickn33/agentic-awesome-skills7source_path: "skills/seo-programmatic/SKILL.md"8source_url: https://github.com/sickn33/agentic-awesome-skills/blob/HEAD/skills/seo-programmatic/SKILL.md9metadata:10 source: https://skillmd.com/skills/sickn33/seo-programmatic11---121314# Programmatic SEO Analysis & Planning1516Build and audit SEO pages generated at scale from structured data sources.17Enforces quality gates to prevent thin content penalties and index bloat.1819## When to Use20- Use when the user wants programmatic SEO planning or review.21- Use when designing templates, data-driven pages, or scalable URL systems.22- Use when preventing thin content and index bloat across large page sets.2324## Data Source Assessment2526Evaluate the data powering programmatic pages:27- **CSV/JSON files**: Row count, column uniqueness, missing values28- **API endpoints**: Response structure, data freshness, rate limits29- **Database queries**: Record count, field completeness, update frequency30- Data quality checks:31 - Each record must have enough unique attributes to generate distinct content32 - Flag duplicate or near-duplicate records (>80% field overlap)33 - Verify data freshness; stale data produces stale pages3435## Template Engine Planning3637Design templates that produce unique, valuable pages:38- **Variable injection points**: Title, H1, body sections, meta description, schema39- **Content blocks**: Static (shared across pages) vs dynamic (unique per page)40- **Conditional logic**: Show/hide sections based on data availability41- **Supplementary content**: Related items, contextual tips, user-generated content42- Template review checklist:43 - Each page must read as a standalone, valuable resource44 - No "mad-libs" patterns (just swapping city/product names in identical text)45 - Dynamic sections must add genuine information, not just keyword variations4647## URL Pattern Strategy4849### Common Patterns50- `/tools/[tool-name]`: Tool/product directory pages51- `/[city]/[service]`: Location + service pages52- `/integrations/[platform]`: Integration landing pages53- `/glossary/[term]`: Definition/reference pages54- `/templates/[template-name]`: Downloadable template pages5556### URL Rules57- Lowercase, hyphenated slugs derived from data58- Logical hierarchy reflecting site architecture59- No duplicate slugs; enforce uniqueness at generation time60- Keep URLs under 100 characters61- No query parameters for primary content URLs62- Consistent trailing slash usage (match existing site pattern)6364## Internal Linking Automation6566- **Hub/spoke model**: Category hub pages linking to individual programmatic pages67- **Related items**: Auto-link to 3-5 related pages based on data attributes68- **Breadcrumbs**: Generate BreadcrumbList schema from URL hierarchy69- **Cross-linking**: Link between programmatic pages sharing attributes (same category, same city, same feature)70- **Anchor text**: Use descriptive, varied anchor text. Avoid exact-match keyword repetition71- Link density: 3-5 internal links per 1000 words (match seo-content guidelines)7273## Thin Content Safeguards7475### Quality Gates7677| Metric | Threshold | Action |78|--------|-----------|--------|79| Pages without content review | 100+ | ⚠️ WARNING: require content audit before publishing |80| Pages without justification | 500+ | 🛑 HARD STOP: require explicit user approval and thin content audit |81| Unique content per page | <40% | ❌ Flag as thin content (likely penalty risk) |82| Word count per page | <300 | ⚠️ Flag for review (may lack sufficient value) |8384### Scaled Content Abuse: Enforcement Context (2025-2026)8586Google's Scaled Content Abuse policy (introduced March 2024) saw major enforcement escalation in 2025:8788- **June 2025:** Wave of manual actions targeting websites with AI-generated content at scale89- **August 2025:** SpamBrain spam update enhanced pattern detection for AI-generated link schemes and content farms90- **Result:** Google reported 45% reduction in low-quality, unoriginal content in search results post-March 2024 enforcement9192**Enhanced quality gates for programmatic pages:**93- **Content differentiation:** ≥30-40% of content must be genuinely unique between any two programmatic pages (not just city/keyword string replacement)94- **Human review:** Minimum 5-10% sample review of generated pages before publishing95- **Progressive rollout:** Publish in batches of 50-100 pages. Monitor indexing and rankings for 2-4 weeks before expanding. Never publish 500+ programmatic pages simultaneously without explicit quality review.96- **Standalone value test:** Each page should pass: "Would this page be worth publishing even if no other similar pages existed?"97- **Site reputation abuse:** If publishing programmatic content under a high-authority domain (not your own), this may trigger site reputation abuse penalties. Google began enforcing this aggressively in November 2024.9899> **Recommendation:** The WARNING gate at `<40% unique content` remains appropriate. Consider a HARD STOP at `<30%` unique content to prevent scaled content abuse risk.100101### Safe Programmatic Pages (OK at scale)102✅ Integration pages (with real setup docs, API details, screenshots)103✅ Template/tool pages (with downloadable content, usage instructions)104✅ Glossary pages (200+ word definitions with examples, related terms)105✅ Product pages (unique specs, reviews, comparison data)106✅ Data-driven pages (unique statistics, charts, analysis per record)107108### Penalty Risk (avoid at scale)109❌ Location pages with only city name swapped in identical text110❌ "Best [tool] for [industry]" without industry-specific value111❌ "[Competitor] alternative" without real comparison data112❌ AI-generated pages without human review and unique value-add113❌ Pages where >60% of content is shared template boilerplate114115### Uniqueness Calculation116Unique content % = (words unique to this page) / (total words on page) × 100117118Measure against all other pages in the programmatic set. Shared headers, footers, and navigation are excluded from the calculation. Template boilerplate text IS included.119120## Canonical Strategy121122- Every programmatic page must have a self-referencing canonical tag123- Parameter variations (sort, filter, pagination) canonical to the base URL124- Paginated series: canonical to page 1 or use rel=next/prev125- If programmatic pages overlap with manual pages, the manual page is canonical126- No canonical to a different domain unless intentional cross-domain setup127128## Sitemap Integration129130- Auto-generate sitemap entries for all programmatic pages131- Split at 50,000 URLs per sitemap file (protocol limit)132- Use sitemap index if multiple sitemap files needed133- `<lastmod>` reflects actual data update timestamp (not generation time)134- Exclude noindexed programmatic pages from sitemap135- Register sitemap in robots.txt136- Update sitemap dynamically as new records are added to data source137138## Index Bloat Prevention139140- **Noindex low-value pages**: Pages that don't meet quality gates141- **Pagination**: Noindex paginated results beyond page 1 (or use rel=next/prev)142- **Faceted navigation**: Noindex filtered views, canonical to base category143- **Crawl budget**: For sites with >10k programmatic pages, monitor crawl stats in Search Console144- **Thin page consolidation**: Merge records with insufficient data into aggregated pages145- **Regular audits**: Monthly review of indexed page count vs intended count146147## Output148149### Programmatic SEO Score: XX/100150151### Assessment Summary152| Category | Status | Score |153|----------|--------|-------|154| Data Quality | ✅/⚠️/❌ | XX/100 |155| Template Uniqueness | ✅/⚠️/❌ | XX/100 |156| URL Structure | ✅/⚠️/❌ | XX/100 |157| Internal Linking | ✅/⚠️/❌ | XX/100 |158| Thin Content Risk | ✅/⚠️/❌ | XX/100 |159| Index Management | ✅/⚠️/❌ | XX/100 |160161### Critical Issues (fix immediately)162### High Priority (fix within 1 week)163### Medium Priority (fix within 1 month)164### Low Priority (backlog)165166### Recommendations167- Data source improvements168- Template modifications169- URL pattern adjustments170- Quality gate compliance actions171172## Error Handling173174| Scenario | Action |175|----------|--------|176| URL unreachable | Report connection error with status code. Suggest verifying URL accessibility and checking for authentication requirements. |177| No programmatic pages detected | Inform user that no template-generated or data-driven page patterns were found. Suggest checking if pages use client-side rendering or if the URL points to the correct section. |178| Thin content threshold exceeded | Trigger quality gate warning. Report the unique content percentage and flag pages below 40% uniqueness. Require user acknowledgment before proceeding. |179| Quality gate violation | Halt analysis at the HARD STOP threshold (500+ pages without justification or <30% unique content). Present findings and require explicit user approval to continue. |180181## Limitations182- Use this skill only when the task clearly matches the scope described above.183- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.184- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.185186---187188**Source:** [`sickn33/agentic-awesome-skills`](https://github.com/sickn33/agentic-awesome-skills) → `skills/seo-programmatic/SKILL.md`189190**Also appears in:** `sickn33/agentic-awesome-skills/plugins/agentic-awesome-skills/skills/seo-programmatic/SKILL.md`, `sickn33/agentic-awesome-skills/plugins/agentic-awesome-skills-claude/skills/seo-programmatic/SKILL.md`