mikefutia/seo-consultant/intent-map

Intent Map

Turn the site's real query data into a content strategy: hubs (head terms deserving a pillar page) and spokes (long-tail variants that support them).

Process

1. Pull the top 500 GSC queries from the last 90 days. If data/ahrefs/organic-keywords.csv exists or an Ahrefs MCP is connected, merge that in and say so.
2. Separate branded queries first — they get one summary line, not clusters.
3. Cluster the rest into hub-and-spoke topics. Label every cluster: commercial / informational / navigational.
4. Map each cluster to the page that currently ranks for it (from the GSC page dimension). Status per cluster:

• healthy — one page owns it
• gap — no page targets it (content opportunity)
• cannibalized — multiple pages compete (consolidation opportunity)

1. Output: one table per hub (spokes, intent, mapped page, status), then a ranked list of the top 3 gaps worth filling — justified by impression volume, not vibes.
2. Save to runs/intent-map-[date].md.

Rules

• The clustering is instant; the judgment is the user's. Present gaps as candidates with the data, not as orders.
• A "gap" with under ~50 total impressions across its spokes is not a gap worth a page — say so rather than inflating the opportunity list.
• Feed the top gap directly into /seo-os:content-from-data when the user wants to act.