> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# rpt_ad_creative_assets

> Every headline, text, image, video and call to action each ad carries, for creative analysis.

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

```sql theme={null}
SELECT
  ad_id,
  asset_text AS headline,
  asset_pinned_position,
  asset_performance_label
FROM `your_project.sm_transformed_v2.rpt_ad_creative_assets`
WHERE source_system = 'Google Ads'
  AND asset_role = 'title'
ORDER BY ad_id, asset_position
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.