---
name: seo-audit-keywords
description: Import and analyze keyword ranking data from CSV exports (Mangools, Ahrefs, SEMrush). Identifies keyword clusters, opportunities, and gaps.
disable-model-invocation: true
allowed-tools: Bash, Read, Write, Glob, Grep
argument-hint: "[csv-file-or-directory]"
---

# SEO Audit: Keyword Analysis

Import and analyze keyword data from CSV file(s) at `$ARGUMENTS`.

## Steps:

1. **Read the CSV file(s)** — Common columns: Keyword, Position, Search Volume, Estimated Visits, Indexed URL

2. **Group keywords by cluster** — Identify semantic groups (e.g., all "custom widget" variants, all "buy X online" variants)

3. **Analyze per cluster:**
   - Total search volume
   - Best/worst position
   - Total estimated visits
   - Indexed URL (which page ranks)

4. **Identify opportunities:**
   - Keywords at positions 4-10 (almost page 1 or just on page 1 — push to top 3)
   - Keywords at positions 11-20 (page 2 — push to page 1)
   - Keywords at 101+ with high volume (not ranking at all)
   - Keywords where the wrong page ranks

5. **Cross-reference with GSC data** if available in the reports directory

6. **Output a structured analysis** with:
   - Top keyword clusters by volume
   - Position distribution (how many keywords in top 3, top 10, top 20, 101+)
   - Biggest opportunities ranked by potential traffic gain
   - Pages ranking for the most keywords
   - Content gaps (high-volume keywords with no ranking page)