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



  2. You must grant Power My Analytics permission to access your Google account
  3. You must grant Power My Analytics the permission See, edit, create, and delete your Google Ads accounts and data on your Google Account
    1. Power My Analytics' connector will never edit, create, or delete anything in your Google Ads account. Google does not provide a read-only option for permissions.

Adding Google Ads as a Data Source

  1. Make sure you are logged out of all Google accounts other than the one you are connecting.
  2. Navigate to your Hub and select Sources from the menu.
  3. Click + Add New Source and choose Google Ads from the gallery.
  4. Sign in to your Google account to authenticate.
  5. Grant Power My Analytics access to your Google account and authorize the required permission scopes (See, edit, create, and delete your Google Ads accounts and data). 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. Google Looker Studio Configuration:
    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

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

Data Sync and Lookback Windows with Google Ads Conversions

Power My Analytics automatically reads each Google Ads account's conversion lookback window settings, and our nightly data refresh will automatically adjust to match your account's longest conversion lookback window. This applies to all reports containing conversion data (Insights, Ad Group Insights, Campaign Insights, Keywords, Search reports) and ensures complete and accurate conversion attribution by capturing all conversions within your configured attribution window.

Limitations and Important Considerations

  1. Backfilling: Up to 2 years
    1. Initial backfill: 13 months when first connecting a data source
  2. Conversion Action and Conversion Category: Conversion Action and Conversion Category are available as live fields only

Unavailable Data 

  1. Manager account metrics are unavailable
    1. Workaround: Issue separate requests to each client account under manager account
  2. Accounts that are in a draft state
  3. Accounts that are not enabled
  4. Unique Users
  5. Performance Max campaigns: unavailable at Ad level, available at Campaign level
  6. Discovery Product Feed campaigns
  7. Demand Gen campaigns
  8. Custom fields

Troubleshooting

See our article Troubleshooting Google Ads​ for information on issues that may affect the Google Ads connector.
    • Related Articles

    • Apple Ads Data Connector User Guide

      Apple Ads is a powerful advertising platform that allows app developers and marketers to promote their iOS apps directly within the App Store search results. This guide will walk you through setting up and using the Apple Ads data connector in Power ...
    • Pinterest Ads Data Connector User Guide

      Pinterest Ads is a powerful advertising platform that allows businesses to promote their products and services to Pinterest's vast user base. This guide will walk you through the process of connecting your Pinterest Ads account to Power My Analytics, ...
    • 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 ...
    • LinkedIn Ads Data Connector User Guide

      LinkedIn Ads is a powerful platform for B2B marketing, lead generation, brand awareness campaigns, and revenue attribution. This guide will help you connect your LinkedIn Ads account to Power My Analytics, enabling you to create comprehensive reports ...
    • Amazon Ads Data Connector User Guide

      Amazon Ads is a powerful advertising platform that allows sellers and brands to promote their products on Amazon. This guide will walk you through how to connect Amazon Ads to Power My Analytics, create reports in Looker Studio, and understand key ...