Criteo data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

account_currency
Display name Currency
Description Ad set bid currency code
Field type dimension
Data type string.currency.code
adset_bid_strategy
Display name Ad set bid type
Description The intended optimization for the Ad Set
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description ID of the ad set
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The Ad set name, set by the advertiser
Field type dimension
Data type string.text.value
adset_status
Display name Ad set status
Description Set by the advertiser, this represents the intent to deliver ads
Field type dimension
Data type string.text.value
advertiser_id
Display name Advertiser ID
Description Id of the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
advertiser_value
Display name Advertiser value
Description The total value generated by the campaign
Field type metric
Data type float.currency.value
average_cart
Display name Average cart
Description Average revenue generated by a campaign's sales
Field type metric
Data type float.currency.value
category_id
Display name Category ID
Description ID of the category
Field type dimension
Data type string.text.value
category_name
Display name Category
Description Name of the category from catalog feed
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description Number of times that your Criteo ads have been clicked
Field type metric
Data type int.number.value
conversion_rate
Display name Conversion rate
Description Percentage of conversions or sales compared to the clicks that occurred
Field type metric
Data type float.number.percentage
cost
Display name Cost
Description Total cost of the campaigns
Field type metric
Data type float.currency.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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description Number of times the Ad is displayed to a user on publishers' websites
Field type metric
Data type int.number.value
non_viewable_displays
Display name Unviewed displays
Description The number of ads that have not been viewed. A display that doesn`t meet the viewed display`s criteria is considered unviewed
Field type metric
Data type int.number.value
overall_competition_win
Display name Overall competition win
Description Percentage of impressions/ad placements won, out of all impressions/ad placements that were bid on
Field type metric
Data type float.number.ratio
potential_displays
Display name Potential displays
Description The number of display opportunities, or the number of bid requests received
Field type metric
Data type int.number.value
qualified_visits
Display name Qualified visits
Description The number of users on the target website or app for which at least two events or one sale event occurred within the hour following a click
Field type metric
Data type int.number.value
revenue
Display name Revenue
Description The amount of money generated by online sales
Field type metric
Data type float.currency.value
sales
Display name Sales
Description The total number of purchases completed via the same device your Criteo ads were clicked, or a different one
Field type metric
Data type float.currency.value
untrackable_displays
Display name Untracked displays
Description This is the number of untracked displays. Some displays cannot be tracked because of the display environment (for instance, native banner)
Field type metric
Data type int.number.value
viewable_displays
Display name Viewed displays
Description The number of ads that have been viewed. A display is considered viewed if at least 50% of the ad appears on the screen for at least one second
Field type metric
Data type int.number.value