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 MCC account (or linked to MCC account) for access to the Google Ads API.

The process to request access to the Google Ads API is easy - just follow Google's instructions. The process typically take about 2-5 business days, according to Google's documentation.

---

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.

   

Finish Fivetran Configuration

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

2. Enter your chosen destination table name.

3. Enter the Google Ads customer ID you found in Step 1.

4. Click Authorize to allow Fivetran to access your Google Ads account via OAuth.

5. Select your sync mode. You can choose Sync All Accounts, Sync Specific Accounts, or Sync Specific Manager Accounts.

6. If you chose Sync Specific Accounts or Sync Specific Manager Accounts, a new Accounts field will appear that lists every account that Fivetran can access. Select which accounts you'd like to sync.

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

7. Select which reports and fields you'd like to sync. Use the following Google resources to choose your reports and fields. Note that the Date field is required because the reports are synced by day.

   • Google Ads API Report Types
   • Google Ads API Selector Fields

   Note: Universal App Campaigns only support a small subset of reports & will result in no data delivered for any other report type.

8. Select how many months of reporting data you'd like to include in your initial sync.

9. (Optional) If you want to set the conversion window size, click Show Advanced Options to show conversion window size options.

10. (Optional) Select from the drop-down list the size of a conversion window or set it to AUTO if you want to detect the window size automatically.