RTB House fields

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

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

23 metrics75 dimensions

ADVERTISER

performance__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
performance__advertiser_hash
Field label Advertiser hash
Description Advertiser hash value
Field type dimension
Data type string.text.value
branding__advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
branding__advertiser_hash
Field label Advertiser hash
Description Advertiser hash value
Field type dimension
Data type string.text.value

CATEGORY

performance__category_name
Field label Category name
Description Category name
Field type dimension
Data type string.text.value
performance__category_hash
Field label Category hash
Description Category hash value
Field type dimension
Data type string.text.value

CREATIVE

performance__creative_name
Field label Creative name
Description Creative name
Field type dimension
Data type string.text.value
performance__creative_hash
Field label Creative hash
Description Creative hash value
Field type dimension
Data type string.text.value
performance__creative_status
Field label Creative status
Description Creative status
Field type dimension
Data type string.text.value
performance__creative_type
Field label Creative type
Description Creative type
Field type dimension
Data type string.text.value
performance__creative_created_at
Field label Creative created at
Description Date and time when the creative was created
Field type dimension
Data type string.time.datetime
performance__creative_updated_at
Field label Creative updated at
Description Date and time when the creative was updated
Field type dimension
Data type string.time.datetime
performance__creative_width
Field label Creative width
Description Creative width
Field type dimension
Data type int.number.value
performance__creative_height
Field label Creative height
Description Creative height
Field type dimension
Data type int.number.value
branding__creative_name
Field label Creative name
Description Creative name. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.text.value
branding__creative_hash
Field label Creative hash
Description Creative hash value. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.text.value
branding__creative_status
Field label Creative status
Description Creative status. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.text.value
branding__creative_type
Field label Creative type
Description Creative type. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.text.value
branding__creative_created_at
Field label Creative created at
Description Date and time when the creative was created. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.time.datetime
branding__creative_updated_at
Field label Creative updated at
Description Date and time when the creative was updated. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.time.datetime
branding__creative_width
Field label Creative width
Description Creative width. Not compatible with Frequency and Reach metrics
Field type dimension
Data type int.number.value
branding__creative_height
Field label Creative height
Description Creative height. Not compatible with Frequency and Reach metrics
Field type dimension
Data type int.number.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

METRICS

branding__impression_count
Field label Impressions
Description The number of times your ad has been displayed on a screen
Field type metric
Data type int.number.value
branding__cost
Field label Cost
Description Campaign cost
Field type metric
Data type float.currency.value
branding__clicks_count
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
branding__completed_views
Field label Completed video views
Description The number of completed video views
Field type metric
Data type int.number.value
branding__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.ratio
branding__ecpm
Field label eCPM
Description Effective Cost Per Mille: (Cost / Impressions) * 1000
Field type metric
Data type float.currency.value
branding__ecpc
Field label eCPC
Description Effective Cost Per Click: Cost / Clicks
Field type metric
Data type float.currency.value
branding__ecpv
Field label eCPCV
Description Effective Cost Per Completed View: Cost / Completed video views
Field type metric
Data type float.currency.value
branding__vcr
Field label VCR
Description Video Completion Rate: Completed video views / Impressions
Field type metric
Data type float.number.ratio
branding__viewability
Field label Viewability
Description Share of impressions that were considered viewable
Field type metric
Data type float.number.ratio
branding__user_frequency
Field label Frequency
Description The average number of times each person viewed your ad
Field type metric
Data type float.number.value
branding__user_reach
Field label Reach
Description The total number of people who have seen your ad or content
Field type metric
Data type int.number.value

OTHER

performance__device_type
Field label Device type
Description Type of device
Field type dimension
Data type string.text.value
performance__country
Field label Country
Description Country
Field type dimension
Data type string.text.value
performance__currency
Field label Currency
Description The currency code of the account
Field type dimension
Data type string.currency.code
performance__user_segment
Field label User segment
Description User segment
Field type dimension
Data type string.text.value
branding__device_type
Field label Device type
Description Type of device. Not compatible with Viewability metric
Field type dimension
Data type string.text.value
branding__country
Field label Country
Description Country. Not compatible with Viewability, Frequency or Reach metrics
Field type dimension
Data type string.text.value
branding__currency
Field label Currency
Description The currency code of the account
Field type dimension
Data type string.currency.code

PERFORMANCE

performance__impression_count
Field label Impressions
Description The number of times your ad has been displayed on a screen
Field type metric
Data type int.number.value
performance__cost
Field label Cost
Description Campaign cost
Field type metric
Data type float.currency.value
performance__clicks_count
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
performance__conversions_count
Field label Conversions
Description The number of conversions
Field type metric
Data type int.number.value
performance__conversions_value
Field label Conversion value
Description The monetary impact of your conversions
Field type metric
Data type int.number.value
performance__ctr
Field label CTR
Description Clicks / Impressions
Field type metric
Data type float.number.ratio
performance__cr
Field label Conversion rate
Description Conversions / Clicks
Field type metric
Data type float.number.ratio
performance__ecpm
Field label eCPM
Description Effective Cost Per Mille: (Cost / Impressions) * 1000
Field type metric
Data type float.currency.value
performance__ecpc
Field label eCPC
Description Effective Cost Per Click: Cost / Clicks
Field type metric
Data type float.currency.value
performance__ecpa
Field label eCPA
Description Effective Cost Per Action: Cost / Conversions
Field type metric
Data type float.currency.value
performance__roas
Field label ROAS
Description Return on ad spend: Conversion value / Cost
Field type metric
Data type float.currency.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

SUBCAMPAIGN

performance__subcampaign_name
Field label Subcampaign name
Description Name of the subcampaign
Field type dimension
Data type string.text.value
performance__subcampaign_hash
Field label Subcampaign hash
Description Subcampaign hash value
Field type dimension
Data type string.text.value
branding__subcampaign_name
Field label Subcampaign name
Description Name of the subcampaign. Not compatible with Frequency and Reach metrics
Field type dimension
Data type string.text.value
branding__subcampaign_hash
Field label Subcampaign hash
Description Subcampaign hash value. Not compatible with Frequency and Reach metrics
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
performance__year
Field label Year
Field type dimension
Data type string.time.year
performance__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
performance__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
performance__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
performance__month
Field label Month
Field type dimension
Data type string.time.month
performance__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
performance__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
performance__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
performance__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
performance__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
performance__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
performance__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
performance__date
Field label Date
Field type dimension
Data type string.time.date
performance__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
performance__hour
Field label Hour
Description Hour of the day
Field type dimension
Data type string.text.value
branding__year
Field label Year
Field type dimension
Data type string.time.year
branding__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
branding__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
branding__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
branding__month
Field label Month
Field type dimension
Data type string.time.month
branding__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
branding__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
branding__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
branding__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
branding__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
branding__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
branding__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
branding__date
Field label Date
Field type dimension
Data type string.time.date
branding__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
branding__hour
Field label Hour
Description Hour of the day
Field type dimension
Data type string.text.value