03 Keyword Clustering — Data skill for Claude Code
Merge GSC + Ahrefs data, filter by KD and intent, build clusters with pillar + supporting topics.
How to install 03 Keyword Clustering
Installs to ~/.claude/skills/pipzzter-seo-ai-visibility-strategy-03-keyword-clustering/SKILL.md
mkdir -p ~/.claude/skills/pipzzter-seo-ai-visibility-strategy-03-keyword-clustering && curl -fsSL https://raw.githubusercontent.com/Pipzzter/seo-ai-visibility-strategy/HEAD/skills/03-keyword-clustering.md -o ~/.claude/skills/pipzzter-seo-ai-visibility-strategy-03-keyword-clustering/SKILL.md Restart Claude Code, or start a new session, for it to be picked up.
What 03 Keyword Clustering does
name: keyword-clustering description: Merge GSC + Ahrefs data, filter by KD and intent, build clusters with pillar + supporting topics.
Keyword Clustering
Purpose
Produce the keyword clusters that drive the entire content plan. Hard rules below prevent hallucinated search volumes and inconsistent KD thresholds.
Rules
- Search volume source = Ahrefs-sourced columns only. The Ahrefs exports — or, when the merged keyword template (input type 11) substitutes for them, its `
Alternatives in Data
- Bitbucket Data Center 71.9k ★
- Financial Services — Reference agents, skills, and data connectors for the financial-services workflows we see most — investment ba 34.5k ★
- Data Contract — This document defines which files belong to the system (auto-updatable) and which belong to the user (never to 32.5k ★
Full documentation available on GitHub
View Source RepositoryRelated Skills
06 Competitor Gap Analysis
Analyze Ahrefs Content Gap data to surface keyword opportunities aligned with client services.
Ecommerce SEO Geo Skills
Portable skills for ecommerce SEO, GEO readiness, structured data, product-listing optimization, keyword gaps,
Gsc Candlestick Report
Claude Code skill that turns Google Search Console data into monthly candlestick charts. See keyword ranking d
Claude AI Gsc Opportunity Finder
Claude skill that analyzes Google Search Console data to find high-potential "striking distance" pages (high i
Mem Dream
Run the full 3-phase dreaming consolidation pipeline (Light → REM → Deep) on one or all workspaces. Deduplicat
Bq Design Table
Design a BigQuery table schema with optimal partitioning, clustering, and data types. Describe your data or pa
Related Agents
Topic Cluster
Builds topic clusters from keyword evidence, user intent, business value, and information-completeness gaps.
SEO Strategist
Top 1% SEO strategist agent — analyzes GSC, Bing, and GA4 data to produce data-driven ranking strategies, keyw
Gsc Insight
Use this agent when the user asks to analyze their Google Search Console data. This includes keyword positions