Skip to main content
Every creative asset of every ad, one row per asset: each headline, primary text, description, image, video, logo, call to action, destination URL and business name an ad carries. Where the platform reports them, rows also carry the asset’s pinned position, the platform’s performance label (Google Ads and Microsoft Advertising rate each asset, for example BEST, GOOD or LOW) and its serving status. 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) to rpt_ad_performance_daily. Performance Max assets belong to an asset group: ad_id is NULL, ad_group_id is the asset group, and they join the report’s Performance Max rows on ad_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_role names the rpt_ad_performance_daily column the asset would fill (title, body, description, image, video, call_to_action, website_url), plus logo, business_name and other. asset_platform_role keeps the platform’s own field name.
  • State, not history: rows describe each creative as it is now; they are not dated.

Example: compare a search ad’s headlines by Google’s rating