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
-
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
-
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 report.
-
Enter your chosen destination table name. It must be unique within the connector.
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 Configuration Type: Pre-built Report or Custom Report.
-
If you choose Use Pre-built Report, select one of the available Prebuilt Reports you'd like to sync.
-
If you choose Use Custom Report, select which 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: Universal App Campaigns only support a small subset of reports and will result in no data delivered for any other report type.
Note: The following reports are not supported:
- BUDGET_PERFORMANCE_REPORT
- CAMPAIGN_CRITERIA_REPORT
- CAMPAIGN_GROUP_PERFORMANCE_REPORT
- CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT
- CAMPAIGN_NEGATIVE_LOCATIONS_REPORT
- CAMPAIGN_NEGATIVE_PLACEMENTS_PERFORMANCE_REPORT
- CAMPAIGN_SHARED_SET_REPORT
- LABEL_REPORT
- SHARED_SET_CRITERIA_REPORT
- SHARED_SET_REPORT
-
Click OK to save the report.
-
If you want to add another report, repeat steps 6 — 11.
-
(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.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration