Missing AD_HISTORY and CREATIVE_HISTORY Tables

Issue

I can see ads in the AD_LEVEL_REPORT table. However, the AD_HISTORY and CREATIVE_HISTORY tables are missing from my destination.

Environment

Connector: Apple Search Ads

Resolution

To ensure the AD_HISTORY and CREATIVE_HISTORY tables populate in your destination, you must create at least one custom ad in your Apple Search Ads account. We don't populate these tables if you only use default ads

For more information on default and custom ads, see the Apple documentation on creating ad variations.

Cause

This issue occurs when your Apple Search Ads account has only default ads. Apple doesn't provide ad_id values for these ads, so we assign a placeholder value of -1 in the AD_LEVEL_REPORT table. However, it's not possible to track ads without ad_id values historically, so we don't populate the AD_HISTORY and CREATIVE_HISTORY tables with these ads. In addition, we don't populate these tables if no matching data exists.