To get started with the Google Search Console connector, just add an account, then make your queries! On the Analytics Edge ribbon bar, click the Google Search button and select the Accounts menu item.
More videos:
Basic Add-in Standard Add-in Core Add-in
ADD AN ACCOUNT
Enter a Reference Name for the account and click the Add Account button. You will step through a Google login sequence to authorize Analytics Edge to access your account. *
* A note about security: an account access token is encrypted and stored in a file on your computer using the reference name you entered. Your workbook queries use the reference name, and during refresh, the connector looks up your access token and sends it direct to Google’s API server with your queries. Your access tokens are not stored in your workbooks, so you can freely share the workbooks.
MAKE A QUERY
In Excel, on the Analytics Edge ribbon bar, click the Google Search button and select the Search Analytics menu item. Select the account and Site for your report, then step through the tabs to select the Fields, Filters, Dates and Sorting options for your query. Click Finish when you are ready to make the query.
