Google Ads

This page contains the setup guide and reference information for Google Ads.

Prerequisites

• A Google account with access to the Google Ads accounts you want to sync.
• If the accounts are accessed through a Google Ads Manager account, make sure the same Google account can access that manager account.

Features

Feature	Supported?
Full Refresh Sync	Yes
Incremental Sync	Yes
Namespaces	No

Setup guide

1. Select Google Ads from the Source list.

2. Enter a Source Name.

3. Click Sign in with Google to authenticate your Google Ads account. In the pop-up, select the appropriate Google account and click Continue to proceed.

4. If the customer accounts are accessed through a manager account, select the Manager Account first, then refresh the Google Ads Accounts dropdown. To remove a selected manager account, open the Manager Account dropdown and select No manager account.

5. Select one or more Google Ads Accounts from the account dropdown. The list is loaded from the Google account you authorized with OAuth, or from the selected manager account when one is configured.

6. (Optional) Enter a Start Date in YYYY-MM-DD format. The data added on and after this date will be replicated. Default start date is 2 years ago.

7. (Optional) Enter an End Date in YYYY-MM-DD format. Any data added after this date will not be replicated. Leaving this field blank will replicate all data from the start date onward.

8. (Advanced, optional) Enter a Conversion Window. This is the number of days after an ad interaction during which a conversion is recorded in Google Ads. For more information on this topic, refer to the Google Ads Help Center. This field defaults to 14 days.

9. (Advanced, optional) Open Advanced settings to add Custom GAQL Queries only when the standard streams do not cover the report you need. Click Add and enter your query, as well as the desired name of the table for this data in the destination. Multiple queries can be provided. For more information on formulating these queries, refer to our guide below.

10. Click Save & Test.

Supported streams

This source is capable of syncing the following streams:

Main Tables

• customer
• customer_label
• campaign_criterion
• campaign_bidding_strategy
• campaign_label
• label
• ad_group_ad
• ad_group_ad_label
• ad_group
• ad_group_label
• ad_group_bidding_strategy
• ad_group_criterion
• ad_listing_group_criterion
• ad_group_criterion_label
• audience
• user_interest
• click_view

Report Tables

• account_performance_report
• campaign
• campaign_budget
• geographic_view
• user_location_view
• display_keyword_view
• topic_view
• shopping_performance_view
• keyword_view
• ad_group_ad_legacy

Troubleshooting

1. This source is constrained by the Google Ads API limits.

Due to a limitation in the Google Ads API which does not allow getting performance data at a granularity level smaller than a day, the Google Ads connector usually pulls data up until the previous day. For example, if the sync runs on Wednesday at 5 PM, then data up until Tuesday midnight is pulled. Data for Wednesday is exported only if a sync runs after Wednesday (for example, 12:01 AM on Thursday) and so on. This avoids syncing partial performance data, only to have to resync it again once the full day's data has been recorded by Google. For example, without this functionality, a sync which runs on Wednesday at 5 PM would get ads performance data for Wednesday between 12:01 AM - 5 PM on Wednesday, then it would need to run again at the end of the day to get all of Wednesday's data.

2. Max number of tables that can be synced at a time is 6,000. We advise you to adjust your settings if it fails to fetch schema due to max number of tables reached.