How Can I Speed Up My Historical Syncs?

Introduction

Historical syncs often take longer than expected. How can I speed up the process?

Environment

Connector: Google Ads

Answer

If you have created the connector and triggered the historical sync, your only option is to wait for the sync to complete. However, if you have not created the connector, you can save time by separating the metadata and statistics tables into two connectors. For example, google_ads_metadata and google_ads_statistics.

When we run a historical sync for Google Ads connectors, 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. By separating the data into two connectors you don't have to wait for both sync processes to complete before you can access data.

To create a connector 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 connectors, you must do so manually.