Introduction

If the historical sync of a Google Ads connector is taking longer than expected, follow the steps below for help with speeding up the process.

Environment

Connector: Google Ads

Speeding Up the Historical Sync

If you have already created the connector and triggered the initial historical sync, your only option is to wait for the sync to complete.

However, if you have not created the connector yet, you can split the metadata tables from the statistics tables into two separate connectors (e.g., google_ads_metadata and google_ads_statistics). This will mean that the data will be in two separate schemas, but it's easy to join the data subsequently. The metadata tables are the following:

• All tables ending with _history
• The label, geo_target, mobile_device, operating_system_version, topic, user_interest and user_list tables

Cause

Our sync strategy replicates both metadata and statistics tables from Google within each connector. The metadata tables are synced first with a single-threaded approach, while the statistics tables are synced subsequently with a multi-threaded approach.

If you are planning to sync data for many accounts (in the hundreds for example) and want to set the historical timeframe to ALL TIME, these initial syncs may take a number of weeks to complete as the metadata syncs can take a lot of time.