Basis data warehouse table groups

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

Table: CAMPAIGN

campaign__brand__brand_id
Display name Brand ID
Description ID of the brand
Field type dimension
Data type string.text.value
campaign__brand__brand_name
Display name Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
campaign__brand__client_id
Display name Client ID
Description ID of the client
Field type dimension
Data type string.text.value
campaign__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign__client_name
Display name Client name
Description Name of the client
Field type dimension
Data type string.text.value
campaign__end_date
Display name Campaign end date
Description The last day of the campaign
Field type dimension
Data type string.time.date
campaign__initiative_name
Display name Initiative name
Description Initiative name of the campaign
Field type dimension
Data type string.text.value
campaign__line_item__line_item_id
Display name Line item ID
Description ID of the line item
Field type dimension
Data type string.text.value
campaign__line_item__line_item_name
Display name Line item name
Description Name of the line item
Field type dimension
Data type string.text.value
campaign__start_date
Display name Campaign start date
Description The first day of the campaign
Field type dimension
Data type string.time.date
campaign__stats__ad_serving_spend
Display name Net ad server spend
Description Amount of spend on ad serving
Field type metric
Data type float.currency.value
campaign__stats__click_conversions
Display name Click conversions
Description Total click conversions
Field type metric
Data type int.number.value
campaign__stats__clicks
Display name Clicks
Description Gross number of clicks
Field type metric
Data type int.number.value
campaign__stats__data_spend
Display name Net data spend
Description Detailed Net and Gross: Amount spent on audience data
Field type metric
Data type float.currency.value
campaign__stats__date
Display name Date
Field type dimension
Data type string.time.date
campaign__stats__delivered_units
Display name Delivered units
Description Delivered units
Field type metric
Data type int.number.value
campaign__stats__impressions
Display name Impressions
Description The gross number of impressions won
Field type metric
Data type int.number.value
campaign__stats__interactions
Display name Number of interacts
Description Total number of interactions
Field type metric
Data type int.number.value
campaign__stats__inventory_spend
Display name Net inventory spend
Description Net inventory spend
Field type metric
Data type float.currency.value
campaign__stats__media_spend
Display name Net media spend
Description Net media spend
Field type metric
Data type float.currency.value
campaign__stats__total_conversions
Display name Conversions
Description Total conversion
Field type metric
Data type int.number.value
campaign__stats__total_spend
Display name Gross total spend
Description Total amount spend on media, ad serving and data including margin or markup
Field type metric
Data type float.currency.value
campaign__stats__total_view_conversions
Display name Viewed
Description Total view conversions
Field type metric
Data type int.number.value
campaign__stats__video_completions
Display name AV 100%
Description The number of times the audio or video ads was view to completion
Field type metric
Data type int.number.value
campaign__stats__video_starts
Display name Video starts
Description The number of times the audio or video ads was started to be viewed
Field type metric
Data type int.number.value
campaign__status
Display name Campaign status
Description The campaign's status: Planning, Live, or Approved
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