topic-clusterslisted
Install: claude install-skill sitetiller/ai-visibility-skills
# Topic clusters from the site's own queries
Goal: a content map built from queries the site already receives, with a decision per topic: write, extend, merge or leave. Google documents no "topic cluster" ranking feature. The structure is a way to organise pages and internal links for readers and crawlers, and the skill presents it that way.
## Inputs
- Search Console query+page rows for 90 days or more (`gsc --dims query,page --out qp.csv`, see `gsc-bing`), or a user export with columns Query, Page, Clicks, Impressions, CTR, Position.
- The site's sitemap (for `links`).
## Steps
1. Export:
```bash
npx sitetiller gsc example.com --start 2026-08-12 --end 2026-11-09 --dims query,page --out qp.csv
```
The API returns at most 50K rows per day per search type and may drop rows when grouping by query and page, so small queries can be missing. Say so in the report.
2. Draft the groups with the helper (offline, reads the CSV as data, no shell, no network):
```bash
node skills/topic-clusters/references/cluster-queries.mjs qp.csv --min-imp 10 --json
```
Each cluster has `label`, `queries`, `impressions`, `clicks`, `avgPosition`, `pages` (which URLs got impressions for the cluster) and `topQueries`. The helper joins queries that share two words (or one word when both are short). It does not understand meaning. Read each cluster and split or merge by hand; record the final names.
3. For each cluster, classify:
| Pattern in the data | Reading | Decision |