How Can I Speed Up My Google Ads Historical Syncs?

Find out why syncs slow down and how to speed them up by separating metadata and statistics tables.

Why are historical syncs slow?

When we run a historical sync for Google Ads connections, we first sync the metadata tables, followed by the statistics tables. It often takes longer to sync metadata tables, particularly if you sync data for many accounts.

How to speed up historical syncs?

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

However, if you have not created the connection, you can save time by separating the metadata and statistics tables into two connectors. For example, google_ads_metadata and google_ads_statistics.

To create a connection for only metadata tables, include the following tables:

• LABEL
• GEO_TARGET
• MOBILE_DEVICE
• OPERATING_SYSTEM_VERSION
• TOPIC
• USER_INTEREST
• USER_LIST
• All tables ending with _HISTORY

All remaining tables are statistics tables.

IMPORTANT: Separating the data will result in two separate schemas. If you want to merge the data after creating two separate connections, you must do so manually.