Quantcast fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

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

34 metrics37 dimensions

AD SET

data__ad_set_name
Field label Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
data__ad_set_id
Field label Ad set ID
Description ID of the ad set
Field type dimension
Data type string.text.value

AGENCY

data__agency_fees
Field label Creative agency fee
Description Total creative agency cost
Field type metric
Data type float.currency.value
data__survey_agency_fees
Field label Survey agency fees
Description Total survey agency cost
Field type metric
Data type float.currency.value
data__net_spend
Field label Net creative spend
Description Total cost for creative (net)
Field type metric
Data type float.currency.value
data__survey_net_spend
Field label Net survey spend
Description Total cost for survey (net)
Field type metric
Data type float.currency.value
data__net_cpm
Field label Net CPM
Description Cost per mille/thousand (net). It is calculated as 1000 * (Net survey spend + Net creative spend) / Impressions
Field type metric
Data type float.currency.value
data__net_cpa
Field label Net Cost per result
Description Net cost per result. It is calculated as Net creative spend / results
Field type metric
Data type float.currency.value
data__net_roas
Field label Net ROAS
Description Return on ad spend (net). It is calculated as Revenue / Net creative spend
Field type metric
Data type float.currency.value

CAMPAIGN

data__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
data__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value

CREATIVE

data__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
data__creative_id
Field label Creative ID
Description ID of the creative
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

DELIVERY

data__device_type
Field label Device type
Description Device type
Field type dimension
Data type string.text.value
data__impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
data__spend
Field label Creative spend
Description Total cost spent on creative
Field type metric
Data type float.currency.value
data__survey_spend
Field label Survey spend
Description Total cost spent on surveys
Field type metric
Data type float.currency.value
data__amount_spent
Field label Amount spent
Description Total spent on campaigns. It is calculated as Creative spend + Survey spend
Field type metric
Data type float.currency.value
data__budget_delivered
Field label Budget delivered
Description All in-platform budget delivered within the selected date range is included. Data is subject to change and is not necessarily used for billing purposes
Field type metric
Data type float.currency.value
data__cpm
Field label CPM
Description Cost Per Thousand, using the Latin “Mille” instead of thousand. The amount an advertiser pays a website for every thousand times a brand’s ad is shown. Calculated as 1000 x Budget delivered / Impressions
Field type metric
Data type float.currency.value
data__clicks
Field label Clicks
Description The number of clicks
Field type metric
Data type int.number.value
data__ctr
Field label CTR
Description Click-through rate. Calculated as clicks / impressions
Field type metric
Data type float.number.ratio

DEMOGRAPHIC

data__age
Field label Age
Description Age of the users
Field type dimension
Data type string.text.value
data__gender
Field label Gender
Description Gender of users
Field type dimension
Data type string.text.value

DEPRECATED

data__net_avoc_cpcv_local
Field label NET CPCV (Audible & Visible)
Description Cost Per Completed View audible & visible (net).
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-07-23
data__net_cpcv
Field label Net CPCV
Description Cost Per Completed View (net).
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2024-07-23

FEES

data__media_fees
Field label Creative media fees
Description Total cost for creative media
Field type metric
Data type float.currency.value
data__non_media_fees
Field label Creative non media fees
Description Total cost for creative non media
Field type metric
Data type float.currency.value
data__survey_media_fees
Field label Survey media fees
Description Total cost for survey media
Field type metric
Data type float.currency.value
data__survey_non_media_fees
Field label Survey non media fees
Description Total cost for survey non media
Field type metric
Data type float.currency.value
data__inventory_cost
Field label Inventory cost
Description Total cost for inventory
Field type metric
Data type float.currency.value

GEOGRAPHIC

data__geo_country
Field label Country
Description Geo country
Field type dimension
Data type string.geo.country
data__geo_region
Field label Region
Description Geo region
Field type dimension
Data type string.geo.region

PERFORMANCE

data__results
Field label Results
Description Number of results
Field type metric
Data type int.number.value
data__click_results
Field label Click results
Description Number of results coming from users who clicked the ad
Field type metric
Data type int.number.value
data__view_results
Field label View results
Description Number of results coming from users who saw the ad
Field type metric
Data type int.number.value
data__cpa
Field label Cost per result
Description Cost per result. It is calculated as Budget delivered / Results
Field type metric
Data type float.currency.value
data__revenue
Field label 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__roas
Field label ROAS
Description Return on ad spend. The amount of revenue generated by all customers who made a purchase and received advertising messaging). It is calculated as Revenue / Budget delivered
Field type metric
Data type float.number.ratio

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

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
data__year
Field label Year
Field type dimension
Data type string.time.year
data__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
data__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
data__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
data__month
Field label Month
Field type dimension
Data type string.time.month
data__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
data__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
data__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
data__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
data__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
data__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
data__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
data__date
Field label Date
Field type dimension
Data type string.time.date
data__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

data__completion_rate
Field label 100% completion rate
Description Full completion rate. It is calculated as Completed views / Impressions
Field type metric
Data type float.number.ratio
data__completed_views
Field label Completed views
Description Number of views that were completed
Field type metric
Data type int.number.value
data__cpcv_local
Field label CPCV
Description Cost Per Completed View. It is calculated as Budget delivered / Completed views
Field type metric
Data type float.currency.value
data__avoc
Field label Completed views (Audible & Visible)
Description Audible and Visible On Complete
Field type metric
Data type int.number.value
data__avoc_rate
Field label 100% completion rate (Audible & Visible)
Description Completion rate (Audible & Visible). It is calculated as Completed views (Audible & Visible) / Impressions
Field type metric
Data type float.number.ratio
data__avoc_cpcv_local
Field label CPCV (Audible & visible)
Description Cost per completed view (audible & visible). It is calculated as Budget delivered / Completed views (Audible & Visible)
Field type metric
Data type float.currency.value