Queries for Top Pages

get-google-search-console-detail-in-minutesCore Add-in, Google Search Connector
This free workbook is a companion to the Simple SEO Report Automation newsletter and video Get Google Search Contents in Minutes. It shows how easily Analytics Edge can automate a sequence of queries; in this case, getting a list of the top pages that appear in Google Search results, then for each of those pages, get the queries that were used to find them.

It includes the impressions, clicks, CTR and position data.

Download the workbook: GoogleSearch-QueriesForTopPages-1-0.xlsx

UPDATE: The functionality in this workbook can easily be accomplished with a single ‘query’ in the Google Search connector v4.0, and it works in the Basic Add-in:

GoogleSearch-QueriesForTopPages-4-0.xlsx