Extract Programmatic SEO Rules From Competitor Site Structures

Reverse-engineer competitor programmatic SEO sites to create a structured database schema and URL pattern mapping for your own content production.

Prompt

Prompt
Act as a technical SEO consultant. Your goal is to analyze the URL structure, page layout, and content patterns of a competitor website to extract the underlying database schema and logic required to build a similar programmatic SEO project. Please ask me these 3 questions first: 1. What is the URL of the competitor site or specific sub-folder you want to analyze? 2. What is the primary entity or topic the site covers? 3. Do you have a list of 5-10 sample URLs from that site? Wait for my response. After I provide the data, follow these rules: 1. Identify the URL slug variables based on common patterns. 2. Map the content elements to required database columns. 3. Suggest a logical hierarchy for the internal linking structure. 4. Exclude all marketing fluff and focus strictly on technical implementation requirements. Output format: ## URL Pattern Analysis. Table with columns: URL Pattern, Variable, Example. ## Database Schema Requirements. List of fields with data types and descriptions. ## Internal Linking Logic. Bullet points describing cross-linking strategy. This is not technical architecture advice; consult with a developer for implementation. Wait for my answers.

Example output

Example for: a competitor site ranking for local HVAC service queries like hvac-repair-in-city-name.com. ## URL Pattern Analysis | URL Pattern | Variable | Example |
| --- | --- | --- |
| /service/city | Service, City | /repair/austin |
| /service/neighborhood | Service, Neighborhood | /repair/downtown | ## Database Schema Requirements - service_name: String. The name of the HVAC task (e.g., furnace repair). - city_name: String. The target municipality. - population_count: Integer. Used for scaling content length. - climate_zone: String. Used to trigger dynamic advice based on weather. - average_temp_winter: Decimal. Dynamic variable for content insertion. - local_competitor_count: Integer. Used for internal linking density. ## Internal Linking Logic - Hub and Spoke: Every city page links back to the main service pillar page. - Geographic Clusters: City pages link to neighboring city pages if they share a county attribute. - Popularity Weighting: Pages with higher population_count attributes receive more inbound links from the homepage. - Service Variations: Each city page contains a navigation list of all other services offered in that specific city. This is not technical architecture advice; consult with a developer for implementation.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Forces the model to identify variables rather than just summarizing content.
  • Creates a technical bridge between URL structures and database architecture.
  • Provides a clear, actionable schema that non-technical users can hand to developers.

Use this prompt when you identify a competitor site that ranks well for high-volume, repetitive search queries. Paste the requested URLs into ChatGPT, Claude, or Gemini to receive a structured schema you can hand off to a developer or use in a no-code tool like Webflow or WordPress.

Common edits

  • Add a rule to suggest specific schema markup types like LocalBusiness or Product.
  • Request that the model also suggests a CSV header structure for bulk content generation.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in SEO
SEO

Build a site migration SEO QA checklist

Create a comprehensive quality assurance checklist to protect organic rankings during site migrations. Use this before staging sites push to production.