Competitive SEO Gap Analysis Workflow

Content

{
  "steps": [
    {
      "tool": "semrush_api",
      "order": 1,
      "action": "Collect top 5 competitor domains ranking for target keyword cluster via Ahrefs/SEMrush API",
      "output": "competitor_domain_list"
    },
    {
      "tool": "semrush_api",
      "order": 2,
      "action": "Extract all ranking URLs and their top 20 keywords for each competitor",
      "output": "competitor_keyword_map"
    },
    {
      "tool": "python_script",
      "order": 3,
      "action": "Compute keyword gap: keywords competitors rank for that we do not",
      "output": "gap_keyword_list"
    },
    {
      "tool": "openai_embeddings",
      "order": 4,
      "action": "Cluster gap keywords by semantic theme using embeddings",
      "output": "keyword_clusters"
    },
    {
      "tool": "spreadsheet",
      "order": 5,
      "action": "Score each cluster by volume × difficulty^-1 × business_relevance",
      "output": "prioritized_cluster_list"
    },
    {
      "tool": "llm",
      "order": 6,
      "action": "Generate content brief for top 3 clusters using LLM",
      "output": "content_briefs"
    }
  ],
  "tools_required": [
    "semrush_api",
    "openai_embeddings",
    "python3",
    "llm"
  ],
  "expected_output": "Prioritized list of content gaps with briefs, estimated traffic opportunity per cluster",
  "trigger_condition": "New content strategy sprint begins or competitor ranking shift detected"
}