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.

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 connector setup form.

2. Enter the Google Ads customer ID you found.

3. Click Authorize with Google to allow Fivetran to access your Google Ads account using OAuth.

4. (Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected in the Select an existing agent drop-down menu. To use a different agent, select the agent of your choice, and then select the same agent for your destination.

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.

   TIP: 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 connector and must comply with Fivetran's naming conventions.

   NOTE: 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 connector'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.

   WARNING: 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.

   IMPORTANT: All connectors 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.
   
   Connectors 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.

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

   NOTE: 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 connector 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.

   IMPORTANT: Changing the conversion window size for the connector 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

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home