Ads

ads_table

The Ads table aggregates data on advertising campaigns from various platforms, detailing when ads were run, through which channels, and their performance metrics such as spend, clicks, and conversions. By querying this table, users can uncover insights into the effectiveness of their ad campaigns across different platforms, optimize ad spend, and improve targeting strategies to enhance overall ad performance.

📘

Note

event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

ID	Type	Description
event_date	date	The date the ad was run. Based on the time zone of the shop at the moment of publishing.
event_date.day	date	The day on which the ad was run. Derived from event_date.
event_date.week	date	The Sunday of the week during which the ad was run. Derived from event_date.
event_date.month	date	The month during which the ad was run. Derived from event_date.
event_date.quarter	date	The first month of the quarter during which the ad was run. Derived from event_date.
event_date.year	date	The year during which the ad was run. Derived from event_date.
event_hour	string	The hour of the day the ad was run, according to a 24-hour clock. Based on the time zone of the shop at the moment of publishing. Example values: 07, 16, 21
ad_bid_amount	string	The bid amount for the ad. Example values: 15, 28, 30
ad_copy	string	The full text (copy) of the ad.
ad_id	string	The unique ad ID. Assigned by the publisher platform. Example value: 120210439891110007
ad_image_url	string	The URL of the ad image. Example value: https://www.example.com/ad-image.jpg
ad_name	string	The name of the specific ad. Example values: Kids Ad 1, Read Our Latest Blog 03/12/2023, 8 best fall looks
ad_status	string	The status of the ad. Example values: active, paused
ad_type	string	The format of the ad. Example values: video, image, copy
adset_bid_amount	string	The bid amount for the ad set. Example values: 25, 35, 40
adset_bid_strategy	string	The bidding strategy for the ad set. Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP
adset_daily_budget	string	The daily budget set for the ad set within a campaign. By default shown in the shop's currency.
adset_id	string	The unique ID for the ad set within a campaign. Assigned by the publisher platform.
adset_lifetime_budget	string	The total budget set for the ad set within a campaign over its lifetime. By default shown in the shop's currency.
adset_name	string	The name of the ad set within a campaign. Example values: Broad Audience, Bracelets, Wellness
adset_status	string	The status of the adset. Example values: active, paused
adset_targeting	record repeated	Details on targeting parameters for the adset, including specific audience segments. Learn more about adset targeting data
adset_targeting.target_key	string	The targeting category key within the adset (e.g., location, age, gender). Learn more about adset targeting data Example values: age_min, age_max, geo_locations_countries, device_platforms, genders
adset_targeting.target_values	record repeated	The specific values associated with the targeting category key, returned as an array. Learn more about adset targeting data
amazon_marketplace_id	string	The Amazon marketplace ID for the marketplace associated with the order. See list of marketplace IDs.
amazon_report_type	string	The type of report generated for Amazon advertising activities (e.g. sponsored products, sponsored brands, sponsored display).
breakdown_dimension	string	The dimension used to break down the data (e.g. country, gender, age, publisher platform, frequency).
breakdown_value	string	The value of the breakdown dimension.
campaign_bid_strategy	string	The bidding strategy for the campaign. Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP
campaign_daily_budget	string	The daily budget set for the campaign. By default shown in the shop's currency.
campaign_id	string	The unique ID for the marketing campaign associated with the ad. Assigned by the publisher platform. Example values: 23852438666180053, 531011533, 20620285829
campaign_lifetime_budget	string	The total budget set for the campaign over its lifetime. By default shown in the shop's currency.
campaign_name	string	The name of the marketing campaign associated with the ad. Example values: Catalog Retargeting, US | Generic | Search, Breakfast of Champions Campaign
campaign_status	string	The status of the campaign. Example values: active, paused
channel	string	The platform through which the ad was delivered.
currency	string	The currency used in the ad platform. Example values: USD, GBP, EUR
destination_url	string	The URL where the ad redirects users upon clicking. Example value: https://www.myshop.com/products/productA
url_template	string	A template URL used to dynamically populate ad URLs with relevant tracking parameters. Example value: utm_source=facebook&utm_campaign={{campaign.name}}
video_url	string	The URL of the ad video. Example values: https://www.youtube.com/embed/example

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Channel-Reported Ad Spend	spend	numeric	Channel-Reported Ad Spend (without Custom Expenses)
Clicks	clicks	numeric	Number of channel-reported clicks
Visits	visits	numeric	Number of channel-reported visits
Outbound Clicks	outbound_clicks	numeric	Number of channel-reported outbound clicks
Impressions	impressions	numeric	Number of channel-reported impressions
Onsite Conversion Value	onsite_conversion_value	numeric	Channel-reported revenue from purchases made on the ad channel shop (e.g. Meta Shop, TikTok Shop)
Onsite Purchases	onsite_purchases	numeric	Number of purchases made on the ad channel shop (e.g. Meta Shop, TikTok Shop)
Channel-Reported Conversion Value	conversion_value	numeric	Revenue generated from channel-reported conversions
Channel-Reported Conversions (Purchases)	conversions	numeric	The number of purchases attributed to the ad.
Google All Conversions	all_conversions	numeric	The total number of conversions of all types (e.g. purchases, registrations, subscriptions, applications), as reported by Google.
Google All Conversion Value	all_conversion_value	numeric	Revenue generated from conversions of all types (e.g. purchases, registrations, subscriptions, applications), as reported by Google.
One-Day View Purchases	one_day_view_purchases	numeric	The total number of purchases made within one day of viewing the ad.
One-Day View Conversion Value	one_day_view_conversion_value	numeric	The total value of purchases made within one day of viewing the ad.
Thruplays	thruplays	numeric	The number of times a video ad was played to completion or for at least 15 seconds.
Reach	reach	numeric	The total number of unique individuals who saw the ad.
Inline Post Engagement	inline_post_engagement	numeric	The inline engagement (likes, shares, comments) with the ad.
Three-Second Video View	three_second_video_view	numeric	The number of times a video ad was viewed for at least 3 seconds (thumbstop ratio).

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Title	ID	Type	Description
Channel-Reported Return on Ad Spend	roas	formula	Channel-Reported ROAS = Channel-Reported Conversion Value / Channel-Reported Ad Spend
Cost Per Mille	cpm	formula	Cost Per 1000 Impressions. Cost Per Mille (CPM) = Ad Spend / Impressions x 1000
Click-Through Rate	ctr	formula	Percentage of people clicking on the ad. Click-Through Rate (CTR) = Clicks / Impressions
Cost Per Click	cpc	formula	Cost for each click on an ad.
Cost Per Acquisition	cpa	formula	Cost to acquire a single paying customer. Cost Per Acquisition (CPA) = Ad Spend / Number of Conversions
Cost Per Outbound Click	cpoc	formula	Cost for each click leading out from the publisher platform to an external website. Cost Per Outbound Click (CPOC) = Ad Spend / Outbound Clicks
Revenue Per Link Click	revenue_per_link_click	formula	Average revenue generated from each outbound click on the ad. Revenue Per Link Click = Conversion Value / Outbound Clicks