Google Search Console Data Connector User Guide

Google Search Console Data Connector User Guide

Google Search Console provides valuable insights into your website's search performance and visibility in Google Search results. This guide will walk you through connecting Google Search Console to Power My Analytics, creating reports, and understanding key metrics and considerations.



Prerequisites

Before connecting Google Search Console to Power My Analytics, ensure you have:
  1. Verified Site Ownership of the website(s) with a role of either Verified Owner or Delegated Owner in Google Search Console

Adding an Owner in Google Search Console

  1. Go to Google Search Console and click on Settings.
  2. Select Users and permissions.



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



  4. For Permission, select Owner.



  5. Click the Add button.

Adding Google Search Console as a Data Source

  1. Log out of all Google accounts except the one you want to connect.
  2. In your Power My Analytics Hub, go to Sources in the menu.
  3. Click + New Data Source and select Google Search Console from the gallery.
  4. Sign in to your Google account when prompted.
  5. Grant Power My Analytics the required permissions (View search console data for your verified sites) to access your Google Search Console data.


Creating a Looker Studio Report

  1. After adding Google Search Console as a data source, go to Reports > Looker Studio in your PMA hub
  2. Select Google Search Console under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g. "Google Search Console - My Website")
      2. Select your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Google Search Console account for real data or "Sample Account" for sample data
      2. Click Next
    3. Step 3:
      1. Choose "Sites", "Tables", and "Property Parameter" for your reports
        1. Property parameters "discover" and "google news" cannot be selected with the "Site Impression" table
        2. Page and Search Appearance dimensions can only be used with the "Url Impression" table
      2. Optional: Allow modification of these selections in reports
      3. Click Connect (top right)
    4. Step 4:
      1. Click Create Report (top right)
For a quick start, use our pre-built Google Search Console demo template.

Key Reports and Fields

Google Search Console data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  1. Performance Metrics: Clicks, Impressions, Average CTR, Position
  2. Query Metrics: Clicks, Impressions, CTR, Position
  3. Page Metrics: Clicks, Impressions, CTR, Position
  4. Country Metrics: Clicks, Impressions, CTR, Position
  5. Device Metrics: Clicks, Impressions, CTR, Position
  6. Search Appearance Metrics: Clicks, Impressions, CTR, Position
  7. Sitemap Metrics: Is Pending, Discovered URLs by Sitemap, Type, Last Submitted, Last Downloaded
For a complete list of available fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Google Search Console data is only available as live data. Historical data is limited to the most recent 16 months. For ongoing collection of historical data, please see Collect Historical Data for Google Search Console.
  2. Sitemaps data: Only lifetime data is available. Historical data collection begins when you first connect the data source.

Unavailable Data

  1. Realtime data
  2. Custom fields

Troubleshooting

See our article Troubleshooting Google Connectors for information on issues that may affect Google connectors.


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

      • Related Articles

      • Error: Missing Google Search Console Scopes

        When creating a report using your Google Search Console account in Power My Analytics, you may encounter an error message stating "Missing Google Search Console Scopes." This guide will help you understand the cause of this error and provide ...

      • Collect Historical Data for Google Search Console

        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 ...

      • Google Ads Data Connector User Guide

        Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in ...

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • GA4 Data Connector User Guide

        Google Analytics 4 (GA4) is a powerful web analytics platform that provides valuable insights into your website and app performance. This guide will walk you through the process of connecting GA4 to Power My Analytics, creating reports in Looker ...