Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| VIDEO | Video ID | video | dim | Id of a channel`s video |
| Video visibility status | video_privacy_status | dim | The video's visibility status. Values may be private, public, unlisted | |
| Video title | video_title | dim | Title of the video | |
| Video URL | video_url | dim | Url of a video | |
| Video thumbnail URL | video_thumbnail_url | dim | Thumbnail of the video URL | |
| Video thumbnail | video_thumbnail | dim | The thumbnail for a video | |
| Video upload status | video_upload_status | dim | The status of the uploaded video. Values may be: deleted, failed, processed, rejected, uploaded | |
| Video failure reason | video_failure_reason | dim | This value explains why a video failed to upload. This property is only present if the Video upload status property indicates that the upload failed | |
| Video rejection reason | video_rejection_reason | dim | This value explains why YouTube rejected an uploaded video. This property is only present if the Video upload status property indicates that the upload was rejected | |
| Video length | video_length | dim | The length of the video | |
| Video embeddability | video_embeddable | dim | This value indicates whether the video can be embedded on another website | |
| Video public stats viewable | video_public_stats_viewable | dim | This value indicates whether the extended video statistics on the video's watch page are publicly viewable | |
| Video made for kids | video_made_for_kids | dim | This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video | |
| Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand | |
| Published time | video_published_at | dim | The published date and time of the video that the search result identifies | |
| Published date | video_published_date | dim | The published date of the video that the search result identifies | |
| Video description | video_description | dim | Description of a video | |
| Video tags | video_tags | dim | A list of keyword tags associated with the video | |
| Live broadcast content | liveBroadcastContent | dim | An indication of whether a video resource has live broadcast content. Valid property values are upcoming, live, and none | |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Engaged views | engaged_views | met | The number of times that the video was viewed for at least 4 seconds. This uses the same counting method that Video views used to | |
| Comments | comments | met | The number of times that users commented on a video | |
| Likes | likes | met | The number of times that users indicated that they liked a video by giving it a positive rating | |
| Dislikes | dislikes | met | The number of times that users indicated that they disliked a video by giving it a negative rating | |
| Shares | shares | met | The number of times that users shared a video through the Share button | |
| Gained subscribers | subscribersGained | met | The number of times that users subscribed to a channel | |
| Lost subscribers | subscribersLost | met | The number of times that users unsubscribed from a channel | |
| Videos added to playlist | videosAddedToPlaylists | met | The number of times that videos were added to any YouTube playlists | |
| Videos removed from playlist | videosRemovedFromPlaylists | met | The number of times that videos were removed from any YouTube playlists | |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Average view duration (sec) | averageViewDuration_seconds | met | The average length, in seconds, of video playbacks | |
| Average view duration (min) | avgTimeViewed_minutes | met | The average length, in minutes, of video playbacks | |
| Average view duration (h:m:s) | avgTimeViewed_hms | met | The average length, in h:m:s format, of video playbacks | |
| Average view duration percentage (%) | averageViewPercentage_perc | met | The average percentage of a video watched during a video playback | |
| ANNOTATIONS | Annotation impressions | annotationImpressions | met | The total number of annotation impressions |
| Annotation clickable impressions | annotationClickableImpressions | met | The number of annotations that appeared and could be clicked | |
| Annotation closable impressions | annotationClosableImpressions | met | The number of annotations that appeared and could be closed | |
| Annotation clicks | annotationClicks | met | The number of clicked annotations | |
| Annotation closes | annotationCloses | met | The number of closed annotations | |
| Annotation click through rate | annotationClickThroughRate | met | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions | |
| Annotation close rate | annotationCloseRate | met | The ratio of annotations that viewers closed to the total number of annotation impressions | |
| CARDS | Card impressions | cardImpressions | met | 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 clicks | cardClicks | met | The number of times that cards were clicked | |
| Card click rate | cardClickRate | met | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions | |
| Card teaser impressions | cardTeaserImpressions | met | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions | |
| Card teaser clicks | cardTeaserClicks | met | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user | |
| Card teaser click rate | cardTeaserClickRate | met | 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 | |
| MONETIZATION | Estimated YouTube Premium minutes watched | estimatedRedMinutesWatched | met | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video |
| Estimated revenue | estimatedRevenue | met | The total estimated net revenue from all Google-sold advertising sources as well as from non-advertising sources for the selected date range and region. Requires monetization be enabled for the channel | |
| Monetized Playbacks | monetizedPlaybacks | met | The number of instances when a viewer played your video and was shown at least one ad impression. A monetized playback is counted if a viewer is shown a preroll ad but quits watching the ad before your video ever starts. The expected estimated error for this figure is ±2.0%. Requires monetization be enabled for the channel | |
| Playback Based CPM | playbackBasedCpm | met | The estimated gross revenue per thousand playbacks. Requires monetization be enabled for the channel | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| VIDEO | Video ID | video | dim | Id of a channel`s video |
| Video visibility status | video_privacy_status | dim | The video's visibility status. Values may be private, public, unlisted | |
| Video title | video_title | dim | Title of the video | |
| Video URL | video_url | dim | Url of a video | |
| Video thumbnail URL | video_thumbnail_url | dim | Thumbnail of the video URL | |
| Video thumbnail | video_thumbnail | dim | The thumbnail for a video | |
| Video upload status | video_upload_status | dim | The status of the uploaded video. Values may be: deleted, failed, processed, rejected, uploaded | |
| Video failure reason | video_failure_reason | dim | This value explains why a video failed to upload. This property is only present if the Video upload status property indicates that the upload failed | |
| Video rejection reason | video_rejection_reason | dim | This value explains why YouTube rejected an uploaded video. This property is only present if the Video upload status property indicates that the upload was rejected | |
| Video length | video_length | dim | The length of the video | |
| Video embeddability | video_embeddable | dim | This value indicates whether the video can be embedded on another website | |
| Video public stats viewable | video_public_stats_viewable | dim | This value indicates whether the extended video statistics on the video's watch page are publicly viewable | |
| Video made for kids | video_made_for_kids | dim | This value indicates whether the video is designated as child-directed, and it contains the current "made for kids" status of the video | |
| Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand | |
| Published time | video_published_at | dim | The published date and time of the video that the search result identifies | |
| Published date | video_published_date | dim | The published date of the video that the search result identifies | |
| Video description | video_description | dim | Description of a video | |
| Video tags | video_tags | dim | A list of keyword tags associated with the video | |
| AUDIENCE RETENTION | Elapsed video time ratio | elapsedVideoTimeRatio | dim | This dimension specifies the ratio of the elapsed portion of the video to the video's length |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Engaged views | engaged_views | met | The number of times that the video was viewed for at least 4 seconds. This uses the same counting method that Video views used to | |
| Comments | comments | met | The number of times that users commented on a video | |
| Likes | likes | met | The number of times that users indicated that they liked a video by giving it a positive rating | |
| Dislikes | dislikes | met | The number of times that users indicated that they disliked a video by giving it a negative rating | |
| Shares | shares | met | The number of times that users shared a video through the Share button | |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Average view duration (sec) | averageViewDuration_seconds | met | The average length, in seconds, of video playbacks | |
| Average view duration (min) | avgTimeViewed_minutes | met | The average length, in minutes, of video playbacks | |
| Average view duration (h:m:s) | avgTimeViewed_hms | met | The average length, in h:m:s format, of video playbacks | |
| Average view duration percentage (%) | averageViewPercentage_perc | met | The average percentage of a video watched during a video playback | |
| ANNOTATIONS | Annotation impressions | annotationImpressions | met | The total number of annotation impressions |
| Annotation clickable impressions | annotationClickableImpressions | met | The number of annotations that appeared and could be clicked | |
| Annotation closable impressions | annotationClosableImpressions | met | The number of annotations that appeared and could be closed | |
| Annotation clicks | annotationClicks | met | The number of clicked annotations | |
| Annotation closes | annotationCloses | met | The number of closed annotations | |
| Annotation click through rate | annotationClickThroughRate | met | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions | |
| Annotation close rate | annotationCloseRate | met | The ratio of annotations that viewers closed to the total number of annotation impressions | |
| CARDS | Card impressions | cardImpressions | met | 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 clicks | cardClicks | met | The number of times that cards were clicked | |
| Card click rate | cardClickRate | met | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions | |
| Card teaser impressions | cardTeaserImpressions | met | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions | |
| Card teaser clicks | cardTeaserClicks | met | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user | |
| Card teaser click rate | cardTeaserClickRate | met | 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 | |
| MONETIZATION | YouTube Premium views | redViews | met | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members |
| Estimated YouTube Premium minutes watched | estimatedRedMinutesWatched | met | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video | |
| Estimated revenue | estimatedRevenue | met | The total estimated net revenue from all Google-sold advertising sources as well as from non-advertising sources for the selected date range and region. Requires monetization be enabled for the channel | |
| Monetized Playbacks | monetizedPlaybacks | met | The number of instances when a viewer played your video and was shown at least one ad impression. A monetized playback is counted if a viewer is shown a preroll ad but quits watching the ad before your video ever starts. The expected estimated error for this figure is ±2.0%. Requires monetization be enabled for the channel | |
| Playback Based CPM | playbackBasedCpm | met | The estimated gross revenue per thousand playbacks. Requires monetization be enabled for the channel | |
| AUDIENCE RETENTION | Audience watch ratio | audienceWatchRatio | met | The absolute ratio of viewers watching the video at the given point in the video |
| Relative retention performance | relativeRetentionPerformance | met | A measurement that shows how well a video retains viewers during playbacks in comparison to all YouTube videos of similar length | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| TIME | Day of month | dayOfMonth | dim | Day of month, e.g. 2 |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| Year | year_channel_totals | dim | Year, e.g. 2017 | |
| Year of week (Sun-Sat) | yearOfWeek_channel_totals | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso_channel_totals | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth_channel_totals | dim | Year and month, e.g. 2017|06 | |
| Month | month_channel_totals | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek_channel_totals | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso_channel_totals | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week_channel_totals | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso_channel_totals | dim | ISO week number, e.g. 51 | |
| VIDEO | Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Engaged views | engaged_views | met | The number of times that the video was viewed for at least 4 seconds. This uses the same counting method that Video views used to | |
| Likes | likes | met | The number of times that users indicated that they liked a video by giving it a positive rating | |
| Dislikes | dislikes | met | The number of times that users indicated that they disliked a video by giving it a negative rating | |
| Shares | shares | met | The number of times that users shared a video through the Share button | |
| Gained subscribers | subscribersGained | met | The number of times that users subscribed to a channel | |
| Lost subscribers | subscribersLost | met | The number of times that users unsubscribed from a channel | |
| Videos added to playlist | videosAddedToPlaylists | met | The number of times that videos were added to any YouTube playlists | |
| Videos removed from playlist | videosRemovedFromPlaylists | met | The number of times that videos were removed from any YouTube playlists | |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Average view duration (sec) | averageViewDuration_seconds | met | The average length, in seconds, of video playbacks | |
| Average view duration (min) | avgTimeViewed_minutes | met | The average length, in minutes, of video playbacks | |
| Average view duration (h:m:s) | avgTimeViewed_hms | met | The average length, in h:m:s format, of video playbacks | |
| Average view duration percentage (%) | averageViewPercentage_perc | met | The average percentage of a video watched during a video playback | |
| ANNOTATIONS | Annotation impressions | annotationImpressions | met | The total number of annotation impressions |
| Annotation clickable impressions | annotationClickableImpressions | met | The number of annotations that appeared and could be clicked | |
| Annotation closable impressions | annotationClosableImpressions | met | The number of annotations that appeared and could be closed | |
| Annotation clicks | annotationClicks | met | The number of clicked annotations | |
| Annotation closes | annotationCloses | met | The number of closed annotations | |
| Annotation click through rate | annotationClickThroughRate | met | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions | |
| Annotation close rate | annotationCloseRate | met | The ratio of annotations that viewers closed to the total number of annotation impressions | |
| CARDS | Card impressions | cardImpressions | met | 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 clicks | cardClicks | met | The number of times that cards were clicked | |
| Card click rate | cardClickRate | met | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions | |
| Card teaser impressions | cardTeaserImpressions | met | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions | |
| Card teaser clicks | cardTeaserClicks | met | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user | |
| Card teaser click rate | cardTeaserClickRate | met | 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 | |
| MONETIZATION | YouTube Premium views | redViews | met | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members |
| Estimated YouTube Premium minutes watched | estimatedRedMinutesWatched | met | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video | |
| Estimated revenue | estimatedRevenue | met | The total estimated net revenue from all Google-sold advertising sources as well as from non-advertising sources for the selected date range and region. Requires monetization be enabled for the channel | |
| Monetized Playbacks | monetizedPlaybacks | met | The number of instances when a viewer played your video and was shown at least one ad impression. A monetized playback is counted if a viewer is shown a preroll ad but quits watching the ad before your video ever starts. The expected estimated error for this figure is ±2.0%. Requires monetization be enabled for the channel | |
| Playback Based CPM | playbackBasedCpm | met | The estimated gross revenue per thousand playbacks. Requires monetization be enabled for the channel | |
| CHANNEL | Channel total page views | channel_views | met | The number of times the channel has been viewed (all time) |
| Channel total subscribers | channel_subscribers | met | The number of subscribers that the channel has (all time). This value is rounded down to three significant figures | |
| Channel total video count | channel_videos | met | The number of public videos uploaded to the channel (all time). Note that the value reflects the count of the channel's public videos only | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| VIDEO | Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| GEOGRAPHIES | Country | country | dim | The country associated with the metrics in the report row. Values are normalized |
| US State | province | dim | The U.S. state or territory associated with the metrics in the report row. Using this field will restrict country to US. Values are normalized | |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Engaged views | engaged_views | met | The number of times that the video was viewed for at least 4 seconds. This uses the same counting method that Video views used to | |
| Comments | comments | met | The number of times that users commented on a video | |
| Likes | likes | met | The number of times that users indicated that they liked a video by giving it a positive rating | |
| Dislikes | dislikes | met | The number of times that users indicated that they disliked a video by giving it a negative rating | |
| Shares | shares | met | The number of times that users shared a video through the Share button | |
| Videos added to playlist | videosAddedToPlaylists | met | The number of times that videos were added to any YouTube playlists | |
| Videos removed from playlist | videosRemovedFromPlaylists | met | The number of times that videos were removed from any YouTube playlists | |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Average view duration (sec) | averageViewDuration_seconds | met | The average length, in seconds, of video playbacks | |
| Average view duration (min) | avgTimeViewed_minutes | met | The average length, in minutes, of video playbacks | |
| Average view duration (h:m:s) | avgTimeViewed_hms | met | The average length, in h:m:s format, of video playbacks | |
| Average view duration percentage (%) | averageViewPercentage_perc | met | The average percentage of a video watched during a video playback | |
| ANNOTATIONS | Annotation impressions | annotationImpressions | met | The total number of annotation impressions |
| Annotation clickable impressions | annotationClickableImpressions | met | The number of annotations that appeared and could be clicked | |
| Annotation closable impressions | annotationClosableImpressions | met | The number of annotations that appeared and could be closed | |
| Annotation clicks | annotationClicks | met | The number of clicked annotations | |
| Annotation closes | annotationCloses | met | The number of closed annotations | |
| Annotation click through rate | annotationClickThroughRate | met | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions | |
| Annotation close rate | annotationCloseRate | met | The ratio of annotations that viewers closed to the total number of annotation impressions | |
| CARDS | Card impressions | cardImpressions | met | 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 clicks | cardClicks | met | The number of times that cards were clicked | |
| Card click rate | cardClickRate | met | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions | |
| Card teaser impressions | cardTeaserImpressions | met | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions | |
| Card teaser clicks | cardTeaserClicks | met | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user | |
| Card teaser click rate | cardTeaserClickRate | met | 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 | |
| MONETIZATION | YouTube Premium views | redViews | met | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members |
| Estimated YouTube Premium minutes watched | estimatedRedMinutesWatched | met | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video | |
| Estimated revenue | estimatedRevenue | met | The total estimated net revenue from all Google-sold advertising sources as well as from non-advertising sources for the selected date range and region. Requires monetization be enabled for the channel | |
| Monetized Playbacks | monetizedPlaybacks | met | The number of instances when a viewer played your video and was shown at least one ad impression. A monetized playback is counted if a viewer is shown a preroll ad but quits watching the ad before your video ever starts. The expected estimated error for this figure is ±2.0%. Requires monetization be enabled for the channel | |
| Playback Based CPM | playbackBasedCpm | met | The estimated gross revenue per thousand playbacks. Requires monetization be enabled for the channel | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| VIDEO | Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand |
| Live or on-demand | liveOrOnDemand | dim | Indicates whether the user activity metrics in the data row are associated with views of a live broadcast or was replayed on-demand. Possible values are LIVE and ON_DEMAND | |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| DEMOGRAPHIC | Age group | ageGroup | dim | This dimension identifies the age group of the logged-in users associated with the report data. Values are normalized |
| Gender | gender | dim | This dimension identifies the gender of the logged-in users associated with the report data. Values are normalized | |
| ENGAGEMENT | Viewer percentage | viewerPercentage | met | The percentage of viewers who were logged in when watching the video |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| VIDEO | Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand |
| Live or on-demand | liveOrOnDemand | dim | Indicates whether the user activity metrics in the data row are associated with views of a live broadcast or was replayed on-demand. Possible values are LIVE and ON_DEMAND | |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| DEVICE/OS | Device type | deviceType | dim | This dimension identifies the physical form factor of the device on which the view occurred. Values are normalized |
| Operating system | operatingSystem | dim | This dimension identifies the software system of the device on which the view occurred | |
| Youtube product | youtubeProduct | dim | This dimension identifies the YouTube service on which the user activity occurred | |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| VIDEO | Creator content type | creatorContentType | dim | Identifies the type of YouTube content. Supported values are liveStream, shorts, story, and videoOnDemand |
| Live or on-demand | liveOrOnDemand | dim | Indicates whether the user activity metrics in the data row are associated with views of a live broadcast or was replayed on-demand. Possible values are LIVE and ON_DEMAND | |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| TRAFFIC SOURCE | Traffic source type | insightTrafficSourceType | dim | This dimension describes the manner in which users reached the video |
| ENGAGEMENT | Video views | views | met | The number of times that a video was viewed. For Shorts, this counts when the video starts to play or replay |
| Estimated minutes watched | estimatedMinutesWatched | met | The number of minutes that users watched videos for the specified channel, content owner or video | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections | |
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| CHANNEL | Channel ID | channel | dim | Id of a channel |
| Channel name | channel_title | dim | Name of the channel | |
| Channel URL | channel_url | dim | Url of a channel | |
| Channel description | channel_description | dim | The channel's description | |
| Channel custom URL | channel_custom_url | dim | The channel's custom URL | |
| Channel created date | channel_published_at | dim | The date and time that the channel was created | |
| Channel thumbnail URL | channel_thumbnail_url | dim | The URL of channel thumbnail | |
| Channel thumbnail | channel_thumbnail | dim | The default thumbnail for a channel | |
| Channel country | channel_country | dim | The country with which the channel is associated. Values are normalized | |
| Channel hidden subscribers | channel_hidden_subscribers | dim | Indicates whether the channel's subscriber count is publicly visible | |
| MONETIZATION | Ad type | adType | dim | The dimension is used in ad performance reports and aggregates the requested metrics based on the types of ads that ran during video playbacks |
| Gross revenue (USD) | grossRevenue | met | The estimated gross revenue, in USD, from all Google-sold or DoubleClick-partner-sold advertising for the selected date range | |
| Gross revenue (GBP) | grossRevenue_gbp | met | The estimated gross revenue, in GBP, from all Google-sold or DoubleClick-partner-sold advertising for the selected date range | |
| Gross revenue (EUR) | grossRevenue_eur | met | The estimated gross revenue, in EUR, from all Google-sold or DoubleClick-partner-sold advertising for the selected date range | |
| Ad impressions | adImpressions | met | The number of verified ad impressions served | |
| CPM | cpm | met | The estimated gross revenue per thousand ad impressions | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |