Keyword Strategy Planner

Say this to activate the skill

---
name: keyword-strategy-planner
description: Turns keyword lists (CSV or tool exports) into topic clusters, intent mapping, and a prioritized content plan, e.g. when asked to "analyze this keyword list".
---

Processes raw keyword data into an actionable SEO and content strategy with clusters, search intent, and prioritization.

## When this skill activates
- A keyword CSV or tool export (Ahrefs, Semrush, Search Console) is provided and should become a content plan.
- Topic clusters, pillar pages, or an editorial calendar should be derived from keyword data.
- An existing site needs a keyword gap or cannibalization check.

## Workflow
1. Load the CSV and normalize columns: keyword, search volume, difficulty, CPC, current position. Flag missing columns explicitly, never guess values.
2. Clean the list: remove duplicates, third-party brand terms, and obvious mismatches. Document how many rows were removed.
3. Classify search intent per keyword: informational, commercial, transactional, navigational. Heuristics: "how/what/why" signals informational, "best/vs/review" signals commercial, "buy/price/pricing" signals transactional.
4. Build clusters: same core topic plus same intent (word stem and semantic proximity). Pick one primary keyword per cluster (highest volume with matching intent), the rest become secondary.
5. Assign a format per cluster: guide, comparison page, product or service page, glossary entry, FAQ. Intent determines the format, not volume.
6. Prioritize with a score: business relevance (1 to 3) times volume class (1 to 3) divided by difficulty class (1 to 3). Flag quick wins (positions 5-20).
7. Check for cannibalization: merge clusters with overlapping primary keywords or sharpen their boundaries.
8. Derive the content plan: working title per cluster, format, keywords, priority, publishing order.

## Output format
Three Markdown tables: (1) cluster overview with primary keyword, intent, format, score, (2) quick wins, (3) editorial plan with working titles. Add a methods note covering cleanup and the score formula. Export as CSV on request.

## Quality rules
- Every keyword lands in exactly one cluster, none is planned twice.
- Each cluster has exactly one primary keyword whose intent matches the cluster intent.
- No two planned pages target the same primary keyword.
- Volume and difficulty values come only from the provided data, never estimate metrics.
- Intent must be justifiable from the keyword wording; when unsure, check the SERP instead of guessing.
- Working titles contain the primary keyword in natural phrasing.

Share this skill