+
Stream your marketing data from Spotify Ads to Snowflake
About Spotify Ads
About SnowFlake
Connect Spotify Ads to Snowflake in 2023
It is very simple to connect Spotify Ads to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1. You need to select Spotify Ads as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4. Your data will now be streamed from Spotify Ads to Snowflake. In case there is an error you will be notified.
Spotify Ads metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Ad | TEXT | Dimension for Ad. |
| Ad Set | TEXT | Dimension for Ad set. |
| Advertiser | TEXT | Dimension for advertiser. |
| Campaign | TEXT | Dimension for campaign. |
| Clicks | NUMERIC | The number of impressions in which your ad was clicked (#) |
| Completes | NUMERIC | The number of ads served that was played to the end (#) |
| Completion_rate | PERCENT | The percentage of ads served that were played to the end (%) |
| Conversion_rate | PERCENT | The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign (%) |
| Cost type | TEXT | Dimension for cost_type. |
| Country | COUNTRY | Dimension for country. |
| Ctr | PERCENT | The percentage of ads that were clicked (%) |
| Currency | TEXT | Dimension for currency. |
| Date | DATE | Dimension for date. |
| DMA | TEXT | Dimension for DMA. |
| Ecpcl | NUMERIC | The average cost per 1,000 completed listens |
| Ecpm | NUMERIC | The average cost per 1,000 impressions |
| Errors | NUMERIC | The number of times an error occurred (#) |
| Fetch_reach | NUMERIC | The number of unique users with FETCH events (#) |
| Fetches | NUMERIC | The number of times an ad is called from the ad server (#) |
| First_quartiles | PERCENT | The percentage of users who listened or viewed a given percentage of the ad (%) |
| Impressions | NUMERIC | The number of times an ad has been successfully served (#) |
| Intent_rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future (%) |
| Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad (#) |
| Midpoints | NUMERIC | The number of users for which the ad played to the midpoint of the ads total length (#) |
| Month | TEXT | Dimension for month. |
| New_listener_conversion_rate | PERCENT | 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 | The total number of streams from new listeners who saw/heard the ad (#) |
| New_listeners | NUMERIC | 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 |
| Paid_listen_freq | NUMERIC | The average frequency for listens on a CPCL campaign |
| Paid_listen_reach | NUMERIC | The number of unique users who had a paid listen for this CPCL campaign |
| Paid_listens | NUMERIC | The number of listens for a CPCL campaign where a user did NOT skip the ad |
| Platform | TEXT | Dimension for platform. |
| Region | REGION | Dimension for region. |
| Render_ratio | NUMERIC | The percentage of impressions in which a creative is actually displayed to the user (#) |
| Serve_freq | NUMERIC | The average number of times each person heard or viewed your ad (#) |
| Serve_reach | NUMERIC | The number of unique users who received your ad (#) |
| Serves | NUMERIC | The total number of ads served (#) |
| Skips | NUMERIC | The number of times a user skips an ad |
| Spend | NUMERIC | The total amount spent in this campaign |
| Starts | NUMERIC | The number of times a user starts hearing/viewing your ad (#) |
| Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Streams_per_new_listener | NUMERIC | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Streams_per_user | NUMERIC | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Third_quartiles | PERCENT | The percentage of users who listened or viewed a given percentage of the ad (%) |
| Year | TEXT | Dimension for year. |
Easily connect Spotify Ads to Snowflake
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.