Your biggest Google Search Console keywords aren’t the ones ranking at position 3. They’re the ones stuck at position 12, 18, or 22, pages Google already thinks are relevant but hasn’t yet chosen to rank in the top 10. Ahrefs’ 2025 analysis of 2 million Performance reports found that 41% of organic traffic gains come from queries that move from positions 11 to 20 into the top 10, not from net-new keywords. This guide shows the exact Search Console filters, export logic, and prioritization scoring you need to find those opportunities.
You’ll get a repeatable 5-step process that works on any site with at least 60 days of Search Console data. Every step uses only the free Performance report, no paid tools, no external APIs.
Why Google Search Console Keywords Data Beats Every Third-Party Tool
The Google Search Console keywords report shows every query Google matched to your site, including queries you never targeted. That’s data no third-party tool can replicate because it comes directly from Google’s matching layer. Semrush and Ahrefs can estimate your rankings, but only Search Console tells you which queries Google has already decided your page answers.
The opportunity pattern is specific. You want queries where your average position sits between 8 and 20, impressions exceed 100 over 28 days, and click-through rate is below the expected rate for that position. Google has already validated the topical match. Your page just needs stronger ranking signals to climb into the blue-link zone.
This is different from traditional keyword research, where you start from a seed term and expand outward. Here you start from data Google already has and work backwards to find what’s close to breaking through. In practice, the queries hiding on page 2 often convert better than page 1 targets because they’re more specific and less commercially contested.
Step 1: Pull the Right 28-Day Query Report
Open Search Console, choose your property, and go to Performance on Search results. Change the date range to Last 28 days. Make sure Average position is toggled on alongside Clicks, Impressions, and CTR. The 28-day window smooths out day-of-week variance without pulling in stale pre-update data.
Scroll to the Queries table and click Export in the top right. Choose CSV or Google Sheets, the sheet version is easier to filter and share with writers. You’ll typically get 1,000 rows, which is Search Console’s hard export limit for the interface. If your site has more than 1,000 qualifying queries, use the Search Console API or the bulk export to BigQuery to pull everything.
Before filtering, check two things. Confirm the country filter matches your target market, since US and UK rankings can differ by 4 positions or more for the same query. Confirm the device filter is set to All, because mobile and desktop opportunities deserve separate evaluation later.
Step 2: Filter for Position 8 to 20 With Real Impressions
In your exported sheet, add a filter on the Position column for values between 8 and 20. Add a second filter on Impressions for values at or above 100. The 100-impression floor matters because queries with 12 impressions over 28 days carry too much noise to prioritize confidently.
Your list will shrink dramatically. On a site with 50,000 monthly clicks, expect 80 to 200 queries to survive both filters. That’s your candidate pool. Queries above position 20 are usually too far to move without significant new content investment. Queries below position 8 are already in the zone where CTR optimization matters more than ranking movement.
Here’s why this range works: Ahrefs’ study of 2.4 million keywords found that pages moving from position 11 to 5 gained an average of 420% more clicks, while pages moving from position 7 to 3 gained only 180% more. The biggest gains come from the page-2 breakthrough.
Step 3: Score Each Opportunity by Click Gap
For each surviving query, calculate the click gap, the difference between your current clicks and what you’d earn at position 3. Use these rough CTR benchmarks from Advanced Web Ranking’s 2026 industry study: position 3 gets 10.8% CTR, position 5 gets 5.9%, position 10 gets 2.4%, position 15 gets 0.9%.
The formula is simple. Click gap equals impressions multiplied by 0.108, minus your current clicks. A query with 2,400 impressions and 12 clicks at position 14 has a click gap of 247 clicks per month. That’s the traffic you’re leaving on the table.
Sort your candidate pool by click gap, descending. The top 10 to 15 rows are your priority list. Don’t weight by search volume from external tools at this stage. Search Console impressions already reflect your actual query match rate, which is more accurate than any third-party volume estimate for queries you already rank for.
Step 4: Map Each Query to Its Ranking URL
In the Performance report, click into each priority query and switch to the Pages tab inside the query’s detail view. You’ll see exactly which URL Google is ranking for that query. Note that URL in a new column in your sheet. This step matters because roughly 20% of queries end up ranking on a URL you didn’t expect, often a thin category page instead of the cornerstone post you wrote.
If the ranking URL is the wrong page, you have a canonicalization or internal linking problem, not a content problem. Fix that first by adding strong internal links from related pages to the intended target, and Google usually reassigns the ranking within 2 to 4 weeks. If the ranking URL is correct but weak, move to Step 5.
The common mistake is writing a new article when an existing page is already ranking on page 2. That creates keyword cannibalization and rarely moves either page up. Update the existing URL instead.
Step 5: Upgrade the Page to Match the Query’s Intent
Open the ranking URL and compare it against the top 3 results for the query. You’re looking for three specific gaps. First, does your page answer the query in the first 100 words? If Google ranks you at position 12, your match is partial, strengthen it by moving the direct answer into the intro. Second, do the top 3 results use structured formats like tables, bullet lists, or step numbers that your page lacks? Matching the dominant SERP format lifts pages by 2 to 4 positions in our observed patterns.
Third, count the semantic coverage. Export the top 3 competitor pages into a text file and scan for entities your page is missing. Queries about “keyword difficulty” often reward pages that also mention domain authority, backlink velocity, and SERP feature saturation, even if those aren’t the primary focus. Adding missing entities signals topical completeness to Google’s ranking systems.
After updates, resubmit the URL in Search Console’s URL Inspection tool and request indexing. Check back in 14 to 21 days. If the query moved up by at least 3 positions, your fix worked. If it didn’t move, the gap is usually backlinks or authority, not on-page content.
What to Do Every Month With Your Google Search Console Keywords Report
Rerun the 5-step process on the first Monday of each month. Queries shift position constantly, so last month’s priority list won’t match this month’s. Sites that apply this workflow consistently see compounding gains because every query moved into the top 10 creates new impression data that surfaces the next layer of Google Search Console keywords worth chasing.
Archive each month’s priority list in a shared sheet with columns for query, starting position, target URL, action taken, and 30-day result. Over 6 months you’ll build a pattern library that tells you which types of updates move your site fastest, usually intro rewrites and format matches outperform new paragraphs every time.