Youtube Connector Reference

37 metrics39 dimensions

Fields

The Youtube connector exposes 76 fields (37 metrics, 39 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 33 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_duration_duplicate	NUMERIC	(Internal) Duplicate-Average View Duration	(Internal) Duplicate for average_view_duration to be used in formula
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).
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.
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.
views	NUMERIC	YouTube Video Views	The number of times that a video was viewed.

Youtube other fields

The Youtube connector has 23 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	TIMESTAMP	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	TIMESTAMP	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
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

API Connectors