Fields Reference · YouTube
YouTube Fields List
34 fields · 16 dimensions · 18 metrics · 10 groups
| Field name | Label | Category | Description |
|---|---|---|---|
average_view_duration | Average View Duration (s) | channel_daily | Average length of a view, in seconds, for the row (a day, or a video over the whole range). It is an AVERAGE: summing it across rows gives a meaningless number. |
average_view_percentage | Average Percentage Viewed | channel_daily | Average share of a video watched per view, in percent points (9.83 means 9.83 %). An AVERAGE: summing it across rows gives a meaningless number. |
channel_id | Channel ID | channel_daily | The YouTube channel id (UC…). Filled by the connector from the connected account. |
channel_name | Channel Name | channel_daily | The channel name as it was when the account was connected. Filled by the connector; falls back to the channel id, never blank. |
comments | Comments | channel_daily | Comments posted. Adds up across days. |
date | Date | channel_daily | The day, as YouTube Analytics reports it. The most recent days (typically the last two or three) are ABSENT until YouTube processes them; a missing day means "not processed yet", not zero. |
dislikes | Dislikes | channel_daily | Dislikes received. Adds up across days. |
estimated_minutes_watched | Estimated Minutes Watched | channel_daily | Minutes of video watched. YouTube rounds each day to whole minutes, so a sum of days can land a few minutes below YouTube's own total for the period. |
estimated_red_minutes_watched | YouTube Premium Minutes Watched | channel_daily | Minutes watched by YouTube Premium members. |
likes | Likes | channel_daily | Likes received. Adds up across days. |
red_views | YouTube Premium Views | channel_daily | Views by YouTube Premium members. |
shares | Shares | channel_daily | Times a video was shared through the Share button. Adds up across days. |
subscribers_gained | Subscribers Gained | channel_daily | Subscribers gained. Adds up across days. |
subscribers_lost | Subscribers Lost | channel_daily | Subscribers lost. Adds up across days. |
videos_added_to_playlists | Videos Added to Playlists | channel_daily | Times a video was added to a playlist. |
videos_removed_from_playlists | Videos Removed from Playlists | channel_daily | Times a video was removed from a playlist. |
views | Views | channel_daily | Number of times videos were viewed. Adds up across days: the sum of the days equals YouTube's own total for the period. |
subscriber_count | Subscribers (Total) | channel_snapshot | The channel's total subscribers at the moment of the query, rounded by YouTube: a current snapshot, not historical. It does not change with the date range and has no daily series, so it cannot be combined with Date. Empty when the channel hides its subscriber count. |
content_type | Content Type | content_type_daily | What kind of content was watched, as YouTube classifies it: shorts, videoOnDemand or liveStream. Summed over content types, views match the channel total. |
country | Country | country_window | Viewer country, as a two-letter ISO 3166-1 code (US, AU…). Only for the whole date range, never per day (YouTube refuses country x day). |
country_estimated_minutes_watched | Minutes Watched by Country | country_window | Minutes watched from the country over the whole range. YouTube only reports countries above its privacy threshold, so the countries together cover only part of the channel's minutes, which can be a smaller share than for views: do not sum them or compare them with the channel's Estimated Minutes Watched. |
country_subscribers_gained | Subscribers Gained by Country | country_window | Subscribers gained from the country over the whole range. YouTube only reports countries above its privacy threshold, so the countries together cover only part of the channel's subscribers gained: do not sum them or compare them with the channel's Subscribers Gained. |
country_views | Views by Country | country_window | Views from the country over the whole range. YouTube only reports countries above its privacy threshold, so the countries together cover only part of the channel's views (often around 70 % or less, lower on small channels): do not sum them or compare them with the channel's Views. |
device_type | Device Type | device_daily | Device the video was watched on (MOBILE, DESKTOP, TV, TABLET). Summed over devices, views can land slightly BELOW the channel total. |
operating_system | Operating System | operating_system_daily | Operating system of the viewer. Summed over systems, views land BELOW the channel total (by about one percent): YouTube leaves the unclassified remainder out. |
playback_location_type | Playback Location | playback_location_daily | Where the video was played, as YouTube classifies it. Summed over locations, views can land slightly BELOW the channel total. |
subscribed_status | Subscribed Status | subscribed_status_daily | Whether the viewer was subscribed to the channel (SUBSCRIBED / UNSUBSCRIBED). Summed, views can land slightly BELOW the channel total. |
traffic_source_type | Traffic Source | traffic_source_daily | How viewers reached the video (YT_SEARCH, RELATED_VIDEO, EXT_URL, SUBSCRIBER…). Summed over sources, views can land slightly BELOW the channel total: YouTube leaves a small remainder out. |
video_duration_seconds | Video Duration (s) | video_top | Length of the video in seconds. A dimension, not a metric: it describes the video and does not add up. |
video_id | Video ID | video_top | The YouTube video id. Only in the top-videos table: one row per video for the whole range, never per day (YouTube refuses video x day). |
video_published_at | Video Published Date | video_top | The day the video was published, in the account's timezone. Use it to count videos published per period. Empty when YouTube no longer lists the video. |
video_thumbnail_url | Video Thumbnail URL | video_top | HTTPS URL of the video's current thumbnail, the largest size YouTube offers (maxres, else standard, high, medium, default). Empty when YouTube no longer lists the video. |
video_title | Video Title | video_top | The video's CURRENT title. Empty when YouTube no longer lists the video (deleted, or made private). |
video_url | Video URL | video_top | Link to the video: youtube.com/shorts/<id> for Shorts, youtube.com/watch?v=<id> otherwise. |