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_dateis a required field for queries on this table.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| ID | Type | Description | Source |
|---|---|---|---|
event_date | date | The date the ad was run. Based on the time zone of the shop at the moment of publishing. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
event_date.day | date | The day on which the ad was run. Derived from event_date. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
event_date.week | date | The Sunday of the week during which the ad was run. Derived from event_date. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
event_date.month | date | The month during which the ad was run. Derived from event_date. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
event_date.quarter | date | The first month of the quarter during which the ad was run. Derived from event_date. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
event_date.year | date | The year during which the ad was run. Derived from event_date. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
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 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
channel | string | The platform through which the ad was delivered. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
campaign_id | string | The unique ID for the marketing campaign associated with the ad. Assigned by the publisher platform. Example values: 23852438666180053, 531011533, 20620285829 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
ad_set_id | string | The unique ID for the ad set within a campaign. Assigned by the publisher platform. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Klaviyo, Taboola, Outbrain |
ad_id | string | The unique ad ID. Assigned by the publisher platform. Example value: 120210439891110007 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Taboola, Outbrain |
campaign_name | string | The name of the marketing campaign associated with the ad. Example values: Catalog Retargeting, US | Generic | Search, Breakfast of Champions Campaign | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
ad_set_name | string | The name of the ad set within a campaign. Example values: Broad Audience, Bracelets, Wellness | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Klaviyo |
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 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Taboola, Outbrain |
ad_status | string | The status of the ad. Example values: active, paused | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Outbrain |
campaign_status | string | The status of the campaign. Example values: active, paused | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Klaviyo |
adset_status | string | The status of the adset. Example values: active, paused | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Klaviyo |
currency | string | The currency used in the ad platform. Example values: USD, GBP, EUR | Criteo, Yotpo Email and SMS, Taboola, Outbrain |
ad_copy | string | The full text (copy) of the ad. | Facebook, Google, TikTok |
ad_image_url | string | [The URL of the ad image. Example value: https://www.example.com/ad-image.jpg | Facebook, Google, TikTok |
ad_type | string | The format of the ad. Example values: video, image, copy | Facebook, Google, TikTok |
video_url | string | The URL of the ad video. Example values: https://www.youtube.com/embed/example | Facebook, Google, TikTok |
breakdown_dimension | string | The dimension used to break down the data (e.g. country, gender, age, publisher platform, frequency). | Facebook, Google, TikTok, Mountain |
breakdown_value | string | The value of the breakdown dimension. | |
campaign_daily_budget | string | The daily budget set for the campaign. By default shown in the shop's currency. | Facebook, Criteo |
adset_daily_budget | string | The daily budget set for the ad set within a campaign. By default shown in the shop's currency. | Facebook, Criteo |
campaign_lifetime_budget | string | The total budget set for the campaign over its lifetime. By default shown in the shop's currency. | Facebook, Criteo |
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. | Facebook, Criteo |
campaign_bid_strategy | string | The bidding strategy for the campaign. Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP | Criteo, Facebook |
adset_bid_strategy | string | The bidding strategy for the ad set. Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP | Criteo, Facebook |
ad_bid_amount | string | The bid amount for the ad. Example values: 15, 28, 30 | |
adset_bid_amount | string | The bid amount for the ad set. Example values: 25, 35, 40 | |
amazon_marketplace_id | string | The Amazon marketplace ID for the marketplace associated with the order. See list of marketplace IDs. | Amazon |
amazon_report_type | string | The type of report generated for Amazon advertising activities (e.g. sponsored products, sponsored brands, sponsored display). | Amazon |
Measures
Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.
| Title | ID | Type | Description | Source |
|---|---|---|---|---|
| Channel-Reported Ad Spend | spend | numeric | Channel-Reported Ad Spend (without Custom Expenses) | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Yotpo Email and SMS, Taboola, Outbrain |
| Clicks | clicks | numeric | Number of channel-reported clicks | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
| Visits | visits | numeric | Number of channel-reported visits | Criteo, Mountain, Taboola |
| Outbound Clicks | outbound_clicks | numeric | Number of channel-reported outbound clicks | |
| Impressions | impressions | numeric | Number of channel-reported impressions | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Taboola, Outbrain |
| Meta Conversion Value | meta_conversion_value | numeric | Channel-reported revenue from purchases made on Facebook/Instagram/Meta Shop | |
| Meta Purchases | meta_purchases | numeric | Number of purchases made on Facebook/Instagram/Meta Shop | |
| Channel-Reported Conversion Value | conversion_value | numeric | Revenue generated from channel-reported conversions | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
| Channel-Reported Conversions (Purchases) | conversions | numeric | The number of purchases attributed to the ad. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
| 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, Taboola, Outbrain |
| 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. | Google, Taboola, Outbrain |
| One-Day View Purchases | one_day_view_purchases | numeric | The total number of purchases made within one day of viewing the ad. | Facebook, Criteo |
| One-Day View Conversion Value | one_day_view_conversion_value | numeric | The total value of purchases made within one day of viewing the ad. | Facebook, Criteo |
| 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). | Facebook, Google, TikTok, Twitter |
Derived
Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.
| Title | ID | Type | Description | Source |
|---|---|---|---|---|
| Channel-Reported Return on Ad Spend | roas | formula | Channel-Reported ROAS = Channel-Reported Conversion Value / Channel-Reported Ad Spend | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |
| Cost Per Mille | cpm | formula | Cost Per 1000 Impressions. Cost Per Mille (CPM) = Ad Spend / Impressions x 1000 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Yotpo Email and SMS, Taboola, Outbrain |
| Click-Through Rate | ctr | formula | Percentage of people clicking on the ad. Click-Through Rate (CTR) = Clicks / Impressions | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Taboola, Outbrain |
| Cost Per Click | cpc | formula | Cost for each click on an ad. | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Yotpo Email and SMS, Taboola, Outbrain |
| Cost Per Acquisition | cpa | formula | Cost to acquire a single paying customer. Cost Per Acquisition (CPA) = Ad Spend / Number of Conversions | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Yotpo Email and SMS, Taboola, Outbrain |
| 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 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Yotpo Email and SMS, Taboola, Outbrain |
| 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 | Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain |