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.
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_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
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.