+
Stream your marketing data from Youtube to Snowflake
About Youtube
About 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:
- 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 Youtube 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 Youtube to Snowflake. In case there is an error you will be notified.
Youtube metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Annotation Click Through Rate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| Annotation Clickable Impressions | NUMERIC | The number of annotations that appeared and could be clicked. |
| Annotation Clicks | NUMERIC | The number of clicked annotations. |
| Annotation Closable Impressions | NUMERIC | The number of annotations that appeared and could be closed. |
| Annotation Close Rate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| Annotation Closes | NUMERIC | The number of closed annotations. |
| Annotation Impressions | NUMERIC | The total number of annotation impressions. |
| Average View Duration | NUMERIC | The average length, in seconds, of video playbacks. |
| Average View Percentage | PERCENT | The average percentage of a video watched during a video playback. |
| Card Click Rate | PERCENT | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions. |
| Card Clicks | NUMERIC | The number of times that cards were clicked. |
| Card Impressions | NUMERIC | The 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 Rate | PERCENT | The 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 Clicks | NUMERIC | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user. |
| Card Teaser Impressions | NUMERIC | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions. |
| Comments | NUMERIC | The number of times that users commented on a video. |
| Date | DATE | Date of reported values. |
| Dislikes | NUMERIC | The number of times that users indicated that they disliked a video by giving it a negative rating. |
| Estimated Minutes Watched | NUMERIC | The number of minutes that users watched videos for the specified channel, content owner, video, or playlist. |
| Estimated Red Minutes Watched | NUMERIC | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video. |
| Likes | NUMERIC | The number of times that users indicated that they liked a video by giving it a positive rating. |
| Red Views | NUMERIC | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members. |
| Shares | NUMERIC | The number of times that users shared a video through the Share button. |
| Subscribers Gained | NUMERIC | The number of times that users subscribed to a channel. |
| Subscribers Lost | NUMERIC | The number of times that users unsubscribed from a channel. |
| Video | OBJECT | Statistics broken down by videos in the channel. |
| Videos Added To Playlists | NUMERIC | The 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 Playlists | NUMERIC | The 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. |
| views | NUMERIC | The number of times that a video was viewed. |
Easily connect Youtube 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.