Documentation Index

Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt

Use this file to discover all available pages before exploring further.

Basis metrics and dimensions

  • Updated on May 15, 2026
  • Published on Aug 5, 2025
Prev Next

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

55 metrics83 dimensions

AUDIO & VIDEO

campaign__stats__video_starts
Field label 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__stats__video_completions
Field label 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_complete_rate
Field label AV completion rate
Description AV complete rate. (AV 100% / Av starts)
Field type metric
Data type float.number.ratio
campaign__stats__total_view_conversions
Field label Viewed
Description Total view conversions
Field type metric
Data type int.number.value
campaign__stats__ecpcv
Field label eCPCV
Description Effective cost per completed video. Cost of a running video to completion (Total spend/ AV 100%)
Field type metric
Data type float.currency.value
campaign__stats__ecpv
Field label eCPV
Description Effective cost per visitor. (Total spend/ Total view conversions)
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__video_starts
Field label 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
l_campaign__l_line_item__l_stats__video_completions
Field label AV 100%
Description The number of times the audio or video ads was view to completion
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__video_complete_rate
Field label AV completion rate
Description AV complete rate. (AV 100% / Av starts)
Field type metric
Data type float.number.ratio
l_campaign__l_line_item__l_stats__total_view_conversions
Field label Viewed
Description Total view conversions
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__ecpcv
Field label eCPCV
Description Effective cost per completed video. Cost of a running video to completion (Total spend/ AV 100%)
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__ecpv
Field label eCPV
Description Effective cost per visitor. (Total spend/ Total view conversions)
Field type metric
Data type float.currency.value

BASE

campaign__stats__impressions
Field label Impressions
Description The gross number of impressions won
Field type metric
Data type int.number.value
campaign__stats__clicks
Field label Clicks
Description Gross number of clicks
Field type metric
Data type int.number.value
campaign__stats__click_through_rate
Field label CTR
Description Click-Through Rate (Click/ Impressions)
Field type metric
Data type float.number.ratio
campaign__stats__total_spend
Field label 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__ecpm
Field label eCPM
Description Effective cost per 1000 imps (Total spend/ Impressions * 1000)
Field type metric
Data type float.currency.value
campaign__stats__ecpc
Field label eCPC
Description Effective cost-per-click (Total spend/ clicks)
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__impressions
Field label Impressions
Description The gross number of impressions won
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__clicks
Field label Clicks
Description Gross number of clicks
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__click_through_rate
Field label CTR
Description Click-Through Rate (Click/ Impressions)
Field type metric
Data type float.number.ratio
l_campaign__l_line_item__l_stats__total_spend
Field label 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
l_campaign__l_line_item__l_stats__ecpm
Field label eCPM
Description Effective cost per 1000 imps (Total spend/ Impressions * 1000)
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__ecpc
Field label eCPC
Description Effective cost-per-click (Total spend/ clicks)
Field type metric
Data type float.currency.value
creative_performance__cp_line_item__cp_stats__impressions
Field label Impressions
Description The gross number of impressions won
Field type metric
Data type int.number.value
creative_performance__cp_line_item__cp_stats__clicks
Field label Clicks
Description Gross number of clicks
Field type metric
Data type int.number.value
creative_performance__cp_line_item__cp_stats__click_through_rate
Field label CTR
Description Click-Through Rate (Clicks/ Impressions)
Field type metric
Data type float.number.ratio

BILLING

campaign__stats__ad_serving_spend
Field label Net ad server spend
Description Amount of spend on ad serving
Field type metric
Data type float.currency.value
campaign__stats__data_spend
Field label Net data spend
Description Detailed Net and Gross: Amount spent on audience data
Field type metric
Data type float.currency.value
campaign__stats__inventory_spend
Field label Net inventory spend
Description Net inventory spend
Field type metric
Data type float.currency.value
campaign__stats__media_spend
Field label Net media spend
Description Net media spend
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__ad_serving_spend
Field label Net ad server spend
Description Amount of spend on ad serving
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__data_spend
Field label Net data spend
Description Detailed Net and Gross: Amount spent on audience data
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__inventory_spend
Field label Net inventory spend
Description Net inventory spend
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__media_spend
Field label Net media spend
Description Net media spend
Field type metric
Data type float.currency.value
creative_performance__cp_line_item__cp_stats__inventory_spend
Field label Inventory spend
Description Net inventory spend
Field type metric
Data type float.currency.value
creative_performance__cp_line_item__cp_stats__data_spend
Field label Data spend
Description Detailed Net and Gross: Amount spent on audience data
Field type metric
Data type float.currency.value
creative_performance__cp_line_item__cp_stats__media_spend
Field label Media spend
Description Net media spend
Field type metric
Data type float.currency.value

CAMPAIGN

campaign__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign__initiative_name
Field label Initiative name
Description Initiative name of the campaign
Field type dimension
Data type string.text.value
campaign__start_date
Field label Campaign start date
Description The first day of the campaign
Field type dimension
Data type string.time.date
campaign__end_date
Field label Campaign end date
Description The last day of the campaign
Field type dimension
Data type string.time.date
campaign__status
Field label Campaign status
Description The campaign's status: Planning, Live, or Approved
Field type dimension
Data type string.text.value
creative_performance__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
creative_performance__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value

CLIENT

campaign__client_name
Field label Client name
Description Name of the client
Field type dimension
Data type string.text.value
campaign__brand__client_id
Field label Client ID
Description ID of the client
Field type dimension
Data type string.text.value
campaign__brand__brand_name
Field label Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
campaign__brand__brand_id
Field label Brand ID
Description ID of the brand
Field type dimension
Data type string.text.value
creative_performance__client_name
Field label Client name
Description Name of the client
Field type dimension
Data type string.text.value
creative_performance__cp_brand__client_id
Field label Client ID
Description ID of the client
Field type dimension
Data type string.text.value
creative_performance__cp_brand__brand_name
Field label Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
creative_performance__cp_brand__brand_id
Field label Brand ID
Description ID of the brand
Field type dimension
Data type string.text.value

CONVERSION

campaign__stats__total_conversions
Field label Conversions
Description Total conversion
Field type metric
Data type int.number.value
campaign__stats__click_through_conversion
Field label CTC (click-through conversions)
Description Click-Through conversion: Conversion recorded after user clicked an ad (Conversions/ Click conversions)
Field type metric
Data type float.number.ratio
campaign__stats__click_conversions
Field label Click conversions
Description Total click conversions
Field type metric
Data type int.number.value
campaign__stats__ecpa
Field label eCPA
Description Effective cost per action (Total spend/ Conversions)
Field type metric
Data type float.currency.value
campaign__stats__delivered_units
Field label Delivered units
Description Delivered units
Field type metric
Data type int.number.value
campaign__stats__interactions
Field label Number of interacts
Description Total number of interactions
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__total_conversions
Field label Conversions
Description Total conversion
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__click_through_conversion
Field label CTC (click-through conversions)
Description Click-Through conversion: Conversion recorded after user clicked an ad (Conversions/ Click conversions)
Field type metric
Data type float.number.ratio
l_campaign__l_line_item__l_stats__click_conversions
Field label Click conversions
Description Total click conversions
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__ecpa
Field label eCPA
Description Effective cost per action (Total spend/ Conversions)
Field type metric
Data type float.currency.value
l_campaign__l_line_item__l_stats__delivered_units
Field label Delivered units
Description Delivered units
Field type metric
Data type int.number.value
l_campaign__l_line_item__l_stats__interactions
Field label Number of interacts
Description Total number of interactions
Field type metric
Data type int.number.value
creative_performance__cp_line_item__cp_stats__total_conversions
Field label Conversions
Description Total number of conversions
Field type metric
Data type int.number.value
creative_performance__cp_line_item__cp_stats__view_through_conversion
Field label VTC (view-through conversions)
Description View-Through conversion: Conversion recorded after user viewed an ad
Field type metric
Data type int.number.value
creative_performance__cp_line_item__cp_stats__click_through_conversion
Field label CTC (click-through conversions)
Description Click-Through conversion: Conversion recorded after user clicked an ad
Field type metric
Data type int.number.value

CREATIVE

creative_performance__cp_line_item__cp_stats__creatives__creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
creative_performance__cp_line_item__cp_stats__creatives__creative_id
Field label Creative ID
Description ID of the creative
Field type dimension
Data type string.text.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

GROUP

creative_performance__cp_line_item__cp_stats__delivery_source__tactics__groups__group_name
Field label Group name
Description Name of the group
Field type dimension
Data type string.text.value
creative_performance__cp_line_item__cp_stats__delivery_source__tactics__groups__group_id
Field label Group ID
Description ID of the group
Field type dimension
Data type string.text.value

LINE ITEM

campaign__line_item__line_item_name
Field label Line item name
Description Name of the line item
Field type dimension
Data type string.text.value
campaign__line_item__line_item_id
Field label Line item ID
Description ID of the line item
Field type dimension
Data type string.text.value
l_campaign__l_line_item__line_item_name
Field label Line item name
Description Name of the line item
Field type dimension
Data type string.text.value
l_campaign__l_line_item__line_item_id
Field label Line item ID
Description ID of the line item
Field type dimension
Data type string.text.value
creative_performance__cp_line_item__line_item_name
Field label Line item name
Description Name of the line item
Field type dimension
Data type string.text.value
creative_performance__cp_line_item__line_item_id
Field label Line item ID
Description ID of the line item
Field type dimension
Data type string.text.value

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
system_metadata.query_excluded_accounts
Field label Excluded invalid accounts
Description A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type dimension
Data type string.text.json

TACTIC

creative_performance__cp_line_item__cp_stats__delivery_source__tactics__tactic_name
Field label Tactic name
Description Name of the tactic
Field type dimension
Data type string.text.value
creative_performance__cp_line_item__cp_stats__delivery_source__tactics__tactic_id
Field label Tactic ID
Description ID of the tactic
Field type dimension
Data type string.text.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__stats__year
Field label Year
Field type dimension
Data type string.time.year
campaign__stats__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign__stats__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign__stats__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign__stats__month
Field label Month
Field type dimension
Data type string.time.month
campaign__stats__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign__stats__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign__stats__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign__stats__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign__stats__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign__stats__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign__stats__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign__stats__date
Field label Date
Field type dimension
Data type string.time.date
campaign__stats__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
l_campaign__l_line_item__l_stats__year
Field label Year
Field type dimension
Data type string.time.year
l_campaign__l_line_item__l_stats__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
l_campaign__l_line_item__l_stats__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
l_campaign__l_line_item__l_stats__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
l_campaign__l_line_item__l_stats__month
Field label Month
Field type dimension
Data type string.time.month
l_campaign__l_line_item__l_stats__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
l_campaign__l_line_item__l_stats__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
l_campaign__l_line_item__l_stats__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
l_campaign__l_line_item__l_stats__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
l_campaign__l_line_item__l_stats__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
l_campaign__l_line_item__l_stats__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
l_campaign__l_line_item__l_stats__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
l_campaign__l_line_item__l_stats__date
Field label Date
Field type dimension
Data type string.time.date
l_campaign__l_line_item__l_stats__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
creative_performance__cp_line_item__cp_stats__year
Field label Year
Field type dimension
Data type string.time.year
creative_performance__cp_line_item__cp_stats__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
creative_performance__cp_line_item__cp_stats__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
creative_performance__cp_line_item__cp_stats__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
creative_performance__cp_line_item__cp_stats__month
Field label Month
Field type dimension
Data type string.time.month
creative_performance__cp_line_item__cp_stats__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
creative_performance__cp_line_item__cp_stats__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
creative_performance__cp_line_item__cp_stats__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
creative_performance__cp_line_item__cp_stats__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
creative_performance__cp_line_item__cp_stats__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
creative_performance__cp_line_item__cp_stats__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
creative_performance__cp_line_item__cp_stats__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
creative_performance__cp_line_item__cp_stats__date
Field label Date
Field type dimension
Data type string.time.date
creative_performance__cp_line_item__cp_stats__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

creative_performance__cp_line_item__cp_stats__video_starts
Field label 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
creative_performance__cp_line_item__cp_stats__video_completions
Field label Video completions
Description The number of times the audio or video ads was view to completion
Field type metric
Data type int.number.value

© Supermetrics 2025