StackAdapt fields

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

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

45 metrics36 dimensions

ADVERTISER

advertiser
Field label Advertiser
Description Name of advertiser, typically an agency or brand
Field type dimension
Data type string.text.value
advertiser_id
Field label Advertiser ID
Description Unique ID of the advertiser
Field type dimension
Data type string.text.value

AUDIO

audio_starts
Field label Audio started
Description Audio started
Field type metric
Data type int.number.value
audio_completions
Field label Audio completed
Description Audio completed
Field type metric
Data type int.number.value
audio_completion_rate
Field label Audio completion rate
Description Listen through rate, calculated by Audio completed / Audio started
Field type metric
Data type float.number.ratio

BASIC

impressions
Field label Impressions
Description Total number of Impressions served
Field type metric
Data type int.number.value
impressions_unique
Field label Unique impressions
Description Total number of unique people who were shown an ad
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description Total number of clicks registered
Field type metric
Data type int.number.value
ctr
Field label CTR
Description Click-through rate expressed as a percentage; Clicks divided by impressions X 100
Field type metric
Data type float.number.percentage
cost
Field label Media cost
Description Total budget spent on campaign
Field type metric
Data type float.currency.value
cpc
Field label CPC
Description Cost per click; Media cost divided by Clicks
Field type metric
Data type float.currency.value
cpm
Field label CPM
Description Cost per mille; Media cost divided by Impressions x 1000
Field type metric
Data type float.currency.value
cpe
Field label CPE
Description Cost per click; Media cost divided by Engagement
Field type metric
Data type float.currency.value
ecpcl
Field label eCPCL
Description Effective cost per completed listen. Calculated by Media cost / Audio completed
Field type metric
Data type float.currency.value
frequency
Field label Frequency
Description Impressions per unique impression
Field type metric
Data type float.number.ratio
tpcpc_cost
Field label Third-party CPC cost
Description Third-party CPC cost
Field type metric
Data type float.currency.value
tpcpm_cost
Field label Third-party CPM cost
Description Third-party CPM cost
Field type metric
Data type float.currency.value

CAMPAIGN

line_item
Field label Campaign group
Description Name of the campaign group, which organizes campaigns into one marketing initiative
Field type dimension
Data type string.text.value
campaign
Field label Campaign
Description Name of the campaign, which consists of creatives, targeting, and technical parameters to drive objectives
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description Unique ID of the campaign
Field type dimension
Data type string.text.value
campaign_type
Field label Campaign type
Description Describes the type of campaign, native or video
Field type dimension
Data type string.text.value

CONVERSIONS

conversions
Field label Conversions
Description Total number of times conversion event took place
Field type metric
Data type int.number.value
cvr
Field label Conversion rate
Description Conversion rate expressed as a percentage; Conversions divided by clicks X 100
Field type metric
Data type float.number.percentage
cpa
Field label Cost per conversion
Description Media cost divided by Conversions
Field type metric
Data type float.currency.value
impression_conversions
Field label Impression conversions
Description Number of impression conversions
Field type metric
Data type int.number.value
click_conversions
Field label Click conversions
Description Number of click conversions
Field type metric
Data type int.number.value
conversion_revenue
Field label Conversion revenue
Description Revenue generated through conversions
Field type metric
Data type float.currency.value
revenue
Field label Revenue
Description Total budget spent including margin
Field type metric
Data type float.currency.value
profit
Field label Profit
Description Margin kept from total budget
Field type metric
Data type float.currency.value
unique_conversions
Field label Unique conversions
Description Number of times a unique conversion event took place
Field type metric
Data type int.number.value
cookie_conversions
Field label Cookie conversions
Description Cookie conversions
Field type metric
Data type int.number.value
ip_conversions
Field label IP conversions
Description IP conversions
Field type metric
Data type int.number.value
secondary_conversions
Field label Secondary conversions
Description Secondary conversions
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

DEPRECATED

viewthrough_conversions
Field label View-through conversions
Description Number of view-through conversions.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2025-05-01

ENGAGEMENT

page_starts
Field label Page starts
Description Number of times user spent least 2 seconds on site
Field type metric
Data type int.number.value
page_time_15s
Field label 15s Engagements (LP)
Description Number of times user has spent at least 15 seconds on the advertiser's domain after clicking the ad
Field type metric
Data type int.number.value
page_time
Field label Total time on page
Description Total time spent on site
Field type metric
Data type int.number.value
engagement_rate
Field label Engagement rate
Description Engagement rate expressed as a percentage; Engagement divided by clicks X 100
Field type metric
Data type float.number.percentage
atos
Field label Average time on site
Description Average time on site (seconds)
Field type metric
Data type float.number.value
Aggregation Non-aggregatable metric

NATIVE AD

native_ad
Field label Creative ad
Description Name of ad creative
Field type dimension
Data type string.text.value
native_ad_id
Field label Creative ad ID
Description Unique ID of ad creative
Field type dimension
Data type string.text.value
heading
Field label Heading
Description Heading text used in ad creative
Field type dimension
Data type string.text.value
tagline
Field label Tagline
Description Tagline text used in ad creative
Field type dimension
Data type string.text.value
click_url
Field label Click URL
Description URL used in ad creative to drive users to a specific site
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

REVENUE

rcpa
Field label rCPA
Description Revenue cost per action. Calculated by Revenue / Conversions
Field type metric
Data type float.currency.value
rcpc
Field label rCPC
Description Revenue cost per click. Calculated by Revenue / Click
Field type metric
Data type float.currency.value
rcpcl
Field label rCPCL
Description Revenue cost per completed listen. Calculated by Revenue / Audio completed
Field type metric
Data type float.currency.value
rcpe
Field label rCPE
Description Revenue cost per engagement. Calculated by Revenue / 15s Engagements (LP)
Field type metric
Data type float.currency.value
rcpm
Field label rCPM
Description Revenue cost per mile. Calculated by (Revenue / Impressions) * 1000
Field type metric
Data type float.currency.value
roas
Field label ROAS
Description Return on ad spend. Calculated by Revenue / Media cost
Field type metric
Data type float.number.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
year
Field label Year
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
yearofweek
Field label Year of week (Sun-Sat)
Description Year of week for US-style Sunday-Saturday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearofweekiso
Field label Year of week (Mon-Sun)
Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017
Field type dimension
Data type string.time.year
yearmonth
Field label Year & month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
yearweek
Field label Year & week (Sun-Sat)
Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
yearweekiso
Field label Year & week (Mon-Sun)
Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
weekiso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
dayofmonth
Field label Day of month
Description Day of month, e.g. 2
Field type dimension
Data type string.time.dayofmonth
dayofweekname
Field label Day of week (Sun-Sat)
Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
dayofweeknameiso
Field label Day of week (Mon-Sun)
Description Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

VIDEO

vcomp_0
Field label Video started
Description Video views started
Field type metric
Data type int.number.value
vcomp_25
Field label Video completed to 25 %
Description Video watched to at least 25 %
Field type metric
Data type int.number.value
vcomp_50
Field label Video completed to 50 %
Description Video watched to at least 50 %
Field type metric
Data type int.number.value
vcomp_75
Field label Video completed to 75 %
Description Video watched to at least 75 %
Field type metric
Data type int.number.value
vcomp_95
Field label Video completed
Description Video watched to at least 95 %
Field type metric
Data type int.number.value
vcomp_rate
Field label Completion rate
Description Video completion rate. Calculated by Video completed / Video started
Field type metric
Data type float.number.value