# Seo Keyword Niche > Mina longtail keywords y question keywords a escala para descubrir oportunidades de contenido nicho, con un plan de content tier (plantilla, patrón de URL, páginas de muestra y quality gates) listo para publicación programática o editorial. Fuente: https://skillsagentes.com/skills/seranking/seo-skills/seo-keyword-niche Markdown: https://skillsagentes.com/skills/seranking/seo-skills/seo-keyword-niche.md Repositorio: https://github.com/seranking/seo-skills Autor: seranking Licencia: MIT Actualizado: hace 4 meses Coste de contexto: 148 tok instalada, 3.1k tok al activarse, 3.1k tok con todos los archivos del bundle Bundle: 1 archivo, 12 KB Permisos que pide: ninguno declarado ## Instalación Un skill son archivos markdown: los mismos archivos valen para cualquier agente y lo único que cambia es el directorio de destino, es decir la bandera `--agent`. Añade `-g` para instalarlo en todos los proyectos de la máquina. ```bash # Claude Code npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent claude-code # Cursor npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent cursor # Codex npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent codex # Gemini CLI npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent gemini # Windsurf npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent windsurf # Cline npx -y skills add seranking/seo-skills --skill seo-keyword-niche --agent cline ``` ## Qué hace - Mina longtail keywords, question keywords, related y similar keywords para un tema o conjunto de seeds - Filtra por volumen mínimo y KD máximo, elimina branded keywords no propias y agrupa por intención en clusters - Muestrea SERPs de keywords representativas para identificar el tipo de página dominante por cluster - Propone un content tier: plantilla de campos, patrón de URL, páginas de muestra y quality gates anti-thin-content - Genera KEYWORD-NICHE-PLAN.md junto con keywords.csv, template-spec y quality-gates para publicación ## Cuándo usarla - El usuario pide 'longtail keywords', 'question keywords' o 'niche content' - Se busca 'content opportunities at scale' o 'programmatic SEO' - Se pregunta 'qué debería escribir sobre {topic}' - Se necesita content mining para una cadencia editorial constante ## Cuándo no - Se busca planear arquitectura pillar+spoke desde seeds amplios (usar seo-keyword-cluster en su lugar) ## Qué la activa - "Necesito ideas de contenido nicho para 'running shoes' a gran escala" - "Mina longtail y question keywords para 'tax preparation'" - "Quiero un plan de contenido programático para reseñas de máquinas de espresso" - "Qué debería escribir sobre cafeteras de espresso" ## Antes de instalar - Requiere el servidor MCP de SE Ranking conectado y que el usuario aporte un seed topic o 2–5 seed keywords, con país objetivo opcional. ## Archivos - SKILL.md — 12 KB ## SKILL.md Reproducido tal cual desde seranking/seo-skills bajo MIT. Esta sección es el documento original y está en inglés. > Example output: [examples/seo-keyword-niche-espresso-machine-reviews-20260514/KEYWORD-NICHE-PLAN.md](../../examples/seo-keyword-niche-espresso-machine-reviews-20260514/KEYWORD-NICHE-PLAN.md) # Keyword Niche Mine the long tail for content opportunities. Pulls longtail variants, question-intent keywords, related keywords, and SERP samples to find under-served niche keywords; clusters them by intent; proposes a content tier (template + URL pattern + sample pages + thin-content quality gates) that can be published programmatically or as a steady editorial cadence. ## Prerequisites - SE Ranking MCP server connected. - User provides: a seed topic (e.g. "running shoes", "tax preparation"), or 2–5 seed keywords. Target country (default `us`). Optional: minimum volume threshold (default: 50/mo for niche skill — lower than `seo-keyword-cluster`'s 100), maximum KD (default: 40 for accessibility). ## Process 1. **Validate & preflight** - Confirm seeds make sense (not too broad, not branded, not single-letter). - `DATA_getCreditBalance` — surface remaining credits. This skill is heavier than most: pulling longtail at depth costs more than pulling head terms. 2. **Longtail expansion** `DATA_getLongTailKeywords` - For each seed: pull longtail variants (typically 3+ words, lower individual volume, lower KD). - Target: 200–500 longtail candidates per seed. 3. **Question expansion** `DATA_getKeywordQuestions` - For each seed: pull question-phrased keywords. - These are gold for content mining — explicit user intent in the keyword. 4. **Related expansion** `DATA_getRelatedKeywords` and `DATA_getSimilarKeywords` - For each seed: pull related + similar keywords. - Catches semantic neighbours that longtail expansion missed. 5. **Filter and clean** - Remove keywords below `min_volume` and above `max_kd`. - Strip branded keywords the seed-domain doesn't own (unless the user supplied a branded seed). - Tag each keyword with detected intent: informational, commercial, transactional, navigational. - De-duplicate across seeds. 6. **SERP sample for representative keywords** `DATA_getSerpResults` - For 5–10 representative keywords (one per emerging cluster), pull top 10. - Identify the dominant page type for each cluster (informs the template proposal in step 8). 7. **Cluster by intent + theme** - Group keywords by semantic similarity + intent. - Each cluster: name, primary keyword, supporting keywords, total volume, weighted KD, dominant page type. - Target 8–20 clusters (more granular than `seo-keyword-cluster`'s 5–12 — this skill is for niche tiers). 8. **Propose a content tier** - Template structure: which fields make each page unique. For `{city} apartment rentals`, the template fields are `{city}`, `{neighborhood}`, `{price_range}`, `{property_count}`. For `{tool} alternatives` it's `{tool}`, `{competitor_count}`, `{primary_use_case}`. - URL pattern: `/{category}/{slug}/` or `/{topic}/{tool}-alternatives/` etc. - Sample pages: 3 fully-spec'd page wireframes for representative cluster keywords. - Internal-linking automation: how to link pages within the tier (hub-spoke from a category page, or peer-to-peer for genuinely flat structures). 9. **Quality gates** (anti-thin-content guardrails) - **Minimum unique data per page:** template fields must produce ≥ 5 unique attributes (counts, prices, names, dates, etc.). Pages without 5+ unique attributes are duplicates in disguise — skip those keyword variants. - **Minimum word count:** 600 words effective content (excludes navigation, footer, boilerplate). - **Schema requirement:** every templated page gets `Article` (or relevant type) + `BreadcrumbList`. - **Index/noindex split:** if the variant doesn't pass the unique-data threshold, generate the page but `noindex` it. ### 9a. Programmatic publishing — extra gates Most users discover this skill because they want to ship pages at scale (programmatic SEO, data-driven directories, location pages). Programmatic publishing is the highest-risk path for spam-classifier blowback. Apply these *in addition* to the gates above whenever the proposed tier expects to ship 50+ templated pages. - **Per-row uniqueness threshold (≥ 30% varying fields).** Of the template's content-producing fields (excluding nav/footer boilerplate), **at least 30% must hold values that differ from the median sibling page**. A 12-field template where 9 fields are identical across pages is templated mush — Google's spam systems are well-tuned for this since the 2024 core update. Compute: `varying_fields / content_fields ≥ 0.30` per row vs the cluster median. - **Min unique-fact count vs parent + sibling (≥ 5 facts).** Each row carries at least 5 facts that *do not appear on the parent hub page or any sibling page in the same cluster*. Facts = numbers, dates, named entities, original quotes, photos. Synonym shuffles don't count. Sample 10 rows manually before greenlighting the tier. - **Data-source independence.** Don't auto-publish from a single source (one CSV, one API, one scrape). If the page's only differentiator is a row from `cities.csv`, the page is a CSV row dressed as content — likely thin. Combine ≥ 2 independent data sources per page. - **Index-bloat circuit-breaker.** After the first 50 pages ship, monitor GSC. If the index-coverage rate drops below 60% (Google indexed <60% of submitted), pause the tier and re-audit. Continuing past this signal compounds bloat across the rest of the tier. - **Crawl-budget honesty.** Sites under 50k pages can usually crawl whatever you ship. Sites >50k must factor in crawl-budget cost: every thin programmatic page steals attention from the cornerstone content. If the site is in this band and the unique-fact count is borderline, default to noindex. These gates are not negotiable for the programmatic path. If the proposed tier can't pass them, the right answer is fewer pages, not lower thresholds. 10. **Synthesise** `KEYWORD-NICHE-PLAN.md` ## Output format Create a folder `seo-keyword-niche-{target-slug}-{YYYYMMDD}/` with: ``` seo-keyword-niche-{target-slug}-{YYYYMMDD}/ ├── KEYWORD-NICHE-PLAN.md (synthesised plan — primary deliverable) ├── keywords.csv (all enriched keywords with cluster + intent — load-bearing CSV the publishing team paste into CMS/sheets) ├── 06-template-spec.md (fields, URL pattern, sample pages — load-bearing reference writers consult directly) ├── 07-quality-gates.md (thin-content guardrails — load-bearing reference release-gate readers consult directly) └── evidence/ ├── 01-seed-expansion.md (raw expansion per seed — raw step output) ├── 02-question-keywords.md (DATA_getKeywordQuestions) ├── 03-filtered-keywords.md (post min-vol / max-kd filter) ├── 04-cluster-assignment.md (every keyword and its cluster) └── 05-serp-samples.md (top 10 for representative cluster keywords) ``` Top-level: `KEYWORD-NICHE-PLAN.md` + `keywords.csv` + `06-template-spec.md` + `07-quality-gates.md`. Writers consult the template spec directly when authoring; release gates consult the quality gates directly. The 01–05 step files preserve raw API/clustering outputs in `evidence/`. `KEYWORD-NICHE-PLAN.md` shape: ```markdown # Keyword Niche Plan: {topic} > Generated {YYYY-MM-DD} · Country: {country} · Seeds: {list} ## Inventory - Longtail keywords mined: {n} - Question keywords: {n} - After filter (min-vol {n}, max-kd {n}): {n} - Clusters formed: {n} - Estimated combined monthly volume: {n} ## Recommended content tier ### Template **URL pattern:** `/{category}/{slug}/` **Required fields per page:** - `{slug}` — URL-friendly identifier - `{H1}` — page primary heading - `{TL;DR}` — first 200 words direct answer - `{primary_keyword}` — target keyword - `{related_keywords}` — secondary keywords from cluster - `{unique_attributes}` — list of ≥ 5 differentiating attributes (numbers, names, dates) - `{related_pages}` — internal-link list (3–5 sibling pages) - `{schema_type}` — Article/Product/Other - `{datestamp}` — last-updated date **Sample pages:** see `06-template-spec.md` for 3 fully-spec'd wireframes. ## Cluster build order (top 10 by priority) | Rank | Cluster | Volume (combined) | Weighted KD | Dominant page type | Pages to ship | |---|---|---|---|---|---| | 1 | {cluster name} | {n} | {kd} | {type} | {n} | | ... | ## Quality gates (do not ship pages that fail) 1. **Unique-data threshold:** each page has ≥ 5 unique attributes vs sibling pages in the same cluster. 2. **Minimum word count:** 600 words effective content. 3. **Schema:** `Article` + `BreadcrumbList` (or relevant `@type` for the page). 4. **Internal links:** ≥ 3 outbound to siblings, ≥ 1 inbound from category hub. 5. **Index/noindex:** noindex pages that don't pass the unique-data threshold. ### Programmatic-only gates (apply when tier ships 50+ pages) 6. **Per-row uniqueness ≥ 30%:** at least 30% of content-producing fields hold values that differ from the cluster median. 7. **Min unique facts vs parent + sibling (≥ 5):** five facts per row that don't appear on the parent hub or any sibling. 8. **Data-source independence:** ≥ 2 independent data sources per page (no single-CSV pages). 9. **Index-bloat circuit-breaker:** pause tier if GSC index-coverage <60% after the first 50 pages. ## Scaling estimate - Clusters: {n} - Pages per cluster (median): {n} - Total pages: {n} - At {pages/week} cadence: {n weeks} to ship the tier. - Crawl-budget impact (for sites > 10k pages): noindex strategy keeps thin variants out of the index. ## Risks / monitoring - **Thin-content penalty:** the quality gates above are the guardrail. Audit at scale via `seo-technical-audit` after first 100 pages ship. - **Index bloat:** monitor in GSC; if newly indexed pages don't accrue impressions in 60 days, candidate for noindex/consolidate. - **Cannibalization:** monitor with `seo-subdomain` + `seo-page` after first 50 pages. ## Recommended next step Build a small pilot — 10 pages from the top cluster — before committing to the full tier. Apply quality gates rigorously to the pilot. Re-audit after 60 days; iterate the template based on which pilot pages indexed and ranked. ``` `keywords.csv` columns: `keyword,volume,kd,cpc,intent,cluster,role_in_cluster,dominant_page_type,unique_attributes_estimate` ## Tips - Respect rate limit: 10 req/sec. Steps 2–4 fan out across all seeds; pace sequentially. - Cost: ~30–80 credits for 5 seeds, ~150+ for 10–20 seeds. Call `DATA_getCreditBalance` before running and surface the estimate. - **Programmatic SEO is risky.** Pages that don't pass the unique-data threshold are dead weight at best, penalty bait at worst. The quality gates in step 9 are not optional. - The pilot recommendation is critical. 10 pages with thoughtful templates outperform 1000 pages of templated mush. - For e-commerce / inventory-driven content (city pages, product variations), the unique-data threshold is usually easy to hit. - For "best X for Y" content (where Y has many variants), pick variants that have genuinely distinct content — don't templatise across near-synonyms. - Pair with `seo-keyword-cluster` for the broader pillar+spoke architecture (this skill complements, not replaces). - Pair with `seo-content-brief` to expand individual pillar topics into full editor briefs. - Pair with `seo-technical-audit` after first 100 pages ship to catch any thin-content / canonicalization issues. - Don't auto-publish. The template, URL pattern, and quality gates ship from this skill; the content authoring + review remains a human responsibility. ## Dónde encaja - Categoría: [SEO y GEO](https://skillsagentes.com/categorias/seo-geo.md) — Keywords, auditorías on-page, datos estructurados y visibilidad en respuestas de IA. - Creador: [seranking](https://skillsagentes.com/creators/seranking.md) — 32 skills en el directorio - [Todas las skills](https://skillsagentes.com/skills.md) - [Ranking de instalaciones](https://skillsagentes.com/ranking.md) ## Otras skills del mismo repositorio - [Client Onboarding Proposal](https://skillsagentes.com/skills/seranking/seo-skills/client-onboarding-proposal.md): Construye una propuesta de onboarding de cliente basada en datos, combinando un audit SEO + búsqueda IA de SE Ranking con un análisis en Planable del rendimiento social actual del cliente. - [Local Gmb Visibility](https://skillsagentes.com/skills/seranking/seo-skills/local-gmb-visibility.md): Combina el seguimiento de rankings por ciudad de SE Ranking con contenido social local en Planable, incluyendo publicaciones de Google Business Profile. - [Ai Search Gaps To Social Campaign](https://skillsagentes.com/skills/seranking/seo-skills/ai-search-gaps-to-social-campaign.md): Encuentra los prompts y temas de búsqueda con IA donde una marca es invisible o pierde frente a competidores en SE Ranking, y convierte esos vacíos en una campaña social en Planable con seguimiento antes/después. - [Site Audit To Social Distribution](https://skillsagentes.com/skills/seranking/seo-skills/site-audit-to-social-distribution.md): Detecta páginas débiles y brechas de contenido en SE Ranking, y coordina la corrección en Planable: redacta el copy reescrito para revisión y aprobación, y programa la distribución social. - [Seo Ai Social Report](https://skillsagentes.com/skills/seranking/seo-skills/seo-ai-social-report.md): Genera un único reporte de rendimiento que une rankings SEO, visibilidad en búsquedas IA (SE Ranking) y engagement social (Planable): resumen en el chat más un informe HTML interactivo autónomo. --- Skills Agentes · [Índice de páginas en markdown](https://skillsagentes.com/sitemap.md) · [Inicio](https://skillsagentes.com/index.md)