rpt_ad_performance_daily

Daily platform-native advertising performance rows. Grain is not unique at the visible keys: hidden sub-ad breakdowns can produce multiple rows for (sm_store_id, source_system, sm_channel, date, ad_id), and ad_id may be NULL. Aggregate metrics before reporting; do not deduplicate or treat (source_system, ad_id) as unique.

Date field: date.
Filters to start with: sm_channel and source_system. Blend with rpt_executive_summary_daily by date and sm_channel.

Query examples

Marketing & Ads

Columns

Column	Type	Description
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`ad_account_id`	STRING	The unique identifier for the ad account that is associated with the ad.
`ad_account_name`	STRING	The name of the ad account that is associated with the ad.
`ad_campaign_id`	STRING	The unique identifier for the campaign that is associated with the ad.
`ad_campaign_name`	STRING	The name of the campaign that is associated with the ad.
`ad_campaign_tactic`	STRING	The tactic of the campaign derived from campaign naming conventions. Possible values are “Prospecting”, “Retargeting”, and “Brand”. Default is “Prospecting”.
`ad_campaign_type`	STRING	The type of campaign that is associated with the ad, such as reach, discovery, search, display, or video (this campaign type will vary by advertising platform).
`ad_clicks`	INT64	The number of times the ad was clicked.
`ad_creative_body`	STRING	The body copy of the ad creative used for the ad.
`ad_creative_call_to_action_type`	STRING	The type of call-to-action used in the ad creative, such as “order now” or “sign up” (the call to action type will vary by advertising platform).
`ad_creative_facebook_url`	STRING	The URL of the ad creative as it appears on Facebook.
`ad_creative_id`	STRING	The unique identifier for the ad creative that is associated with the ad.
`ad_creative_image_url`	STRING	The URL of the image used in the ad creative.
`ad_creative_instagram_url`	STRING	The URL of the ad creative as it appears on Instagram.
`ad_creative_link_params`	STRING	The URL parameters used in the ad creative link.
`ad_creative_thumbnail_url`	STRING	The URL of the thumbnail image used in the ad creative.
`ad_creative_title`	STRING	The title of the ad creative used for the ad.
`ad_group_id`	STRING	The unique identifier for the ad group that contains the ad. Used to group related ads within a campaign for organizational and reporting purposes.
`ad_group_name`	STRING	The name of the ad group that contains the ad. Provides human-readable identification for ad set organization within campaigns.
`ad_id`	STRING	The unique identifier for the ad.
`ad_impressions`	INT64	The number of times the ad was shown.
`ad_inline_link_clicks`	INT64	The number of clicks on links within the ad that led users to advertiser-specified destinations. Subset of total ad_clicks; excludes non-link engagement clicks (e.g., likes, comments).
`ad_name`	STRING	The name of the ad.
`ad_platform_campaign_objective`	STRING	The objective of the campaign that is associated with the ad, such as “maximize conversion” or “target impression share” (the campaign objective will vary by advertising platform).
`ad_platform_reported_conversion_windows`	STRUCT	Platform-reported conversions by attribution window. The struct is populated only when the upstream adapter supplies window detail and is null otherwise. Meta supplies populated structs; unsupported fields within those structs are zero.
`ad_platform_reported_conversion_windows._1d_click`	FLOAT64
`ad_platform_reported_conversion_windows._1d_ev`	FLOAT64
`ad_platform_reported_conversion_windows._1d_view`	FLOAT64	Platform-reported conversions using a 1-day view attribution window (Meta Ads-specific window).
`ad_platform_reported_conversion_windows._28d_click`	FLOAT64
`ad_platform_reported_conversion_windows._7d_click`	FLOAT64	Platform-reported conversions using a 7-day click attribution window (Meta Ads-specific window).
`ad_platform_reported_conversion_windows._7d_view`	FLOAT64
`ad_platform_reported_conversion_windows.default_window`	FLOAT64	Platform-reported conversions for the platform’s default attribution value. For Meta, that is the attribution setting on the ad set. Meta’s own default for that setting is 7-day click, 1-day view.
`ad_platform_reported_conversions`	FLOAT64	The number of conversions attributable to the ad, as reported by the advertising platform.
`ad_platform_reported_revenue`	FLOAT64	The amount of revenue attributable to the ad, as reported by the advertising platform. Google Ads, Meta, TikTok, AppLovin, and Snapchat use the workspace reporting currency when reporting-currency conversion is enabled. Amazon Ads revenue is always in the store currency (Currency & region). Other sources stay in the account currency.
`ad_platform_reported_revenue_windows`	STRUCT	Platform-reported revenue by attribution window. The struct is populated only when the upstream adapter supplies window detail and is null otherwise. Meta supplies populated structs; unsupported fields within those structs are zero.
`ad_platform_reported_revenue_windows._1d_click`	FLOAT64
`ad_platform_reported_revenue_windows._1d_ev`	FLOAT64
`ad_platform_reported_revenue_windows._1d_view`	FLOAT64	Platform-reported revenue using a 1-day view attribution window (Meta Ads-specific window).
`ad_platform_reported_revenue_windows._28d_click`	FLOAT64
`ad_platform_reported_revenue_windows._7d_click`	FLOAT64	Platform-reported revenue using a 7-day click attribution window (Meta Ads-specific window).
`ad_platform_reported_revenue_windows._7d_view`	FLOAT64
`ad_platform_reported_revenue_windows.default_window`	FLOAT64	Platform-reported revenue for the platform’s default attribution value. For Meta, that is the attribution setting on the ad set. Meta’s own default for that setting is 7-day click, 1-day view.
`ad_spend`	NUMERIC	The amount spent on the ad. Google Ads, Meta, TikTok, AppLovin, and Snapchat use the workspace reporting currency when reporting-currency conversion is enabled. Amazon Ads spend is always in the store currency (Currency & region). Other sources stay in the account currency.
`date`	DATE	The date when the ad was delivered.
`sm_channel`	STRING	The sales channel associated with the ad.
`source_system`	STRING	The advertising source system used to deliver the ad.
`sub_channel`	STRING	Sub-channel classification for the ad, typically derived from campaign naming or ad platform specifics. Provides additional granularity beyond sm_channel for channel-specific analysis (e.g., Affiliate, Brand, Retargeting).

Advertising accounts can use different source currencies. When reporting-currency conversion is enabled, SourceMedium converts Google Ads, Meta, TikTok, AppLovin, and Snapchat one account at a time before combining them in the workspace reporting currency. Amazon Ads spend and platform-reported revenue are always in the currency on your SourceMedium store (Currency & region), including when that conversion is off, and they are not converted again with those platforms. Your store currency can differ from the workspace reporting currency. Other advertising sources stay in their account currency. Reconcile by source_system and ad_account_id. See Reporting Currency.

Get into BigQuery

Activate

SQL Query Library

Common analyses (SQL)

Tables

Schema Standards

rpt_ad_performance_daily

Query examples

Columns

​Query examples

​Columns

Query examples

Columns