Why Do I See IDs in Performance Tables but Not in Metadata Tables?

Question

Why do I see ad_id, ad_group_id, or campaign_id values in Microsoft Advertising performance report tables, such as AD_PERFORMANCE_DAILY_REPORT, AD_GROUP_PERFORMANCE_DAILY_REPORT, or CAMPAIGN_PERFORMANCE_DAILY_REPORT, but not in their matching *_history metadata tables?

Environment

Connector: Microsoft Advertising

Answer

Fivetran populates performance report tables with data from the Microsoft Reporting API, which includes historical metrics for objects that were deleted, removed, or expired in the source account.

However, we populate the metadata *_HISTORY tables with data from the Microsoft Bulk API, which excludes deleted, removed, or expired objects. As a result, performance report tables can contain ad_id, ad_group_id, or campaign_id values that don't appear in the corresponding metadata *_HISTORY tables.

After an object is deleted, removed, or expired in the source account, we no longer sync its metadata row, but continue to retain historical performance metrics for reporting and analysis.