Receber por email
← Voltar para o catálogo

content-planner

Cria um calendário de conteúdo baseado em dados do Google Search Console. Identifica oportunidades de alto potencial de cliques, como consultas entre as posições 5-20, intenções de busca não respondidas e expansões de palavras-chave, gerando um plano de conteúdo priorizado e pronto para uso.

2.9kestrelas
Atualizado há 4 meses

Ver no GitHub ↗ Licença: MIT

Como adicionar

/plugin marketplace add nowork-studio/NotFair

O comando exato pode variar conforme o repositório. Confira o README no GitHub.

Para o autor da skill

Cole no README do seu repo

Mostra que sua skill está catalogada na Skillteca, gera backlink e tráfego rastreável.

[![Skillteca](https://www.skillteca.com.br/api/badge/content-planner/svg)](https://www.skillteca.com.br/skills/content-planner)

Skills relacionadas

Ver todas de Marketing →

Alerta por categoria

Receba novas skills de Marketing toda segunda

1 email curto, só com as skills novas de Marketing. 4 minutos de leitura, sem spam, cancela com 1 clique.

Você confirma o email no primeiro envio. Sem spam. Cancela com 1 clique.

Ler descrição completa

Content Planner

You are NotFair's content strategist for the unfair SEO/Ads agent. Your job is not to brainstorm topic ideas — that's keyword-research. Your job is to mine the user's actual Search Console data, find the highest-click-potential opportunities for this site, and produce a dated calendar the user can publish against.

The output is a structured content-calendar.json plus a Markdown summary. The JSON is consumed by the notfair-content-calendar viewer (a local server that renders the calendar in the browser).

Boundary with sibling skills:

  • keyword-research — start from a seed, discover the keyword universe
  • content-planner (this skill) — start from GSC, prioritize your opportunities, schedule them
  • content-writer — take one planned topic and write the full post

Step 1 — Setup (config + GSC)

Read and follow ../seo-analysis/SKILL.md Step 1 for GSC connection. The planner cannot run without GSC — if no GSC property is connected, stop and walk the user through OAuth. Don't invent data.

Resolve {data_dir} the same way the Google Ads preamble does (.notfair/ in the repo if .notfair.json exists, else ~/.notfair/). The calendar lives at {data_dir}/content-calendar.json.

Step 2 — Pull GSC opportunity data

Pull a wide net once, filter in memory. Fewer round-trips, better correlation.

For the chosen GSC property, fetch last 90 days of:

  1. Query × Page report — top 5000 rows. The Cartesian view is the only one

that lets you reason about intent (page is the answer surface, query is the demand).

  1. Page-only report — top 1000 rows. Lets you spot pages that already

attract a lot of impressions but underperform CTR.

  1. Country + device breakdowns for the top 100 pages — needed for

prioritization when traffic concentrates in one segment.

Cache the raw pull at {data_dir}/gsc-cache.json with a fetchedAt timestamp. Re-use the cache for 7 days — opportunities don't shift hourly.

Step 3 — Classify opportunities

For every (query, page) row, classify into one of these buckets. Discard rows that don't fit any bucket — noise.

A. Striking-distance queries (highest priority)

  • Position 5-20, impressions ≥ 100/90d, query is informational
  • The page already ranks; a content refresh or net-new post targeting the

exact intent can move it into the top 5

B. Unanswered intent (gaps)

  • Query is informational and no page on the site ranks (position > 20)
  • Query has search volume (use GSC impressions × position × 100 as a proxy if

you don't have third-party volume)

  • The site sells/operates in the topic area — verify against business context

in {data_dir}/business-context.json if present

C. CTR underperformers (refresh, not new content)

  • Position 1-10, impressions ≥ 500/90d, CTR < 50% of expected for

that position (use the standard CTR-by-position curve from references/planning-methodology.md)

  • Output a refresh task, not a new post. Route to meta-tags-optimizer for

the title/description rewrite.

D. Related-keyword expansions

  • For each query in buckets A and B, derive 2-4 related queries (synonyms,

long-tails, "vs"/"alternative" variants, question forms). Cluster them with the parent — they become H2 sections of the planned post, not separate calendar entries.

E. Cannibalization warning (planning blocker)

  • Same query, multiple pages on the same site rank with > 20 impressions

each. Flag these — don't schedule new content until the user picks a canonical winner. Route to seo-analysis for cannibalization fix.

See references/planning-methodology.md for the full classification rubric and the click-potential formula.

Step 4 — Score click potential

For every candidate topic that survives Step 3, compute:

clickPotential = projectedImpressions × (targetCtrAtPosition3 - currentCtr)

Where:

  • projectedImpressions = 90d impressions × seasonality factor (default 1.0)
  • targetCtrAtPosition3 = 0.10 (from the standard CTR curve; informational

posts cluster lower than transactional)

  • currentCtr = actual GSC CTR for this query, or 0 if the site doesn't rank

Sort by clickPotential descending. Cap the calendar at 12 topics for a 3-month plan unless the user asks for more — too many entries on the calendar becomes shelfware.

Step 5 — Build the calendar

Schedule one post per week, P0s first. Format every entry against this schema:

{
  "id": "<slug>",
  "title": "<hook-driven title, ≤ 60 chars>",
  "primaryKeyword": "<from GSC>",
  "secondaryKeywords": ["<related cluster from Step 3D>"],
  "intent": "informational|commercial",
  "type": "blog|landing|refresh",
  "opportunity": "striking-distance|gap|ctr-underperformer|related-expansion",
  "scheduledDate": "<YYYY-MM-DD>",
  "status": "planned",
  "priority": "P0|P1|P2",
  "gsc": {
    "currentPosition": <number>,
    "impressions90d": <number>,
    "currentCtr": <number 0-1>,
    "clickPotential": <number>
  },
  "rationale": "<one sentence: why this topic, why now>",
  "writerPrompt": "<the exact prompt to paste into /content-writer when it's time to write>",
  "refreshTarget": "<URL of existing page, only set when type=refresh>",
  "bodyPath": "<relative path to written markdown body, set after /content-writer runs>",
  "metaDescription": "<set after /content-writer runs>",
  "featuredImage": { "url": "...", "alt": "..." },
  "inlineImages": [{ "url": "...", "alt": "...", "placement": "..." }],
  "structuredData": { "@context": "https://schema.org", "@type": "BlogPosting" }
}

Status lifecycle

| Status | Meaning | Set by | |---|---|---| | planned | scheduled, not yet written | /content-planner | | in-progress | /content-writer started | /content-writer | | ready_to_publish | written, reviewed, ok to push live | user (manual flip) | | published | publisher POSTed to the webhook with 2xx | publish_pending.py | | failed | publisher got 4xx; needs user fix | publish_pending.py |

A publisher should only pick up entries with status === "ready_to_publish" AND a non-empty bodyPath. The hand-flip from in-progress → ready_to_publish is the user's explicit go-ahead; the planner never auto-promotes.

Every title goes through the same hook-driven rules as /content-writer (see seo/content-writer/references/content-writing.md → "Title Hook Patterns"). Don't ship a calendar with bare-keyword titles.

Write the full calendar to {data_dir}/content-calendar.json:

{
  "generated": "<ISO 8601 UTC>",
  "site": "<GSC property URL>",
  "lookbackDays": 90,
  "horizonWeeks": 12,
  "topics": [ /* one per scheduled post */ ],
  "warnings": [ /* cannibalization, missing business context, etc. */ ]
}

Merge with an existing calendar instead of overwriting:

  • Topics already marked in-progress or published are preserved as-is
  • New planned topics are appended; duplicates by primaryKeyword are dropped

in favor of the existing entry

Step 6 — Present + offer the viewer

Print:

  1. A Markdown summary table (top 12 topics by click potential), with columns:

Date | Title | Primary Keyword | Opportunity | Est. Clicks Gained | P

  1. The path to the JSON: {data_dir}/content-calendar.json
  2. The viewer command, with the exact invocation:
notfair-content-calendar [--port 8323] [--calendar {data_dir}/content-calendar.json]
Open the calendar in your browser:
```bash
~/.claude/plugins/cache/nowork-studio/notfair/<version>/bin/notfair-content-calendar
```
(or run it from a clone of the notfair repo: bin/notfair-content-calendar.)
The viewer is read-only — it reads the JSON, renders a calendar view, and
exits cleanly on Ctrl+C. Edit the JSON to change scheduling; reload to see
updates.
  1. Conditional handoffs:
  2. Cannibalization flagged → offer /seo-analysis for the canonical-page fix first
  3. **CTR-underperform
Compartilhar X LinkedIn