Criteo Retail Media fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Criteo Retail Media data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

73 metrics228 dimensions

ACCOUNT

campaign_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
campaign_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
campaign_a__campaign__account_currency
Field label Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
line_item_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
line_item_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
line_item_a__line_item__account_currency
Field label Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
product_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
product_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
product_a__product__account_currency
Field label Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
page_type_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
page_type_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
page_type_a__page_type__account_currency
Field label Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
keyword_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
keyword_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
keyword_a__keyword__account_currency
Field label Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
attributed_transaction_a__account
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
attributed_transaction_a__account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value

AD DELIVERY

attributed_transaction_a__attributed_transaction__line_item_name
Field label Line item name
Description Line item name of the requested report
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__line_item_id
Field label Line item ID
Description Line item ID of the requested report
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__retailer_name
Field label Retailer name
Description Retailer name of the retailer the line item served on
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__page_type_name
Field label Page type
Description Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc.
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__keyword
Field label Keyword
Description Keyword or phrase used to land on the search page where an ad creative rendered
Field type dimension
Data type string.text.value

ASSISTED SALES

line_item_a__line_item__assisted_sales
Field label Assisted sales
Description Assisted sales
Field type metric
Data type float.currency.value
line_item_a__line_item__assisted_units
Field label Assisted units
Description Assisted units
Field type metric
Data type int.number.value

ATTRIBUTION

attributed_transaction_a__attributed_transaction__adv_engagement
Field label Advertisement engagement
Description Type of ad engagement the purchase was attributed to
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__adv_to_purchased_product_relationship
Field label Advertisement to purchased product relationship
Description Attribution rule used to match the impression or click to a sale
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__sales_channel
Field label Sales channel
Description Sales channel the attributed purchase was made through
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__attribution_window
Field label Attribution window
Description Click and view attribution window of the requested report
Field type dimension
Data type string.text.value
campaign_a__campaign__attributed_orders
Field label Orders
Description Attributed orders
Field type metric
Data type int.number.value
campaign_a__campaign__attributed_units
Field label Units
Description The number of units sold that can be attributed to your ads
Field type metric
Data type int.number.value
campaign_a__campaign__attributed_sales
Field label Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
campaign_a__campaign__roas
Field label ROAS
Description Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend
Field type metric
Data type float.number.ratio
line_item_a__line_item__attributed_orders
Field label Orders
Description Attributed orders
Field type metric
Data type int.number.value
line_item_a__line_item__attributed_units
Field label Units
Description The number of units sold that can be attributed to your ads
Field type metric
Data type int.number.value
line_item_a__line_item__attributed_sales
Field label Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
line_item_a__line_item__roas
Field label ROAS
Description Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend
Field type metric
Data type float.number.ratio
product_a__product__attributed_orders
Field label Orders
Description Attributed orders
Field type metric
Data type int.number.value
product_a__product__attributed_units
Field label Units
Description The number of units sold that can be attributed to your ads
Field type metric
Data type int.number.value
product_a__product__attributed_sales
Field label Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
product_a__product__roas
Field label ROAS
Description Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend
Field type metric
Data type float.number.ratio
page_type_a__page_type__attributed_orders
Field label Orders
Description Attributed orders
Field type metric
Data type int.number.value
page_type_a__page_type__attributed_units
Field label Units
Description The number of units sold that can be attributed to your ads
Field type metric
Data type int.number.value
page_type_a__page_type__attributed_sales
Field label Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
page_type_a__page_type__roas
Field label ROAS
Description Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend
Field type metric
Data type float.number.ratio
keyword_a__keyword__attributed_orders
Field label Orders
Description Attributed orders
Field type metric
Data type int.number.value
keyword_a__keyword__attributed_units
Field label Units
Description The number of units sold that can be attributed to your ads
Field type metric
Data type int.number.value
keyword_a__keyword__attributed_sales
Field label Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
keyword_a__keyword__roas
Field label ROAS
Description Return on ad spend (ROAS) is calculated by dividing the number of Attributed sales by the total Ad spend
Field type metric
Data type float.number.ratio
attributed_transaction_a__attributed_transaction__attributed_sales
Field label Attributed sales
Description Sales revenue attributed to a click or impression
Field type metric
Data type float.currency.value
attributed_transaction_a__attributed_transaction__attributed_units
Field label Attributed units
Description Units sold attributed to a click or impression
Field type metric
Data type int.number.value

BRAND & PRODUCT

product_a__product__brand_id
Field label Brand ID
Description Advertised product brand ID
Field type dimension
Data type string.text.value
product_a__product__brand_name
Field label Brand name
Description Advertised product brand name; names are standardized across retailers
Field type dimension
Data type string.text.value
product_a__product__adv_product_id
Field label Advertised product ID
Description Advertised product ID; this references the same ID used in Catalogs
Field type dimension
Data type string.text.value
product_a__product__adv_product_name
Field label Advertised product name
Description Advertised product name
Field type dimension
Data type string.text.value
product_a__product__adv_product_category
Field label Advertised product category
Description Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories
Field type dimension
Data type string.text.value

CAMPAIGN

campaign_a__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_a__campaign_id
Field label Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_a__campaign_type
Field label Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
campaign_a__status
Field label Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
campaign_a__promoted_brands_ids
Field label Promoted brands IDs
Description A list of the brand IDs that are being promoted in the campaign
Field type dimension
Data type string.text.value
campaign_a__click_attribution_window
Field label Click attribution window
Description The length of time that clicks are attributed to the campaign
Field type dimension
Data type string.text.value
campaign_a__view_attribution_window
Field label View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value
campaign_a__budget
Field label Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
campaign_a__budget_spent
Field label Budget spent
Description The amount of budget that has been spent so far on the campaign
Field type dimension
Data type float.currency.value
campaign_a__budget_remaining
Field label Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type float.currency.value
campaign_a__created_at
Field label Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
campaign_a__updated_at
Field label Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
campaign_a__created_at_date
Field label Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
campaign_a__updated_at_date
Field label Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
campaign_a__start_date
Field label Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
campaign_a__end_date
Field label End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
line_item_a__line_item__campaign_name
Field label Campaign name
Description Campaign name of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__campaign_id
Field label Campaign ID
Description Campaign ID of the requested report
Field type dimension
Data type string.text.value
product_a__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
product_a__campaign_id
Field label Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
product_a__campaign_type
Field label Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
product_a__status
Field label Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
product_a__promoted_brands_ids
Field label Promoted brands IDs
Description A list of the brand IDs that are being promoted in the campaign
Field type dimension
Data type string.text.value
product_a__click_attribution_window
Field label Click attribution window
Description The length of time that clicks are attributed to the campaign
Field type dimension
Data type string.text.value
product_a__view_attribution_window
Field label View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value
product_a__budget
Field label Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
product_a__budget_spent
Field label Budget spent
Description The amount of budget that has been spent so far on the campaign
Field type dimension
Data type string.text.value
product_a__budget_remaining
Field label Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type string.text.value
product_a__created_at
Field label Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
product_a__updated_at
Field label Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
product_a__created_at_date
Field label Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
product_a__updated_at_date
Field label Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
product_a__start_date
Field label Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
product_a__end_date
Field label End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
page_type_a__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
page_type_a__campaign_id
Field label Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
page_type_a__campaign_type
Field label Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
page_type_a__status
Field label Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
page_type_a__promoted_brands_ids
Field label Promoted brands IDs
Description A list of the brand IDs that are being promoted in the campaign
Field type dimension
Data type string.text.value
page_type_a__click_attribution_window
Field label Click attribution window
Description The length of time that clicks are attributed to the campaign
Field type dimension
Data type string.text.value
page_type_a__view_attribution_window
Field label View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value
page_type_a__budget
Field label Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
page_type_a__budget_spent
Field label Budget spent
Description The amount of budget that has been spent so far on the campaign
Field type dimension
Data type float.currency.value
page_type_a__budget_remaining
Field label Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type float.currency.value
page_type_a__created_at
Field label Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
page_type_a__updated_at
Field label Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
page_type_a__created_at_date
Field label Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
page_type_a__updated_at_date
Field label Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
page_type_a__start_date
Field label Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
page_type_a__end_date
Field label End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
keyword_a__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
keyword_a__campaign_id
Field label Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
keyword_a__campaign_type
Field label Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
keyword_a__status
Field label Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
keyword_a__promoted_brands_ids
Field label Promoted brands IDs
Description A list of the brand IDs that are being promoted in the campaign
Field type dimension
Data type string.text.value
keyword_a__click_attribution_window
Field label Click attribution window
Description The length of time that clicks are attributed to the campaign
Field type dimension
Data type string.text.value
keyword_a__view_attribution_window
Field label View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value
keyword_a__budget
Field label Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
keyword_a__budget_spent
Field label Budget spent
Description The amount of budget that has been spent so far on the campaign
Field type dimension
Data type float.currency.value
keyword_a__budget_remaining
Field label Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type float.currency.value
keyword_a__created_at
Field label Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
keyword_a__updated_at
Field label Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
keyword_a__created_at_date
Field label Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
keyword_a__updated_at_date
Field label Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
keyword_a__start_date
Field label Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
keyword_a__end_date
Field label End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
attributed_transaction_a__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
attributed_transaction_a__campaign_id
Field label Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

KEYWORD

keyword_a__keyword__keyword
Field label Keyword
Description Keyword
Field type dimension
Data type string.text.value

LINE ITEM

line_item_a__line_item_name
Field label Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
line_item_a__line_item_id
Field label Line item ID
Description A unique identifier for the line item
Field type dimension
Data type string.text.value
line_item_a__line_item_type
Field label Line item type
Description The type of line item (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
line_item_a__status
Field label Line item status
Description The current status of the line item (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
line_item_a__target_retailer_id
Field label Target retailer ID
Description The ID of the retailer that the line item is targeting
Field type dimension
Data type string.text.value
line_item_a__budget
Field label Budget
Description The total budget for the line item
Field type dimension
Data type string.text.value
line_item_a__budget_spent
Field label Budget spent
Description The amount of budget that has been spent so far on the line item
Field type dimension
Data type float.currency.value
line_item_a__budget_remaining
Field label Budget remaining
Description The amount of budget that is still available for the line item
Field type dimension
Data type float.currency.value
line_item_a__created_at
Field label Created at
Description The date and time when the line item was created
Field type dimension
Data type string.time.datetime
line_item_a__updated_at
Field label Updated at
Description The date and time when the line item was last updated
Field type dimension
Data type string.time.datetime
line_item_a__created_at_date
Field label Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
line_item_a__updated_at_date
Field label Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
line_item_a__start_date
Field label Start date
Description The date when the line item will start running
Field type dimension
Data type string.time.datetime
line_item_a__end_date
Field label End date
Description The date when the line item will stop running
Field type dimension
Data type string.time.datetime

PAGE TYPE

page_type_a__page_type__page_type_name
Field label Page type
Description Type of retailer web page an ad creative rendered on, such as home page, browse pages, search pages, product detail pages, checkout pages etc.
Field type dimension
Data type string.text.value

PERFORMANCE

campaign_a__campaign__impressions
Field label Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
campaign_a__campaign__clicks
Field label Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
campaign_a__campaign__ctr
Field label CTR
Description Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions
Field type metric
Data type float.number.ratio
campaign_a__campaign__spend
Field label Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
campaign_a__campaign__spend_usd
Field label Cost (USD)
Description Spend converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
campaign_a__campaign__spend_eur
Field label Cost (EUR)
Description Spend converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
campaign_a__campaign__spend_gbp
Field label Cost (GBP)
Description Spend converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
campaign_a__campaign__cpm
Field label CPM
Description Cost per mille
Field type metric
Data type float.currency.value
campaign_a__campaign__cpc
Field label CPC
Description The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks
Field type metric
Data type float.currency.value
line_item_a__line_item__impressions
Field label Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
line_item_a__line_item__clicks
Field label Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
line_item_a__line_item__ctr
Field label CTR
Description Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions
Field type metric
Data type float.number.ratio
line_item_a__line_item__spend
Field label Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
line_item_a__line_item__spend_usd
Field label Cost (USD)
Description Spend converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
line_item_a__line_item__spend_eur
Field label Cost (EUR)
Description Spend converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
line_item_a__line_item__spend_gbp
Field label Cost (GBP)
Description Spend converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
line_item_a__line_item__cpm
Field label CPM
Description Cost per mille
Field type metric
Data type float.currency.value
line_item_a__line_item__cpc
Field label CPC
Description The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks
Field type metric
Data type float.currency.value
product_a__product__impressions
Field label Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
product_a__product__clicks
Field label Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
product_a__product__ctr
Field label CTR
Description Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions
Field type metric
Data type float.number.ratio
product_a__product__spend
Field label Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
product_a__product__spend_usd
Field label Cost (USD)
Description Spend converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
product_a__product__spend_eur
Field label Cost (EUR)
Description Spend converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
product_a__product__spend_gbp
Field label Cost (GBP)
Description Spend converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
product_a__product__cpm
Field label CPM
Description Cost per mille
Field type metric
Data type float.currency.value
product_a__product__cpc
Field label CPC
Description The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks
Field type metric
Data type float.currency.value
page_type_a__page_type__impressions
Field label Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
page_type_a__page_type__clicks
Field label Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
page_type_a__page_type__ctr
Field label CTR
Description Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions
Field type metric
Data type float.number.ratio
page_type_a__page_type__spend
Field label Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
page_type_a__page_type__spend_usd
Field label Cost (USD)
Description Spend converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
page_type_a__page_type__spend_eur
Field label Cost (EUR)
Description Spend converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
page_type_a__page_type__spend_gbp
Field label Cost (GBP)
Description Spend converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
page_type_a__page_type__cpm
Field label CPM
Description Cost per mille
Field type metric
Data type float.currency.value
page_type_a__page_type__cpc
Field label CPC
Description The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks
Field type metric
Data type float.currency.value
keyword_a__keyword__impressions
Field label Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
keyword_a__keyword__clicks
Field label Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
keyword_a__keyword__ctr
Field label CTR
Description Click-through rate (CTR) is calculated by dividing the number of clicks by the number of impressions
Field type metric
Data type float.number.ratio
keyword_a__keyword__spend
Field label Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
keyword_a__keyword__spend_usd
Field label Cost (USD)
Description Spend converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
keyword_a__keyword__spend_eur
Field label Cost (EUR)
Description Spend converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
keyword_a__keyword__spend_gbp
Field label Cost (GBP)
Description Spend converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
keyword_a__keyword__cpm
Field label CPM
Description Cost per mille
Field type metric
Data type float.currency.value
keyword_a__keyword__cpc
Field label CPC
Description The average cost-per-click coming from Open Auction (CPC pricing model) campaign types. It is calculated by dividing the total click ad spend by the total number of clicks
Field type metric
Data type float.currency.value

PRODUCT

attributed_transaction_a__attributed_transaction__adv_product_name
Field label Advertised product name
Description Advertised product name
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__adv_product_id
Field label Advertised product ID
Description Advertised product ID; this references the same ID used in Catalogs
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__adv_product_category
Field label Advertised product category
Description Category of product advertised; categories are standardized across brands and retailers, which may differ from retailer-specific categories
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__adv_product_gtin
Field label Advertised product GTIN
Description Advertised product Global Trade Item Number (GTIN), if available; also known as European Article Number (EAN) or Universal Product Code (UPC)
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__adv_product_mpn
Field label Advertised product MPN
Description Advertised product Manufacturer Part Number (MPN), if available
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__purchased_product_name
Field label Purchased product name
Description Purchased product name
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__purchased_product_id
Field label Purchased product ID
Description Purchased product ID; this references the same ID used in Catalogs
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__purchased_product_category
Field label Purchased product category
Description Category of product purchased; categories are standardized across brands and retailers, which may differ from retailer-specific categories
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__purchased_product_gtin
Field label Purchased product GTIN
Description Purchased product Global Trade Item Number (GTIN), if available; also known as European Article Number (EAN) or Universal Product Code (UPC)
Field type dimension
Data type string.text.value
attributed_transaction_a__attributed_transaction__purchased_product_mpn
Field label Purchased product MPN
Description Purchased product Manufacturer Part Number (MPN), if available
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REACH

campaign_a__campaign__unique_visitors
Field label Unique visitors
Description The number of distinct shoppers who have been exposed to an ad in the reporting time period. Each shopper is counted only once, even if a shopper viewed an ad multiple times. Note about aggregation: It's possible that the sum of unique visitors across multiple rows does not equal the total row. E.g., the same shopper may see your ad on Monday and Wednesday. At the week level the shopper is counted as one unique visitor. But, at the day level they are counted once on Monday and once again on Wednesday. This is expected, because identifying a shopper as unique depends on the dimension level
Field type metric
Data type int.number.value
campaign_a__campaign__frequency
Field label Frequency
Description The average number of times an ad is displayed to the same shopper. Calculated by dividing the total number of impressions by unique visitors
Field type metric
Data type float.number.ratio
line_item_a__line_item__unique_visitors
Field label Unique visitors
Description The number of distinct shoppers who have been exposed to an ad in the reporting time period. Each shopper is counted only once, even if a shopper viewed an ad multiple times. Note about aggregation: It's possible that the sum of unique visitors across multiple rows does not equal the total row. E.g., the same shopper may see your ad on Monday and Wednesday. At the week level the shopper is counted as one unique visitor. But, at the day level they are counted once on Monday and once again on Wednesday. This is expected, because identifying a shopper as unique depends on the dimension level
Field type metric
Data type int.number.value
line_item_a__line_item__frequency
Field label Frequency
Description The average number of times an ad is displayed to the same shopper. Calculated by dividing the total number of impressions by unique visitors
Field type metric
Data type float.number.ratio

RETAILER

line_item_a__line_item__retailer_name
Field label Retailer name
Description Retailer name of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__retailer_id
Field label Retailer ID
Description Retailer ID of the requested report
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
campaign_a__campaign__year
Field label Year
Field type dimension
Data type string.time.year
campaign_a__campaign__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign_a__campaign__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign_a__campaign__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign_a__campaign__month
Field label Month
Field type dimension
Data type string.time.month
campaign_a__campaign__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign_a__campaign__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign_a__campaign__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign_a__campaign__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign_a__campaign__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign_a__campaign__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign_a__campaign__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign_a__campaign__date
Field label Date
Field type dimension
Data type string.time.date
campaign_a__campaign__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
line_item_a__line_item__year
Field label Year
Field type dimension
Data type string.time.year
line_item_a__line_item__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
line_item_a__line_item__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
line_item_a__line_item__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
line_item_a__line_item__month
Field label Month
Field type dimension
Data type string.time.month
line_item_a__line_item__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
line_item_a__line_item__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
line_item_a__line_item__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
line_item_a__line_item__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
line_item_a__line_item__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
line_item_a__line_item__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
line_item_a__line_item__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
line_item_a__line_item__date
Field label Date
Field type dimension
Data type string.time.date
line_item_a__line_item__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
product_a__product__year
Field label Year
Field type dimension
Data type string.time.year
product_a__product__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
product_a__product__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
product_a__product__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
product_a__product__month
Field label Month
Field type dimension
Data type string.time.month
product_a__product__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
product_a__product__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
product_a__product__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
product_a__product__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
product_a__product__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
product_a__product__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
product_a__product__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
product_a__product__date
Field label Date
Field type dimension
Data type string.time.date
product_a__product__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
page_type_a__page_type__year
Field label Year
Field type dimension
Data type string.time.year
page_type_a__page_type__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
page_type_a__page_type__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
page_type_a__page_type__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
page_type_a__page_type__month
Field label Month
Field type dimension
Data type string.time.month
page_type_a__page_type__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
page_type_a__page_type__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
page_type_a__page_type__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
page_type_a__page_type__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
page_type_a__page_type__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
page_type_a__page_type__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
page_type_a__page_type__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
page_type_a__page_type__date
Field label Date
Field type dimension
Data type string.time.date
page_type_a__page_type__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
keyword_a__keyword__year
Field label Year
Field type dimension
Data type string.time.year
keyword_a__keyword__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
keyword_a__keyword__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
keyword_a__keyword__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
keyword_a__keyword__month
Field label Month
Field type dimension
Data type string.time.month
keyword_a__keyword__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
keyword_a__keyword__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
keyword_a__keyword__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
keyword_a__keyword__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
keyword_a__keyword__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
keyword_a__keyword__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
keyword_a__keyword__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
keyword_a__keyword__date
Field label Date
Field type dimension
Data type string.time.date
keyword_a__keyword__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
attributed_transaction_a__attributed_transaction__year
Field label Year
Field type dimension
Data type string.time.year
attributed_transaction_a__attributed_transaction__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
attributed_transaction_a__attributed_transaction__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
attributed_transaction_a__attributed_transaction__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
attributed_transaction_a__attributed_transaction__month
Field label Month
Field type dimension
Data type string.time.month
attributed_transaction_a__attributed_transaction__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
attributed_transaction_a__attributed_transaction__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
attributed_transaction_a__attributed_transaction__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
attributed_transaction_a__attributed_transaction__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
attributed_transaction_a__attributed_transaction__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
attributed_transaction_a__attributed_transaction__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
attributed_transaction_a__attributed_transaction__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
attributed_transaction_a__attributed_transaction__date
Field label Date
Field type dimension
Data type string.time.date
attributed_transaction_a__attributed_transaction__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
attributed_transaction_a__attributed_transaction__adv_date
Field label Advertisement date
Description Date of advertisement
Field type dimension
Data type string.time.date
attributed_transaction_a__attributed_transaction__adv_hour
Field label Advertised hour
Description Hour of advertisement
Field type dimension
Data type string.time.hour
attributed_transaction_a__attributed_transaction__purchased_date
Field label Purchased date
Description Date of the attributed product purchase
Field type dimension
Data type string.time.date
attributed_transaction_a__attributed_transaction__purchased_hour
Field label Purchased hour
Description Hour of the attributed product purchase
Field type dimension
Data type string.time.hour
attributed_transaction_a__attributed_transaction__days_difference
Field label Days difference
Description Days between advertisement and purchase
Field type dimension
Data type string.text.value