Google Search Console reveals exactly what people type to find your site—often keywords you never targeted. This guide walks you through GSC's Performance report, filters, and export techniques to mine real keyword opportunities your competitors miss.
I've spent thousands of dollars on Ahrefs, SEMrush, and other keyword platforms over the years. They're useful, but they all share one fatal flaw: they estimate search volume and guess which keywords might work for you. Google Search Console shows you exactly what people typed to find your site in the last 16 months. No guessing.
When a prospect comes to me saying their SEO isn't working, the first place I look is GSC. Nine times out of ten, I find queries getting 500+ impressions per month where they rank position 12. That's a layup. A few content tweaks, maybe a better title tag, and suddenly they're on page one. Traditional keyword tools would never surface these because they focus on head terms and competition scores.
The other advantage: GSC reveals how Google actually interprets your pages. You might think a blog post targets "Ottawa commercial roofing," but GSC shows it's getting impressions for "flat roof repair cost Canada." That tells you what to double down on or what to clarify if the traffic is irrelevant. This kind of intelligence costs nothing and updates daily.
Log into Google Search Console at search.google.com/search-console. If you haven't set up GSC yet, verify your property first—either via Google Analytics, DNS record, or HTML file upload. I prefer DNS because it doesn't break if you change CMSs.
Once you're in, click "Performance" in the left sidebar, then the "Search results" sub-option. You'll see a graph and four metric toggles: Total clicks, Total impressions, Average CTR, and Average position. Turn them all on. I know it looks messy, but you need the full picture to spot patterns.
Set your date range to the last three months minimum, ideally six. Don't compare year-over-year in this view—it muddies the data when you're hunting keywords. Scroll below the graph to the "Queries" tab. This is your keyword goldmine. By default, it shows the top queries by clicks, but we're going to filter it smarter in the next section.
One gotcha: if your site is new or low-traffic, you might see "Not enough data" for some queries. Google anonymizes rare searches to protect user privacy. You can't fix this; you just need more traffic.
Click the "+ NEW" filter button above the queries table. Add a Position filter: "Position is greater than 7 AND Position is less than 21." This isolates keywords where you're on page two or bottom of page one—prime real estate for fast gains.
Now sort the table by Impressions, descending. Look for queries with 100+ impressions per month. Those are real demand signals. If you're ranking position 12 for a term getting 300 impressions, you're invisible to 99% of searchers. But you're close enough that Google thinks you're relevant. Fix the page, and you can crack the top five.
I also filter by CTR sometimes—anything below 1% in positions 8-15 suggests your meta description or title tag is repelling clicks. Even if you rank well, you lose. Rewrite those snippets to match search intent better.
Another trick: filter by specific pages. Click the "Pages" tab, pick a URL that gets decent traffic, then switch back to Queries. Now you see only keywords for that one page. This is perfect for identifying what Google thinks the page is about versus what you intended. I've found so many accidental ranking opportunities this way—like a client's project portfolio page ranking for "construction budget template" because we mentioned budgets once in passing.
GSC's interface only shows 1,000 rows per view, and that's after filters. If you have a mature site, you're leaving data on the table. Click the export icon (looks like a download arrow) in the top right and choose "Download Google Sheets" or CSV. I prefer Sheets because it auto-updates if you share the link.
Once exported, add columns for your own tags: "Priority" (high/medium/low), "Content gap" (yes/no), "Page exists" (yes/no). Sort by impressions and position again, then manually review the top 200-300 keywords. Ask yourself: do we have a page that directly answers this query? If not, that's a content gap.
For Ottawa SEO Inc., I export this data monthly and keep a master spreadsheet going back three years. You start to see patterns—like "snow removal contract template" spiking every November, or "website redesign cost" peaking in January when budgets reset. These patterns inform our content calendar six months ahead.
Don't skip the "low-hanging fruit" tab either. Create a filter for queries where you rank 4-10 with CTR under 3%. Those are titles and descriptions that need rewriting, not full content overhauls. I've seen traffic double on pages just by making the snippet more compelling. That's a 30-minute fix, not a $2,000 content project.
People ask me this constantly, so let's clear it up. Google Search Console and Google Analytics are completely separate tools. They don't live in the same interface, though you *can* link them to see limited GSC data inside GA4's Acquisition reports.
Google Analytics tracks what happens *after* someone clicks to your site: pages viewed, time on site, conversions, bounce rate. It tells you nothing about the search query they typed or what position you ranked. Google Search Console tracks what happens *before* the click: impressions, queries, positions, and how your pages appear in search results.
To link them (which I recommend), go into GA4 under Admin > Property Settings > Search Console Links, then connect your verified GSC property. Now you'll see basic query data under Acquisition > Search Console in GA4. But it's watered down—you still need to use the standalone GSC for serious keyword research.
I use GA4 to see which GSC keywords actually convert. Export your GSC queries, cross-reference the landing pages in GA4's conversions report, and you'll know which keywords are worth the optimization effort. A term with 10,000 impressions is worthless if it never converts. This combo saved a client $8,000 last year—they were about to build a guide targeting a high-volume keyword that GSC showed got clicks but GA4 proved had a 0% conversion rate.
GSC's date comparison feature is underused. Set your date range to the last three months, then check the "Compare" box and pick the previous three months. Now every query shows percentage change in clicks and impressions.
Look for queries that jumped 200%+ in impressions. Those are either seasonal (fine, plan for next year) or emerging trends (move fast). In early 2024, I noticed a client's "hybrid work policy template" query spiked 400% in January. We expanded that blog post into a full guide by February and owned that keyword all year. Waiting until a traditional keyword tool flagged it would've been too late.
Seasonal patterns also tell you when to refresh content. If "Christmas marketing ideas" gets 90% of its impressions October-December, update that post every September. Google rewards fresh content in the lead-up, and you'll dominate when demand peaks.
Canadian businesses especially need to watch this. US-focused keyword tools often miss our seasonal quirks—like "RRSP contribution deadline" spiking late February, or "Canada Day event ideas" ramping in May. GSC shows you *your* audience's calendar, not a generalized one. I run this comparison quarterly and it feeds our entire content roadmap.
Biggest mistake: only looking at your top queries by clicks. Those are already working. The gold is in positions 8-40 with high impressions—queries where you're almost relevant but not quite.
Second mistake: ignoring branded queries. Yes, "Ottawa SEO Inc" is my brand, but GSC shows variations like "Ottawa SEO Inc reviews" or "Ottawa SEO Inc pricing." If those get impressions and you don't have dedicated pages, you're bleeding trust. Create them.
Third: not filtering out irrelevant junk. If you run a B2B consultancy and GSC shows queries for "free" or "DIY" with high impressions but 0.01% CTR, add those as negative signals in your content. Google's confused about your intent. Clarify it by removing wishy-washy language that attracts tire-kickers.
Fourth: treating GSC as a one-time audit. I check it weekly, minimum. Search behavior shifts faster than quarterly keyword reports can catch. A competitor launches, Google updates its algorithm, or a news event makes your niche term go viral—you need to see it in near real-time and react.
Last: not validating the data. GSC sometimes reports queries with 1,000 impressions but the page doesn't mention the keyword once. Check the SERP yourself. Maybe Google's pulling it from your schema markup, or a user review, or it's just wrong. Don't rewrite a whole page based on a fluke.
Open Google Search Console, click Performance, then Search results. Set your date range to three or six months, turn on all metrics, and go to the Queries tab. Filter by position 8-20 and sort by impressions to find keywords where you're close to page one but not quite there. Export the data, prioritize high-impression terms, and either optimize existing pages or create new content to target gaps.
Google Search Console is not inside Google Analytics—they're separate tools. You can link them so GA4's Acquisition reports show limited GSC query data, but full keyword research requires using the standalone Search Console interface at search.google.com/search-console. GSC tracks pre-click search data; Analytics tracks post-click behavior.
Google Search Console stores 16 months of search query data. You can view any date range within that window and compare periods. After 16 months, the data is gone, so if you want historical trend analysis, export your GSC reports monthly and archive them. I keep a running spreadsheet going back years for seasonal pattern tracking.
No. Google Search Console only shows queries and performance data for properties you own and have verified. You can't see competitor keyword data in GSC. For competitor research, you'd need third-party tools like Ahrefs or SEMrush. GSC's strength is showing you what your own site already ranks for, which competitors can't see about you either.
Google anonymizes queries that are extremely rare or could identify individual users to protect privacy. If a keyword only triggered your page once or twice in the selected date range, GSC won't show it. This is normal for long-tail queries on lower-traffic sites. As your traffic grows, you'll see more query data, but you'll never see every single search term.