Power BI Connector for YouTube Analytics

Build 22.0.8479

Activities

Query YouTube Activities. An Activity resource contains information about an action that a particular Channel, or User, has taken on YouTube.

Table Specific Information

Select

YouTube Analytics allows only a subset of columns to be used as filter criteria. You can specify exactly one of the following columns: ChannelId or Home. Additionally, extra optional columns supported are PublishedAt and Region.

All columns support the '=' operator. PublishedAt also supports '>', '>=', '<', and '<='.

By default, if no filters are specified, the driver will return activities generated by authenticated user.

SELECT * FROM Activities WHERE Home = true LIMIT 2

SELECT * FROM Activities WHERE ChannelId = "abc123" AND PublishedAt < '2016-01-01T10:00:00Z'

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Id [KEY] String The Id that YouTube uses to uniquely identify the activity.
PublishedAt Datetime The date and time that the activity occurred. The value is in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.
ChannelId String The Id that YouTube uses to uniquely identify the channel associated with the activity.
Title String The title of the resource primarily associated with the activity.
Description String The description of the resource primarily associated with the activity.
ChannelTitle String Channel title for the channel responsible for this activity.
Type String The type of activity that the resource describes. Valid values: channelItem, comment (not currently returned), favorite, like, playlistItem, recommendation, social, subscription, and upload.
GroupId String The group Id associated with the activity.
ThumbnailsDefaultUrl String The URL of the default image thumbnail.
UploadVideoId String The Id that YouTube uses to uniquely identify the uploaded video.
LikeResourceIdKind String The type of the resource that received a positive (like) rating.
LikeResourceIdVideoId String The Id that YouTube uses to uniquely identify the video, if the rated resource is a video. This column is only present if the ResourceIdKind is youtube#video.
FavoriteResourceIdKind String The type of the YouTube entity marked as a favorite.
FavoriteResourceIdVideoId String The Id that YouTube uses to uniquely identify the favorite video.
CommentResourceIdKind String The comment on the API resource.
CommentResourceIdVideoId String The Id that YouTube uses to uniquely identify the video associated with a comment.
CommentResourceIdChannelId String The Id that YouTube uses to uniquely identify the channel associated with a comment.
SubscriptionResourceIdKind String The type of the subscription. A subscription is a channel that a user subscribed to.
SubscriptionResourceIdChannelId String The Id that YouTube uses to uniquely identify the channel that the user subscribed to.
PlaylistItemResourceIdKind String The type of the playlist item.
PlaylistItemResourceIdVideoId String The Id that YouTube uses to uniquely identify the video that was added to the playlist.
PlaylistItemPlaylistId String The value that YouTube uses to uniquely identify the playlist.
PlaylistItemPlaylistItemId String The value that YouTube uses to uniquely identify the item in the playlist.
RecommendationResourceIdKind String The type of the recommendation.
RecommendationResourceIdVideoId String The Id that YouTube uses to uniquely identify the video, if the recommended resource is a video.
RecommendationResourceIdChannelId String The Id that YouTube uses to uniquely identify the channel, if the recommended resource is a channel.
RecommendationReason String The reason that the YouTube entity was recommended to the user. Valid values for this column : unspecified, videoFavorited, videoLiked, and videoWatched.
RecommendationSeedResourceIdKind String The type of the YouTube entity that caused the recommendation.
RecommendationSeedResourceIdVideoId String The Id that YouTube uses to uniquely identify the video, if the recommendation was caused by a particular video.
RecommendationSeedResourceIdChannelId String The Id that YouTube uses to uniquely identify the channel, if the recommendation was caused by a particular channel.
RecommendationSeedResourceIdPlaylistId String The Id that YouTube uses to uniquely identify the playlist, if the recommendation was caused by a particular playlist.
SocialType String The name of the social network post. Valid values for this column: facebook, googlePlus, twitter, and unspecified.
SocialResourceIdKind String The type of the social network post.
SocialResourceIdVideoId String The Id that YouTube uses to uniquely identify the video featured in a social network post, if the post refers to a video.
SocialResourceIdChannelId String The Id that YouTube uses to uniquely identify the channel featured in a social network post, if the post refers to a channel.
SocialResourceIdPlaylistId String The Id that YouTube uses to uniquely identify the playlist featured in a social network post.
SocialAuthor String The author of the social network post.
SocialReferenceUrl String The URL of the social network post.
SocialImageUrl String An image of the author of the post.
ChannelItemResourceId String The Id of the YouTube entity that was added to the channel.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Region String Instructs the API to filter by region. The parameter value is an ISO 3166-1 alpha-2 country code.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479