Connect Spotify Ads to Snowflake

spotify ads
+
snowflake

Stream your marketing data from Spotify Ads to 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:

  1. Add all the columns that are returned by your connector’s URL. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username Import Snowflake 1
  • Get the password Import Snowflake 2
  • Get the account Import Snowflake 3
  • Get the warehouse Import Snowflake 4
  • Get the database Import Snowflake 5
  • Get the schema Import Snowflake 6
  • Get the table name Import Snowflake 7

Second step

1. You need to select Spotify Ads as a Data Source and Grant Access to Windsor.ai.

Spotify integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save
Snowflake connector

 

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

Connect your data

nametypedescription
TEXTDimension for Ad.
Ad SetTEXTDimension for Ad set.
AdvertiserTEXTDimension for advertiser.
CampaignTEXTDimension for campaign.
ClicksNUMERICThe number of impressions in which your ad was clicked (#)
CompletesNUMERICThe number of ads served that was played to the end (#)
Completion_ratePERCENTThe percentage of ads served that were played to the end (%)
Conversion_ratePERCENTThe percentage of users who listened to the artist after seeing or hearing an ad served by the campaign (%)
Cost typeTEXTDimension for cost_type.
CountryCOUNTRYDimension for country.
CtrPERCENTThe percentage of ads that were clicked (%)
CurrencyTEXTDimension for currency.
DateDATEDimension for date.
DMATEXTDimension for DMA.
EcpclNUMERICThe average cost per 1,000 completed listens
EcpmNUMERICThe average cost per 1,000 impressions
ErrorsNUMERICThe number of times an error occurred (#)
Fetch_reachNUMERICThe number of unique users with FETCH events (#)
FetchesNUMERICThe number of times an ad is called from the ad server (#)
First_quartilesPERCENTThe percentage of users who listened or viewed a given percentage of the ad (%)
ImpressionsNUMERICThe number of times an ad has been successfully served (#)
Intent_ratePERCENTThe rate at which listeners indicated an intent to stream the artist again in the future (%)
ListenersNUMERICThe number of users who listened to the artist after hearing/seeing an ad (#)
MidpointsNUMERICThe number of users for which the ad played to the midpoint of the ads total length (#)
MonthTEXTDimension for month.
New_listener_conversion_ratePERCENTThe 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_streamsNUMERICThe total number of streams from new listeners who saw/heard the ad (#)
New_listenersNUMERICThe 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_impressionsNUMERICoff spotify impressions
NUMERICThe average frequency for listens on a CPCL campaign
NUMERICThe number of unique users who had a paid listen for this CPCL campaign
NUMERICThe number of listens for a CPCL campaign where a user did NOT skip the ad
PlatformTEXTDimension for platform.
RegionREGIONDimension for region.
Render_ratioNUMERICThe percentage of impressions in which a creative is actually displayed to the user (#)
Serve_freqNUMERICThe average number of times each person heard or viewed your ad (#)
Serve_reachNUMERICThe number of unique users who received your ad (#)
ServesNUMERICThe total number of ads served (#)
SkipsNUMERICThe number of times a user skips an ad
SpendNUMERICThe total amount spent in this campaign
StartsNUMERICThe number of times a user starts hearing/viewing your ad (#)
StreamsNUMERICThe total number of streams from listeners who saw/heard the ad (#)
Streams_per_new_listenerNUMERICThe average number of times each new listener streamed the artist after seeing/hearing the ad (#)
Streams_per_userNUMERICThe average number of times each listener streamed the artist after seeing/hearing the ad (#)
Third_quartilesPERCENTThe percentage of users who listened or viewed a given percentage of the ad (%)
YearTEXTDimension for year.

Easily connect Spotify Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Spotify Ads and Snowflake Integrations