Google Ads Setup Guide link
Follow our setup guide to connect Google Ads to Fivetran.
Prerequisiteslink
To connect Google Ads to Fivetran, you need a Google Ads account.
Setup instructionslink
Find customer IDlink
Log in to your Google Ads account.
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 link
Enter your chosen destination schema name in the connector setup form.
Enter the Google Ads customer ID you found in Step 1.
Click Authorize with Google to allow Fivetran to access your Google Ads account via OAuth.
Select your sync mode. You can choose Sync All Accounts, Sync Specific Accounts, or Sync Specific Manager Accounts.
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.
(Optional) If you want to sync a Custom report, click Add custom report.
a. Enter your chosen 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.
b. (Optional) Select the Report Name of the report you'd like to sync.
c. (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 rowssegments.keyword
,segments.keyword.ad_group_criterion
- adding these fields to the report may result in fetching only the rows that include the keyword criterionsegments.geo_target_*
- adding these fields to the report may result in fetching less rows than expected because not all rows can be segmented by allgeo_target
segments
NOTE: The
segments.date
field is required because the reports are synced by day. All reports without thesegments.date
field are not supported.d. Click Save.
e. Repeat the previous five steps if you want to add another Custom report.
(Optional) If you want to set the conversion window size, click Show Advanced Options to show conversion window size options.
(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.
IMPORTANT: Changing the conversion window size for the connector does not affect the conversion window settings in your Google Ads account.
Select how many months' worth of reporting data you'd like to include in your initial sync.
Click Save & Test.
Upon successful completion of the setup tests, review your schema. The schema includes your saved reports, predefined metadata, and prebuilt reports tables.
Related articleslink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration