Criteo Retail Media data warehouse table groups

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

Table: CAMPAIGN

campaign_a__account
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
campaign_a__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
campaign_a__budget
Display name Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
campaign_a__budget_remaining
Display name Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type float.currency.value
campaign_a__budget_spent
Display name 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__campaign__account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
campaign_a__campaign__attributed_orders
Display name Orders
Description Attributed orders
Field type metric
Data type int.number.value
campaign_a__campaign__attributed_sales
Display name Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
campaign_a__campaign__attributed_units
Display name 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__clicks
Display name Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
campaign_a__campaign__date
Display name Date
Field type dimension
Data type string.time.date
campaign_a__campaign__impressions
Display name Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
campaign_a__campaign__spend
Display name Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
campaign_a__campaign_id
Display name Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_a__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_a__campaign_type
Display name Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
campaign_a__click_attribution_window
Display name 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__created_at
Display name Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
campaign_a__created_at_date
Display name Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
campaign_a__end_date
Display name End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
campaign_a__promoted_brands_ids
Display name 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__start_date
Display name Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
campaign_a__status
Display name Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
campaign_a__updated_at
Display name Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
campaign_a__updated_at_date
Display name Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
campaign_a__view_attribution_window
Display name View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value
dataSourceName
Display name 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

Table: LINE_ITEM

dataSourceName
Display name 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
line_item_a__account
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
line_item_a__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
line_item_a__budget
Display name Budget
Description The total budget for the line item
Field type dimension
Data type string.text.value
line_item_a__budget_remaining
Display name 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__budget_spent
Display name 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__created_at
Display name Created at
Description The date and time when the line item was created
Field type dimension
Data type string.time.datetime
line_item_a__created_at_date
Display name Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
line_item_a__end_date
Display name End date
Description The date when the line item will stop running
Field type dimension
Data type string.time.datetime
line_item_a__line_item__account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
line_item_a__line_item__assisted_sales
Display name Assisted sales
Description Assisted sales
Field type metric
Data type float.currency.value
line_item_a__line_item__assisted_units
Display name Assisted units
Description Assisted units
Field type metric
Data type int.number.value
line_item_a__line_item__attributed_orders
Display name Orders
Description Attributed orders
Field type metric
Data type int.number.value
line_item_a__line_item__attributed_sales
Display name Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
line_item_a__line_item__attributed_units
Display name 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__campaign_id
Display name Campaign ID
Description Campaign ID of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__campaign_name
Display name Campaign name
Description Campaign name of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__clicks
Display name Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
line_item_a__line_item__date
Display name Date
Field type dimension
Data type string.time.date
line_item_a__line_item__impressions
Display name Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
line_item_a__line_item__retailer_id
Display name Retailer ID
Description Retailer ID of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__retailer_name
Display name Retailer name
Description Retailer name of the requested report
Field type dimension
Data type string.text.value
line_item_a__line_item__spend
Display name Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
line_item_a__line_item_id
Display name Line item ID
Description A unique identifier for the line item
Field type dimension
Data type string.text.value
line_item_a__line_item_name
Display name Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
line_item_a__line_item_type
Display name 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__start_date
Display name Start date
Description The date when the line item will start running
Field type dimension
Data type string.time.datetime
line_item_a__status
Display name 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
Display name 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__updated_at
Display name 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__updated_at_date
Display name Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date

Table: PRODUCT

dataSourceName
Display name 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
product_a__account
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
product_a__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
product_a__budget
Display name Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
product_a__budget_remaining
Display name Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type string.text.value
product_a__budget_spent
Display name 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__campaign_id
Display name Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
product_a__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
product_a__campaign_type
Display name Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
product_a__click_attribution_window
Display name 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__created_at
Display name Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
product_a__created_at_date
Display name Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
product_a__end_date
Display name End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
product_a__product__account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
product_a__product__adv_product_category
Display name 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
product_a__product__adv_product_id
Display name 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
Display name Advertised product name
Description Advertised product name
Field type dimension
Data type string.text.value
product_a__product__attributed_orders
Display name Orders
Description Attributed orders
Field type metric
Data type int.number.value
product_a__product__attributed_sales
Display name Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
product_a__product__attributed_units
Display name 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__brand_id
Display name Brand ID
Description Advertised product brand ID
Field type dimension
Data type string.text.value
product_a__product__brand_name
Display name Brand name
Description Advertised product brand name; names are standardized across retailers
Field type dimension
Data type string.text.value
product_a__product__clicks
Display name Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
product_a__product__date
Display name Date
Field type dimension
Data type string.time.date
product_a__product__impressions
Display name Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
product_a__product__spend
Display name Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
product_a__promoted_brands_ids
Display name 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__start_date
Display name Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
product_a__status
Display name Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
product_a__updated_at
Display name Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
product_a__updated_at_date
Display name Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
product_a__view_attribution_window
Display name View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value

Table: PAGE_TYPE

dataSourceName
Display name 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
page_type_a__account
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
page_type_a__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
page_type_a__budget
Display name Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
page_type_a__budget_remaining
Display name 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__budget_spent
Display name 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__campaign_id
Display name Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
page_type_a__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
page_type_a__campaign_type
Display name Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
page_type_a__click_attribution_window
Display name 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__created_at
Display name Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
page_type_a__created_at_date
Display name Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
page_type_a__end_date
Display name End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
page_type_a__page_type__account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
page_type_a__page_type__attributed_orders
Display name Orders
Description Attributed orders
Field type metric
Data type int.number.value
page_type_a__page_type__attributed_sales
Display name Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
page_type_a__page_type__attributed_units
Display name 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__clicks
Display name Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
page_type_a__page_type__date
Display name Date
Field type dimension
Data type string.time.date
page_type_a__page_type__impressions
Display name Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
page_type_a__page_type__page_type_name
Display name 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
page_type_a__page_type__spend
Display name Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
page_type_a__promoted_brands_ids
Display name 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__start_date
Display name Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
page_type_a__status
Display name 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__updated_at
Display name 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__updated_at_date
Display name Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
page_type_a__view_attribution_window
Display name View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value

Table: KEYWORD

dataSourceName
Display name 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
keyword_a__account
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
keyword_a__account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
keyword_a__budget
Display name Budget
Description The total budget for the campaign
Field type dimension
Data type float.currency.value
keyword_a__budget_remaining
Display name Budget remaining
Description The amount of budget that is still available for the campaign
Field type dimension
Data type float.currency.value
keyword_a__budget_spent
Display name 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__campaign_id
Display name Campaign ID
Description A unique identifier for the campaign
Field type dimension
Data type string.text.value
keyword_a__campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
keyword_a__campaign_type
Display name Campaign type
Description The type of campaign (e.g., search, display, sponsored products)
Field type dimension
Data type string.text.value
keyword_a__click_attribution_window
Display name 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__created_at
Display name Created at datetime
Description The date and time when the campaign was created
Field type dimension
Data type string.time.datetime
keyword_a__created_at_date
Display name Created at date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
keyword_a__end_date
Display name End date
Description The date when the campaign will stop running
Field type dimension
Data type string.time.date
keyword_a__keyword__account_currency
Display name Account currency
Description The currency of the account
Field type dimension
Data type string.currency.code
keyword_a__keyword__attributed_orders
Display name Orders
Description Attributed orders
Field type metric
Data type int.number.value
keyword_a__keyword__attributed_sales
Display name Sales
Description The revenue that can be attributed to your ads
Field type metric
Data type float.currency.value
keyword_a__keyword__attributed_units
Display name 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__clicks
Display name Clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
keyword_a__keyword__date
Display name Date
Field type dimension
Data type string.time.date
keyword_a__keyword__impressions
Display name Impressions
Description The number of times your ads were displayed
Field type metric
Data type int.number.value
keyword_a__keyword__keyword
Display name Keyword
Description Keyword
Field type dimension
Data type string.text.value
keyword_a__keyword__spend
Display name Cost
Description Total spend including any platform fees
Field type metric
Data type float.currency.value
keyword_a__promoted_brands_ids
Display name 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__start_date
Display name Start date
Description The date when the campaign will start running
Field type dimension
Data type string.time.date
keyword_a__status
Display name Campaign status
Description The current status of the campaign (e.g., active, paused, ended)
Field type dimension
Data type string.text.value
keyword_a__updated_at
Display name Updated at datetime
Description The date and time when the campaign was last updated
Field type dimension
Data type string.time.datetime
keyword_a__updated_at_date
Display name Updated at date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
keyword_a__view_attribution_window
Display name View attribution window
Description The length of time that views are attributed to the campaign
Field type dimension
Data type string.text.value