rpt_ad_performance_daily shows one primary asset per ad in its ad_creative_* columns. This table lists all of them, and is_primary_asset marks the one the report shows.
- Join to performance:
(sm_store_id, source_system, ad_id)torpt_ad_performance_daily. Performance Max assets belong to an asset group:ad_idis NULL,ad_group_idis the asset group, and they join the report’s Performance Max rows onad_creative_id. - Variants: Meta (Advantage+ and flexible creatives), Google Ads (responsive search, display, Demand Gen, video and Performance Max), TikTok (including every creative of an Upgraded Smart+ ad) and Microsoft Advertising list every asset variant. Other platforms serve one creative per ad, so their rows are that creative’s values.
- Roles:
asset_rolenames therpt_ad_performance_dailycolumn the asset would fill (title,body,description,image,video,call_to_action,website_url), pluslogo,business_nameandother.asset_platform_rolekeeps the platform’s own field name. - State, not history: rows describe each creative as it is now; they are not dated.

