Readpeak data warehouse table groups

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

Table: CAMPAIGN

campaigns_report__advertiser
Display name Advertiser Name
Description The name of the advertiser
Field type dimension
Data type string.text.value
campaigns_report__campaign
Display name Campaign Name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaigns_report__campaign_creator
Display name Campaign Creator Email
Description The email of the campaign creator
Field type dimension
Data type string.text.value
campaigns_report__campaign_creator_name
Display name Campaign Creator Name
Description The name of the campaign creator
Field type dimension
Data type string.text.value
campaigns_report__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
campaigns_report__client
Display name Client Name
Description The name of the client
Field type dimension
Data type string.text.value
campaigns_report__currency
Display name Currency
Field type dimension
Data type string.currency.code
campaigns_report__date
Display name Date
Field type dimension
Data type string.time.date
campaigns_report__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
campaigns_report__location
Display name Publisher Name
Description The publisher that showed the impression
Field type dimension
Data type string.text.value
campaigns_report__spend
Display name Spend
Description The amount of money was spent
Field type metric
Data type float.currency.value
campaigns_report__spend_in_currency
Display name Spend in Campaign Currency
Description The amount of money was spent in campaign
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

Table: AD

campaigns_report__ad_group
Display name Ad Group Name
Description The name of the ad group
Field type dimension
Data type string.text.value
campaigns_report__ad_group_id
Display name Ad Group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
campaigns_report__advertiser
Display name Advertiser Name
Description The name of the advertiser
Field type dimension
Data type string.text.value
campaigns_report__article_creation_date
Display name Ad Creation Date
Description The date the ad was created
Field type dimension
Data type string.time.date
campaigns_report__article_title
Display name Ad Variation Title
Description The title of the ad variation
Field type dimension
Data type string.text.value
campaigns_report__article_update_date
Display name Ad Update Date
Description The date the ad was updated
Field type dimension
Data type string.time.date
campaigns_report__campaign
Display name Campaign Name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaigns_report__campaign_creator
Display name Campaign Creator Email
Description The email of the campaign creator
Field type dimension
Data type string.text.value
campaigns_report__campaign_creator_name
Display name Campaign Creator Name
Description The name of the campaign creator
Field type dimension
Data type string.text.value
campaigns_report__clicks
Display name Clicks
Description The number of clicks
Field type metric
Data type int.number.value
campaigns_report__client
Display name Client Name
Description The name of the client
Field type dimension
Data type string.text.value
campaigns_report__cta
Display name Ad Call-To-Action
Description The CTA statement of the ad
Field type dimension
Data type string.text.value
campaigns_report__currency
Display name Currency
Field type dimension
Data type string.currency.code
campaigns_report__date
Display name Date
Field type dimension
Data type string.time.date
campaigns_report__image_url
Display name Ad Image URL
Description The URL of the ad image
Field type dimension
Data type string.text.url
campaigns_report__impressions
Display name Impressions
Description The number of impressions
Field type metric
Data type int.number.value
campaigns_report__location
Display name Publisher Name
Description The publisher that showed the impression
Field type dimension
Data type string.text.value
campaigns_report__spend
Display name Spend
Description The amount of money was spent
Field type metric
Data type float.currency.value
campaigns_report__spend_in_currency
Display name Spend in Campaign Currency
Description The amount of money was spent in campaign
Field type metric
Data type float.currency.value
campaigns_report__target_url
Display name Click URL
Description The link that a visitor goes to when he/she clicks on the ad
Field type dimension
Data type string.text.url
campaigns_report__text
Display name Ad Teaser
Description The teaser of the ad
Field type dimension
Data type string.text.value
campaigns_report__theme
Display name Ad Theme
Description The theme of the ad
Field type dimension
Data type string.text.value
campaigns_report__variation_no
Display name Ad Variation Number
Description The number of the ad variation
Field type dimension
Data type string.text.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