UserActivityByProvince
This report provides user activity statistics, sorted by province (includes Washington DC).
テーブル固有の情報
Select Rules
州別のユーザーアクティビティは、米国の州およびコロンビア特別区に適用されます。province を使用するには、filters パラメータ値をcountry==US に設定する必要があります。
Video レポート：
| ディメンション | 必須 | province |
| オプション | creatorContentType | |
| 指標 | １つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、averageViewPercentage、annotationClickThroughRate、annotationCloseRate、annotationImpressions、annotationClickableImpressions、annotationClosableImpressions、annotationClicks、annotationCloses、cardClickRate、cardTeaserClickRate、cardImpressions、cardTeaserImpressions、cardClicks、cardTeaserClicks |
| フィルタ | 必須 | country==US |
| 0または１つ使用 | video、group |
Playlist レポート：
このレポートは、米国各州とワシントンDC のプレイリストのアクティビティの統計です。このレポートでは、 filters パラメータ値にcountry==US を含める必要があります。
| ディメンション | 必須 | province |
| ０または１つ以上使用 | subscribedStatus、youtubeProduct | |
| 指標 | １つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、playlistStarts、viewsPerPlaylistStart、averageTimeInPlaylist |
| フィルタ | 必須 | isCurated==1;country==US |
| ０または１つ使用 | continent、subContinent | |
| ０または１つ使用 | playlist、group | |
| ０または１つ以上使用 | subscribedStatus、youtubeProduct |
コンテンツ所有者レポート：
| ディメンション | 必須 | province |
| オプション | creatorContentType | |
| 指標 | １つ以上使用 | views、redViews、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、averageViewPercentage、annotationClickThroughRate、annotationCloseRate、annotationImpressions、annotationClickableImpressions、annotationClosableImpressions、annotationClicks、annotationCloses、cardClickRate、cardTeaserClickRate、cardImpressions、cardTeaserImpressions、cardClicks、cardTeaserClicks |
| フィルタ | １つだけ使用 | video、channel、group、またはuploaderType とclaimedStatus のサポートされている組み合わせ |
| 必須 | country==US |
コンテンツ所有者の再生リストのレポート：
| ディメンション | 必須 | province |
| ０または１つ以上使用 | subscribedStatus、estimatedMinutesWatched、estimatedRedMinutesWatched、averageViewDuration、playlistStarts、viewsPerPlaylistStart、averageTimeInPlaylist | |
| フィルタ | 必須 | isCurated==1;country==US |
| ０または１つ使用 | playlist、channel、group | |
| ０または１つ以上使用 | 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. |