Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Spotify Ads data to
Spotify Ads Connector Reference
316 metrics60 dimensions
https://connectors.windsor.ai/spotify?api_key=[your API key]&date_preset=last_7d&fields=date,spend,impressions,clicks,ctr
The Spotify Ads connector exposes 376 fields (316 metrics, 60 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Spotify Ads Fields
Spotify Ads Ad fields
The Ad report of the Spotify Ads connector includes 59 fields.
Spotify Ads Ad fields (ad to ad_return_on_ad_spend)
| ID | Type | Name | Description |
|---|---|---|---|
| ad | TEXT | Ad | Dimension for ad. |
| ad_add_to_cart | NUMERIC | Ad Add To Cart | The number of add-to-cart events attributed to this ad |
| ad_average_order_value | NUMERIC | Ad Average Order Value | The average revenue per purchase attributed to this ad |
| ad_clicks | NUMERIC | Spotify Ad Clicks | The number of impressions in which your ad was clicked |
| ad_completes | NUMERIC | Ad Completes | The number of ads served that was played to the end |
| ad_conversion_rate | PERCENT | Ad Conversion Rate | The percentage of users who listened to the artist after seeing or hearing an ad served by the ad |
| ad_cost_per_lead | NUMERIC | Ad Cost Per Lead | The average cost per lead for this ad |
| ad_ctr | PERCENT | Ad CTR | The percentage of ads that were clicked (%) |
| ad_custom_event_1 | NUMERIC | Ad Custom Event 1 | Custom event 1 attributed to this ad |
| ad_custom_event_2 | NUMERIC | Ad Custom Event 2 | Custom event 2 attributed to this ad |
| ad_custom_event_3 | NUMERIC | Ad Custom Event 3 | Custom event 3 attributed to this ad |
| ad_custom_event_4 | NUMERIC | Ad Custom Event 4 | Custom event 4 attributed to this ad |
| ad_custom_event_5 | NUMERIC | Ad Custom Event 5 | Custom event 5 attributed to this ad |
| ad_customer_acquisition_cost | NUMERIC | Ad Customer Acquisition Cost | The average cost to acquire a customer for this ad |
| ad_ecpcl | NUMERIC | Ad Effective Cost per Completed Listen | The average cost per 1,000 completed listens |
| ad_ecpm | NUMERIC | Ad Effective Cost Per Mille | The average cost per 1,000 impressions |
| ad_entity_id | TEXT | Ad Entity Id | Ad Entity Id |
| ad_entity_status | TEXT | Ad Entity Status | Ad Entity Status |
| ad_first_quartiles | NUMERIC | Ad First Quartiles | The number of users who listened or viewed 25% of the ad's total length |
| ad_frequency | NUMERIC | Ad Frequency of Ads Served | The average number of times each person heard or viewed your ad |
| ad_impressions | NUMERIC | Ad Impressions | The number of times an ad has been successfully served |
| ad_intent_rate | PERCENT | Ad Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| ad_leads | NUMERIC | Ad Leads | The number of leads generated from this ad |
| ad_listeners | NUMERIC | Ad Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| ad_midpoints | NUMERIC | Ad Midpoints | The number of users for which the ad played to the midpoint of the ads total length |
| ad_new_listener_conversion_rate | PERCENT | Ad New Listener Conversion Rate | The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| ad_new_listener_streams | NUMERIC | Ad New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| ad_new_listeners | NUMERIC | Ad New Listeners | 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 |
| ad_off_spotify_impressions | NUMERIC | Ad Off Spotify Impressions | The number of ads served off of Spotify |
| ad_page_views | NUMERIC | Ad Page Views | The number of page views resulting from this ad |
| ad_paid_listen_frequency | NUMERIC | Ad Paid Listen Frequency | The average frequency for listens on a CPCL ad -- NOTE: Applies to CPCL ads only |
| ad_paid_listen_reach | NUMERIC | Ad Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL ad -- NOTE: Applies to active audio/CPCL ads only |
| ad_paid_listens | NUMERIC | Ad Paid Listens | The number of listens for a CPCL ad where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL ads only |
| ad_parent_entity_id | TEXT | Ad Parent Entity Id | Ad Parent Entity Id |
| ad_parent_entity_name | TEXT | Ad Parent Entity Name | Ad Parent Entity Name |
| ad_parent_entity_status | TEXT | Ad Parent Entity Status | Ad Parent Entity Status |
| ad_products | NUMERIC | Ad Products | The number of products involved in conversion events for this ad |
| ad_purchases | NUMERIC | Ad Purchases | The number of purchases attributed to this ad |
| ad_reach | NUMERIC | Ad Reach of Ads Served | The number of unique users who received your ad |
| ad_return_on_ad_spend | NUMERIC | Ad Return On Ad Spend | The return on ad spend (revenue divided by spend) for this ad |
Spotify Ads Ad fields (ad_revenue to ad_video_views)
| ID | Type | Name | Description |
|---|---|---|---|
| ad_revenue | NUMERIC | Ad Revenue | The total revenue generated from this ad |
| ad_set_entity_id | TEXT | Ad Set Entity Id | Ad Set Entity Id |
| ad_set_entity_status | TEXT | Ad Set Entity Status | Ad Set Entity Status |
| ad_set_parent_entity_id | TEXT | Ad Set Parent Entity Id | Ad Set Parent Entity Id |
| ad_set_parent_entity_name | TEXT | Ad Set Parent Entity Name | Ad Set Parent Entity Name |
| ad_set_parent_entity_status | TEXT | Ad Set Parent Entity Status | Ad Set Parent Entity Status |
| ad_sign_ups | NUMERIC | Ad Sign Ups | The number of sign-up events attributed to this ad |
| ad_skips | NUMERIC | Ad Skips | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| ad_spend | NUMERIC | Ad Amount Spent | The total amount spent in this ad |
| ad_start_checkout | NUMERIC | Ad Start Checkout | The number of checkout-start events attributed to this ad |
| ad_starts | NUMERIC | Ad Starts | The number of times a user starts hearing/viewing your ad |
| ad_streamed_impressions | NUMERIC | Ad Streamed Impressions | The number of streamed impressions for this ad |
| ad_streams | NUMERIC | Ad Streams | The total number of streams from listeners who saw/heard the ad (#) |
| ad_streams_per_new_listener | NUMERIC | Ad Streams per new listener | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| ad_streams_per_user | NUMERIC | Ad Streams Per Listener | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| ad_third_quartiles | NUMERIC | Ad Third Quartiles | The number of users who listened or viewed 75% of the ad's total length |
| ad_video_expand_rate | PERCENT | Ad Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen |
| ad_video_expands | NUMERIC | Ad Video Expands | The number of times your video ad was expanded to full screen |
| ad_video_views | NUMERIC | Ad Video Views | The number of times your video ad was viewed |
Spotify Ads Ad_Set fields
The Ad_Set report of the Spotify Ads connector includes 67 fields.
Spotify Ads Ad_Set fields (ad_set to ad_set_off_spotify_impressions)
| ID | Type | Name | Description |
|---|---|---|---|
| ad_set | TEXT | Ad_Set | Dimension for ad_set. |
| ad_set_add_to_cart | NUMERIC | Ad_Set Add To Cart | The number of add-to-cart events attributed to this ad set |
| ad_set_asset_format | TEXT | Ad Set Asset Format | Format of the asset (AUDIO/VIDEO/IMAGE) |
| ad_set_average_order_value | NUMERIC | Ad_Set Average Order Value | The average revenue per purchase attributed to this ad set |
| ad_set_base_rate_micro_amount | NUMERIC | Ad Set Base Rate Micro Amount | Base rate per 1000 impressions in micros |
| ad_set_bid_micro_amount | NUMERIC | Ad Set Bid Micro Amount | Bid per 1000 impressions in micros |
| ad_set_bid_strategy | TEXT | Ad Set Bid Strategy Type | Bid strategy (MAX_BID/COST_PER_RESULT) |
| ad_set_category | TEXT | Ad Set Category | Ad category ID of the ad set |
| ad_set_clicks | NUMERIC | Ad_Set Clicks | The number of impressions in which your ad was clicked |
| ad_set_completes | NUMERIC | Ad_Set Completes | The number of impressions in which your ad was clicked |
| ad_set_conversion_rate | PERCENT | Ad_Set Conversion Rate | The percentage of users who listened to the artist after seeing or hearing an ad served by the ad_set |
| ad_set_cost_model | TEXT | Ad Set Cost Model | Charge method (CPM/CPCL) |
| ad_set_cost_per_lead | NUMERIC | Ad_Set Cost Per Lead | The average cost per lead for this ad set |
| ad_set_created_at | Ad Set Created At | Date the ad set was created | |
| ad_set_ctr | PERCENT | Ad_Set CTR | The percentage of ads that were clicked (%) |
| ad_set_custom_event_1 | NUMERIC | Ad_Set Custom Event 1 | Custom event 1 attributed to this ad set |
| ad_set_custom_event_2 | NUMERIC | Ad_Set Custom Event 2 | Custom event 2 attributed to this ad set |
| ad_set_custom_event_3 | NUMERIC | Ad_Set Custom Event 3 | Custom event 3 attributed to this ad set |
| ad_set_custom_event_4 | NUMERIC | Ad_Set Custom Event 4 | Custom event 4 attributed to this ad set |
| ad_set_custom_event_5 | NUMERIC | Ad_Set Custom Event 5 | Custom event 5 attributed to this ad set |
| ad_set_customer_acquisition_cost | NUMERIC | Ad_Set Customer Acquisition Cost | The average cost to acquire a customer for this ad set |
| ad_set_dataset_id | TEXT | Ad Set Dataset ID | Dataset attached to the ad set |
| ad_set_delivery | TEXT | Ad Set Delivery | Delivery toggle (ON/OFF) |
| ad_set_delivery_goal | TEXT | Ad Set Delivery Goal | Goal of the ad set (IMPRESSIONS/REACH/CLICKS/etc.) |
| ad_set_ecpcl | NUMERIC | Ad_Set Effective Cost per Completed Listen | The average cost per 1,000 completed listens |
| ad_set_ecpm | NUMERIC | Ad_Set Effective Cost Per Mille | The average cost per 1,000 impressions |
| ad_set_end_time | Ad Set Scheduled End Time | Scheduled end time of the ad set | |
| ad_set_first_quartiles | NUMERIC | Ad_Set First Quartiles | The number of users who listened or viewed 25% of the ad's total length |
| ad_set_frequency | NUMERIC | Ad_Set Frequency of Ads Served | The average number of times each person heard or viewed your ad |
| ad_set_impressions | NUMERIC | Ad_Set Impressions | The number of times an ad has been successfully served |
| ad_set_intent_rate | PERCENT | Ad_Set Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| ad_set_is_paused | TEXT | Ad Set Is Paused | Whether the ad set is currently paused |
| ad_set_leads | NUMERIC | Ad_Set Leads | The number of leads generated from this ad set |
| ad_set_listeners | NUMERIC | Ad_Set Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| ad_set_midpoints | NUMERIC | Ad_Set Midpoints | The number of users for which the ad played to the midpoint of the ads total length |
| ad_set_mobile_app_id | TEXT | Ad Set Mobile App ID | Mobile app tied to the ad set |
| ad_set_new_listener_conversion_rate | PERCENT | Ad_Set New Listener Conversion Rate | The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| ad_set_new_listener_streams | NUMERIC | Ad_Set New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| ad_set_new_listeners | NUMERIC | Ad_Set New Listeners | 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 |
| ad_set_off_spotify_impressions | NUMERIC | Ad_Set Off Spotify Impressions | The number of ads served off of Spotify |
Spotify Ads Ad_Set fields (ad_set_pacing to ad_set_video_views)
| ID | Type | Name | Description |
|---|---|---|---|
| ad_set_pacing | TEXT | Ad Set Pacing | Pacing option (PACING_EVEN/PACING_ASAP) |
| ad_set_page_views | NUMERIC | Ad_Set Page Views | The number of page views resulting from this ad set |
| ad_set_paid_listen_frequency | NUMERIC | Ad_Set Paid Listen Frequency | The average frequency for listens on a CPCL ad_set -- NOTE: Applies to CPCL ad_sets only |
| ad_set_paid_listen_reach | NUMERIC | Ad_Set Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL ad_set -- NOTE: Applies to active audio/CPCL ad_sets only |
| ad_set_paid_listens | NUMERIC | Ad_Set Paid Listens | The number of listens for a CPCL ad_set where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL ad_sets only |
| ad_set_pause_reason | TEXT | Ad Set Pause Reason | Reason for pause (USER_PAUSED/ACCOUNT_GREYLISTED/ACCOUNT_SUSPENDED) |
| ad_set_products | NUMERIC | Ad_Set Products | The number of products involved in conversion events for this ad set |
| ad_set_purchases | NUMERIC | Ad_Set Purchases | The number of purchases attributed to this ad set |
| ad_set_reach | NUMERIC | Ad_Set Reach of Ads Served | The number of unique users who received your ad |
| ad_set_reject_reason | TEXT | Ad Set Reject Reason | Reason the ad set was rejected |
| ad_set_return_on_ad_spend | NUMERIC | Ad_Set Return On Ad Spend | The return on ad spend (revenue divided by spend) for this ad set |
| ad_set_revenue | NUMERIC | Ad_Set Revenue | The total revenue generated from this ad set |
| ad_set_sign_ups | NUMERIC | Ad_Set Sign Ups | The number of sign-up events attributed to this ad set |
| ad_set_skips | NUMERIC | Ad_Set Skips | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| ad_set_spend | NUMERIC | Ad_Set Amount Spent | The total amount spent in this ad_set |
| ad_set_start_checkout | NUMERIC | Ad_Set Start Checkout | The number of checkout-start events attributed to this ad set |
| ad_set_start_time | Ad Set Scheduled Start Time | Scheduled start time of the ad set | |
| ad_set_starts | NUMERIC | Ad_Set Starts | The number of times a user starts hearing/viewing your ad |
| ad_set_streamed_impressions | NUMERIC | Ad_Set Streamed Impressions | The number of streamed impressions for this ad set |
| ad_set_streams | NUMERIC | Ad_Set Streams | The total number of streams from listeners who saw/heard the ad (#) |
| ad_set_streams_per_new_listener | NUMERIC | Ad_Set Streams per new listener | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| ad_set_streams_per_user | NUMERIC | Ad_Set Streams Per Listener | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| ad_set_third_quartiles | NUMERIC | Ad_Set Third Quartiles | The number of users who listened or viewed 75% of the ad's total length |
| ad_set_updated_at | Ad Set Updated At | Date the ad set was last updated | |
| ad_set_video_expand_rate | PERCENT | Ad_Set Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen |
| ad_set_video_expands | NUMERIC | Ad_Set Video Expands | The number of times your video ad was expanded to full screen |
| ad_set_video_views | NUMERIC | Ad_Set Video Views | The number of times your video ad was viewed |
Spotify Ads Age fields
The Age report of the Spotify Ads connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| age | TEXT | Age | Dimension for age. |
| age_add_to_cart | NUMERIC | Age Add To Cart | The number of add-to-cart events attributed to this age group |
| age_average_order_value | NUMERIC | Age Average Order Value | The average revenue per purchase attributed to this age group |
| age_clicks | NUMERIC | Age Clicks | The number of impressions in which your ad was clicked |
| age_conversion_rate | PERCENT | Age Conversion Rate | The percentage of users who listened to the artist after seeing or hearing an ad served by the age |
| age_ctr | PERCENT | Age CTR | The percentage of ads that were clicked (%) |
| age_custom_event_1 | NUMERIC | Age Custom Event 1 | Custom event 1 attributed to this age group |
| age_custom_event_2 | NUMERIC | Age Custom Event 2 | Custom event 2 attributed to this age group |
| age_custom_event_3 | NUMERIC | Age Custom Event 3 | Custom event 3 attributed to this age group |
| age_custom_event_4 | NUMERIC | Age Custom Event 4 | Custom event 4 attributed to this age group |
| age_custom_event_5 | NUMERIC | Age Custom Event 5 | Custom event 5 attributed to this age group |
| age_ecpm | NUMERIC | Age Effective Cost Per Mille | The average cost per 1,000 impressions |
| age_entity | TEXT | Age Entity | Entity name |
| age_impressions | NUMERIC | Age Impressions | The number of times an ad has been successfully served |
| age_intent_rate | PERCENT | Age Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| age_leads | NUMERIC | Age Leads | The number of leads generated from this age group |
| age_listeners | NUMERIC | Age Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| age_new_listener_conversion_rate | PERCENT | Age New Listener Conversion Rate | The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| age_new_listener_streams | NUMERIC | Age New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| age_new_listeners | NUMERIC | Age New Listeners | 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 |
| age_page_views | NUMERIC | Age Page Views | The number of page views resulting from this age group |
| age_paid_listen_reach | NUMERIC | Age Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL age -- NOTE: Applies to active audio/CPCL ages only |
| age_paid_listens | NUMERIC | Age Paid Listens | The number of listens for a CPCL age where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL ages only |
| age_products | NUMERIC | Age Products | The number of products involved in conversion events for this age group |
| age_purchases | NUMERIC | Age Purchases | The number of purchases attributed to this age group |
| age_reach | NUMERIC | Age Reach of Ads Served | The number of unique users who received your ad |
| age_revenue | NUMERIC | Age Revenue | The total revenue generated from this age group |
| age_sign_ups | NUMERIC | Age Sign Ups | The number of sign-up events attributed to this age group |
| age_start_checkout | NUMERIC | Age Start Checkout | The number of checkout-start events attributed to this age group |
| age_streamed_impressions | NUMERIC | Age Streamed Impressions | The number of streamed impressions for this age group |
| age_streams | NUMERIC | Age Streams | The total number of streams from listeners who saw/heard the ad (#) |
| age_streams_per_new_listener | NUMERIC | Age Streams per new listener | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| age_streams_per_user | NUMERIC | Age Streams Per Listener | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| age_video_expand_rate | PERCENT | Age Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen for this age group |
| age_video_expands | NUMERIC | Age Video Expands | The number of times your video ad was expanded to full screen for this age group |
| age_video_views | NUMERIC | Age Video Views | The number of times your video ad was viewed for this age group |
Spotify Ads Campaign fields
The Campaign report of the Spotify Ads connector includes 49 fields.
Spotify Ads Campaign fields (campaign to campaign_start_checkout)
| ID | Type | Name | Description |
|---|---|---|---|
| campaign | TEXT | Campaign | Dimension for campaign. |
| campaign_add_to_cart | NUMERIC | Campaign Add To Cart | The number of add-to-cart events attributed to this campaign |
| campaign_average_order_value | NUMERIC | Campaign Average Order Value | The average revenue per purchase attributed to this campaign |
| campaign_clicks | NUMERIC | Campaign Clicks | The number of impressions in which your ad was clicked |
| campaign_completes | NUMERIC | Campaign Completes | The number of ads served that was played to the end |
| campaign_conversion_rate | PERCENT | Campaign Conversion Rate | The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign |
| campaign_cost_per_lead | NUMERIC | Campaign Cost Per Lead | The average cost per lead for this campaign |
| campaign_ctr | PERCENT | Campaign CTR | The percentage of ads that were clicked (%) |
| campaign_custom_event_1 | NUMERIC | Campaign Custom Event 1 | Custom event 1 attributed to this campaign |
| campaign_custom_event_2 | NUMERIC | Campaign Custom Event 2 | Custom event 2 attributed to this campaign |
| campaign_custom_event_3 | NUMERIC | Campaign Custom Event 3 | Custom event 3 attributed to this campaign |
| campaign_custom_event_4 | NUMERIC | Campaign Custom Event 4 | Custom event 4 attributed to this campaign |
| campaign_custom_event_5 | NUMERIC | Campaign Custom Event 5 | Custom event 5 attributed to this campaign |
| campaign_customer_acquisition_cost | NUMERIC | Campaign Customer Acquisition Cost | The average cost to acquire a customer for this campaign |
| campaign_ecpcl | NUMERIC | Campaign Effective Cost per Completed Listen | The average cost per 1,000 completed listens |
| campaign_ecpm | NUMERIC | Campaign Effective Cost Per Mille | The average cost per 1,000 impressions |
| campaign_first_quartiles | NUMERIC | Campaign First Quartiles | The number of users who listened or viewed 25% of the ad's total length |
| campaign_frequency | NUMERIC | Campaign Frequency of Ads Served | The average number of times each person heard or viewed your ad |
| campaign_impressions | NUMERIC | Campaign Impressions | The number of times an ad has been successfully served |
| campaign_intent_rate | PERCENT | Campaign Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| campaign_leads | NUMERIC | Campaign Leads | The number of leads generated from this campaign |
| campaign_listeners | NUMERIC | Campaign Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| campaign_midpoints | NUMERIC | Campaign Midpoints | The number of users for which the ad played to the midpoint of the ads total length |
| campaign_new_listener_conversion_rate | PERCENT | Campaign New Listener Conversion Rate | The percentage of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| campaign_new_listener_streams | NUMERIC | Campaign New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| campaign_new_listeners | NUMERIC | Campaign New Listeners | 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 |
| campaign_off_spotify_impressions | NUMERIC | Campaign Off Spotify Impressions | The number of ads served off of Spotify |
| campaign_page_views | NUMERIC | Campaign Page Views | The number of page views resulting from this campaign |
| campaign_paid_listen_frequency | NUMERIC | Campaign Paid Listen Frequency | The average frequency for listens on a CPCL campaign -- NOTE: Applies to CPCL campaigns only |
| campaign_paid_listen_reach | NUMERIC | Campaign Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL campaign -- NOTE: Applies to active audio/CPCL campaigns only |
| campaign_paid_listens | NUMERIC | Campaign Paid Listens | The number of listens for a CPCL campaign where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL campaigns only |
| campaign_products | NUMERIC | Campaign Products | The number of products involved in conversion events for this campaign |
| campaign_purchases | NUMERIC | Campaign Purchases | The number of purchases attributed to this campaign |
| campaign_reach | NUMERIC | Campaign Reach of Ads Served | The number of unique users who received your ad |
| campaign_return_on_ad_spend | NUMERIC | Campaign Return On Ad Spend | The return on ad spend (revenue divided by spend) for this campaign |
| campaign_revenue | NUMERIC | Campaign Revenue | The total revenue generated from this campaign |
| campaign_sign_ups | NUMERIC | Campaign Sign Ups | The number of sign-up events attributed to this campaign |
| campaign_skips | NUMERIC | Campaign Skips | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| campaign_spend | NUMERIC | Campaign Amount Spent | The total amount spent in this campaign |
| campaign_start_checkout | NUMERIC | Campaign Start Checkout | The number of checkout-start events attributed to this campaign |
Spotify Ads Campaign fields (campaign_starts to campaign_video_views)
| ID | Type | Name | Description |
|---|---|---|---|
| campaign_starts | NUMERIC | Campaign Starts | The number of times a user starts hearing/viewing your ad |
| campaign_streamed_impressions | NUMERIC | Campaign Streamed Impressions | The number of streamed impressions for this campaign |
| campaign_streams | NUMERIC | Campaign Streams | The total number of streams from listeners who saw/heard the ad (#) |
| campaign_streams_per_new_listener | NUMERIC | Campaign Streams per new listener | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| campaign_streams_per_user | NUMERIC | Campaign Streams Per Listener | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| campaign_third_quartiles | NUMERIC | Campaign Third Quartiles | The number of users who listened or viewed 75% of the ad's total length |
| campaign_video_expand_rate | PERCENT | Campaign Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen |
| campaign_video_expands | NUMERIC | Campaign Video Expands | The number of times your video ad was expanded to full screen |
| campaign_video_views | NUMERIC | Campaign Video Views | The number of times your video ad was viewed |
Spotify Ads Country fields
The Country report of the Spotify Ads connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| country | COUNTRY | Country | Dimension for country. |
| country_add_to_cart | NUMERIC | Country Add To Cart | The number of add-to-cart events attributed to this country |
| country_average_order_value | NUMERIC | Country Average Order Value | The average revenue per purchase attributed to this country |
| country_clicks | NUMERIC | Country Clicks | The number of impressions in which your ad was clicked |
| country_conversion_rate | PERCENT | Country Conversion Rate | The percentcountry of users who listened to the artist after seeing or hearing an ad served by the country |
| country_ctr | PERCENT | Country CTR | The percentcountry of ads that were clicked (%) |
| country_custom_event_1 | NUMERIC | Country Custom Event 1 | Custom event 1 attributed to this country |
| country_custom_event_2 | NUMERIC | Country Custom Event 2 | Custom event 2 attributed to this country |
| country_custom_event_3 | NUMERIC | Country Custom Event 3 | Custom event 3 attributed to this country |
| country_custom_event_4 | NUMERIC | Country Custom Event 4 | Custom event 4 attributed to this country |
| country_custom_event_5 | NUMERIC | Country Custom Event 5 | Custom event 5 attributed to this country |
| country_ecpm | NUMERIC | Country Effective Cost Per Mille | The avercountry cost per 1,000 impressions |
| country_entity | COUNTRY | Country Entity | Country entity |
| country_impressions | NUMERIC | Country Impressions | The number of times an ad has been successfully served |
| country_intent_rate | PERCENT | Country Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| country_leads | NUMERIC | Country Leads | The number of leads generated from this country |
| country_listeners | NUMERIC | Country Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| country_new_listener_conversion_rate | PERCENT | Country New Listener Conversion Rate | The percentcountry of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| country_new_listener_streams | NUMERIC | Country New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| country_new_listeners | NUMERIC | Country New Listeners | 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 |
| country_page_views | NUMERIC | Country Page Views | The number of page views resulting from this country |
| country_paid_listen_reach | NUMERIC | Country Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL country -- NOTE: Applies to active audio/CPCL countrys only |
| country_paid_listens | NUMERIC | Country Paid Listens | The number of listens for a CPCL country where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL countrys only |
| country_products | NUMERIC | Country Products | The number of products involved in conversion events for this country |
| country_purchases | NUMERIC | Country Purchases | The number of purchases attributed to this country |
| country_reach | NUMERIC | Country Reach of Ads Served | The number of unique users who received your ad |
| country_revenue | NUMERIC | Country Revenue | The total revenue generated from this country |
| country_sign_ups | NUMERIC | Country Sign Ups | The number of sign-up events attributed to this country |
| country_start_checkout | NUMERIC | Country Start Checkout | The number of checkout-start events attributed to this country |
| country_streamed_impressions | NUMERIC | Country Streamed Impressions | The number of streamed impressions for this country |
| country_streams | NUMERIC | Country Streams | The total number of streams from listeners who saw/heard the ad (#) |
| country_streams_per_new_listener | NUMERIC | Country Streams per new listener | The avercountry number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| country_streams_per_user | NUMERIC | Country Streams Per Listener | The avercountry number of times each listener streamed the artist after seeing/hearing the ad (#) |
| country_video_expand_rate | PERCENT | Country Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen for this country |
| country_video_expands | NUMERIC | Country Video Expands | The number of times your video ad was expanded to full screen for this country |
| country_video_views | NUMERIC | Country Video Views | The number of times your video ad was viewed for this country |
Spotify Ads Gender fields
The Gender report of the Spotify Ads connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| gender | TEXT | Gender | Dimension for gender. |
| gender_add_to_cart | NUMERIC | Gender Add To Cart | The number of add-to-cart events attributed to this gender |
| gender_average_order_value | NUMERIC | Gender Average Order Value | The average revenue per purchase attributed to this gender |
| gender_clicks | NUMERIC | Gender Clicks | The number of impressions in which your ad was clicked |
| gender_conversion_rate | PERCENT | Gender Conversion Rate | The percentgender of users who listened to the artist after seeing or hearing an ad served by the gender |
| gender_ctr | PERCENT | Gender CTR | The percentgender of ads that were clicked (%) |
| gender_custom_event_1 | NUMERIC | Gender Custom Event 1 | Custom event 1 attributed to this gender |
| gender_custom_event_2 | NUMERIC | Gender Custom Event 2 | Custom event 2 attributed to this gender |
| gender_custom_event_3 | NUMERIC | Gender Custom Event 3 | Custom event 3 attributed to this gender |
| gender_custom_event_4 | NUMERIC | Gender Custom Event 4 | Custom event 4 attributed to this gender |
| gender_custom_event_5 | NUMERIC | Gender Custom Event 5 | Custom event 5 attributed to this gender |
| gender_ecpm | NUMERIC | Gender Effective Cost Per Mille | The avergender cost per 1,000 impressions |
| gender_entity | TEXT | Gender Entity | Dimension for gender. |
| gender_impressions | NUMERIC | Gender Impressions | The number of times an ad has been successfully served |
| gender_intent_rate | PERCENT | Gender Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| gender_leads | NUMERIC | Gender Leads | The number of leads generated from this gender |
| gender_listeners | NUMERIC | Gender Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| gender_new_listener_conversion_rate | PERCENT | Gender New Listener Conversion Rate | The percentgender of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| gender_new_listener_streams | NUMERIC | Gender New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| gender_new_listeners | NUMERIC | Gender New Listeners | 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 |
| gender_page_views | NUMERIC | Gender Page Views | The number of page views resulting from this gender |
| gender_paid_listen_reach | NUMERIC | Gender Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL gender -- NOTE: Applies to active audio/CPCL genders only |
| gender_paid_listens | NUMERIC | Gender Paid Listens | The number of listens for a CPCL gender where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL genders only |
| gender_products | NUMERIC | Gender Products | The number of products involved in conversion events for this gender |
| gender_purchases | NUMERIC | Gender Purchases | The number of purchases attributed to this gender |
| gender_reach | NUMERIC | Gender Reach of Ads Served | The number of unique users who received your ad |
| gender_revenue | NUMERIC | Gender Revenue | The total revenue generated from this gender |
| gender_sign_ups | NUMERIC | Gender Sign Ups | The number of sign-up events attributed to this gender |
| gender_start_checkout | NUMERIC | Gender Start Checkout | The number of checkout-start events attributed to this gender |
| gender_streamed_impressions | NUMERIC | Gender Streamed Impressions | The number of streamed impressions for this gender |
| gender_streams | NUMERIC | Gender Streams | The total number of streams from listeners who saw/heard the ad (#) |
| gender_streams_per_new_listener | NUMERIC | Gender Streams per new listener | The avergender number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| gender_streams_per_user | NUMERIC | Gender Streams Per Listener | The avergender number of times each listener streamed the artist after seeing/hearing the ad (#) |
| gender_video_expand_rate | PERCENT | Gender Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen for this gender |
| gender_video_expands | NUMERIC | Gender Video Expands | The number of times your video ad was expanded to full screen for this gender |
| gender_video_views | NUMERIC | Gender Video Views | The number of times your video ad was viewed for this gender |
Spotify Ads Genre fields
The Genre report of the Spotify Ads connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| genre | TEXT | Genre | Dimension for genre. |
| genre_add_to_cart | NUMERIC | Genre Add To Cart | The number of add-to-cart events attributed to this genre |
| genre_average_order_value | NUMERIC | Genre Average Order Value | The average revenue per purchase attributed to this genre |
| genre_clicks | NUMERIC | Genre Clicks | The number of impressions in which your ad was clicked |
| genre_conversion_rate | PERCENT | Genre Conversion Rate | The percentgenre of users who listened to the artist after seeing or hearing an ad served by the genre |
| genre_ctr | PERCENT | Genre CTR | The percentgenre of ads that were clicked (%) |
| genre_custom_event_1 | NUMERIC | Genre Custom Event 1 | Custom event 1 attributed to this genre |
| genre_custom_event_2 | NUMERIC | Genre Custom Event 2 | Custom event 2 attributed to this genre |
| genre_custom_event_3 | NUMERIC | Genre Custom Event 3 | Custom event 3 attributed to this genre |
| genre_custom_event_4 | NUMERIC | Genre Custom Event 4 | Custom event 4 attributed to this genre |
| genre_custom_event_5 | NUMERIC | Genre Custom Event 5 | Custom event 5 attributed to this genre |
| genre_ecpm | NUMERIC | Genre Effective Cost Per Mille | The avergenre cost per 1,000 impressions |
| genre_entity | TEXT | Genre Entity | Dimension for genre. |
| genre_impressions | NUMERIC | Genre Impressions | The number of times an ad has been successfully served |
| genre_intent_rate | PERCENT | Genre Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| genre_leads | NUMERIC | Genre Leads | The number of leads generated from this genre |
| genre_listeners | NUMERIC | Genre Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| genre_new_listener_conversion_rate | PERCENT | Genre New Listener Conversion Rate | The percentgenre of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| genre_new_listener_streams | NUMERIC | Genre New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| genre_new_listeners | NUMERIC | Genre New Listeners | 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 |
| genre_page_views | NUMERIC | Genre Page Views | The number of page views resulting from this genre |
| genre_paid_listen_reach | NUMERIC | Genre Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL genre -- NOTE: Applies to active audio/CPCL genres only |
| genre_paid_listens | NUMERIC | Genre Paid Listens | The number of listens for a CPCL genre where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL genres only |
| genre_products | NUMERIC | Genre Products | The number of products involved in conversion events for this genre |
| genre_purchases | NUMERIC | Genre Purchases | The number of purchases attributed to this genre |
| genre_reach | NUMERIC | Genre Reach of Ads Served | The number of unique users who received your ad |
| genre_revenue | NUMERIC | Genre Revenue | The total revenue generated from this genre |
| genre_sign_ups | NUMERIC | Genre Sign Ups | The number of sign-up events attributed to this genre |
| genre_start_checkout | NUMERIC | Genre Start Checkout | The number of checkout-start events attributed to this genre |
| genre_streamed_impressions | NUMERIC | Genre Streamed Impressions | The number of streamed impressions for this genre |
| genre_streams | NUMERIC | Genre Streams | The total number of streams from listeners who saw/heard the ad (#) |
| genre_streams_per_new_listener | NUMERIC | Genre Streams per new listener | The avergenre number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| genre_streams_per_user | NUMERIC | Genre Streams Per Listener | The avergenre number of times each listener streamed the artist after seeing/hearing the ad (#) |
| genre_video_expand_rate | PERCENT | Genre Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen for this genre |
| genre_video_expands | NUMERIC | Genre Video Expands | The number of times your video ad was expanded to full screen for this genre |
| genre_video_views | NUMERIC | Genre Video Views | The number of times your video ad was viewed for this genre |
Spotify Ads Platform fields
The Platform report of the Spotify Ads connector includes 36 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| platform | TEXT | Platform | Dimension for platform. |
| platform_add_to_cart | NUMERIC | Platform Add To Cart | The number of add-to-cart events attributed to this platform |
| platform_average_order_value | NUMERIC | Platform Average Order Value | The average revenue per purchase attributed to this platform |
| platform_clicks | NUMERIC | Platform Clicks | The number of impressions in which your ad was clicked |
| platform_conversion_rate | PERCENT | Platform Conversion Rate | The percentplatform of users who listened to the artist after seeing or hearing an ad served by the platform |
| platform_ctr | PERCENT | Platform CTR | The percentplatform of ads that were clicked (%) |
| platform_custom_event_1 | NUMERIC | Platform Custom Event 1 | Custom event 1 attributed to this platform |
| platform_custom_event_2 | NUMERIC | Platform Custom Event 2 | Custom event 2 attributed to this platform |
| platform_custom_event_3 | NUMERIC | Platform Custom Event 3 | Custom event 3 attributed to this platform |
| platform_custom_event_4 | NUMERIC | Platform Custom Event 4 | Custom event 4 attributed to this platform |
| platform_custom_event_5 | NUMERIC | Platform Custom Event 5 | Custom event 5 attributed to this platform |
| platform_ecpm | NUMERIC | Platform Effective Cost Per Mille | The averplatform cost per 1,000 impressions |
| platform_entity | TEXT | Platform Entity | Dimension for platform. |
| platform_impressions | NUMERIC | Platform Impressions | The number of times an ad has been successfully served |
| platform_intent_rate | PERCENT | Platform Intent Rate | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| platform_leads | NUMERIC | Platform Leads | The number of leads generated from this platform |
| platform_listeners | NUMERIC | Platform Listeners | The number of users who listened to the artist after hearing/seeing an ad |
| platform_new_listener_conversion_rate | PERCENT | Platform New Listener Conversion Rate | The percentplatform of users who listened to the artist for the first time in at least a month after seeing or hearing the ad |
| platform_new_listener_streams | NUMERIC | Platform New Listener Streams | The total number of streams from new listeners who saw/heard the ad |
| platform_new_listeners | NUMERIC | Platform New Listeners | 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 |
| platform_page_views | NUMERIC | Platform Page Views | The number of page views resulting from this platform |
| platform_paid_listen_reach | NUMERIC | Platform Reach of Paid Listens | The number of unique users who had a paid listen for this CPCL platform -- NOTE: Applies to active audio/CPCL platforms only |
| platform_paid_listens | NUMERIC | Platform Paid Listens | The number of listens for a CPCL platform where a user did NOT skip the ad -- NOTE: Applies to active audio/CPCL platforms only |
| platform_products | NUMERIC | Platform Products | The number of products involved in conversion events for this platform |
| platform_purchases | NUMERIC | Platform Purchases | The number of purchases attributed to this platform |
| platform_reach | NUMERIC | Platform Reach of Ads Served | The number of unique users who received your ad |
| platform_revenue | NUMERIC | Platform Revenue | The total revenue generated from this platform |
| platform_sign_ups | NUMERIC | Platform Sign Ups | The number of sign-up events attributed to this platform |
| platform_start_checkout | NUMERIC | Platform Start Checkout | The number of checkout-start events attributed to this platform |
| platform_streamed_impressions | NUMERIC | Platform Streamed Impressions | The number of streamed impressions for this platform |
| platform_streams | NUMERIC | Platform Streams | The total number of streams from listeners who saw/heard the ad (#) |
| platform_streams_per_new_listener | NUMERIC | Platform Streams per new listener | The averplatform number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| platform_streams_per_user | NUMERIC | Platform Streams Per Listener | The averplatform number of times each listener streamed the artist after seeing/hearing the ad (#) |
| platform_video_expand_rate | PERCENT | Platform Video Expand Rate | The percentage of video impressions that resulted in an expand to full screen for this platform |
| platform_video_expands | NUMERIC | Platform Video Expands | The number of times your video ad was expanded to full screen for this platform |
| platform_video_views | NUMERIC | Platform Video Views | The number of times your video ad was viewed for this platform |
Spotify Ads other fields
The Spotify Ads connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The account ID | |
| account_name | TEXT | Account Name | The account name | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |