Spotify Ads data warehouse table groups

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

Table: CAMPAIGN

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
performance__advertiser_id
Display name Advertiser ID
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__advertiser_name
Display name Advertiser name
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__campaign_current_status
Display name Campaign current status
Description Status of the campaign
Field type dimension
Data type string.text.value
performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
performance__clicks
Display name Clicks
Description The number of impressions in which your ad was clicked
Field type metric
Data type int.number.value
performance__completes
Display name Completes
Description The number of ads served that was played to the end
Field type metric
Data type int.number.value
performance__country
Display name Country
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.country.twolettercode
performance__currency
Display name Currency
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__dma
Display name DMA
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.region
performance__errors
Display name Errors
Description The number of times an error occurred. Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__fetch_reach
Display name Fetch reach
Description Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__fetches
Display name Fetches
Description The number of times an ad is called from the ad server. Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__first_quartiles
Display name 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__impressions
Display name Impressions
Description The number of times an ad has been served
Field type metric
Data type int.number.value
performance__midpoints
Display name 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__new_listeners
Display name 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__off_spotify_impressions
Display name Off Spotify impressions
Description The number of ads served off of Spotify
Field type metric
Data type int.number.value
performance__paid_listen_reach
Display name 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
performance__paid_listens
Display name 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__platform
Display name Platform
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__reach
Display name Reach
Description The number of unique users who received your ad
Field type metric
Data type int.number.value
performance__region
Display name Region
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.region
performance__skips
Display name Skips
Description The number of times a user skips and ad
Field type metric
Data type int.number.value
performance__spend
Display name Spend
Description The total amount spent
Field type metric
Data type float.currency.value
performance__starts
Display name Starts
Description The number of times a user starts hearing or viewing your ad
Field type metric
Data type int.number.value
performance__third_quartiles
Display name 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

Table: AD

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
performance__ad_current_status
Display name Ad current status
Description Status of the ad
Field type dimension
Data type string.text.value
performance__ad_id
Display name Ad ID
Description ID of the Ad
Field type dimension
Data type string.text.value
performance__ad_name
Display name Ad name
Description Name of the ad
Field type dimension
Data type string.text.value
performance__ad_set_budget_micros
Display name Ad set budget
Description Budget for the ad set
Field type dimension
Data type float.number.value
performance__ad_set_cost_type
Display name Ad set cost type
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__ad_set_currency
Display name Ad set currency
Description The currency of the ad set budget
Field type dimension
Data type string.text.value
performance__ad_set_current_status
Display name Ad set current status
Description Status of the ad set
Field type dimension
Data type string.text.value
performance__ad_set_end_date
Display name Ad set end date
Description The end date of the ad set
Field type dimension
Data type string.time.date
performance__ad_set_id
Display name Ad set ID
Description ID of the ad set
Field type dimension
Data type string.text.value
performance__ad_set_name
Display name Ad set name
Description Name of the ad set
Field type dimension
Data type string.text.value
performance__ad_set_start_date
Display name Ad set start date
Description The start date of the ad set
Field type dimension
Data type string.time.date
performance__advertiser_id
Display name Advertiser ID
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__advertiser_name
Display name Advertiser name
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__campaign_current_status
Display name Campaign current status
Description Status of the campaign
Field type dimension
Data type string.text.value
performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
performance__clicks
Display name Clicks
Description The number of impressions in which your ad was clicked
Field type metric
Data type int.number.value
performance__completes
Display name Completes
Description The number of ads served that was played to the end
Field type metric
Data type int.number.value
performance__cost_type
Display name Cost model
Description Method used to determine how advertisers are charged for their ad campaigns
Field type dimension
Data type string.text.value
performance__country
Display name Country
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.country.twolettercode
performance__currency
Display name Currency
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__date
Display name Date
Field type dimension
Data type string.time.date
performance__dma
Display name DMA
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.region
performance__errors
Display name Errors
Description The number of times an error occurred. Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__fetch_reach
Display name Fetch reach
Description Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__fetches
Display name Fetches
Description The number of times an ad is called from the ad server. Please note that this field will be removed on 2023-11-07
Field type metric
Data type int.number.value
performance__first_quartiles
Display name 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__impressions
Display name Impressions
Description The number of times an ad has been served
Field type metric
Data type int.number.value
performance__midpoints
Display name 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__new_listeners
Display name 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__off_spotify_impressions
Display name Off Spotify impressions
Description The number of ads served off of Spotify
Field type metric
Data type int.number.value
performance__paid_listen_reach
Display name 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
performance__paid_listens
Display name 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__platform
Display name Platform
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.text.value
performance__reach
Display name Reach
Description The number of unique users who received your ad
Field type metric
Data type int.number.value
performance__region
Display name Region
Description Please note that this field will be removed on 2023-11-07
Field type dimension
Data type string.geo.region
performance__skips
Display name Skips
Description The number of times a user skips and ad
Field type metric
Data type int.number.value
performance__spend
Display name Spend
Description The total amount spent
Field type metric
Data type float.currency.value
performance__starts
Display name Starts
Description The number of times a user starts hearing or viewing your ad
Field type metric
Data type int.number.value
performance__third_quartiles
Display name 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