UserActivityByCountry
This report provides user activity statistics.
Table Specific Information
Select Rules
User activity by country can only be filtered to return data for a specific video.
Video Reports:
| Dimensions | Required | country |
| Optional | creatorContentType | |
| Metrics | Use 1 or more | views, redViews, comments, likes, dislikes, videosAddedToPlaylists, videosRemovedFromPlaylists, shares, estimatedMinutesWatched, estimatedRedMinutesWatched, averageViewDuration, averageViewPercentage, annotationClickThroughRate, annotationCloseRate, annotationImpressions, annotationClickableImpressions, annotationClosableImpressions, annotationClicks, annotationCloses, cardClickRate, cardTeaserClickRate, cardImpressions, cardTeaserImpressions, cardClicks, cardTeaserClicks, subscribersGained, subscribersLost, estimatedRevenue*, estimatedAdRevenue*, grossRevenue*, estimatedRedPartnerRevenue*, monetizedPlaybacks*, playbackBasedCpm*, adImpressions*, cpm* |
| Use 0 or 1 | video, group |
Playlist Reports:
| Dimensions | Required | country |
| Use 0 or more | subscribedStatus, youtubeProduct | |
| Metrics | Use 1 or more | views, redViews, estimatedMinutesWatched, estimatedRedMinutesWatched, averageViewDuration, playlistStarts, viewsPerPlaylistStart, averageTimeInPlaylist |
| Filters | Required | isCurated==1 |
| Use 0 or 1 | playlist, group | |
| Use 0 or more | subscribedStatus, youtubeProduct |
Content Owner Reports:
| Dimensions | Required | country |
| Optional | creatorContentType | |
| Metrics | Use 1 or more | views, redViews, comments, likes, dislikes, videosAddedToPlaylists, videosRemovedFromPlaylists, shares, estimatedMinutesWatched, estimatedRedMinutesWatched, averageViewDuration, averageViewPercentage, annotationClickThroughRate, annotationCloseRate, annotationImpressions, annotationClickableImpressions, annotationClosableImpressions, annotationClicks, annotationCloses, cardClickRate, cardTeaserClickRate, cardImpressions, cardTeaserImpressions, cardClicks, cardTeaserClicks, subscribersGained, subscribersLost, estimatedRevenue*, estimatedAdRevenue*, grossRevenue*, estimatedRedPartnerRevenue*, monetizedPlaybacks*, playbackBasedCpm*, adImpressions*, cpm* |
| Filters | Use exactly 1 | video, channel, group, or a supported combination of uploaderType and claimedStatus |
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| Country | String | True | True | The country associated with the metrics in the report row. The dimension value is a two-letter ISO-3166-1 country code, such as US, CN (China), or FR (France). The country code ZZ is used to report metrics for which YouTube could not identify the associated country. | |
| CreatorContentType | String | True | This dimension identifies the type of content associated with the user activity metrics in the data row. The allowed values are LIVE_STREAM, SHORTS, STORY, VIDEO_ON_DEMAND, UNSPECIFIED. | ||
| Views | Double | True | The number of times that a video was viewed. In a playlist report, the metric indicates the number of times that a video was viewed in the context of a playlist. | ||
| RedViews | Double | The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members. | |||
| Likes | Double | The number of times that users indicated that they liked a video by giving it a positive rating. | |||
| Comments | Double | The number of times that users commented on a video. | |||
| Dislikes | Double | The number of times that users indicated that they disliked a video by giving it a negative rating. | |||
| VideosAddedToPlaylists | Double | 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. | |||
| VideosRemovedFromPlaylists | Double | 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. | |||
| Shares | Double | The number of times that users shared a video through the Share button. | |||
| EstimatedMinutesWatched | Double | The number of minutes that users watched videos for the specified channel, content owner, video, or playlist. | |||
| EstimatedRedMinutesWatched | Double | The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video. | |||
| AverageViewDuration | Double | The average length, in seconds, of video playbacks. As of December 13, 2021, this metric excludes looping clips traffic. In a playlist report, the metric indicates the average length, in seconds, of video playbacks that occurred in the context of a playlist. | |||
| AverageViewPercentage | Double | The average percentage of a video watched during a video playback. | |||
| AnnotationClickThroughRate | Double | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. | |||
| AnnotationCloseRate | Double | The ratio of annotations that viewers closed to the total number of annotation impressions. | |||
| AnnotationImpressions | Double | The total number of annotation impressions. | |||
| AnnotationClickableImpressions | Double | The number of annotations that appeared and could be clicked. | |||
| AnnotationClosableImpressions | Double | The number of annotations that appeared and could be closed. | |||
| AnnotationClicks | Double | The number of clicked annotations. | |||
| AnnotationCloses | Double | The number of closed annotations. | |||
| CardClickRate | Double | The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions. | |||
| CardTeaserClickRate | Double | 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. | |||
| CardImpressions | Double | 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. | |||
| CardTeaserImpressions | Double | The number of times that card teasers were displayed. A video view can generate multiple teaser impressions. | |||
| CardClicks | Double | The number of times that cards were clicked. | |||
| CardTeaserClicks | Double | The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user. | |||
| SubscribersGained | Double | The number of times that users subscribed to a channel. | |||
| SubscribersLost | Double | The number of times that users unsubscribed from a channel. | |||
| EstimatedRevenue | Double | 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. | |||
| EstimatedAdRevenue | Double | The total estimated net revenue from all Google-sold advertising sources for the selected date range and region. | |||
| GrossRevenue | Double | The estimated gross revenue, in USD, from all Google-sold or DoubleClick-partner-sold advertising for the selected date range and region. Gross revenue is subject to month-end adjustment and does not include partner-served advertising. Gross revenue should not be confused with estimated revenue, or net revenue, which factors in your share of ownership and revenue-sharing agreements. | |||
| EstimatedRedPartnerRevenue | Double | The total estimated revenue earned from YouTube Premium (previously known as YouTube Red) subscriptions for the selected report dimensions. The metric's value reflects revenue from both music and non-music content and is subject to month-end adjustment. | |||
| MonetizedPlaybacks | Double | 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%. | |||
| PlaybackBasedCpm | Double | The estimated gross revenue per thousand playbacks. | |||
| AdImpressions | Double | The number of verified ad impressions served. | |||
| CPM | Double | The estimated gross revenue per thousand ad impressions. | |||
| Channel | String | (only used in content owner reports) The Id for a YouTube channel. The channel dimension is frequently used in content owner reports because those reports typically aggregate data for multiple channels. | |||
| Video | String | True | The Id of a YouTube video. | ||
| Playlist | String | The Id of a YouTube playlist. | |||
| Group | String | (filter only) The Id of a YouTube Analytics group. | |||
| StartDate | Date | Start date for fetching Analytics data. | |||
| EndDate | Date | End date for fetching Analytics data. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Segments | String | Segments the data returned for your request. Either a SegmentId or a custom segment. |