# Ads performance by campaign by hour - BigQuery table name: `amazon_ads_performance_by_campaign_by_hour` - Available in: Amazon Ads - Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.md Advertising performance for each campaign and each Amazon activity hour. Filter on the local date, then group by weekday and local hour and recompute ratios from the summed measures. Hours use the advertiser's Amazon Ads profile timezone, including daylight saving. If that timezone is unknown, the local date, hour, and weekday are null. A null measure is unavailable, not zero. A missing traffic or conversion side stays null. Turning this table on does not mean the stream is subscribed, receiving, or complete for every past hour. This is not the shopper's purchase hour, and it is not hourly profit, fees, or total advertising cost of sales. - Source type: `AMAZON_ADS` - Source ID: `e22ddcc5203b6dceecebfa06a0101e44e00bd143573dbd96479fe659db96a183` - Requires a date period: yes - Contains PII: no - Premium table: no - User-managed: no - Default dataset: no - Rows count towards billing: no - Hub: https://www.datadoe.com/hub/data-scheme?source=AMAZON_ADS&table=e22ddcc5203b6dceecebfa06a0101e44e00bd143573dbd96479fe659db96a183 ## Fetch periods - `CONTINUOUS` ## Prerequisites Requires AMS Traffic and AMS Conversion. Turning this table on can turn those tables on and starts collection for every Sponsored Products, Sponsored Brands, and Sponsored Display dataset they use. This view does not store a second billed copy of those rows. Rows with row billing on a required table still count toward usage. ## Search aliases - dayparting - hour of day - weekday ## Columns (107) - `marketplace_id` (`TEXT`, required) — Amazon marketplace identifier. - `marketplace_country_code` (`TEXT`, required) — Marketplace country code. - `marketplace_country_name` (`TEXT`, required) — Marketplace country name. - `seller_or_vendor_id` (`TEXT`, required) — DataDoe seller or vendor context id. Campaign ids are not unique across accounts. - `seller_or_vendor_name` (`TEXT`, nullable) — Seller or vendor display name. Filter and group by seller_or_vendor_id. - `marketplace_seller_id` (`TEXT`, nullable) — Amazon selling partner id. Null for an Ads account with no seller id. - `amazon_ads_profile_id` (`TEXT`, nullable) — Amazon Ads profile id. - `amazon_ads_advertiser_id` (`TEXT`, nullable) — Amazon Ads advertiser id. Null when the stream did not report it. - `ad_campaign_type` (`TEXT`, required) — Sponsored Products, Sponsored Brands, or Sponsored Display. - `ad_campaign_id` (`TEXT`, required) — Amazon Ads campaign id. Use it with the Ads connection, not on its own. - `currency` (`TEXT`, required) — Currency of the measures on this row. Do not combine different currencies. - `time_window_starts_at` (`DATE`, required) — UTC start of the Amazon activity window. This is not the time the event was received. Events with no start stay on AMS Traffic and AMS Conversion and are not given an hour. - `time_window_ends_at` (`DATE`, required) — UTC end of the activity window, 1 hour after time_window_starts_at. - `reporting_timezone` (`TEXT`, nullable) — IANA timezone of the Amazon Ads profile, such as Europe/London. Null when that timezone is not verified. There is no UTC fallback. - `reporting_timezone_source` (`TEXT`, required) — ADS_PROFILE when reporting_timezone is verified. UNKNOWN when it is not. - `date` (`DATE`, nullable) — Calendar date of the activity window in reporting_timezone. Filter on this date, then group by weekday and local_hour. Null when the timezone is unknown. A retention period uses this date, so those rows are removed when retention is set. - `date_utc` (`DATE`, required) — UTC calendar date of the activity window. This is a diagnostic, not the local date. - `local_hour` (`NUMBER`, nullable) — Hour of the activity window in reporting_timezone, from 0 to 23. Null when the timezone is unknown. Repeated local hours during daylight saving stay on separate UTC windows. - `weekday` (`NUMBER`, nullable) — Local weekday of date. Monday is 1 and Sunday is 7. Null when the timezone is unknown. - `weekday_name` (`TEXT`, nullable) — English name of weekday. Use weekday for grouping. - `utc_offset_minutes` (`NUMBER`, nullable) — Minutes between the local activity time and UTC, including the daylight-saving offset. Null when the timezone is unknown. - `default_click_attribution_window_days` (`NUMBER`, nullable) — 7 for Sponsored Products and 14 for Sponsored Brands and Sponsored Display. Null for any other ad product. This chooses the default click metrics only. The 1, 7, 14, and 30 day columns stay separate. - `ad_impressions` (`NUMBER`, nullable) — Sum of impressions for this campaign and activity hour. Null when traffic was not reported. Null is not zero. - `ad_clicks` (`NUMBER`, nullable) — Sum of clicks for this campaign and activity hour. Null when traffic was not reported. Null is not zero. - `ad_view_impressions` (`NUMBER`, nullable) — Sum of view impressions for this campaign and activity hour. Null when the ad product does not report them. - `ad_viewable_impressions` (`NUMBER`, nullable) — Sum of viewable impressions for this campaign and activity hour. Null when the ad product does not report them. - `ad_spend` (`NUMBER`, nullable) — Sum of ad spend for this campaign and activity hour, in currency. Null when traffic was not reported. - `ad_attributed_conversions_1d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_1d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_7d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_7d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_14d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_30d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_conversions_30d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_1d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_1d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_7d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_7d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_14d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_30d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_30d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_1d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_1d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_7d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_7d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_14d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_30d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_30d_same_sku` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_conversions_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_sales_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_units_ordered_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_orders_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_sales_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_attributed_units_ordered_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_orders_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_sales_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_view_attributed_units_ordered_new_to_brand_14d` (`NUMBER`, nullable) — Sum of this Amazon Marketing Stream attribution measure for the campaign and activity hour. The window, same-SKU, new-to-brand, and view-through meanings stay separate. Null when conversion was not reported. This is an advertising outcome on the activity hour, not the purchase hour. - `ad_click_attributed_conversions` (`NUMBER`, nullable) — Click conversions for the default window: 7 days for Sponsored Products, 14 days for Sponsored Brands and Sponsored Display. Null when that window or the conversion side is unavailable. - `ad_click_attributed_sales` (`NUMBER`, nullable) — Click sales for the default attribution window, in currency. Null when that window or the conversion side is unavailable. - `ad_click_attributed_units_ordered` (`NUMBER`, nullable) — Click units ordered for the default attribution window. Null when that window or the conversion side is unavailable. - `ad_cpc` (`NUMBER`, nullable) — Cost per click: ad spend divided by clicks. Money per click, in currency. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_ctr` (`NUMBER`, nullable) — Click-through rate: clicks divided by impressions. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr` (`NUMBER`, nullable) — Default click conversion rate: ad_click_attributed_conversions divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos` (`NUMBER`, nullable) — Default click advertising cost of sales: ad spend divided by ad_click_attributed_sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas` (`NUMBER`, nullable) — Default click return on ad spend: ad_click_attributed_sales divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_1d` (`NUMBER`, nullable) — Click conversion rate for the 1-day conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_1d` (`NUMBER`, nullable) — Advertising cost of sales for the 1-day sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_1d` (`NUMBER`, nullable) — Return on ad spend for the 1-day sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_1d_same_sku` (`NUMBER`, nullable) — Click conversion rate for the 1-day same-SKU conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_1d_same_sku` (`NUMBER`, nullable) — Advertising cost of sales for the 1-day same-SKU sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_1d_same_sku` (`NUMBER`, nullable) — Return on ad spend for the 1-day same-SKU sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_7d` (`NUMBER`, nullable) — Click conversion rate for the 7-day conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_7d` (`NUMBER`, nullable) — Advertising cost of sales for the 7-day sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_7d` (`NUMBER`, nullable) — Return on ad spend for the 7-day sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_7d_same_sku` (`NUMBER`, nullable) — Click conversion rate for the 7-day same-SKU conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_7d_same_sku` (`NUMBER`, nullable) — Advertising cost of sales for the 7-day same-SKU sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_7d_same_sku` (`NUMBER`, nullable) — Return on ad spend for the 7-day same-SKU sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_14d` (`NUMBER`, nullable) — Click conversion rate for the 14-day conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_14d` (`NUMBER`, nullable) — Advertising cost of sales for the 14-day sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_14d` (`NUMBER`, nullable) — Return on ad spend for the 14-day sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_14d_same_sku` (`NUMBER`, nullable) — Click conversion rate for the 14-day same-SKU conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_14d_same_sku` (`NUMBER`, nullable) — Advertising cost of sales for the 14-day same-SKU sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_14d_same_sku` (`NUMBER`, nullable) — Return on ad spend for the 14-day same-SKU sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_30d` (`NUMBER`, nullable) — Click conversion rate for the 30-day conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_30d` (`NUMBER`, nullable) — Advertising cost of sales for the 30-day sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_30d` (`NUMBER`, nullable) — Return on ad spend for the 30-day sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_cvr_30d_same_sku` (`NUMBER`, nullable) — Click conversion rate for the 30-day same-SKU conversions, divided by clicks. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_acos_30d_same_sku` (`NUMBER`, nullable) — Advertising cost of sales for the 30-day same-SKU sales. Ad spend divided by those sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_roas_30d_same_sku` (`NUMBER`, nullable) — Return on ad spend for the 30-day same-SKU sales, divided by ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_view_acos_14d` (`NUMBER`, nullable) — View-through advertising cost of sales using 14-day view sales. Separate from click advertising cost of sales. A decimal ratio. 0.25 means 25%. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `ad_view_roas_14d` (`NUMBER`, nullable) — View-through return on ad spend using 14-day view sales. Separate from click return on ad spend. A multiple, not a percentage. — definition: `Divide the numerator by the denominator only when both values are available, the numerator is zero or greater, and the denominator is greater than zero. Otherwise null. When you group rows, divide the summed numerator by the summed denominator. Do not average this ratio.` - `traffic_source_rows` (`NUMBER`, required) — Count of canonical AMS Traffic events in this row, after repeated deliveries of the same idempotency id are collapsed. 0 when only conversion data is present. This does not prove every hour was collected. - `conversion_source_rows` (`NUMBER`, required) — Count of canonical AMS Conversion events in this row. 0 when only traffic data is present. This is not the conversion count. - `traffic_data_present` (`LOGIC`, required) — True when traffic_source_rows is greater than zero. - `conversion_data_present` (`LOGIC`, required) — True when conversion_source_rows is greater than zero. - `traffic_first_received_at` (`DATE`, nullable) — Earliest received time among the traffic events in this row. Null when traffic is absent. - `traffic_last_received_at` (`DATE`, nullable) — Latest received time among the traffic events in this row. Null when traffic is absent. - `conversion_first_received_at` (`DATE`, nullable) — Earliest received time among the conversion events in this row. Null when conversion is absent. - `conversion_last_received_at` (`DATE`, nullable) — Latest received time among the conversion events in this row. Null when conversion is absent. - `source_last_updated_at` (`DATE`, nullable) — Latest source dt_updated across the traffic and conversion events in this row. - `source_presence` (`TEXT`, required) — BOTH, TRAFFIC_ONLY, or CONVERSION_ONLY. This shows which side contributed. It does not mean collection is complete. - `has_negative_aggregates` (`LOGIC`, required) — True when any summed traffic or conversion measure is below zero. Negative corrections stay in the measure. - `dt_created` (`DATE`, nullable) — Earliest source dt_created among the events in this row. Not the time this view was built. - `dt_updated` (`DATE`, nullable) — Same timestamp as source_last_updated_at. Not the current time. --- Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.