UserActivityByProvince
This report provides user activity statistics, sorted by province (includes Washington DC).
テーブル固有の情報
Select Rules
州別のユーザーアクティビティは、米国の州およびコロンビア特別区に適用されます。province を使用するには、filters パラメータ値をcountry==US に設定する必要があります。
Video レポート:
ディメンション | 必須 | province |
オプション | creatorContentType | |
指標 | 1つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、averageViewPercentage、annotationClickThroughRate、annotationCloseRate、annotationImpressions、annotationClickableImpressions、annotationClosableImpressions、annotationClicks、annotationCloses、cardClickRate、cardTeaserClickRate、cardImpressions、cardTeaserImpressions、cardClicks、cardTeaserClicks |
フィルタ | 必須 | country==US |
0または1つ使用 | video、group |
Playlist レポート:
このレポートは、米国各州とワシントンDC のプレイリストのアクティビティの統計です。このレポートでは、 filters パラメータ値にcountry==US を含める必要があります。
ディメンション | 必須 | province |
0または1つ以上使用 | subscribedStatus、youtubeProduct | |
指標 | 1つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、playlistStarts、viewsPerPlaylistStart、averageTimeInPlaylist |
フィルタ | 必須 | isCurated==1;country==US |
0または1つ使用 | continent、subContinent | |
0または1つ使用 | playlist、group | |
0または1つ以上使用 | subscribedStatus、youtubeProduct |
コンテンツ所有者レポート:
ディメンション | 必須 | province |
オプション | creatorContentType | |
指標 | 1つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、averageViewPercentage、annotationClickThroughRate、annotationCloseRate、annotationImpressions、annotationClickableImpressions、annotationClosableImpressions、annotationClicks、annotationCloses、cardClickRate、cardTeaserClickRate、cardImpressions、cardTeaserImpressions、cardClicks、cardTeaserClicks |
フィルタ | 1つだけ使用 | video、channel、group、またはuploaderType とclaimedStatus のサポートされている組み合わせ |
必須 | country==US |
コンテンツ所有者の再生リストのレポート:
ディメンション | 必須 | province |
0または1つ以上使用 | subscribedStatus、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、playlistStarts、viewsPerPlaylistStart、averageTimeInPlaylist | |
フィルタ | 必須 | isCurated==1;country==US |
0または1つ使用 | playlist、channel、group | |
0または1つ以上使用 | subscribedStatus、youtubeProduct |
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
Province | String | True | True | The U.S. state or territory associated with the metrics in the report row. The dimension value is an ISO 3166-2 code that identifies a U.S. state or the District of Columbia, such as US-MI (Michigan) or US-TX (Texas). The province code US-ZZ is used to report metrics for which YouTube could not identify the associated U.S. state. If the Province column is specified, Country must be set to US in the WHERE clause. | |
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. | |||
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. | |||
Country | String | 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. | |||
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. | |||
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. | |||
StartDate | Date | Start date for fetching Analytics data. | |||
EndDate | Date | End date for fetching Analytics data. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Segments | String | Segments the data returned for your request. Either a SegmentId or a custom segment. |