Connect Youtube to Snowflake

youtube
+
snowflake

Stream your marketing data from Youtube to Snowflake

Connect Youtube to Snowflake in 2023

It is very simple to connect Youtube 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 Youtube as a Data Source and Grant Access to Windsor.ai.

youtube 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 Youtube to Snowflake. In case there is an error you will be notified.

Youtube metrics and dimensions available for streaming into Snowflake

Connect your data

nametypedescription
Annotation Click Through RateNUMERICThe ratio of annotations that viewers clicked to the total number of clickable annotation impressions.
Annotation Clickable ImpressionsNUMERICThe number of annotations that appeared and could be clicked.
Annotation ClicksNUMERICThe number of clicked annotations.
Annotation Closable ImpressionsNUMERICThe number of annotations that appeared and could be closed.
Annotation Close RateNUMERICThe ratio of annotations that viewers closed to the total number of annotation impressions.
Annotation ClosesNUMERICThe number of closed annotations.
Annotation ImpressionsNUMERICThe total number of annotation impressions.
Average View DurationNUMERICThe average length, in seconds, of video playbacks.
Average View PercentagePERCENTThe average percentage of a video watched during a video playback.
Card Click RatePERCENTThe click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions.
Card ClicksNUMERICThe number of times that cards were clicked.
Card ImpressionsNUMERICThe number of times cards were displayed. When the card panel is opened, a card impression is logged for each of the video's cards.
Card Teaser Click RatePERCENTThe click-through-rate for card teasers, which is calculated as the ratio of clicks on card teasers to the total number of card teaser impressions.
Card Teaser ClicksNUMERICThe number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user.
Card Teaser ImpressionsNUMERICThe number of times that card teasers were displayed. A video view can generate multiple teaser impressions.
CommentsNUMERICThe number of times that users commented on a video.
DateDATEDate of reported values.
DislikesNUMERICThe number of times that users indicated that they disliked a video by giving it a negative rating.
Estimated Minutes WatchedNUMERICThe number of minutes that users watched videos for the specified channel, content owner, video, or playlist.
Estimated Red Minutes WatchedNUMERICThe number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video.
LikesNUMERICThe number of times that users indicated that they liked a video by giving it a positive rating.
Red ViewsNUMERICThe number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members.
SharesNUMERICThe number of times that users shared a video through the Share button.
Subscribers GainedNUMERICThe number of times that users subscribed to a channel.
Subscribers LostNUMERICThe number of times that users unsubscribed from a channel.
VideoOBJECTStatistics broken down by videos in the channel.
Videos Added To PlaylistsNUMERICThe number of times that videos were added to any YouTube playlists. The videos could have been added to the video owner's playlist or to other channels' playlists.
Videos Removed From PlaylistsNUMERICThe number of times that videos were removed from any YouTube playlists. The videos could have been removed from the video owner's playlist or from other channels' playlists.
viewsNUMERICThe number of times that a video was viewed.

Easily connect Youtube 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 Youtube and Snowflake Integrations