Quantcast data warehouse table groups

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

Table: CAMPAIGN

data__ad_set_id
Display name Ad set ID
Description ID of the ad set
Field type dimension
Data type string.text.value
data__ad_set_name
Display name Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
data__agency_fees
Display name Creative agency fee
Description Total creative agency cost
Field type metric
Data type float.currency.value
data__amount_spent
Display name Amount spent
Description Total spent on campaigns. It is calculated as Creative spend + Survey spend
Field type metric
Data type float.currency.value
data__avoc
Display name Completed views (Audible & Visible)
Description Audible and Visible On Complete
Field type metric
Data type int.number.value
data__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
data__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
data__click_results
Display name Click results
Description Number of results coming from users who clicked the ad
Field type metric
Data type int.number.value
data__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
data__completed_views
Display name Completed views
Description Number of views that were completed
Field type metric
Data type int.number.value
data__creative_id
Display name Creative ID
Description ID of the creative
Field type dimension
Data type string.text.value
data__creative_name
Display name Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
data__date
Display name Date
Field type dimension
Data type string.time.date
data__impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
data__inventory_cost
Display name Inventory cost
Description Total cost for inventory
Field type metric
Data type float.currency.value
data__media_fees
Display name Creative media fees
Description Total cost for creative media
Field type metric
Data type float.currency.value
data__non_media_fees
Display name Creative non media fees
Description Total cost for creative non media
Field type metric
Data type float.currency.value
data__results
Display name Results
Description Number of results
Field type metric
Data type int.number.value
data__revenue
Display name Revenue
Description Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold
Field type metric
Data type float.currency.value
data__spend
Display name Creative spend
Description Total cost spent on creative
Field type metric
Data type float.currency.value
data__survey_agency_fees
Display name Survey agency fees
Description Total survey agency cost
Field type metric
Data type float.currency.value
data__survey_media_fees
Display name Survey media fees
Description Total cost for survey media
Field type metric
Data type float.currency.value
data__survey_non_media_fees
Display name Survey non media fees
Description Total cost for survey non media
Field type metric
Data type float.currency.value
data__survey_spend
Display name Survey spend
Description Total cost spent on surveys
Field type metric
Data type float.currency.value
data__view_results
Display name View results
Description Number of results coming from users who saw the ad
Field type metric
Data type int.number.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: GEO

data__ad_set_name
Display name Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
data__agency_fees
Display name Creative agency fee
Description Total creative agency cost
Field type metric
Data type float.currency.value
data__amount_spent
Display name Amount spent
Description Total spent on campaigns. It is calculated as Creative spend + Survey spend
Field type metric
Data type float.currency.value
data__avoc
Display name Completed views (Audible & Visible)
Description Audible and Visible On Complete
Field type metric
Data type int.number.value
data__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
data__click_results
Display name Click results
Description Number of results coming from users who clicked the ad
Field type metric
Data type int.number.value
data__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
data__completed_views
Display name Completed views
Description Number of views that were completed
Field type metric
Data type int.number.value
data__creative_name
Display name Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
data__date
Display name Date
Field type dimension
Data type string.time.date
data__geo_country
Display name Country
Description Geo country
Field type dimension
Data type string.geo.country
data__geo_region
Display name Region
Description Geo region
Field type dimension
Data type string.geo.region
data__impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
data__inventory_cost
Display name Inventory cost
Description Total cost for inventory
Field type metric
Data type float.currency.value
data__media_fees
Display name Creative media fees
Description Total cost for creative media
Field type metric
Data type float.currency.value
data__non_media_fees
Display name Creative non media fees
Description Total cost for creative non media
Field type metric
Data type float.currency.value
data__results
Display name Results
Description Number of results
Field type metric
Data type int.number.value
data__revenue
Display name Revenue
Description Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold
Field type metric
Data type float.currency.value
data__spend
Display name Creative spend
Description Total cost spent on creative
Field type metric
Data type float.currency.value
data__survey_agency_fees
Display name Survey agency fees
Description Total survey agency cost
Field type metric
Data type float.currency.value
data__survey_media_fees
Display name Survey media fees
Description Total cost for survey media
Field type metric
Data type float.currency.value
data__survey_non_media_fees
Display name Survey non media fees
Description Total cost for survey non media
Field type metric
Data type float.currency.value
data__survey_spend
Display name Survey spend
Description Total cost spent on surveys
Field type metric
Data type float.currency.value
data__view_results
Display name View results
Description Number of results coming from users who saw the ad
Field type metric
Data type int.number.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: DEMOGRAPHIC

data__ad_set_name
Display name Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
data__age
Display name Age
Description Age of the users
Field type dimension
Data type string.text.value
data__agency_fees
Display name Creative agency fee
Description Total creative agency cost
Field type metric
Data type float.currency.value
data__amount_spent
Display name Amount spent
Description Total spent on campaigns. It is calculated as Creative spend + Survey spend
Field type metric
Data type float.currency.value
data__avoc
Display name Completed views (Audible & Visible)
Description Audible and Visible On Complete
Field type metric
Data type int.number.value
data__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
data__click_results
Display name Click results
Description Number of results coming from users who clicked the ad
Field type metric
Data type int.number.value
data__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
data__completed_views
Display name Completed views
Description Number of views that were completed
Field type metric
Data type int.number.value
data__creative_name
Display name Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
data__date
Display name Date
Field type dimension
Data type string.time.date
data__gender
Display name Gender
Description Gender of users
Field type dimension
Data type string.text.value
data__impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
data__inventory_cost
Display name Inventory cost
Description Total cost for inventory
Field type metric
Data type float.currency.value
data__media_fees
Display name Creative media fees
Description Total cost for creative media
Field type metric
Data type float.currency.value
data__non_media_fees
Display name Creative non media fees
Description Total cost for creative non media
Field type metric
Data type float.currency.value
data__results
Display name Results
Description Number of results
Field type metric
Data type int.number.value
data__revenue
Display name Revenue
Description Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold
Field type metric
Data type float.currency.value
data__spend
Display name Creative spend
Description Total cost spent on creative
Field type metric
Data type float.currency.value
data__survey_agency_fees
Display name Survey agency fees
Description Total survey agency cost
Field type metric
Data type float.currency.value
data__survey_media_fees
Display name Survey media fees
Description Total cost for survey media
Field type metric
Data type float.currency.value
data__survey_non_media_fees
Display name Survey non media fees
Description Total cost for survey non media
Field type metric
Data type float.currency.value
data__survey_spend
Display name Survey spend
Description Total cost spent on surveys
Field type metric
Data type float.currency.value
data__view_results
Display name View results
Description Number of results coming from users who saw the ad
Field type metric
Data type int.number.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: DEVICE

data__ad_set_name
Display name Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
data__agency_fees
Display name Creative agency fee
Description Total creative agency cost
Field type metric
Data type float.currency.value
data__amount_spent
Display name Amount spent
Description Total spent on campaigns. It is calculated as Creative spend + Survey spend
Field type metric
Data type float.currency.value
data__avoc
Display name Completed views (Audible & Visible)
Description Audible and Visible On Complete
Field type metric
Data type int.number.value
data__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
data__click_results
Display name Click results
Description Number of results coming from users who clicked the ad
Field type metric
Data type int.number.value
data__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
data__completed_views
Display name Completed views
Description Number of views that were completed
Field type metric
Data type int.number.value
data__creative_name
Display name Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
data__date
Display name Date
Field type dimension
Data type string.time.date
data__device_type
Display name Device type
Description Device type
Field type dimension
Data type string.text.value
data__impressions
Display name Impressions
Description Number of impressions
Field type metric
Data type int.number.value
data__inventory_cost
Display name Inventory cost
Description Total cost for inventory
Field type metric
Data type float.currency.value
data__media_fees
Display name Creative media fees
Description Total cost for creative media
Field type metric
Data type float.currency.value
data__non_media_fees
Display name Creative non media fees
Description Total cost for creative non media
Field type metric
Data type float.currency.value
data__results
Display name Results
Description Number of results
Field type metric
Data type int.number.value
data__revenue
Display name Revenue
Description Revenue is the money generated from normal business operations, calculated as the average sales price times the number of units sold
Field type metric
Data type float.currency.value
data__spend
Display name Creative spend
Description Total cost spent on creative
Field type metric
Data type float.currency.value
data__survey_agency_fees
Display name Survey agency fees
Description Total survey agency cost
Field type metric
Data type float.currency.value
data__survey_media_fees
Display name Survey media fees
Description Total cost for survey media
Field type metric
Data type float.currency.value
data__survey_non_media_fees
Display name Survey non media fees
Description Total cost for survey non media
Field type metric
Data type float.currency.value
data__survey_spend
Display name Survey spend
Description Total cost spent on surveys
Field type metric
Data type float.currency.value
data__view_results
Display name View results
Description Number of results coming from users who saw the ad
Field type metric
Data type int.number.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