GSC → Content Brief
Turn underperforming GSC queries into ready-to-write briefs.
GSC underperformers CSV
Header: query,impressions,clicks,position
6 brief candidate(s)
High impressions + position 5-20 = quick wins from new content.
View brief
# Brief: how to choose hiking boots **Search intent**: how-to ## Outline - Intro (problem framing) - Quick answer / TL;DR - Step-by-step process - Common mistakes - FAQ ## Targets - Primary keyword: how to choose hiking boots - Word count: 1500-2500 - Include: stats, named sources, examples
View brief
# Brief: hiking boots vs trail runners **Search intent**: comparison ## Outline - Quick verdict - Comparison table - When to choose option A - When to choose option B - Edge cases ## Targets - Primary keyword: hiking boots vs trail runners - Word count: 1500-2500 - Include: stats, named sources, examples
View brief
# Brief: hiking boots break in time **Search intent**: informational ## Outline - Definition (40-60 word answer for snippets) - Why it matters - Key concepts - Practical examples - FAQ ## Targets - Primary keyword: hiking boots break in time - Word count: 1500-2500 - Include: stats, named sources, examples
View brief
# Brief: hiking boots for wide feet **Search intent**: informational ## Outline - Definition (40-60 word answer for snippets) - Why it matters - Key concepts - Practical examples - FAQ ## Targets - Primary keyword: hiking boots for wide feet - Word count: 1500-2500 - Include: stats, named sources, examples
View brief
# Brief: waterproof hiking boots cheap **Search intent**: informational ## Outline - Definition (40-60 word answer for snippets) - Why it matters - Key concepts - Practical examples - FAQ ## Targets - Primary keyword: waterproof hiking boots cheap - Word count: 1500-2500 - Include: stats, named sources, examples
View brief
# Brief: sock liners for hiking **Search intent**: informational ## Outline - Definition (40-60 word answer for snippets) - Why it matters - Key concepts - Practical examples - FAQ ## Targets - Primary keyword: sock liners for hiking - Word count: 1500-2500 - Include: stats, named sources, examples
Start here · What does GSC → Content Brief do?
Search Console shows which queries earn impressions even when clicks lag. Those rows are brief candidates if position sits in striking distance.
Paste a CSV with query,impressions,clicks,position. The tool scores opportunity using impressions, position band, and CTR gap, then sorts the list.
Each row gets a generated brief: detected intent (how-to, comparison, best list, or default informational), outline bullets, primary keyword line, and targets like word count and source expectations.
When to use this tool
- Rewrite queue from Performance export
Export queries without the page dimension, paste here, and slide the impression floor to match high-value demand.
- Striking-distance sweeps
Keep the default position window roughly 5–20 or widen the slider to match how aggressive you want to be.
- Writer handoffs
Copy brief Markdown straight into Notion, Linear, or your CMS so intent and outline travel with the keyword.
- Teaching content SEO
Use the sample CSV to show how CTR and position interact before anyone opens a doc template.
Examples
Walk through these with the form above — they are practice scenarios, not live data.
High impressions, weak CTR
Try this
Find a row with tens of thousands of impressions, double-digit clicks, and average position near 10.
What to look for
It should bubble up in brief candidate count. Copy the brief and focus the ticket on title and on-page answer box.
Tighten thresholds
Try this
Drag Min impressions higher and lower the Position range cap to match enterprise traffic only.
What to look for
The candidate list shrinks to fewer, larger bets—useful before a quarterly content sprint.
Short tutorial
Follow in order the first time you use the tool; later you can skip to the step you need.
- Step 1 — Export queries from Search Console
Use the Performance tab, queries tab, and export CSV. Ensure header names match or rename them before pasting.
- Step 2 — Paste and scan stats
Verify totals look like your export. Bad delimiters or stray quote characters break rows silently.
- Step 3 — Tune sliders
Raise minimum impressions to ignore noise. Adjust the upper position bound to define striking distance for your niche.
- Step 4 — Copy a brief
Click Copy brief on the row you will ship first. Paste into your writing tool and human-edit every line.
- Step 5 — Pair with site analytics
Cross-check conversions or engagement before you commit headcount. GSC alone cannot prove business value.
More detail
New here? Skim Start here first, then run one Examples scenario in the form above.
GSC → Content Brief does one job: turn underperforming GSC queries into ready-to-write briefs. It lives under Keyword Research on SEOToolkits, where the beginner idea is simple: Keyword research is how SEOs understand the words people use and the intent behind those words.
FAQ
- Does this pull data from Google automatically?
- No. It is paste-only. Treat this page as a sandbox for CSV slices you already exported.
- How is opportunity calculated?
- It blends impressions, inverse position, and unused CTR headroom. It is a heuristic for sorting, not a Google metric.
- Can I include multiple countries?
- The parser only sees the columns in the header. Fold segments externally or keep one country per paste.
- Are outlines final?
- No. They are starters from simple regex intent detection. Editors should still research SERP features manually.
Related tools
Same workflow cluster on SEOToolkits — open another module without leaving context.
Search Console Analyzer
Slice GSC performance data with custom segments and pivots.
GSC Cannibalization Tracker
Spot URL pairs competing for the same query in Search Console.
Content Brief Generator
Turn a target keyword into a writer-ready outline and brief.
Keyword Intent Classifier
Tag queries as informational, navigational, transactional, commercial.