winston-keyword-mapping: keyword universe and URL map from SEMrush exports.
Takes SEMrush organic research exports for a client site and competitors, then ships a complete keyword universe, intent-classified keyword list, URL map, and SEO strategy deck.
- Type
- Claude Skill
- Purpose
- Productized SEO kickoff deliverable
- Replaces
- 1-2 weeks of strategist time per kickoff engagement
- Status
- Live and shipping client work
What it does.
Drop in the SEMrush organic research exports for the client site and the competitor set. The Skill consolidates the keyword universe, deduplicates and classifies by search intent, maps each keyword to the most relevant existing or recommended URL, and writes a kickoff strategy deck that summarizes the opportunity, the gaps, and the recommended phase one targets.
How we use it.
Standard kickoff deliverable for new SEO engagements. Strategist gathers the SEMrush exports, triggers the Skill, reviews the keyword universe and the mapping, edits the strategic call on phase one, and ships the deck. The keyword workbook becomes the input for everything downstream: content briefs, on-page work, performance reporting.
Why we built it.
Kickoff keyword research is the same workflow every time: pull exports, dedupe, classify intent, map to URLs, build the deck. One to two weeks of strategist time per engagement. The judgment is in the phase-one call. The rest is data plumbing. Build the Skill for the plumbing. Keep the strategist on the call.
The stack inside it.
- Pandas for SEMrush export consolidation, deduplication, and intent classification
- Anthropic API for intent and topic classification on edge cases
- openpyxl to render the keyword universe and URL map workbook
- python-pptx to render the kickoff SEO strategy deck
- A reusable SEMrush export schema parser
- Claude Skills as the activation and prioritization layer
What this proves.
Skills compound. Every job that was a half-day or a multi-day stretch of senior time becomes a Skill the team triggers from chat. The output ships faster. The strategist's calendar opens up for the work that actually needs human judgment: positioning, narrative, the prioritization call on what the data is really saying. That is the Winston operating model in one Skill.