Spotify Ads fields

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

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

39 metrics50 dimensions

AD

performance__ad_id
Field label Ad ID
Description ID of the Ad
Field type dimension
Data type string.text.value
performance__ad_name
Field label Ad name
Description Name of the ad
Field type dimension
Data type string.text.value
performance__ad_current_status
Field label Ad current status
Description Status of the ad
Field type dimension
Data type string.text.value

AD SET

performance__ad_set__ad_set_id
Field label Ad set ID
Description ID of the ad set
Field type dimension
Data type string.text.value
performance__ad_set__ad_set_name
Field label Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
performance__ad_set__ad_set_start_date_time
Field label Ad set start date and time
Description The start date and time of the ad set
Field type dimension
Data type string.time.datetime
performance__ad_set__ad_set_start_date
Field label Ad set start date
Description The start date of the ad set
Field type dimension
Data type string.time.date
performance__ad_set__ad_set_end_date_time
Field label Ad set end date and time
Description The end date and time of the ad set
Field type dimension
Data type string.time.datetime
performance__ad_set__ad_set_end_date
Field label Ad set end date
Description The end date of the ad set
Field type dimension
Data type string.time.date
performance__ad_set__ad_set_status
Field label Ad set current status
Description Status of the ad set
Field type dimension
Data type string.text.value
performance__ad_set__ad_set_budget_micros
Field label Ad set budget
Description Budget for the ad set
Field type dimension
Data type float.number.value
performance__ad_set__ad_set_currency
Field label Ad set currency
Description The currency of the ad set budget
Field type dimension
Data type string.text.value
performance__ad_set__cost_model
Field label Cost model
Description Method used to determine how advertisers are charged for their ad campaigns
Field type dimension
Data type string.text.value

CAMPAIGN

performance__ad_set__campaign__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
performance__ad_set__campaign__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
performance__ad_set__campaign__campaign_current_status
Field label Campaign current status
Description Status of the campaign
Field type dimension
Data type string.text.value

CORE METRICS

performance__details__impressions
Field label Impressions
Description The number of times an ad has been served
Field type metric
Data type int.number.value
performance__details__spend
Field label Spend
Description The total amount spent
Field type metric
Data type float.currency.value
performance__details__clicks
Field label Clicks
Description The number of impressions in which your ad was clicked
Field type metric
Data type int.number.value
performance__details__reach
Field label Reach
Description The number of unique users who received your ad
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
performance__details__frequency
Field label Frequency
Description The number of ads that were clicked (Impressions / Reach)
Field type metric
Data type float.number.value
performance__details__ctr
Field label CTR
Description The percentage of ads that were clicked (Clicks / Impressions)
Field type metric
Data type float.number.ratio
performance__details__cpm
Field label CPM
Description Cost per 1000 impressions ((Spend / Impressions) * 1000)
Field type metric
Data type float.currency.value
performance__details__ecpcl
Field label eCPCL
Description Effective cost per 1000 completed listens ((Spend / Completes) * 1000)
Field type metric
Data type float.currency.value
performance__details__off_spotify_impressions
Field label Off Spotify impressions
Description The number of ads served off of Spotify
Field type metric
Data type int.number.value
performance__details__completes
Field label Completes
Description The number of ads served that was played to the end
Field type metric
Data type int.number.value
performance__details__completion_rate
Field label Completion rate
Description The percentage of ad served that was played to the end (Completes / Impressions)
Field type metric
Data type float.number.ratio
performance__details__ad_played_to_25
Field label Ad played to 25%
Description The percentage of users who listened or viewed a given percentage of the ad (First quartiles / Impressions)
Field type metric
Data type float.number.ratio
performance__details__ad_played_to_50
Field label Ad played to 50%
Description The percentage of users who listened or viewed a given percentage of the ad (Midpoints / Impressions)
Field type metric
Data type float.number.ratio
performance__details__ad_played_to_75
Field label Ad played to 75%
Description The percentage of users who listened or viewed a given percentage of the ad (Third quartiles / Impressions)
Field type metric
Data type float.number.ratio

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

DELIVERY

performance__details__starts
Field label Starts
Description The number of times a user starts hearing or viewing your ad
Field type metric
Data type int.number.value
performance__details__first_quartiles
Field label First quartile plays
Description The number of users who listened or viewed 25% of the ad's total length
Field type metric
Data type int.number.value
performance__details__midpoints
Field label Midpoint plays
Description The number of users for which the ad played to the midpoint of the ad's total length
Field type metric
Data type int.number.value
performance__details__third_quartiles
Field label Third quartile plays
Description The number of users who listened or viewed 75% of the ad's total length
Field type metric
Data type int.number.value
performance__details__skips
Field label Skips
Description The number of times a user skips and ad
Field type metric
Data type int.number.value

DEPRECATED

performance__region
Field label Region
Field type dimension
Data type string.geo.region
🚫 Deprecated Deprecated on 2023-11-07
performance__platform
Field label Platform
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-11-07
performance__currency
Field label Currency
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-11-07
performance__country
Field label Country
Field type dimension
Data type string.geo.country.twolettercode
🚫 Deprecated Deprecated on 2023-11-07
performance__advertiser_name
Field label Advertiser name
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-11-07
performance__advertiser_id
Field label Advertiser ID
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-11-07
performance__ad_set_cost_type
Field label Ad set cost type
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2023-11-07
performance__dma
Field label DMA
Field type dimension
Data type string.geo.region
🚫 Deprecated Deprecated on 2023-11-07
performance__serve_freq
Field label Serve frequency
Description The average number of times each person heard or viewed your ad.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2023-11-07
performance__render_ratio
Field label Render ratio
Description The percentage of impressions in which a creative is actually displayed to the user.
Field type metric
Data type float.number.ratio
🚫 Deprecated Deprecated on 2023-11-07
performance__fetch_reach
Field label Fetch reach
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2023-11-07
performance__serves
Field label Serves
Description The total number of ads served.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2023-11-07
performance__fetches
Field label Fetches
Description The number of times an ad is called from the ad server.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2023-11-07
performance__spend_gbp
Field label Spend (GBP)
Description Spend converted to GBP.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2023-11-07
performance__spend_eur
Field label Spend (EUR)
Description Spend converted to EUR.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2023-11-07
performance__spend_usd
Field label Spend (USD)
Description Spend converted to USD.
Field type metric
Data type float.currency.value
🚫 Deprecated Deprecated on 2023-11-07
performance__errors
Field label Errors
Description The number of times an error occurred.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2023-11-07

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

STREAMING CONVERSION METRICS

performance__details__paid_listens
Field label Paid listens
Description The number of listens for a CPCL campaign where user did not skip the ad
Field type metric
Data type int.number.value
performance__details__paid_listen_freq
Field label Paid listens frequency
Description The frequency for listens on a CPCL campaign (Paid listens / Paid listen reach)
Field type metric
Data type float.number.value
performance__details__paid_listen_reach
Field label Paid listen reach
Description The number of unique users who had a paid listen for this CPCL campaign
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
performance__details__conversion_rate
Field label Conversion rate
Description The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign (Unique listeners / Impressions)
Field type metric
Data type float.number.ratio
performance__details__intent_rate
Field label Intent rate
Description The rate at which listeners indicated an intent to stream the artist again in the future
Field type metric
Data type float.number.ratio
performance__details__new_listeners
Field label New listeners
Description The total number of users who listened to the artist for the first time in at least a month after seeing or hearing the ad
Field type metric
Data type int.number.value
performance__details__new_listener_conversion_rate
Field label New listener conversion rate
Description The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad
Field type metric
Data type float.number.ratio
performance__details__streams
Field label Streams
Description The total number of streams from listeners who saw or heard the ad
Field type metric
Data type int.number.value
performance__details__streams_per_listener
Field label Streams per listener
Description The average number of times each listener streamed the artist after seeing or hearing the ad (Streams / Unique listeners)
Field type metric
Data type float.number.value
performance__details__streams_per_new_listener
Field label Streams per new listener
Description The average number of times each new listener streamed the artist after seeing or hearing the ad (Streams / New listeners)
Field type metric
Data type float.number.value
performance__details__unique_listeners
Field label Unique listeners
Description The number of users who listened to the artist after hearing or seeing an ad
Field type metric
Data type int.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
performance__details__year
Field label Year
Field type dimension
Data type string.time.year
performance__details__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
performance__details__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
performance__details__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
performance__details__month
Field label Month
Field type dimension
Data type string.time.month
performance__details__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
performance__details__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
performance__details__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
performance__details__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
performance__details__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
performance__details__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
performance__details__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
performance__details__date
Field label Date
Field type dimension
Data type string.time.date
performance__details__atom
Field label Datetime
Field type dimension
Data type string.time.datetime