Hannah Meier·
Pasted 300 Search Console queries and it clustered them into 12 topics with one page-two quick win I published Friday
Clusters raw Search Console queries into topics by intent, maps them to existing pages, and surfaces position 8–20 quick wins worth immediate content work.
Search Console Query Clustering + Quick Wins
You are an SEO analyst. Cluster the Search Console query export below into actionable topics and find the quick wins.
Query data (query, clicks, impressions, CTR, position):
{{gsc_queries}}
Site: {{domain}} — {{site_description}}
Existing key pages: {{key_pages}}
Steps:
1. **Cluster by search intent, not string similarity.** "backup software pricing" and "how much does backup cost" belong together; "backup software" (informational) and "buy backup software" (transactional) do not. Target 8–15 clusters. Name each cluster with the head query.
2. **Per cluster compute:** total impressions, total clicks, impression-weighted average position, dominant intent (informational / commercial / transactional / navigational).
3. **Map to pages.** For each cluster, name the existing page that should own it, or mark GAP if nothing fits. One page per cluster — if two clusters map to the same page, flag potential cannibalization.
4. **Quick wins:** clusters with weighted position 8–20 AND meaningful impressions. For each, state the single most likely fix: title rewrite, add a missing section, internal links from stronger pages, or new page.
5. **Ignore list:** clusters not worth pursuing (branded competitors, irrelevant, zero commercial value) with a one-line reason.
Output: cluster table, quick-win shortlist (max 5, ordered by impressions × ease), and the cannibalization flags. Be decisive — one recommended fix per quick win, not a menu.
Ergebnisse
## Clusters — 287 queries → 12 topics
| Cluster (head query) | Queries | Impr. | Clicks | Wtd. pos | Intent | Owning page |
|---|---|---|---|---|---|---|
| invoice template switzerland | 41 | 18,400 | 610 | 4.2 | trans. | /vorlagen/rechnung |
| qr bill generator | 28 | 12,100 | 380 | 5.1 | trans. | /qr-rechnung |
| mwst calculation | 35 | 9,800 | 95 | 11.3 | info. | /blog/mwst-guide |
| invoice requirements law | 22 | 7,200 | 60 | 13.8 | info. | GAP |
| dunning letter template | 19 | 6,900 | 210 | 6.0 | trans. | /vorlagen/mahnung |
| freelancer accounting basics | 31 | 5,400 | 40 | 17.2 | info. | /blog/buchhaltung-101 |
| e-invoicing 2026 rules | 16 | 4,800 | 25 | 14.6 | info. | GAP |
| accounting software comparison | 24 | 4,100 | 18 | 19.4 | comm. | /vergleich |
| invoice in english from switzerland | 12 | 2,300 | 85 | 7.9 | trans. | /vorlagen/rechnung |
| payroll small business | 18 | 2,100 | 8 | 24.0 | info. | GAP |
| receipt scanning app | 11 | 1,600 | 12 | 15.1 | comm. | /features/scan |
| competitor brand queries | 30 | 3,900 | 22 | 12.7 | nav. | — |
## Quick wins (impressions × ease)
1. **mwst calculation (pos 11.3, 9,800 impr.)** — Fix: add a worked calculation example with the current rates as a table near the top of /blog/mwst-guide. The page ranks on relevance but lacks the exact answer searchers want. Highest impressions on page two; do this one first.
2. **invoice requirements law (pos 13.8, GAP)** — Fix: new page. Every query is "must an invoice contain X" — a checklist page with legal citations wins this cluster whole.
3. **e-invoicing 2026 rules (pos 14.6, GAP)** — Fix: new page, time-sensitive. Ranking without a dedicated page means weak competition.
4. **freelancer accounting basics (pos 17.2)** — Fix: internal links from the two template pages (pos 4–6) to /blog/buchhaltung-101 with descriptive anchors.
5. **receipt scanning app (pos 15.1)** — Fix: title rewrite on /features/scan; current title doesn't contain "app" and every query does.
## Cannibalization flag
- **/vorlagen/rechnung owns two clusters** (main invoice + English invoice). Fine for now — but if you build a dedicated English-invoice page later, 301 thinking required, since the main page already ranks 7.9 for those queries.
## Ignore list
- Competitor brand queries (30) — you rank on comparison blog mentions; low intent to switch, no action.
- payroll small business — pos 24 with 8 clicks; you don't offer payroll. Writing this would attract traffic that bounces.
Modell: Gemini 2.5 Pro
38 Likes24 SavesScore: 27
2 Kommentare
David Park·
Impression-weighted position instead of plain average — small detail, completely changes which wins float up.
Lara Vogt·
The ignore list with reasons is so useful for stakeholders who ask why we're not chasing every keyword.