YouTube

Adding the data source

Requirements

Have a YouTube channel associated with the Google account that will authorize the data source

If your account is a Brand Account,;

the user who will authorize the data source must be the Owner, of the account;

Instructions

1) Login to Kondado, go to add data sources page and select the YouTube data source;

2) Click on “Sign in with Google”

3) Select the google account you will use

4) Select the channel (YouTube account) you will use

5) On the next screen, check ALL permissions that are required and click Continue

6) You will be redirected to Kondado's page with access already authorized. Give your data source a name

Now just click on SAVE and to start receiving data from YouTube in Data Warehouse or Data Lake

Pipelines

Relationship Chart

Clique para ampliar

Channel Daily Views

Campo	Tipo
dimension_x	text
day	date
channel	text
channel_title	text
channel_description	text
channel_custom_url	text
channel_thumbnail	text
views	int
estimatedminuteswatched	int

This pipeline brings the metrics of views and estimated Minutes Watched per day according to several possible breakdowns, which are combinations of dimensions together with day and channel

Channel Daily Stats

Campo	Tipo
day	date
channel	text
channel_title	text
channel_description	text
channel_custom_url	text
channel_thumbnail	text
views	int
comments	int
dislikes	int
likes	int
shares	int
annotationclickthroughrate	float
annotationcloserate	float
averageviewduration	int
estimatedminuteswatched	int
subscribersgained	int
subscriberslost	int
redviews	int
estimatedredminuteswatched	int
averageviewpercentage	float
videosaddedtoplaylists	int
videosremovedfromplaylists	int
annotationimpressions	int
annotationclickableimpressions	int
annotationclicks	int
annotationclosableimpressions	int
annotationcloses	int
cardimpressions	int
cardclicks	int
cardclickrate	float
cardteaserimpressions	int
cardteaserclicks	int
cardteaserclickrate	int

This pipeline brings several metrics, in the day and channel dimensions

Videos daily stats

Campo	Tipo
day	date
video_id	text
channel_id	text	Estatísticas diárias do canal > > channel Visualizações diárias do canal > > channel
channel_title	text
channel_description	text
channel_custom_url	text
channel_thumbnail	text
video_title	text
video_description	text
video_thumbnail_url	text
views	int
comments	int
dislikes	int
likes	int
shares	int
annotationclickthroughrate	float
annotationcloserate	float
averageviewduration	int
estimatedminuteswatched	int
subscribersgained	int
subscriberslost	int
redviews	int
estimatedredminuteswatched	int
averageviewpercentage	float
videosaddedtoplaylists	int
videosremovedfromplaylists	int
annotationimpressions	int
annotationclickableimpressions	int
annotationclicks	int
annotationclosableimpressions	int
annotationcloses	int
cardimpressions	int
cardclicks	int
cardclickrate	float
cardteaserimpressions	int
cardteaserclicks	int
cardteaserclickrate	int

Videos daily views

Campo	Tipo
day	date
video_id	text
channel_id	text	Estatísticas diárias do canal > > channel Visualizações diárias do canal > > channel
channel_title	text
channel_description	text
channel_custom_url	text
channel_thumbnail	text
video_title	text
video_description	text
video_thumbnail_url	text
views	int
estimatedminuteswatched	int

Dimensions

insightPlaybackLocationType

Data in the report is aggregated based on the type of page or application where video playbacks occurred. Possible values for this dimension are:

BROWSE – The data describes views that took place on the YouTube home page or home screen, in the user's subscription feed, or in another YouTube browsing feature.
CHANNEL – The data describes views that occurred on a channel page.
EMBEDDED – The data describes views that occurred on another website or application where the video was embedded using an <iframe> or <object> embed.
EXTERNAL_APP – The data describes views that occurred in a third-party application where the video was played using a method other than an <iframe> or <object> embed. For example, playbacks in applications that use the YouTube Android Player API would be categorized using this value.
MOBILE – The data describes views that occurred on YouTube's mobile website or on approved YouTube API clients, including mobile devices.
As of September 10, 2013, playbacks are no longer categorized as MOBILE playbacks in YouTube Analytics reports. The value may remain in reports since legacy data still falls under that category. However, following that date, mobile playbacks are classified as either WATCH, EMBEDDED, or EXTERNAL_APP playbacks, depending on the type of application where the playbacks occur.
SEARCH – The data describes views that took place directly on the YouTube search results page.
WATCH – The data describes views that occurred on the video's YouTube watch page or in an official YouTube application, such as the YouTube Android app.
YT_OTHER – The data describes views that are not otherwise classified.

insightTrafficSourceType

Data in the report is aggregated based on the referrer type, which describes the manner in which users reached the video. Possible values for this dimension are:

ADVERTISING – The viewer was referred to the video by an advertisement. If you filter based on this traffic source, the insightTrafficSourceDetail field identifies the type of advertisement.
ANNOTATION – Viewers reached the video by clicking on an annotation in another video.
CAMPAIGN_CARD – Views originated from claimed, user-uploaded videos that the content owner used to promote the viewed content. This traffic source is only supported for content owner reports.
END_SCREEN – The views were referred from the end screen of another video.
EXT_URL – The video views were referred from a link on another website. If you filter based on this traffic source, the insightTrafficSourceDetail field identifies the web page. This traffic source includes referrals from Google search results.
NO_LINK_EMBEDDED – The video was embedded on another website when it was viewed.
NO_LINK_OTHER – YouTube did not identify a referrer for the traffic. This category encompasses direct traffic to a video as well as traffic on mobile apps.
NOTIFICATION – The video views were referred from an email or notification from YouTube.
PLAYLIST – The video views occurred while the video was being played as part of a playlist. Note that this traffic source is different from YT_PLAYLIST_PAGE, which indicates that the views originated from the page that lists all of the videos in the playlist.
PROMOTED – The video views were referred from an unpaid YouTube promotion, such as the YouTube "Spotlight Videos" page.
RELATED_VIDEO – The video views were referred from a related video listing on another video watch page. If you filter based on this traffic source, the insightTrafficSourceDetail field specifies the video ID for that video.
SHORTS – The viewer was referred by swiping vertically from the previous video in the Shorts viewing experience.
SUBSCRIBER – The video views were referred from feeds on the YouTube homepage or from YouTube subscription features. If you filter based on this traffic source, the insightTrafficSourceDetail field specifies the homepage feed items or other page from which views were referred.
YT_CHANNEL – The video views occurred on a channel page. If you filter based on this traffic source, the insightTrafficSourceDetail field specifies the channel ID for that channel.
YT_OTHER_PAGE – The video views were referred from a link other than a search result or related video link that appeared on a YouTube page. If you filter based on this traffic source, the insightTrafficSourceDetail field identifies the page.
YT_PLAYLIST_PAGE – The video views originated from a page that lists all of the videos in a playlist. Note that this traffic source is different from PLAYLIST, which indicates that the views occurred while the video was being played as part of a playlist.
YT_SEARCH – The video views were referred from YouTube search results. If you filter based on this traffic source, the insightTrafficSourceDetail field specifies the search term.

deviceType

This dimension identifies the physical form factor of the device on which the view occurred. The following list identifies the device types for which the API returns data. You can also use the deviceType dimension as a filter to restrict an operating system report to only contain data for a specific type of device.

DESKTOP
GAME_CONSOLE
MOBILE
TABLET
TV
UNKNOWN_PLATFORM

operatingSystem

This dimension identifies the software system of the device on which the view occurred. The following list identifies the operating systems for which the API returns data. You can also use the operatingSystem as a filter to restrict a device type report to only contain data for a specific operating system.

ANDROID
BADA
BLACKBERRY
CHROMECAST
DOCOMO
FIREFOX
HIPTOP
IOS
KAIOS
LINUX
MACINTOSH
MEEGO
NINTENDO_3DS
OTHER
PLAYSTATION
PLAYSTATION_VITA
REALMEDIA
SMART_TV
SYMBIAN
TIZEN
VIDAA
WEBOS
WII
WINDOWS
WINDOWS_MOBILE
XBOX

subscribedStatus

This dimension indicates whether the user activity metrics in the data row are associated with viewers who were subscribed to the video's or playlist's channel. Possible values are SUBSCRIBED and UNSUBSCRIBED.
Note that the dimension value is accurate as of the time that the user activity occurs. For example, suppose a user has not subscribed to a channel and watches one of that channel's videos, then subscribes to the channel and watches another video, all on the same day. The channel's report indicates that one view has a subscribedStatus value of SUBSCRIBED, and one view has a subscribedStatus value of UNSUBSCRIBED.

liveOrOnDemand

This dimension indicates whether the user activity metrics in the data row are associated with views of a live broadcast. Data for this dimension is available for dates beginning April 1, 2014. The dimension values: LIVE e ON_DEMAND

youtubeProduct

This dimension identifies the YouTube service on which the user activity occurred. Data for this dimension is available as of July 18, 2015.

The possible dimension values:

Core: The user activity that did not occur in one of the specialty YouTube applications (YouTube Gaming, YouTube Kids, or YouTube Music). Exception: User activity that occurred in YouTube Music before March 1, 2021, is included in CORE.
Gaming: The user activity occurred in YouTube Gaming.
Kids: The user activity occurred in YouTube Kids.
Music: The user activity occurred in YouTube Music on or after March 1, 2021. Data prior to March 1, 2021 is included in CORE. Real-time data is not recorded.
Unkown: The user activity occurred prior to July 18, 2015.

Metrics

views

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. The YouTube Help Center provides additional information about how views are reported.;

estimatedMinutesWatched

The number of minutes that users watched videos for the specified channel, content owner, video, or playlist.

comments

The number of times that users commented on a video.

likes

The number of times that users indicated that they liked a video by giving it a positive rating.
dislikes

The number of times that users indicated that they disliked a video by giving it a negative rating.

shares

The number of times that users shared a video through the Share button.

annotationClickThroughRate

The ratio of annotations that viewers clicked to the total number of clickable annotation impressions.

annotationCloseRate

The ratio of annotations that viewers closed to the total number of annotation impressions.

averageViewDuration

The average length, in seconds, of video playbacks.

subscribersGained

The number of times that users subscribed to a channel.

subscribersLost

The number of times that users unsubscribed from a channel.

redViews

The number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members.

estimatedRedMinutesWatched

The number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video.

averageViewDuration

The average length, in seconds, of video playbacks.

averageViewPercentage

The average percentage of a video watched during a video playback.

videosAddedToPlaylists

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.
The metric value does include the number of times that videos were added to default playlists like the "Watch Later" playlist. However, it does not count playlists that a video is automatically added to, such as a channel's uploads playlist or a user's watch history.
This metric returns an absolute number, meaning that if a user adds a video to a playlist, removes it, and then adds it again, the metric value reflects the video being added to a playlist twice. Data for this metric is not available for dates before October 1, 2014.
videosRemovedFromPlaylists

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.
The metric value includes the number of times that videos were removed from default playlists like the "Watch Later" playlist.
This metric returns an absolute number, meaning that if a user adds a video to a playlist, removes it, adds it again, and then removes it again, the metric value reflects the video being removed from a playlist twice. Data for this metric is not available for dates before October 1, 2014.
annotationImpressions

The total number of annotation impressions.

annotationClickableImpressions

The number of annotations that appeared and could be clicked.
annotationClicks

The number of clicked annotations.

annotationClosableImpressions

The number of annotations that appeared and could be closed.

annotationCloses

The number of closed annotations.

cardImpressions

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.

cardClicks

The number of times that cards were clicked.

cardClickRate

The click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions.

cardTeaserImpressions

The number of times that card teasers were displayed. A video view can generate multiple teaser impressions.

cardTeaserClicks

The number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user.

cardTeaserClickRate

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.