- 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
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 using the default attribution window for the platform (e.g., Meta Ads default blended window). |
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. Uses the workspace reporting currency when reporting-currency conversion is enabled. |
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 using the default attribution window for the platform (e.g., Meta Ads default blended window). |
ad_spend | NUMERIC | The amount spent on the ad. Uses the workspace reporting currency when reporting-currency conversion is enabled. |
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. SourceMedium converts Google Ads, Meta, TikTok, AppLovin, and Snapchat accounts separately before combining results in the workspace reporting currency. Other advertising sources stay in their native currency unless SourceMedium has enabled conversion for that surface. Reconcile by
source_system and ad_account_id; see Reporting Currency.