Google Ads Data Connector User Guide

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 Looker Studio, and understand key metrics and considerations when working with Google Ads data.



Prerequisites

Before connecting Google Ads to Power My Analytics:
  1. Ensure you have a Google account with at least Read-Only access to the Google Ads or Manager account you want to connect

Adding Google Ads 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, select Sources from the menu.
  3. Click + New Data Source and choose Google from the gallery.
  4. Sign in to your Google account when prompted.
  5. Grant Power My Analytics access to your Google account. Power My Analytics will never edit, create, or delete anything in your Google Ads account; Google does not provide a read-only option.

Creating a Looker Studio Report

  1. After adding Google Ads as a data source, go to Reports > Looker Studio in your PMA hub
  2. Select Google Ads under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. In Looker Studio, follow these configuration steps:
    1. Step 1:
      1. Name your data source (e.g. "Google Ads - Your Company Name")
      2. Select your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked for the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Choose your Google Ads account for real data or "Sample Account" for sample data
      2. Click Next
    3. Step 3:
      1. Select "Account" for reports
      2. Optional: Allow "Account" modification 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 Ads demo template.

Key Reports and Fields

  1. Account Metrics: Impressions, Interactions, Interaction Rate, Clicks, Avg. CPC, Avg. Cost, Cost, Conv. rate, Conversions, Cost/conv., View Through Conversions
  2. Campaign Metrics: Clicks, Impressions, CTR, Avg. CPC, Cost, Conversions, View Through Conversions, Cost/conv., Conv. rate
  3. Ad Group Metrics: Clicks, Impressions, CTR, Avg. CPC, Cost, Conversions, View Through Conversions, Cost/conv., Conv. rate
  4. Ad Metrics: Clicks, Impressions, CTR, Avg. CPC, Cost, Conversions, View Through Conversions, Cost/conv., Conv. rate
  5. Keyword Metrics: Clicks, Impressions, CTR, Avg. CPC, Cost, Conversions, View Through Conversions, Cost/conv., Conv. rate, Avg. CPM
  6. Search Term Metrics: Clicks, Impressions, CTR, Avg. CPC, Cost, Conversions, View Through Conversions, Cost/conv., Conv. rate
  7. Demographic Metrics: Impressions by Age, Impressions by Gender, Clicks, Cost, Avg. CPC, Impressions by Day Of Week
  8. Location Metrics: Avg. CPM, Impressions, Interactions
  9. Local Service Leads Metrics: Business category, consumer name, lead charged status, lead ID, lead status, lead type, phone number, service type
For a complete list of available Google Ads fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling is limited to 2 years, with an initial backfill of 13 months when first connecting.
  2. Conversion Action and Conversion Category are available as live fields only.

Unavailable Data 

  1. Manager account metrics are unavailable. You'll need to issue separate requests for each client account.
  2. Data is unavailable for accounts in draft state or not enabled.
  3. Performance Max campaigns data is unavailable at the Ad level, but available at the Campaign level.
  4. Discovery Product Feed campaigns, Demand Gen campaigns, and custom fields are not available.

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

      • Pinterest Ads Data Connector User Guide

        The following article is a guide to automating reports with your Pinterest 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 Pinterest Ads reports. To begin ...
      • LinkedIn Ads Data Connector User Guide

        The following article is a guide to automating reports with your LinkedIn 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 LinkedIn Ads reports. To begin ...
      • Quora Ads Data Connector User Guide

        Quora Ads allows marketers to reach a highly engaged audience through targeted advertising on the Quora platform. This guide will walk you through how to connect your Quora Ads data to Power My Analytics and create insightful reports in Looker ...
      • Instagram Ads Data Connector User Guide

        Instagram Ads allows businesses to create and run paid advertisements on the Instagram platform. This guide will walk you through setting up Instagram Ads as a data source in Power My Analytics and creating reports in Looker Studio. Prerequisites ...
      • Facebook Ads Data Connector User Guide

        Facebook Ads is a powerful advertising platform that allows businesses to reach their target audience on Facebook, Instagram, and across the web. This guide will walk you through how to connect your Facebook Ads account to Power My Analytics, create ...