Overview
Spotify Ads is an advertising platform that enables advertisers to create, manage and measure advertising campaigns across Spotify. Through the Spotify Ads API, integrations can access campaign structures, advertising entities, reporting data and performance metrics.
The Spotify Ads API exposes a range of campaign, delivery and performance data, including:
Campaign & Delivery Configuration
Ad accounts
Campaigns
Ad sets
Ads
Assets
Campaign and ad set status
Campaign and ad set hierarchy
Performance & Measurement Data
Impressions
Streamed impressions
Spend
Clicks
Reach
Frequency
Starts
Completion rate
Video views
Video expands
Unmutes
Quartile completion metrics
Engagement & Conversion Data
CTR
Streams
Listeners
New listeners
Page views
Leads
Add to cart
Purchases
Revenue
Return on ad spend
Customer acquisition cost
Cost per lead
Audience & Insight Data
Age
Gender
Country
Region
City
Genre
Interests
Placement
Platform
Format
Audience
Granularity:
The integration retrieves data across the Spotify advertising hierarchy at Ad Account, Campaign, Ad Set and Ad levels. Reporting can also be broken down using audience and insight dimensions such as age, gender, country, genre, placement and platform.
Purpose:
Track Spotify advertising delivery and performance metrics including spend, impressions, clicks, reach, streams, listeners, video performance and conversions for reporting and campaign analysis.
Refresh Cadence:
Spotify reporting data is available through the Reporting API and supports reporting at lifetime and daily granularity.
Update Modes:
Append for time-based performance data and Refresh for campaign and metadata data.
Jobs Configuration
1. Spotify Ads - Delivery Import
Feed: spotify
Status: Active
Job Label: Spotify Ads - Delivery Import
Lookback: Last 5 days
First Run Hour: 6 AM daily
Poll Frequency: Every 24 hours
Targets:
Table: spotify_data_insights
Description: Spotify Ads - Delivery Data
Update Mode: Append new data daily
Date Column: date
Priority: 1
2. Spotify Ads - Metadata Refresh
Feed: spotify
Status: Active
Job Label: Spotify Ads - Metadata Refresh
Lookback: Last 1 day
First Run Hour: 6 AM daily
Poll Frequency: Every 24 hours
Targets:
spotify_meta_ad_account (priority 1, refresh mode)
spotify_meta_campaign (priority 2, refresh mode)
spotify_meta_adset (priority 3, refresh mode)
spotify_meta_ad (priority 4, refresh mode)
spotify_meta_asset (priority 5, refresh mode)
Connection Details
Parameter | Description | Notes |
Client ID | {val_1} | Spotify Ads API client ID |
Client Secret | {val_2} | Spotify Ads API client secret |
Access Token | {val_3} | OAuth access token |
Options | spotify_ad_account_ids | Comma-separated Spotify Ad Account IDs |
Dimensions
Dimension Name | Maps to Fields |
Account [Spotify] | spotify_meta_ad_account.name |
Campaign [Spotify] | spotify_meta_campaign.name |
Ad Set [Spotify] | spotify_meta_adset.name |
Ad [Spotify] | spotify_meta_ad.name |
Platform [Spotify] | spotify_data_insights.platform |
Country [Spotify] | spotify_data_insights.country |
Region [Spotify] | spotify_data_insights.region |
Placement [Spotify] | spotify_data_insights.placement |
Gender [Spotify] | spotify_data_insights.gender |
Age [Spotify] | spotify_data_insights.age |
Genre [Spotify] | spotify_data_insights.genre |
Format [Spotify] | spotify_data_insights.format |
Base Metrics
Metric Name | Formula | Description |
Spend [Spotify] | SUM({spend}) | Total advertising spend |
Impressions [Spotify] | SUM({impressions}) | Total impressions |
Streamed Impressions [Spotify] | SUM({streamed_impressions}) | Impressions where the ad was streamed |
Clicks [Spotify] | SUM({clicks}) | Total clicks |
Reach [Spotify] | SUM({reach}) | Number of unique users reached |
Starts [Spotify] | SUM({starts}) | Number of times users started hearing or viewing an ad |
Video Views [Spotify] | SUM({video_views}) | Number of video views |
Video Expands [Spotify] | SUM({video_expands}) | Number of times a user expanded a video ad |
Unmutes [Spotify] | SUM({unmutes}) | Number of times an ad was unmuted |
First Quartiles [Spotify] | SUM({first_quartiles}) | Ads played through at least 25% |
Midpoints [Spotify] | SUM({midpoints}) | Ads played through at least 50% |
Third Quartiles [Spotify] | SUM({third_quartiles}) | Ads played through at least 75% |
Completes [Spotify] | SUM({completes}) | Ads played through to completion |
Streams [Spotify] | SUM({streams}) | Total streams |
Listeners [Spotify] | SUM({listeners}) | Number of listeners |
New Listeners [Spotify] | SUM({new_listeners}) | Number of new listeners |
Page Views [Spotify] | SUM({page_views}) | Total page views |
Leads [Spotify] | SUM({leads}) | Total leads |
Purchases [Spotify] | SUM({purchases}) | Total purchases |
Revenue [Spotify] | SUM({revenue}) | Total reported revenue |
Datasource Joins
Data joins are performed to link Spotify reporting data to the respective Spotify metadata tables:
Join Field (LHS) | Join Field (RHS) | Source Table |
ad_id | spotify_meta_ad.id | spotify_data_insights |
ad_set_id | spotify_meta_adset.id | spotify_data_insights |
campaign_id | spotify_meta_campaign.id | spotify_data_insights |
ad_account_id | spotify_meta_ad_account.id | spotify_data_insights |
Composite Metrics
Metric Name | Formula | Description | Round | Prefix | Suffix |
CPC [Spotify] | {Spend [Spotify]} / {Clicks [Spotify]} | Cost per click | 2 | £ |
|
CPM [Spotify] | {Spend [Spotify]} / {Impressions [Spotify]} * 1000 | Cost per thousand impressions | 2 | £ |
|
CTR [Spotify] | {Clicks [Spotify]} / {Impressions [Spotify]} * 100 | Click-through rate | 2 |
| % |
CPV [Spotify] | {Spend [Spotify]} / {Video Views [Spotify]} | Cost per video view | 2 | £ |
|
VCR [Spotify] | {Completes [Spotify]} / {Video Views [Spotify]} * 100 | Video completion rate | 2 |
| % |
VTR [Spotify] | {Completes [Spotify]} / {Impressions [Spotify]} * 100 | Video thru rate | 2 |
| % |
Video Expand Rate [Spotify] | {Video Expands [Spotify]} / {Impressions [Spotify]} * 100 | Video expand rate | 2 |
| % |