RTB House data warehouse table groups

Search fields

Table: DEVICE

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

performance__advertiser_hash

Display name	Advertiser hash
Description	Advertiser hash value
Field type	dimension
Data type	string.text.value

performance__advertiser_name

Display name	Advertiser name
Description	Name of the advertiser
Field type	dimension
Data type	string.text.value

performance__clicks_count

Display name	Clicks
Description	Number of clicks
Field type	metric
Data type	int.number.value

performance__cost

Display name	Cost
Description	Campaign cost
Field type	metric
Data type	float.currency.value

performance__creative_created_at

Display name	Creative created at
Description	Date and time when the creative was created
Field type	dimension
Data type	string.time.datetime

performance__creative_hash

Display name	Creative hash
Description	Creative hash value
Field type	dimension
Data type	string.text.value

performance__creative_height

Display name	Creative height
Description	Creative height
Field type	dimension
Data type	int.number.value

performance__creative_name

Display name	Creative name
Description	Creative name
Field type	dimension
Data type	string.text.value

performance__creative_status

Display name	Creative status
Description	Creative status
Field type	dimension
Data type	string.text.value

performance__creative_type

Display name	Creative type
Description	Creative type
Field type	dimension
Data type	string.text.value

performance__creative_updated_at

Display name	Creative updated at
Description	Date and time when the creative was updated
Field type	dimension
Data type	string.time.datetime

performance__creative_width

Display name	Creative width
Description	Creative width
Field type	dimension
Data type	int.number.value

performance__currency

Display name	Currency
Description	The currency code of the account
Field type	dimension
Data type	string.currency.code

performance__date

Display name	Date
Field type	dimension
Data type	string.time.date

performance__device_type

Display name	Device type
Description	Type of device
Field type	dimension
Data type	string.text.value

performance__impression_count

Display name	Impressions
Description	The number of times your ad has been displayed on a screen
Field type	metric
Data type	int.number.value

performance__subcampaign_hash

Display name	Subcampaign hash
Description	Subcampaign hash value
Field type	dimension
Data type	string.text.value

performance__subcampaign_name

Display name	Subcampaign name
Description	Name of the subcampaign
Field type	dimension
Data type	string.text.value

performance__user_segment

Display name	User segment
Description	User segment
Field type	dimension
Data type	string.text.value

Table: GEO