Google Search Console Data Connector User Guide

Google Search Console Data Connector User Guide

Info
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 + Add New 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. Sitemaps: Sitemaps data is only available as lifetime data, historical data will be collected beginning from the first time you connect.
  2. Backfilling: Backfilling is available to 16 months. We store your data the first day you connect with us.

Unavailable Data

  1. Realtime data
  2. Custom fields

Troubleshooting

See our article Troubleshooting Google Search Console for information on issues that may affect the Google Search Console connector.

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

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

    • Troubleshooting Google Search Console

      Most errors that occur in Google Search Console reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Google Search Console reports. Google ...

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

    • Google Merchant Center Data Connector User Guide

      Google Merchant Center is a powerful ecommerce platform that helps you manage your product listings and shopping campaigns across Google services. This guide will walk you through the process of connecting Google Merchant Center to Power My ...