+
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 |
|---|---|---|
| Account ID | TEXT | The account ID |
| Account Name | TEXT | The account name |
| Ad | TEXT | Dimension for ad. |
| Spotify Ad Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Ad Completes | NUMERIC | The number of ads served that was played to the end |
| Ad Conversion Rate | PERCENT | The percentage of users who listened to the artist after seeing or hearing an ad served by the ad |
| Ad CTR | PERCENT | The percentage of ads that were clicked (%) |
| Ad Effective Cost per Completed Listen | NUMERIC | The average cost per 1,000 completed listens |
| Ad Effective Cost Per Mille | NUMERIC | The average cost per 1,000 impressions |
| Ad Entity Id | TEXT | Ad Entity Id |
| Ad Entity Status | TEXT | Ad Entity Status |
| Ad First Quartiles | NUMERIC | The number of users who listened or viewed 25% of the ad's total length |
| Ad Frequency of Ads Served | NUMERIC | The average number of times each person heard or viewed your ad |
| Ad Impressions | NUMERIC | The number of times an ad has been successfully served |
| Ad Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Ad Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Ad Midpoints | NUMERIC | The number of users for which the ad played to the midpoint of the ads total length |
| Ad 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 |
| Ad New Listener Streams | NUMERIC | The total number of streams from new listeners who saw/heard the ad |
| 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 |
| Ad Off Spotify Impressions | NUMERIC | The number of ads served off of Spotify |
| Ad Paid Listen Frequency | NUMERIC | The average frequency for listens on a CPCL ad -- NOTE: Applies to CPCL ads only |
| Ad Reach of Paid Listens | NUMERIC | 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 | 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 Name | TEXT | Ad Parent Entity Name |
| Ad Parent Entity Status | TEXT | Ad Parent Entity Status |
| Ad Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Ad_Set | TEXT | Dimension for ad_set. |
| Ad_Set Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Ad_Set Completes | NUMERIC | The number of impressions in which your ad was clicked |
| Ad_Set Conversion Rate | PERCENT | The percentage of users who listened to the artist after seeing or hearing an ad served by the ad_set |
| Ad_Set CTR | PERCENT | The percentage of ads that were clicked (%) |
| Ad_Set Effective Cost per Completed Listen | NUMERIC | The average cost per 1,000 completed listens |
| Ad_Set Effective Cost Per Mille | NUMERIC | The average cost per 1,000 impressions |
| Ad Set Entity Id | TEXT | Ad Set Entity Id |
| Ad Set Entity Status | TEXT | Ad Set Entity Status |
| Ad_Set First Quartiles | NUMERIC | The number of users who listened or viewed 25% of the ad's total length |
| Ad_Set Frequency of Ads Served | NUMERIC | The average number of times each person heard or viewed your ad |
| Ad_Set Impressions | NUMERIC | The number of times an ad has been successfully served |
| Ad_Set Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Ad_Set Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Ad_Set Midpoints | NUMERIC | The number of users for which the ad played to the midpoint of the ads total length |
| Ad_Set 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 |
| Ad_Set New Listener Streams | NUMERIC | The total number of streams from new listeners who saw/heard the ad |
| Ad_Set 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 |
| Ad_Set Off Spotify Impressions | NUMERIC | The number of ads served off of Spotify |
| Ad_Set Paid Listen Frequency | NUMERIC | The average frequency for listens on a CPCL ad_set -- NOTE: Applies to CPCL ad_sets only |
| Ad_Set Reach of Paid Listens | NUMERIC | 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 | 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 Parent Entity Id | TEXT | Ad Set Parent Entity Id |
| Ad Set Parent Entity Name | TEXT | Ad Set Parent Entity Name |
| Ad Set Parent Entity Status | TEXT | Ad Set Parent Entity Status |
| Ad_Set Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Ad_Set Skips | NUMERIC | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| Ad_Set Amount Spent | NUMERIC | The total amount spent in this ad_set |
| Ad_Set Starts | NUMERIC | The number of times a user starts hearing/viewing your ad |
| Ad_Set Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Ad_Set Streams per new listener | NUMERIC | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Ad_Set Streams Per Listener | NUMERIC | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Ad_Set Third Quartiles | NUMERIC | The number of users who listened or viewed 75% of the ad's total length |
| Ad Skips | NUMERIC | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| Ad Amount Spent | NUMERIC | The total amount spent in this ad |
| Ad Starts | NUMERIC | The number of times a user starts hearing/viewing your ad |
| Ad Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Ad Streams per new listener | NUMERIC | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Ad Streams Per Listener | NUMERIC | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Ad Third Quartiles | NUMERIC | The number of users who listened or viewed 75% of the ad's total length |
| Age | TEXT | Dimension for age. |
| Age Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Age Conversion Rate | PERCENT | The percentage of users who listened to the artist after seeing or hearing an ad served by the age |
| Age CTR | PERCENT | The percentage of ads that were clicked (%) |
| Age Effective Cost Per Mille | NUMERIC | The average cost per 1,000 impressions |
| Age Entity | TEXT | Entity name |
| Age Impressions | NUMERIC | The number of times an ad has been successfully served |
| Age Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Age Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Age 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 |
| Age New Listener Streams | NUMERIC | The total number of streams from new listeners who saw/heard the ad |
| Age 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 |
| Age Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Age Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Age Streams per new listener | NUMERIC | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Age Streams Per Listener | NUMERIC | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Campaign | TEXT | Dimension for campaign. |
| Campaign Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Campaign Completes | NUMERIC | The number of ads served that was played to the end |
| Campaign Conversion Rate | PERCENT | The percentage of users who listened to the artist after seeing or hearing an ad served by the campaign |
| Campaign CTR | PERCENT | The percentage of ads that were clicked (%) |
| Campaign Effective Cost per Completed Listen | NUMERIC | The average cost per 1,000 completed listens |
| Campaign Effective Cost Per Mille | NUMERIC | The average cost per 1,000 impressions |
| Campaign First Quartiles | NUMERIC | The number of users who listened or viewed 25% of the ad's total length |
| Campaign Frequency of Ads Served | NUMERIC | The average number of times each person heard or viewed your ad |
| Campaign Impressions | NUMERIC | The number of times an ad has been successfully served |
| Campaign Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Campaign Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Campaign Midpoints | NUMERIC | The number of users for which the ad played to the midpoint of the ads total length |
| Campaign 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 |
| Campaign New Listener Streams | NUMERIC | The total number of streams from new listeners who saw/heard the ad |
| Campaign 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 |
| Campaign Off Spotify Impressions | NUMERIC | The number of ads served off of Spotify |
| Campaign Paid Listen Frequency | NUMERIC | The average frequency for listens on a CPCL campaign -- NOTE: Applies to CPCL campaigns only |
| Campaign Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Campaign Skips | NUMERIC | The number of times a user skips an ad -- NOTE: Skippable ads are currently supported in AU only |
| Campaign Amount Spent | NUMERIC | The total amount spent in this campaign |
| Campaign Starts | NUMERIC | The number of times a user starts hearing/viewing your ad |
| Campaign Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Campaign Streams per new listener | NUMERIC | The average number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Campaign Streams Per Listener | NUMERIC | The average number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Campaign Third Quartiles | NUMERIC | The number of users who listened or viewed 75% of the ad's total length |
| Country | COUNTRY | Dimension for country. |
| Country Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Country Conversion Rate | PERCENT | The percentcountry of users who listened to the artist after seeing or hearing an ad served by the country |
| Country CTR | PERCENT | The percentcountry of ads that were clicked (%) |
| Country Effective Cost Per Mille | NUMERIC | The avercountry cost per 1,000 impressions |
| Country Entity | COUNTRY | Country entity |
| Country Impressions | NUMERIC | The number of times an ad has been successfully served |
| Country Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Country Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Country New Listener Conversion Rate | PERCENT | 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 | The total number of streams from new listeners who saw/heard the ad |
| Country 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 |
| Country Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Country Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Country Streams per new listener | NUMERIC | The avercountry number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Country Streams Per Listener | NUMERIC | The avercountry number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date |
| Day of month | TEXT | Day of the month |
| Gender | TEXT | Dimension for gender. |
| Gender Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Gender Conversion Rate | PERCENT | The percentgender of users who listened to the artist after seeing or hearing an ad served by the gender |
| Gender CTR | PERCENT | The percentgender of ads that were clicked (%) |
| Gender Effective Cost Per Mille | NUMERIC | The avergender cost per 1,000 impressions |
| Gender Entity | TEXT | Dimension for gender. |
| Gender Impressions | NUMERIC | The number of times an ad has been successfully served |
| Gender Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Gender Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Gender New Listener Conversion Rate | PERCENT | 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 | The total number of streams from new listeners who saw/heard the ad |
| Gender 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 |
| Gender Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Gender Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Gender Streams per new listener | NUMERIC | The avergender number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Gender Streams Per Listener | NUMERIC | The avergender number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Genre | TEXT | Dimension for genre. |
| Genre Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Genre Conversion Rate | PERCENT | The percentgenre of users who listened to the artist after seeing or hearing an ad served by the genre |
| Genre CTR | PERCENT | The percentgenre of ads that were clicked (%) |
| Genre Effective Cost Per Mille | NUMERIC | The avergenre cost per 1,000 impressions |
| Genre Entity | TEXT | Dimension for genre. |
| Genre Impressions | NUMERIC | The number of times an ad has been successfully served |
| Genre Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Genre Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Genre New Listener Conversion Rate | PERCENT | 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 | The total number of streams from new listeners who saw/heard the ad |
| Genre 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 |
| Genre Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Genre Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Genre Streams per new listener | NUMERIC | The avergenre number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Genre Streams Per Listener | NUMERIC | The avergenre number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Month | TEXT | Number of the month |
| Platform | TEXT | Dimension for platform. |
| Platform Clicks | NUMERIC | The number of impressions in which your ad was clicked |
| Platform Conversion Rate | PERCENT | The percentplatform of users who listened to the artist after seeing or hearing an ad served by the platform |
| Platform CTR | PERCENT | The percentplatform of ads that were clicked (%) |
| Platform Effective Cost Per Mille | NUMERIC | The averplatform cost per 1,000 impressions |
| Platform Entity | TEXT | Dimension for platform. |
| Platform Impressions | NUMERIC | The number of times an ad has been successfully served |
| Platform Intent Rate | PERCENT | The rate at which listeners indicated an intent to stream the artist again in the future the artist again in the future (%) |
| Platform Listeners | NUMERIC | The number of users who listened to the artist after hearing/seeing an ad |
| Platform New Listener Conversion Rate | PERCENT | 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 | The total number of streams from new listeners who saw/heard the ad |
| Platform 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 |
| Platform Reach of Paid Listens | NUMERIC | 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 | 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 Reach of Ads Served | NUMERIC | The number of unique users who received your ad |
| Platform Streams | NUMERIC | The total number of streams from listeners who saw/heard the ad (#) |
| Platform Streams per new listener | NUMERIC | The averplatform number of times each new listener streamed the artist after seeing/hearing the ad (#) |
| Platform Streams Per Listener | NUMERIC | The averplatform number of times each listener streamed the artist after seeing/hearing the ad (#) |
| Source | TEXT | The name of the Windsor connector returning the row |
| Today | DATE | Today's date |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
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.