Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Youtube data to
Youtube Connector Reference
39 metrics48 dimensions
The Youtube connector exposes 87 fields (39 metrics, 48 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Youtube Fields
Youtube Data - Channel fields
The Data - Channel report of the Youtube connector includes 10 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The ID that YouTube uses to uniquely identify the channel/account. |
| account_name | TEXT | Account Name | The channel's title/account name. |
| channel_description | TEXT | Channel Description | The channel's description. |
| channel_id | TEXT | Channel ID | The ID that YouTube uses to uniquely identify the channel that the video was uploaded to. |
| channel_image | IMAGE_URL | Thumbnail | Thumbnail image URL associated with the channel |
| channel_title | TEXT | Channel Title | The channel's title. |
| comment_count | NUMERIC | Comment Count | The total number of comments on the channel |
| subscriber_count | NUMERIC | Subscriber Count | The channel's absolute subscriber total at query time: a point-in-time snapshot from the Data API, not bounded by the requested date range. YouTube Analytics exposes no absolute subscriber metric, so track changes over time with subscribers_gained_channel / subscribers_lost_channel. |
| video_count | NUMERIC | Videos Published | The number of public videos uploaded to the channel. |
| view_count | NUMERIC | View Count | The total number of views for all videos on the channel |
Youtube Data - Video fields
The Data - Video report of the Youtube connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| privacy_status | TEXT | Privacy Status | The video's privacy status. |
| 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. |
| video_age_restriction | TEXT | Age restriction | A rating that YouTube uses to identify age-restricted content. |
| video_category | TEXT | Category Id | The YouTube video category associated with the video. |
| video_comment_count | NUMERIC | Video Comment Count | The lifetime total number of comments on the video. Absent when comments are disabled for the video. |
| video_description | TEXT | Video description | The video's description. |
| video_has_captions | BOOLEAN | Video has captions | Indicates whether captions are available for the video. |
| video_length | TEXT | Video length | The length of the 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. |
| video_like_count | NUMERIC | Video Like Count | The lifetime total number of users who indicated that they liked the video. Absent when the video's like count is hidden. |
| video_resolution | TEXT | Video resolution | Indicates whether the video is available in high definition (HD) or only in standard definition. |
| video_tags | TEXT | Video tags | A list of keyword tags associated with the video. |
| video_title | TEXT | Video title | The video title |
| video_view_count | NUMERIC | Video View Count | The lifetime total number of times the video was viewed. |
| videoimage | IMAGE_URL | Video image URL (default) | Thumbnail image URL associated with the video |
| videourl | TEXT | Full Video URL | Full URL of the video |
Youtube Demographics fields
The Demographics report of the Youtube connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| viewer_age_group | TEXT | Viewer Age Group | The viewer age bucket, one of age13-17, age18-24, age25-34, age35-44, age45-54, age55-64 or age65-. Groups a channel-wide report by age; combine with viewer_percentage. The API reports demographics as percentages only (no absolute viewer counts) and can't break them down by date. |
| viewer_gender | TEXT | Viewer Gender | The viewer gender, one of female, male or user_specified. Groups a channel-wide report by gender; combine with viewer_percentage. The API reports demographics as percentages only (no absolute viewer counts) and can't break them down by date. |
| viewer_percentage | PERCENT | Viewer Percentage | The percentage of viewers in each viewer_age_group or viewer_gender bucket; the values in a report sum to about 100. This is the only metric the demographic reports expose (the API has no absolute demographic viewer count). |
Youtube Geography fields
The Geography report of the Youtube connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| city | CITY | City | The estimated city the activity is associated with. Groups the report by city; the YouTube Analytics API returns at most the top 250 cities and only covers data since 2022. |
| country | COUNTRY | Country | The ISO-3166-1 two-letter code of the country the activity is associated with. Groups the report by country; combine with views, estimated_minutes_watched, subscribers_gained or subscribers_lost. |
| region | REGION | Region | The ISO-3166-2 province/state code the activity is associated with. Groups the report by region and is automatically restricted to the United States (country==US), the only country the API breaks down by province. |
Youtube Video fields
The Video report of the Youtube connector includes 30 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| annotation_click_through_rate | NUMERIC | Annotation Click Through Rate | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| annotation_clickable_impressions | NUMERIC | Annotation Clickable Impressions | The number of annotations that appeared and could be clicked. |
| annotation_clicks | NUMERIC | Annotation Clicks | The number of clicked annotations. |
| annotation_closable_impressions | NUMERIC | Annotation Closable Impressions | The number of annotations that appeared and could be closed. |
| annotation_close_rate | NUMERIC | Annotation Close Rate | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotation_closes | NUMERIC | Annotation Closes | The number of closed annotations. |
| annotation_impressions | NUMERIC | Annotation Impressions | The total number of annotation impressions. |
| average_view_duration | NUMERIC | Average View Duration | The average length, in seconds, of video playbacks. |
| average_view_percentage | PERCENT | Average View Percentage | The average percentage of a video watched during a video playback. |
| average_view_percentage_duplicate | PERCENT | (Internal) Duplicate-Average View Percentage | (Internal) Duplicate of average_view_percentage to be used in formula |
| 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. |
| card_clicks | NUMERIC | Card Clicks | The number of times that cards were clicked. |
| 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. |
| 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. |
| 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. |
| card_teaser_impressions | NUMERIC | Card Teaser Impressions | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions. |
| comments | NUMERIC | Comments | The number of times that users commented on a video. |
| creator_content_type | TEXT | Content Type | The type of YouTube content associated with the row. One of shorts, videoOnDemand, liveStream, story, or unspecified. |
| date | DATE | Date | Date of reported values. |
| dislikes | NUMERIC | Dislikes | The number of times that users indicated that they disliked a video by giving it a negative rating. |
| engaged_views | NUMERIC | Engaged Views | The number of times the channel's videos have been viewed past the initial seconds. Reflects the pre-March-2025 view-counting methodology and is the comparable metric for Shorts, whose 'views' now counts plays and replays with no minimum watch time. |
| estimated_minutes_watched | NUMERIC | Estimated Minutes Watched | The number of minutes that users watched videos for the specified channel, content owner, video, or playlist. |
| 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. |
| likes | NUMERIC | Likes | The number of times that users indicated that they liked a video by giving it a positive rating. |
| red_views | NUMERIC | Red Views | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members. |
| shares | NUMERIC | Shares | The number of times that users shared a video through the Share button. |
| subscribers_gained | NUMERIC | Subscribers Gained | The number of subscribers gained, attributed to the videos in the report and bounded by the requested date range. This is a relative change per video, not the channel's absolute subscriber total (see subscriber_count) nor a channel-wide time series (see subscribers_gained_channel). |
| subscribers_lost | NUMERIC | Subscribers Lost | The number of subscribers lost, attributed to the videos in the report and bounded by the requested date range. This is a relative change per video, not the channel's absolute subscriber total (see subscriber_count) nor a channel-wide time series (see subscribers_lost_channel). |
| video | TEXT | Video | The ID of a YouTube video (Youtube Analytics). |
| views | NUMERIC | YouTube Video Views | The number of times that a video was viewed. |
Youtube other fields
The Youtube connector has 25 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| playlist_id | TEXT | Playlist ID | The ID of a playlist that the video belongs to. A video in several playlists produces one row per playlist; a video in none is reported with an empty value. | Data - Playlist |
| playlist_title | TEXT | Playlist Title | The title of a playlist that the video belongs to. | Data - Playlist |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| subscribers_gained_channel | NUMERIC | Subscribers Gained (Channel) | Channel-wide subscribers gained per day: a time series across all content, not attributed to individual videos. Request together with date. | Channel Analytics |
| subscribers_lost_channel | NUMERIC | Subscribers Lost (Channel) | Channel-wide subscribers lost per day: a time series across all content, not attributed to individual videos. Request together with date. | Channel Analytics |
| today | DATE | Today | Today's date | |
| traffic_source | TEXT | Traffic Source | How viewers reached the videos, e.g. YT_SEARCH, RELATED_VIDEO, EXT_URL, SUBSCRIBER or PLAYLIST. Groups the report by traffic source; combine with views, estimated_minutes_watched or engaged_views. | Traffic Source |
| 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. | Playlist Activity |
| 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. | Playlist Activity |
| 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_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| 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 |