Windsor brings all your Youtube data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Youtube Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| annotation_click_through_rate | NUMERIC | Annotation Click Through Rate | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. | Video |
| annotation_clickable_impressions | NUMERIC | Annotation Clickable Impressions | The number of annotations that appeared and could be clicked. | Video |
| annotation_clicks | NUMERIC | Annotation Clicks | The number of clicked annotations. | Video |
| annotation_closable_impressions | NUMERIC | Annotation Closable Impressions | The number of annotations that appeared and could be closed. | Video |
| annotation_close_rate | NUMERIC | Annotation Close Rate | The ratio of annotations that viewers closed to the total number of annotation impressions. | Video |
| annotation_closes | NUMERIC | Annotation Closes | The number of closed annotations. | Video |
| annotation_impressions | NUMERIC | Annotation Impressions | The total number of annotation impressions. | Video |
| average_view_duration | NUMERIC | Average View Duration | The average length, in seconds, of video playbacks. | Video |
| average_view_percentage | PERCENT | Average View Percentage | The average percentage of a video watched during a video playback. | Video |
| card_click_rate | PERCENT | Card Click Rate | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions. | Video |
| card_clicks | NUMERIC | Card Clicks | The number of times that cards were clicked. | Video |
| card_impressions | NUMERIC | Card Impressions | 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. | Video |
| card_teaser_click_rate | PERCENT | Card Teaser Click Rate | 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. | Video |
| card_teaser_clicks | NUMERIC | Card Teaser Clicks | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user. | Video |
| card_teaser_impressions | NUMERIC | Card Teaser Impressions | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions. | Video |
| channel_id | TEXT | Channel ID | The ID that YouTube uses to uniquely identify the channel that the video was uploaded to. | Data - Channel |
| channel_image | IMAGE_URL | Thumbnail | Thumbnail image URL associated with the channel | Data - Channel |
| channel_title | TEXT | Channel title | The channel's title. | Data - Channel |
| comments | NUMERIC | Comments | The number of times that users commented on a video. | Video |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date of reported values. | Video |
| day_of_month | TEXT | Day of month | Day of the month | |
| dislikes | NUMERIC | Dislikes | The number of times that users indicated that they disliked a video by giving it a negative rating. | Video |
| estimated_minutes_watched | NUMERIC | Estimated Minutes Watched | The number of minutes that users watched videos for the specified channel, content owner, video, or playlist. | Video |
| estimated_red_minutes_watched | NUMERIC | Estimated Red Minutes Watched | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video. | Video |
| likes | NUMERIC | Likes | The number of times that users indicated that they liked a video by giving it a positive rating. | Video |
| month | TEXT | Month | Number of the month | |
| privacy_status | TEXT | Privacy Status | The video's privacy status. | Data - Video |
| published_at | DATE | Publish 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. | Data - Video |
| red_views | NUMERIC | Red Views | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members. | Video |
| shares | NUMERIC | Shares | The number of times that users shared a video through the Share button. | Video |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| subscriber_count | NUMERIC | Subscriber Count | The number of subscribers that the channel has. | Data - Channel |
| subscribers_gained | NUMERIC | Subscribers Gained | The number of times that users subscribed to a channel. | Video |
| subscribers_lost | NUMERIC | Subscribers Lost | The number of times that users unsubscribed from a channel. | Video |
| today | DATE | Today | Today's date | |
| video | TEXT | Video | The ID of a YouTube video (Youtube Analytics). | Video |
| video_age_restriction | TEXT | Age restriction | A rating that YouTube uses to identify age-restricted content. | Data - Video |
| video_category | TEXT | Category Id | The YouTube video category associated with the video. | Data - Video |
| video_count | NUMERIC | Videos Published | The number of public videos uploaded to the channel. | Data - Channel |
| video_description | TEXT | Video description | The video's description. | Data - Video |
| video_has_captions | BOOLEAN | Video has captions | Indicates whether captions are available for the video. | Data - Video |
| video_length | TEXT | Video length | The length of the video. | Data - Video |
| video_licensed_content | BOOLEAN | Video is licensed content | 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. | Data - Video |
| video_resolution | TEXT | Video resolution | Indicates whether the video is available in high definition (HD) or only in standard definition. | Data - Video |
| video_tags | TEXT | Video tags | A list of keyword tags associated with the video. | Data - Video |
| video_title | TEXT | Video title | The video title | Data - Video |
| videoimage | IMAGE_URL | Video image URL (default) | Thumbnail image URL associated with the video | Data - Video |
| videos_added_to_playlists | NUMERIC | Videos Added To Playlists | 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. | Video |
| videos_removed_from_playlists | NUMERIC | Videos Removed From Playlists | 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. | Video |
| videourl | TEXT | Full Video URL | Full URL of the video | Data - Video |
| views | NUMERIC | YouTube Video Views | The number of times that a video was viewed. | Video |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |