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.

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)