Criteo Retail Media metrics and dimensions

73 metrics228 dimensions

Search fields

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