Striking Distance Keyword Finder
This free tool finds the keywords your site is already close to ranking for. Paste in a Google Search Console export, or drop in the zip file Google gives you, and it pulls out every query sitting just off page one, usually positions 11 to 20, where a small content update can make a big difference. Set your own position range and impression floor, hide your brand terms, and it ranks the opportunities by how many extra clicks each one could bring in. Spot the words those queries share, see which pages are competing with each other, and export the list as CSV. Everything runs in your browser, so your Search Console data never leaves your computer.
How to get the export from Google Search Console
- Open Search Console, pick your property, and go to Performance > Search results.
- Set the date range. The last 3 months is a good default; use 28 days if your site changes fast.
- Optional: click + New to filter by a page, country, or device if you only want part of the picture.
- Click Export (top right) and choose Download CSV. You'll get a zip file; drop it on this page as it is, or unzip it and paste
Queries.csvabove. - Prefer Google Sheets? Export there instead, then copy the Queries tab and paste it here.
| Keyword | Page | Position | Impressions | Clicks | CTR | Extra clicks/mo | Priority |
|---|
Similar Tools
What Are Striking Distance Keywords?
They're the searches your site already ranks for, just not high enough for anyone to see. The usual definition is anything in positions 11 to 20, which is page two of Google. You've done the hard part: Google has decided your page is relevant to the query and has given it a spot. You're just a few places short of where the clicks are.
That matters because the drop-off is brutal. The first result on a page gets roughly a quarter of all clicks, position five gets around six percent, and by position eleven you're down near one percent. A keyword with 2,000 impressions a month at position 13 might be sending you 20 visits. Move it to position 5 and the same impressions turn into 120 or more. Nothing else in SEO gives you that kind of return for an afternoon's editing, because you're improving a page that already exists and already has Google's attention.
Some people stretch the range to positions 4 to 20, or even 8 to 30, and the tool lets you do that. Page two is where the easiest wins hide, though, and it's where we'd start.
Which Search Console Report Do I Export, and How?
In Search Console, open Performance, then Search results. Set the date range at the top (three months is the default and works well), then click Export in the top right and choose Download CSV. Google hands you a zip file with several spreadsheets inside. You can drop that zip straight onto this page and the tool will find the Queries table inside it. If you'd rather, unzip it and paste the contents of Queries.csv into the box.
A few tips that make the results more useful:
- Filter by page first if you're working on one article. Click "+ New" above the chart, choose Page, enter the URL, then export. Now every query in the list belongs to that page and you know exactly what to add to it.
- Pick a sensible date range. Three months smooths out the weekly wobble. Sixteen months is too long, because positions from a year ago don't tell you much about today. Set the "Export covers" option to match so the monthly estimate is right.
- Watch the 1,000 row limit. The Search Console interface only exports the top 1,000 rows. For big sites that's fine for a first pass, but you'll get more with the Google Sheets export, Looker Studio, or the Search Console API, all of which this tool can read as long as the export has a query column and a position column.
- Copying from the table also works. Select rows in the Performance report, copy them, and paste. The tool recognizes tab-separated data with or without a header row.
I Have the List. What Do I Actually Change on the Page?
Start with the "Words these keywords share" chips above the table. If a dozen page-two queries all contain "cost" or "vs" or "for beginners", your page is being found for an angle it doesn't really cover, and that's the gap to fill. From there, work down this list and stop when the keyword is genuinely addressed:
- Answer it properly. If the query is a question or a subtopic your page only brushes past, add a subheading that uses the natural wording and write two or three good paragraphs under it. This is where most of the gain comes from.
- Check the title and meta description. If the striking distance keyword is a better match for the page than what's in the title now, swap it in. It's often the single quickest fix, and it helps CTR at whatever position you land.
- Add internal links. Find three or four related posts on your site and link from them to this page using the keyword, or something close to it, as the anchor. Our Internal Link Opportunity Finder lists the exact sentences where you can do that.
- Refresh what's stale. Update dates, stats, screenshots, and examples. Pages that slide to page two often got there by going out of date, not by being wrong.
- Match the intent. Search the keyword yourself and look at what's on page one. If they're all listicles and you're a tutorial, or they're all product pages and you're a blog post, rewording won't bridge that gap. Either restructure or let it go.
Don't just sprinkle the keyword into existing sentences. Google is good at noticing when a page mentions something and when a page is actually about it. Then give it four to eight weeks, re-export, and see what moved.
How Is "Extra Clicks a Month" Worked Out, and How Much Should I Trust It?
It takes the impressions a keyword already gets, applies the average click-through rate for the target position you chose (around 6% for position five, for example), subtracts the clicks you're getting today, and scales the answer to a month based on the "Export covers" setting. So a keyword with 3,000 impressions over three months, 15 clicks, and a target of position five works out to roughly 55 extra clicks a month.
Treat it as a way to rank the list, not a forecast. Real click-through rates swing a lot by query: a search with a featured snippet, four ads, and a map pack above the results leaves far less for the organic links, while a long specific question with nothing in the way can beat the averages comfortably. Impressions also tend to grow as you climb, since Google shows a page-one result to more searchers than a page-two one, so the number is, if anything, conservative. The priority badges work the same way: "High" means the keyword is in the top fifth of your own list by potential, not that it meets some universal threshold.
The Export Doesn't Say Which Page Ranks for Each Keyword. How Do I Find Out?
That's the one annoying thing about the standard Queries export: Google gives you the keyword and the position, but not the URL. You have three ways around it.
The quick way is to click a keyword in Search Console, which adds it as a filter, then open the Pages tab to see which URLs show up for it. That's fine for a handful of keywords. For a whole list, export with the page filter applied instead, one page at a time, so you know every query belongs to that URL. Or use a source that includes both columns at once: Looker Studio, the Search Analytics for Sheets add-on, and the Search Console API can all export query and page together, and if your file has a page column this tool will show it and let you group the results by page.
When you do have page data, keep an eye out for the red "pages" badge next to a keyword. It means more than one of your URLs is ranking for the same query, and they're probably splitting the signal between them. Our Keyword Cannibalization Checker helps you decide which page should own it and what to do with the other.
Is My Search Console Data Safe Here?
Yes. The file is opened by your browser, on your computer, and nothing in it is sent to us or anyone else. There's no upload, no account, and no copy kept anywhere; close the tab and it's gone. The only things remembered are your settings, like the position range and brand terms, which are stored in your own browser so you don't have to type them again. Files up to about 50 MB and 200,000 rows are fine, which is far more than Search Console will ever give you in one export.
Let's Grow Your Business
Want some free consulting? Let's hop on a call and talk about what we can do to help.
