Spotify Ads Field Reference
Sample
https://connectors.windsor.ai/spotify?api_key=[your API key]&date_preset=last_7d&fields=date,spend,impressions,clicks,ctr
Fields
| ID | Type | Name | Description |
|---|
| ad | TEXT | Ad | Dimension for Ad. |
| ad_set | TEXT | Ad Set | Dimension for Ad set. |
| advertiser | TEXT | Advertiser | Dimension for advertiser. |
| campaign | TEXT | Campaign | Dimension for campaign. |
| clicks | NUMERIC | Clicks | The number of impressions in which your ad was clicked (#) |
| completes | NUMERIC | Completes | The number of ads served that was played to the end (#) |
| completion_rate | NUMERIC | Completion_rate | The percentage of ads served that were played to the end (%) |
| conversion_rate | PERCENT | Conversion_rate | The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign (%) |
| cost_type | TEXT | Cost type | Dimension for cost_type. |
| country | COUNTRY | Country | Dimension for country. |
| ctr | PERCENT | Ctr | The percentage of ads that were clicked (%) |
| currency | TEXT | Currency | Dimension for currency. |
| date | DATE | Date | Dimension for date. |
| dma | TEXT | DMA | Dimension for DMA. |
| ecpcl | NUMERIC | Ecpcl | The average cost per 1,000 completed listens |
| ecpm | NUMERIC | Ecpm | The average cost per 1,000 impressions |
| errors | NUMERIC | Errors | The number of times an error occurred (#) |
| fetch_reach | NUMERIC | Fetch_reach | The number of unique users with FETCH events (#) |
| fetches | NUMERIC | Fetches | The number of times an ad is called from the ad server (#) |
| first_quartiles | PERCENT | First_quartiles | The percentage of users who listened or viewed a given percentage of the ad (%) |
| impressions | NUMERIC | Impressions | The number of times an ad has been successfully served (#) |
| intent_rate | PERCENT | Intent_rate | The rate at which listeners indicated an intent to stream the artist again in the future (%) |
| listeners | NUMERIC | Listeners | The number of users who listened to the artist after hearing/seeing an ad (#) |
| midpoints | NUMERIC | Midpoints | The number of users for which the ad played to the midpoint of the ads total length (#) |
| month | TEXT | Month | Dimension for month. |
| new_listener_conversion_rate | PERCENT | 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 (%) |
| new_listener_streams | NUMERIC | New_listener_streams | The total number of streams from new listeners who saw/heard the ad (#) |
| new_listeners | NUMERIC | 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 (#) |
| off_spotify_impressions | NUMERIC | Off_spotify_impressions | off spotify impressions |
| paid_listen_freq | NUMERIC | Paid_listen_freq | The average frequency for listens on a CPCL campaign |
| paid_listen_reach | NUMERIC | Paid_listen_reach | The number of unique users who had a paid listen for this CPCL campaign |
| paid_listens | NUMERIC | Paid_listens | The number of listens for a CPCL campaign where a user did NOT skip the ad |
| platform | TEXT | Platform | Dimension for platform. |
| region | TEXT | Region | Dimension for region. |
| render_ratio | NUMERIC | Render_ratio | The percentage of impressions in which a creative is actually displayed to the user (#) |
| serve_freq | NUMERIC | Serve_freq | The average number of times each person heard or viewed your ad (#) |
| serve_reach | NUMERIC | Serve_reach | The number of unique users who received your ad (#) |
| serves | NUMERIC | Serves | The total number of ads served (#) |
| skips | NUMERIC | Skips | The number of times a user skips an ad |
| spend | NUMERIC | Spend | The total amount spent in this campaign |
| starts | NUMERIC | Starts | The number of times a user starts hearing/viewing your ad (#) |
| streams | NUMERIC | Streams | The total number of streams from listeners who saw/heard the ad (#) |
| streams_per_new_listener | NUMERIC | Streams_per_new_listener | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| streams_per_user | NUMERIC | Streams_per_user | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| third_quartiles | PERCENT | Third_quartiles | The percentage of users who listened or viewed a given percentage of the ad (%) |
| year | TEXT | Year | Dimension for year. |