Google Ads Setup Guide

Follow our setup guide to connect Google Ads to Fivetran.

Prerequisites

To connect Google Ads to Fivetran, you need a Google Ads account.

If you choose the Fivetran-managed service account authentication method, you also need Admin access to the Google Ads account, so you can grant the Fivetran service account access.

Setup instructions

Find customer ID

1. Log in to your Google Ads account.

2. Locate your Google Ads customer ID and make a note of it. You will need it to fill in your Google Ads setup form.

   

Begin Fivetran configuration

1. Enter your chosen destination schema name in the connection setup form.

2. (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.

3. Enter the Google Ads customer ID you found.

4. Choose your Authentication method:

   • OAuth (recommended): Allows Fivetran to access your Google Ads account using your Google user account. Click Authorize with Google to allow Fivetran to access your Google Ads account using OAuth.

   • Fivetran-managed service account: Allows Fivetran to access your Google Ads account using a service account managed by Fivetran. To authenticate with a Fivetran-managed service account:

     You must have Admin access to the Google Ads account you want to sync.

     1. Click Copy next to the Service account email field to copy the service account email displayed in the Fivetran connection setup form.
     2. In a new browser tab, log in to your Google Ads account.
        We recommend adding the service account to a manager account, so that it can access all client accounts managed by it.

     3. Click Admin in the left navigation menu, then select Access and security.
     4. On the Users tab, click +.
     5. In the Email field, enter the service account email you copied from the Fivetran connection setup form.
     6. Select the Read-only or Standard access level.
     7. Click Add account.
     8. Return to the Fivetran connection setup form and click Test Fivetran-managed service account access to verify that Fivetran can access your Google Ads data. Once the test is successful, the remaining configuration fields appear.
     For more information on adding a service account to your Google Ads account, see Google Ads documentation.

5. Select your sync mode:

   • Select Sync All Accounts to sync all accounts you have access to.
   • Select Sync Specific Accounts to sync specific accounts only. Use the + Accounts link to add accounts you'd like to sync.
   • Select Sync Specific Manager Accounts to sync specific Manager accounts only. Use the + Manager accounts link to add accounts you'd like to sync.
   In the Sync Specific Manager Accounts mode, Fivetran will find and sync the client accounts that are direct children of the selected manager accounts. If a manager account has sub-manager accounts, their clients won't be synced.

(Optional) Add Custom report

If you want to sync a Custom report:

1. Click + Custom report.

2. Enter a Destination table name for the custom report being added. It must be unique within this connection and must comply with Fivetran's naming conventions.

   Give the table a name you will find easy to identify with the report in the future. When you want to enable or disable the sync for a particular report once it is set up, you will do so by selecting its table in the connection's Schema tab.

3. (Optional) Select the Report Name of the report you'd like to sync.

4. (Optional) Select the Fields you'd like to sync for the report. See Google's Ads API Report Types documentation.

   Including certain fields in the report can result in fetching less rows than expected or no rows at all. These known fields are:

   • bidding_strategy, accessible_bidding_strategy - Adding these fields to the report may result in fetching no rows.
   • segments.keyword, segments.keyword.ad_group_criterion - Adding these fields to the report may result in fetching only the rows that include the keyword criterion.
   • segments.geo_target_* - Adding these fields to the report may result in fetching less rows than expected because not all rows can be segmented by all geo_target segments.
   All connections created before June 7, 2024 require the segments.date field because the reports are synced by day. All reports without the segments.date field are not supported.
   
   Connections created after June 7, 2024 provide a higher timeline granularity and require one of the following segments: segments.date, segments.week, or segments.month.

5. Click Save.

   Repeat the previous five steps if you want to add another Custom report.

   To sync Performance Max campaign data, you must apply a specific configuration while adding a Custom report. See How Can I Sync Performance Max Campaigns to learn more.

Finish Fivetran configuration

1. (Optional) Click Show Advanced Options to set the skip empty reports option and conversion window size.

2. (Optional) Set the Skip Empty Reports toggle to On or Off. Disabling this option may decrease connection performance.

3. (Optional) Select the size of the conversion window in the drop-down menu or set it to AUTO if you want to detect the window size automatically.

   Changing the conversion window size for the connection does not affect the conversion window settings in your Google Ads account.

4. In the Historical Sync Time Frame drop-down, select how many months' worth of reporting data you'd like to include in your initial sync.

5. Click Save & Test. Fivetran will take it from here and sync your Google Ads account data.

Related articles

Connector Overview

Schema Information

Release Notes

API Connector Configuration

Documentation Home