What do you have?

One row per search and page, with the header row. A BigQuery bulk export with sum_position works too.

Searches for your name are marked usually fine. Separate several names with commas.

In all, across your pages. Raise it on a big site.

Runs in your browser. Your data is not uploaded.

Getting query and page rows

The normal Performance report export gives queries and pages in separate sheets, so it cannot show which page got which search. Use one of these instead:

  1. 1 Looker Studio: add a Search Console data source with the URL Impression table, make a table with the query and the landing page plus clicks, impressions and average position, then export it as CSV.
  2. 2 Search Console API: a Search Analytics query grouped by the dimensions query and page returns up to 25,000 rows a request.
  3. 3 Bulk data export to BigQuery: the searchdata_url_impression table has the query and the URL in each row. Export the columns query, url, clicks, impressions and sum_position.
  4. 4 One search at a time: in the Performance report, click a query in the Queries table, then open the Pages tab to see the pages shown for it.

No Search Console yet? Choose "Planned pages" and list each page with the keyword it targets.

Searches shared by your pages appear here

Add a table with the query and the page in each row, list your planned pages, or try the example.

Free SEO Keyword Cannibalization Checker. Runs in your browser, no sign-up. Open the full tool on DigitalSnot →