Try our plataform
YouTube

Creating the data source

Based on the YouTube API documentation (Analytics) and (Data)

Requirements

  • If your account is a Brand Account, the user authorizing the connector must be the Owner of the account
  • You must have a YouTube channel associated with the Google account that will authorize the connector

Instructions

  1. Log in to the Kondado platform, go to the add connectors page and select the YouTube connector
  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 the permissions that are requested and click Continue
  6. You will be redirected to the Kondado page with access already authorized. Give your connector a name

Now just click SAVE and start receiving YouTube data in your Data Warehouse or Data Lake

Data has a delay of up to 3 days for availability via API

Pipelines

Summary

Relationship chart

Click to expand

Channel Daily Stats

This integration brings various metrics, in the day and channel dimensions

Replication type: Incremental

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

Channel Daily Views

This integration brings the views and estimatedMinutesWatched metrics per day according to various possible breakdowns, which are combinations of dimensions together with day and channel

Replication type: Full

Parameters:

  • Breakdown: Select additional dimensions to aggregate the data (besides day+channel)
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

Playlist Items

Replication type: Full

Campo Tipo

playlist_id

text

[en] Playlist ID

video_id

text

[en] Video ID

playlist_title

text

[en] Playlist title

video_title

text

[en] Video title

video_description

text

[en] Video description

video_thumbnail_url

text

[en] Video thumbnail URL

position

int

[en] Video position in playlist

video_owner_channel_title

text

[en] Video owner channel title

video_owner_channel_id

text

[en] Video owner channel ID

channel_id

text

[en] Playlist channel ID

video_published_at

timestamp

[en] Video publish date

added_to_playlist_at

timestamp

[en] Date the video was added to the playlist

kdd_extracted_at

timestamp

[en] Extraction date/time

Playlists

Replication type: Full

Campo Tipo

playlist_id

text

[en] YouTube playlist ID

published_at

timestamp

[en] Playlist creation date

channel_id

text

[en] Channel ID

title

text

[en] Playlist title

description

text

[en] Playlist description

channel_title

text

[en] Channel title

thumbnail_url

text

[en] Playlist thumbnail URL

privacy_status

text

[en] Privacy status (public, private, unlisted)

item_count

int

[en] Number of videos in the playlist

kdd_extracted_at

timestamp

[en] Extraction date/time

Videos daily stats

Replication type: Incremental

Parameters:

  • Read start date (Savepoint): Data replication start date based on created date

Relationships:

Campo Tipo

day

date

video_id

text

channel_id

text

    Channel Daily Stats > > channel

    Channel Daily Views > > 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

Replication type: Incremental

Parameters:

  • Read start date (Savepoint): Data replication start date based on created date
  • Breakdown: Select additional dimensions to aggregate the data (besides day+channel)

Relationships:

Campo Tipo

day

date

video_id

text

channel_id

text

    Channel Daily Stats > > channel

    Channel Daily Views > > 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

Notes

Dimensions

insightPlaybackLocationType

Aggregates data based on the type of application where the video was played. Possible values are:

  • YT_OTHER: other type of playback, not previously classified
  • WATCH: playbacks on the video's own page on YouTube or in an official YouTube application, such as the Android app
  • SEARCH: direct playbacks on the YouTube search results page
  • MOBILE: YouTube mobile site or clients using approved YouTube API clients, including mobile devices. Since 09/10/2013, playbacks are no longer categorized as MOBILE
  • EXTERNAL_APP: third-party application, using a method other than embed. This includes playbacks in applications that use the YouTube Android Player API
  • EMBEDDED: another website, where the video was embedded
  • CHANNEL: channel page
  • BROWSE: YouTube home page or initial screen, in the user's subscription feed or in another YouTube navigation component

insightTrafficSourceType

Aggregates data based on how users reached the video (referrer). Possible values are:

  • YT_SEARCH: views from YouTube search results
  • YT_PLAYLIST_PAGE: views from the listing of all videos in a playlist. This is different from PLAYLIST, which indicates that the video was played as part of a playlist
  • YT_OTHER_PAGE: views from a link that are not search results or related videos
  • YT_CHANNEL: views on the channel page
  • SUBSCRIBER: the video was found via the YouTube homepage feed or YouTube subscription functionality
  • SHORTS: the view occurred due to a vertical swipe from a previous video in the Shorts viewing experience
  • RELATED_VIDEO: views came from a listing of similar videos on another video's page
  • PROMOTED: playbacks came from unpaid YouTube promotion, such as the "Spotlight Videos" page
  • PLAYLIST: the video was played as part of a playlist. This is different from YT_PLAYLIST_PAGE, which indicates that the video was played while listed in the playlist
  • NOTIFICATION: the video was referenced from a YouTube email or notification
  • NO_LINK_OTHER: YouTube did not identify the source. Includes direct traffic and app traffic
  • NO_LINK_EMBEDDED: the video was embedded on another site when it was played
  • EXT_URL: link on another site (external URL). Includes references from Google search results
  • END_SCREEN: end screen of another video
  • CAMPAIGN_CARD: card on another video
  • ANNOTATION: annotation on another video
  • ADVERTISING: advertisement

deviceType

Aggregates results based on the physical form of the device where views occurred. The returned values can be: DESKTOP, GAME_CONSOLE, MOBILE, TABLET, TV and UNKNOWN_PLATFORM

operatingSystem

Identifies the software system of the device where the view occurred. Possible values are: 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 and XBOX

subscribedStatus

Indicates whether the metric is related to viewers who were subscribed to the video's or playlist's channel. Possible values are SUBSCRIBED and UNSUBSCRIBED. Note that this dimension is given according to the moment when the user activity occurred. For example, an unsubscribed user watched a video and then subscribed to the channel and watched another video on the same day. In this case, one of their views will be counted as SUBSCRIBED and another as UNSUBSCRIBED.

liveOrOnDemand

Indicates whether the user activity occurred during a live broadcast or not. Data will be available for this dimension from 2014-04-01. Possible values are: LIVE and ON_DEMAND

youtubeProduct

Identifies the YouTube service where the user activity occurred. Data is available from 2015-07-18. Possible values are:

  • UNKNOWN: Activity occurred before 2015-07-18
  • MUSIC: Activity that occurred on YouTube Music after 2021-03-01. Data before 2021-03-01 is in CORE. Real-time data is not stored
  • KIDS: Activity that occurred on YouTube Kids
  • GAMING: Activity that occurred on YouTube Gaming
  • CORE: The activity did not occur in one of the special apps (YouTube Gaming, YouTube Kids, or YouTube Music). Exception: Activities that occurred on YouTube Music before 2021-03-01 are included in CORE

Metrics

views

Number of times a video was viewed. The YouTube help center provides additional information on how views are reported

estimatedMinutesWatched

Number of minutes that users watched videos

comments

The number of times users commented on a video

likes

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

dislikes

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

shares

The number of times users shared a video using the Share button

annotationClickThroughRate

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

annotationCloseRate

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

averageViewDuration

The average length, in seconds, of video playbacks

subscribersGained

The number of times users subscribed to a channel

subscribersLost

The number of times users unsubscribed from a channel

redViews

The number of times a video was viewed by YouTube Premium members (formerly YouTube Red)

estimatedRedMinutesWatched

The number of minutes that YouTube Premium members (formerly YouTube Red) watched a video

averageViewPercentage

The average percentage of a video watched during playbacks

videosAddedToPlaylists

The number of times videos were added to any YouTube playlist. These videos may have been added to the video owner's playlist or to other channels' playlists. This value also considers when videos are added to default playlists like "Watch Later", but does not consider when videos are automatically added to playlists like a channel's uploads or the user's watch history. Only absolute values are returned. So, if a user adds the video to a playlist, removes it and then adds it again, the value will be counted double. This metric does not return values before 2014-10-01

videosRemovedFromPlaylists

The number of times videos were removed from any YouTube playlist. These videos may have been removed from the owner's playlists or from other channels' playlists. This metric includes the number of times videos were removed from default playlists like "Watch Later". The returned value is absolute, meaning if a user removes the video from a playlist, adds it back and then removes it again, the metric will reflect the doubled value. Data available from 2014-10-01

annotationImpressions

The number of annotation impressions

annotationClickableImpressions

The number of annotations that appeared and could be clicked

annotationClicks

The number of annotations clicked

annotationClosableImpressions

The number of annotations that appeared and could be closed

annotationCloses

The number of annotations closed

cardImpressions

The number of times cards were displayed. When the card panel is opened, a card impression is counted for each of the video's cards

cardClicks

The number of times cards were clicked

cardClickRate

The card click rate, calculated as the division between the number of card clicks and the number of card impressions

cardTeaserImpressions

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

cardTeaserClicks

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

cardTeaserClickRate

The card teaser click rate, calculated as the ratio between the number of card teaser clicks and the number of card teaser impressions

  • Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information