Google Search Console Data Connector User Guide

Google Search Console Data Connector User Guide

The following article is a guide to automating reports with your Google Search Console connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Search Console reports. To begin creating reports with your Google Search Console connector, you will need at least one Google Search Console account as well as access to Looker Studio or Google Sheets.


Available Data

  1. Key Performance Indicators - Total clicks, total impressions, average CTR, and position.
  2. Queries - Clicks, impressions, CTR, and position by query.
  3. Pages - Clicks, impressions, CTR, and position by page.
  4. Countries - Clicks, impressions, CTR, and position by country.
  5. Devices - Clicks, impressions, CTR, and position by devices (mobile, desktop, or tablet).
  6. Search Appearance - Clicks, impressions, CTR, and position by search appearance.
  7. Sitemaps - (Lifetime only - see API Limitations below) Indexed and discovered URLs by sitemap, type, last submitted, and last downloaded. Error and valid with warning sums.
  8. Complete List of Fields.

API Limitations

  1. Discover and Google News search types cannot be selected along with Site Impression on the connector configuration screen.
  2. Page and Search Appearance dimensions can only be used with URL Impression. Select Allow "Tables" to be modified in report  on the connector configuration screen to adjust for the relevant charts.
  3. Sitemaps data is lifetime only. Include "today" the first time you connect. Unlike other fields in this connector, Sitemap fields will be warehoused beginning the first time you connect.
  4. Realtime data is not available.
  5. Custom fields are not available.

Connection Requirements

A successful connection requires Verified Site Ownership with either the Verified Owner or Delegated Owner role. To add an owner, go to Google Search Console and click on Settings. Select Users and permissions.



Click Add user and enter the email address you'd like to add as an owner.



For Permission, select Owner. Then click the Add button.


On Your First Connection

When you first connect to Google in your Hub, make sure you are logged out of all extra Google accounts. Being logged into multiple Google accounts may result in errors.



You will be asked to grant permissions to your Google account. To use Google Search Console, you must select View search console data for your verified sites .



Be sure to select Allow "Tables" to be modified in reports on the connector configuration page. 



If you have selected Site Impression under Tables, you will not be able to select either discover or google news for your Property Parameter.


Backfilling

Google Search Console collects live data only. Backfilling and data warehousing are not available for this connector, and Google's API provides only the most recent 16 months of historical data. We recommend the following alternative solutions for ongoing collection of historical data beyond the most recent 16 months. 

Export to BigQuery or MySQL

Our Enterprise plan offers the ability to export data to BigQuery and MySQL. Follow the instructions in How to Export to BigQuery or How to Export to MySQL to set up an initial backfill of your historic Google Search Console data, followed by a regularly scheduled rolling update with the latest data. This scheduled export will append the newest data to the historic data on an ongoing basis, allowing you to collect data beyond 16 months.

Use the Spreadsheets Add-on

With our Spreadsheets add-on, you can use Google Sheets as a destination for your Google Search Console data. To store historic data as well as the latest data, create a new Google Sheets spreadsheet and enable the Power My Analytics Spreadsheets add-on. In the first sheet of the spreadsheet (Sheet1), create a report with a date range of the last 16 months:



Make sure to give this report a distinct name like "Historic data".



Next, create a new sheet (Sheet2) in the spreadsheet. Create a new report and set the date range to Custom start to date. Set the start date to today's date.



Make sure to give your report a distinct name like "Current data".



After creating your reports, go to the Sheets sidebar and delete the "Historic data" report. The first sheet of your spreadsheet will still contain the data, but it will no longer be updated. This is necessary to avoid data loss, as scheduling a refresh in the Sheets sidebar will cause all reports to refresh, and refreshing the "Historic data" report would cause the loss of any data older than 16 months.



Next, click on the alarm clock icon to create a scheduled refresh of your current data.



You can select a monthly, weekly, or daily refresh (hourly refresh is only available to Enterprise users).



Select a refresh time, then click Save.



You will need to repeat this process every 16 months in order to avoid gaps in data.

Troubleshooting

See our article Troubleshooting Google Connectors for all of the latest information on issues that may affect Google connectors .

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Apple Search Ads Data Connector User Guide

        The following article is a guide to automating reports with your Apple Search Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Apple Search Ads reports. To ...
      • Error: Missing Google Search Console Scopes

        This article will address the following error: Missing Google Search Console Scopes Cause You may receive this error when connecting to a Google Search Console account. It is a result of insufficient permissions granted to Power My Analytics. ...
      • Google Ads Data Connector User Guide

        The following article is a guide to automating reports with your Google Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Google Ads reports. To begin creating ...
      • Mailchimp Data Connector User Guide

        The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...
      • GA4 Data Connector User Guide

        The following article is a guide to automating reports with your GA4 connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your GA4 reports. To begin creating reports with ...