Find opportunities in your export
What the finder checks
- Where impressions come from. A table of impressions by position band. A site-wide average position of 60 or 70 usually hides a few queries near the top and many deep in the results; this shows the split.
- Striking distance. Queries or pages in positions 4 to 20 that already earn impressions. Improving the page that ranks for them is usually the quickest way to more clicks.
- Low click-through rate for the position. Rows whose CTR is less than half of your own median for the same position band. The benchmark comes from your data, not from an industry average, because CTR varies widely with the layout of each results page.
- What tracking would cost. Count the striking-distance queries, or every query with enough impressions, as rank-tracking combinations and see the smallest published plan that covers them at every vendor we track. Weekly tracking is often enough for a short list you are improving.
- Search intent groups. Queries grouped by wording: comparisons, alternatives, price and cost, free, reviews, best lists, local and questions. It shows which kinds of searches already find you.
The optional “clicks at your top-3 CTR” column multiplies a row's impressions by your own median CTR for positions 1 to 3. Treat it as a rough ceiling for prioritizing, not a forecast: higher positions can also bring more impressions, and some queries never reach a typical CTR.
How to export the right file
- Open Google Search Console and choose your property.
- Go to Performance → Search results. Select a date range of at least 28 days; three months smooths out weekly swings. Add a country filter if you only serve one market.
- Click Export and choose Download CSV. The ZIP file contains separate tables for queries, pages, countries, devices and dates.
- Load the ZIP file above. The finder opens the queries table and lets you switch to pages.
Exports in other interface languages work too: the finder recognizes English and Spanish column names, comma or semicolon separators and either decimal mark. If the columns are not recognized, it assumes Search Console's order: query or page, clicks, impressions, CTR, position.
Limits to keep in mind
- An export contains at most 1,000 rows, and Search Console omits rare, anonymized queries from the table. Totals here can therefore be lower than in the report chart.
- The queries and pages tables are separate, so the export does not say which page ranks for which query. Click the query in Search Console and open the Pages tab to see that.
- Average position is an average over real impressions in every location and device. Read why it differs from a rank tracker before comparing the two.
- Wording rules are simple and English-centered. A query can belong to more than one idea; it is shown in the first group that matches.
Privacy
The file is read with your browser's own file APIs and analyzed on this page. It is not uploaded, stored or sent to PayToRank or anyone else, and it is gone when you close or reload the page. The CSV download is generated on your device. See the privacy policy.
What to do with the results
Pick three striking-distance queries with the most impressions. For each, find the ranking page in Search Console, check that it answers the query directly near the top, improve the title if the CTR is low for its position, and link to it from related pages. Note the date of the change and compare the same query four weeks later; the free rank tracking guide describes a simple weekly routine.
If you need to watch specific cities, competitors or phrases you do not rank for yet, Search Console cannot do it; compare options in the rank tracker shortlist and size the plan with the rank tracker cost calculator.