IQM fields

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

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

23 metrics38 dimensions

BUDGET

campaign_performance__budget_total
Field label Total budget
Description The total of budget
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
campaign_performance__budget_day
Field label Daily budget
Description Daily budget - The amount to spend on average each day
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
campaign_performance__max_bid
Field label Max bid
Description Max bid - The amount up to which you allow us to bid
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric

CAMPAIGN

campaign_performance__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type int.number.value
campaign_performance__campaign_type
Field label Campaign type
Description Type of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_status
Field label Campaign status
Description Status of the campaign
Field type dimension
Data type string.text.value
campaign_performance__budget_pacing
Field label Budget pacing
Description Budget pacing
Field type dimension
Data type bool
campaign_performance__new_platform
Field label From new platform
Description Is campaign from new platform
Field type dimension
Data type bool
campaign_performance__creative_type
Field label Creative type
Description Creative type
Field type dimension
Data type string.text.value
campaign_performance__campaign_timezone
Field label Campaign timezone
Description Timezone of the campaign
Field type dimension
Data type string.time.timezone
campaign_performance__start_datetime
Field label Campaign start date & time
Description Start time and date of the campaign
Field type dimension
Data type string.time.datetime
campaign_performance__start_date
Field label Campaign start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
campaign_performance__end_datetime
Field label Campaign end date & time
Description End time and date of the campaign
Field type dimension
Data type string.time.datetime
campaign_performance__end_date
Field label Campaign end date
Description End date of the campaign
Field type dimension
Data type string.time.date

COST

campaign_performance__effective_cost_per_mille
Field label eCPM
Description Effective cost per mille - The amount you pay per one thousand impression
Field type metric
Data type float.currency.value
campaign_performance__effective_cost_per_click
Field label eCPC
Description Effective cost per click. The amount of spent divided my the number of clicks
Field type metric
Data type float.currency.value
campaign_performance__effective_cost_per_complete_view
Field label eCPCV
Description Cost per complete view - The amount spent divide by video ads that play through completion
Field type metric
Data type float.currency.value

COUNTS

campaign_performance__impressions
Field label Impressions
Description Number of times ad displayed on someone's screen
Field type metric
Data type int.number.value
campaign_performance__clicks
Field label Clicks
Description Number of times someone clicks your ad
Field type metric
Data type int.number.value
campaign_performance__reach
Field label Reach
Description Reach
Field type metric
Data type int.number.value
campaign_performance__bid_impressions
Field label Bid impressions
Description Bid impression
Field type metric
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

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

RATES

campaign_performance__ctr
Field label CTR
Description Click through rate. Clicks / Impressions - The percentage of clicks received per impressions served
Field type metric
Data type float.number.ratio
campaign_performance__video_completion_rate
Field label VCR
Description Video completion rate - Percentage of video ads that play through completion
Field type metric
Data type float.number.ratio
campaign_performance__frequency
Field label Frequency
Description Frequency
Field type metric
Data type float.number.value
campaign_performance__win_rate
Field label Win rate
Description Win rate - The percentage of impressions won the bids made
Field type metric
Data type float.number.ratio

SPENDING

campaign_performance__spent
Field label Total spent
Description Sum of the Media Spent and Data Spent
Field type metric
Data type float.currency.value
campaign_performance__media_spent
Field label Media spent
Description Amount spent to win impressions
Field type metric
Data type float.currency.value
campaign_performance__data_cost
Field label Data cost
Description Amount spent to serve impressions to audience you matched or purchased
Field type metric
Data type float.currency.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
campaign_performance__year
Field label Year
Field type dimension
Data type string.time.year
campaign_performance__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign_performance__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign_performance__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign_performance__month
Field label Month
Field type dimension
Data type string.time.month
campaign_performance__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign_performance__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign_performance__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign_performance__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign_performance__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign_performance__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign_performance__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign_performance__date
Field label Date
Field type dimension
Data type string.time.date
campaign_performance__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

campaign_performance__start_count
Field label Video start
Description Number of video ads start to play
Field type metric
Data type int.number.value
campaign_performance__first_count
Field label 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__mid_count
Field label 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__third_count
Field label Video 75%
Description Number of video ads start to play through 75% of their duration
Field type metric
Data type int.number.value
campaign_performance__complete_count
Field label Video 100%
Description Number of video ads start to play through to completion
Field type metric
Data type int.number.value
campaign_performance__audio_video_viewed
Field label Hours viewed
Description Total time spent on audio video. Metric is displayed in hours
Field type metric
Data type float.number.value