IQM data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

campaign_performance__audio_video_viewed
Display name Hours viewed
Description Total time spent on audio video. Metric is displayed in hours
Field type metric
Data type float.number.value
campaign_performance__bid_impressions
Display name Bid impressions
Description Bid impression
Field type metric
Data type int.number.value
campaign_performance__budget_day
Display name Daily budget
Description Daily budget - The amount to spend on average each day
Field type metric
Data type float.currency.value
campaign_performance__budget_pacing
Display name Budget pacing
Description Budget pacing
Field type dimension
Data type bool
campaign_performance__budget_total
Display name Total budget
Description The total of budget
Field type metric
Data type float.currency.value
campaign_performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type int.number.value
campaign_performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_status
Display name Campaign status
Description Status of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_timezone
Display name Campaign timezone
Description Timezone of the campaign
Field type dimension
Data type string.time.timezone
campaign_performance__campaign_type
Display name Campaign type
Description Type of the campaign
Field type dimension
Data type string.text.value
campaign_performance__clicks
Display name Clicks
Description Number of times someone clicks your ad
Field type metric
Data type int.number.value
campaign_performance__complete_count
Display name Video 100%
Description Number of video ads start to play through to completion
Field type metric
Data type int.number.value
campaign_performance__creative_type
Display name Creative type
Description Creative type
Field type dimension
Data type string.text.value
campaign_performance__data_cost
Display name Data cost
Description Amount spent to serve impressions to audience you matched or purchased
Field type metric
Data type float.currency.value
campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign_performance__end_date
Display name Campaign end date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaign_performance__end_datetime
Display name Campaign end date & time
Description End time and date of the campaign
Field type dimension
Data type string.time.datetime
campaign_performance__first_count
Display name Video 25%
Description Number of video ads start to play through 25% of their duration
Field type metric
Data type int.number.value
campaign_performance__impressions
Display name Impressions
Description Number of times ad displayed on someone's screen
Field type metric
Data type int.number.value
campaign_performance__max_bid
Display name Max bid
Description Max bid - The amount up to which you allow us to bid
Field type metric
Data type float.currency.value
campaign_performance__media_spent
Display name Media spent
Description Amount spent to win impressions
Field type metric
Data type float.currency.value
campaign_performance__mid_count
Display name Video 50%
Description Number of video ads start to play through 50% of their duration
Field type metric
Data type int.number.value
campaign_performance__new_platform
Display name From new platform
Description Is campaign from new platform
Field type dimension
Data type bool
campaign_performance__spent
Display name Total spent
Description Sum of the Media Spent and Data Spent
Field type metric
Data type float.currency.value
campaign_performance__start_count
Display name Video start
Description Number of video ads start to play
Field type metric
Data type int.number.value
campaign_performance__start_date
Display name Campaign start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
campaign_performance__start_datetime
Display name Campaign start date & time
Description Start time and date of the campaign
Field type dimension
Data type string.time.datetime
campaign_performance__third_count
Display name Video 75%
Description Number of video ads start to play through 75% of their duration
Field type metric
Data type int.number.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