+
Stream 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. |
| Channel ID | TEXT | The ID that YouTube uses to uniquely identify the channel that the video was uploaded to. |
| Thumbnail | IMAGE_URL | Thumbnail image URL associated with the channel |
| Channel title | TEXT | The channel's title. |
| Comments | NUMERIC | The number of times that users commented on a video. |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date of reported values. |
| Day of month | TEXT | Day of the month |
| 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. |
| Month | TEXT | Number of the month |
| Privacy Status | TEXT | The video's privacy status. |
| Publish date | DATE | The date and time that the video was published. Note that this time might be different than the time that the video was uploaded. |
| 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. |
| Source | TEXT | The name of the Windsor connector returning the row |
| Subscriber Count | NUMERIC | The number of subscribers that the channel has. |
| 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. |
| Today | DATE | Today's date |
| Video | TEXT | The ID of a YouTube video (Youtube Analytics). |
| Age restriction | TEXT | A rating that YouTube uses to identify age-restricted content. |
| Category Id | TEXT | The YouTube video category associated with the video. |
| Videos Published | NUMERIC | The number of public videos uploaded to the channel. |
| Video description | TEXT | The video's description. |
| Video has captions | BOOLEAN | Indicates whether captions are available for the video. |
| Video length | TEXT | The length of the video. |
| Video is licensed content | BOOLEAN | Indicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner. |
| Video resolution | TEXT | Indicates whether the video is available in high definition (HD) or only in standard definition. |
| Video tags | TEXT | A list of keyword tags associated with the video. |
| Video title | TEXT | The video title |
| Video image URL (default) | IMAGE_URL | Thumbnail image URL associated with the video |
| 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. |
| Full Video URL | TEXT | Full URL of the video |
| YouTube Video Views | NUMERIC | The number of times that a video was viewed. |
| 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 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.