Key takeaways
- In Search Console's Performance report, click a query and then open Pages to see which of your URLs appeared for it.
- To see queries for one URL, click the page first and then open Queries.
- Separate unfiltered Queries.csv and Pages.csv exports do not contain query-to-page pairs and cannot be joined to recreate them.
- Compare like-for-like date, country, device and search-type filters. A few impressions or one day's position are weak evidence for a rewrite.
The page behind a keyword is usually the missing piece in a Search Console audit. A sitewide query table tells you what people searched; a sitewide page table tells you which URLs appeared. Neither table alone tells you which URL was shown for a particular query.
That matters when you want to improve an existing page, decide whether to publish a new one, or check whether two pages genuinely compete. Here is a repeatable workflow using Google's own Performance report.
Table of contents
If the URL is absent from search entirely, use the Page indexing decision tree before changing its title or copy.
Find the pages Google showed for one query
- Open your verified property in Search Console > Performance > Search results.
- Set the search type to Web and choose a complete date range. Record any existing country or device filters.
- Open Queries and click the query you are investigating. This applies a query filter to the whole report.
- Open Pages. The rows now show URLs that received impressions for that selected query.
- Compare impressions, clicks and the page's purpose. Open the actual pages before deciding whether they overlap in intent.
This is the process in Google's Search Console common tasks. If you want to inspect a group of related queries, use a query filter such as “queries containing” or a carefully checked regular expression. Keep the filter visible while switching tabs.
Find the queries that show one page
- Return to the unfiltered Search results Performance report.
- Open Pages and click the exact URL you want to improve.
- Switch to Queries. You now see the visible query rows for that page.
- Sort by impressions and group related questions by search intent. Check country and device before interpreting an unexpected query.
If a page about a Nepal service appears mostly for broad international definitions, the query mix may explain a low click rate better than the title does. If a page appears for a buying question but only answers a definition, improve the answer or link visitors to the relevant service. Do not force every query into one title.
Export a query-to-page view correctly
With one query selected, export the Pages view. With one page selected, export the Queries view. Save the date range and filters beside each file so you know what it represents later.
An unfiltered Performance download often gives separate files named Queries.csv and Pages.csv. They are aggregate tables, not a relational pair. There is no shared key that tells you which query belonged to which page. If you need a large query-plus-page dataset, use the Search Console API with both dimensions, or a suitable bulk export. Handle sampling, anonymized queries and row limits before drawing conclusions.
Worked example: improve, separate or leave alone?
Illustrative example; these numbers are not client or site results. Suppose the query “SEO audit in Nepal” shows a service page with 80 impressions and a tutorial with 20 impressions. The service page explains the offer; the tutorial teaches readers to audit their own site.
| Observation | Next check | Likely action |
|---|---|---|
| Two URLs appear for one query | Do they meet different informational and commercial intents? | If yes, keep both and clarify titles and internal links. |
| Two near-identical audit guides appear | Do both answer the same task with overlapping content? | Consider merging the best material and redirecting the retired URL. |
| Service page is shown but gets few clicks | What country, device and other queries drove its impressions? | Improve the offer and snippet only after confirming the relevant query mix. |
Two URLs in the table do not prove keyword cannibalization. The decision depends on whether the pages have the same purpose and whether the preferred page is losing meaningful visibility.
Read Search Console numbers with their limits
- Average position is an average across impressions. Treat a small sample or mixed countries cautiously.
- CTR is clicks divided by impressions. It depends on position, query intent, device and search appearance; a zero-click row alone does not diagnose the cause.
- Filtered totals may differ because of aggregation and anonymized queries. Google documents these limitations in its filtering guidance.
- Impressions are not indexing status. Check the Page Indexing report or URL Inspection for an individual URL.
Turn the analysis into one useful change
Choose a page with enough relevant impressions to learn from. Write down the query family, current page purpose, one content or title change and the date you publish it. Compare the same filters after Google recrawls the page. Keep new articles for distinct reader needs; a fresh URL that repeats an existing guide makes the site harder to maintain.
If you are new to the interface, start with the Search Console beginner guide. For a full audit workflow, see the SEO audit guide.
Want help turning search data into a focused content plan?
Get in touch