Follow our setup guide to connect Google Ads to Fivetran.
To connect Google Ads to Fivetran, you need a Google Ads account.
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 Configurationlink
Enter your chosen destination schema name in the connector setup form.
Enter the Google Ads customer ID you found in Step 1.
Click Authorize 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.
Click Add custom report.
Enter your chosen destination table name. 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.
Select the reports and fields you’d like to sync. Use the following Google resources to choose your reports and fields. Note that the
Datefield is required because the reports are synced by day.
NOTE: App Campaigns only support a small subset of reports. No data will be synced for any other report types.
NOTE: The following reports are not supported:
Click OK to save the report.
If you want to add another report, repeat steps 6 — 9.
(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.
Select how many months 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.