Google Merchant Center Data Connector User Guide

Google Merchant Center Data Connector User Guide

Info
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 Analytics, creating reports in Looker Studio, and understanding key metrics and considerations for product performance tracking.

Prerequisites

Before connecting Google Merchant Center to Power My Analytics, ensure you have:
  1. An active Google Merchant Center account
  2. You must grant Power My Analytics permission to access your Google account
  3. You must grant Power My Analytics the permission Manage your product listings and accounts for Google Shopping on your Google Account

Notes
Power My Analytics' connector will never edit, create, or delete anything in your Google Merchant Center account. Google does not provide a read-only option for permissions.

    Adding Google Merchant Center 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, navigate to Sources.
    3. Click + Add New Source and select Google from the gallery.
    4. Sign in to your Google account when prompted.
    5. Grant Power My Analytics the required permission (Manage your product listings and accounts for Google Shopping) for your Google account.

    Creating a Looker Studio Report

    Follow these steps to create a Looker Studio report using your Google Merchant Center data:
    1. In your Power My Analytics Hub, go to Reports > Looker Studio
    2. Select Google Merchant Center 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 Merchant Center - My Business")
        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 Merchant Center account for real data or "Sample Account" for demo data
        2. Click Next
      3. Step 3:
        1. Select "Merchant Center Accounts" for your report
        2. Optional: Allow "Merchant Center Accounts" modification in reports
        3. Click Connect (top right)
      4. Step 4:
        1. Click Create Report (top right)

    Key Reports and Fields

    The Power My Analytics Google Merchant Center connector offers metrics and dimensions for tracking product performance. Here are some popular report types and metrics:
    1. Key Performance Metrics: Clicks, Impressions, CTR, Conversions, Conversion Rate
    2. Product Metrics: Product Price, Product Sale Price, Clicks, Title, Product Availability, Product Last Update Date
    3. Product Traffic Metrics: Clicks, Impressions, CTR, Conversions, Conversion Rate
    For a complete list of available fields, refer to the Schema Explorer.

    Limitations and Important Considerations

    1. Backfilling: Power My Analytics can backfill up to 2 years of historical data from Google Merchant Center.
      1. Initial backfill: When you first connect your Google Merchant Center account, an initial backfill of 13 months of data will be performed.
    2. Organic and Paid Product Clicks: Product clicks are only available as total clicks, not broken down by organic and paid clicks as in Google Merchant Center's UI reports. This is a limitation of Google's API.

    Troubleshooting

    If you encounter issues with your Google Merchant Center connection, please see the following articles for assistance:

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

        • Related Articles

        • How to Connect to Google Merchant Center

          This guide will walk you through the process of integrating Google Merchant Center with Power My Analytics, enabling you to automate data collection, centralize your product metrics, and create powerful reports. By the end of this guide, you'll be ...

        • Error: Missing Google Merchant Scopes

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

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

        • eBay Seller Center Data Connector User Guide

          As an eBay seller, you need quick access to your sales data and performance metrics to make informed decisions. This guide will walk you through connecting your eBay Seller Center account to Power My Analytics, enabling you to automate data ...

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