How Do the TikTok Ads CREATIVE_HISTORY, SMART_PLUS_AD_HISTORY, and AD_HISTORY Tables Differ?

Question

What is the difference between the CREATIVE_HISTORY, SMART_PLUS_AD_HISTORY, and AD_HISTORY tables?

Environment

Connector: TikTok Ads

Answer

Fivetran supports multiple TikTok Ads history tables for different levels of ad data:

• CREATIVE_HISTORY captures Smart+ creative-level metadata. Use this table when you need details about creative assets associated with Smart+ campaigns.
• SMART_PLUS_AD_HISTORY captures Smart+ ad-level metadata and identifiers for upgraded Smart+ ads. Use this table when you need Smart+ ad-level data.
• AD_HISTORY syncs ad history data. It includes duplicated creatives data for upgraded Smart+ campaigns, but Fivetran eventually plans to remove that duplicated data. For updates, see our TikTok Ads Release Notes.

We recommend using CREATIVE_HISTORY for Smart+ creative-level queries, SMART_PLUS_AD_HISTORY for Smart+ ad-level queries, and AD_HISTORY for manual non-Smart+ ad queries.