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
- Log in to the Kondado platform, go to the add connectors page and select the YouTube connector
- Click on "Sign in with Google"
- Select the Google account you will use
- Select the channel (YouTube account) you will use
- On the next screen, check ALL the permissions that are requested and click Continue
- 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
Daily YouTube channel metrics: one row per day per channel, with aggregated performance indicators such as views, estimated minutes watched, average view duration and average view percentage, likes, dislikes, comments, shares, subscribers gained and lost, plus card and annotation metrics (impressions, clicks and rates). Includes the channel title, description, custom URL and thumbnail.
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date (day) the metrics refer to; one row per day. ISO-8601 format (YYYY-MM-DD). |
|
|
text |
[en] Identifier of the YouTube channel the row refers to. |
|
|
text |
[en] Name (title) of the YouTube channel. |
|
|
text |
[en] Description of the YouTube channel. |
|
|
text |
[en] Custom (vanity) URL of the YouTube channel. |
|
|
text |
[en] URL of the channel thumbnail image. |
|
|
int |
[en] Number of views recorded in the period. Starting on August 24, 2026, YouTube counts a view as soon as the video starts to play, with no minimum watch-time requirement — the methodology was aligned with the one already used for Shorts, and now applies to long-form videos and live streams as well. The previous count (with minimum watch time) remains available on the YouTube API as the engagedViews metric, which Kondado does not collect. |
|
|
int |
[en] Number of comments posted in the period. |
|
|
int |
[en] Number of dislikes recorded in the period. |
|
|
int |
[en] Number of likes recorded in the period. |
|
|
int |
[en] Number of times the content was shared in the period. |
|
|
float |
[en] Annotation click-through rate: ratio of clicks to clickable annotation impressions (value between 0 and 1). |
|
|
float |
[en] Annotation close rate: ratio of closed annotations to closable annotation impressions (value between 0 and 1). |
|
|
int |
[en] Average duration of playbacks, in seconds. |
|
|
int |
[en] Estimated total minutes watched in the period. |
|
|
int |
[en] Number of subscribers gained in the period. |
|
|
int |
[en] Number of subscribers lost in the period. |
|
|
int |
[en] Number of views by YouTube Premium members. |
|
|
int |
[en] Estimated minutes watched by YouTube Premium members. |
|
|
float |
[en] Average percentage of each video that was watched (value between 0 and 100). |
|
|
int |
[en] Number of times videos were added to playlists. |
|
|
int |
[en] Number of times videos were removed from playlists. |
|
|
int |
[en] Total number of annotation impressions. |
|
|
int |
[en] Number of annotation impressions that were clickable. |
|
|
int |
[en] Number of clicked annotations. |
|
|
int |
[en] Number of annotation impressions that were closable. |
|
|
int |
[en] Number of annotations closed by viewers. |
|
|
int |
[en] Number of times cards were shown. |
|
|
int |
[en] Number of card clicks. |
|
|
float |
[en] Card click rate: ratio of clicks to card impressions (value between 0 and 1). |
|
|
int |
[en] Number of times card teasers were shown. |
|
|
int |
[en] Number of card teaser clicks. |
|
|
int |
[en] Card teaser click rate: ratio of clicks to teaser impressions (value between 0 and 1). |
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)
Daily YouTube channel views broken down by a chosen dimension: one row per day, per channel and per value of the selected dimension (for example device type, operating system, subscription status or traffic source), with the number of views and estimated minutes watched, plus the channel title, description, custom URL and thumbnail.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Value of the breakdown dimension chosen for the report — for example the device type, operating system, subscription status or traffic source corresponding to this row. |
|
|
date |
[en] Date (day) the metrics refer to; one row per day. ISO-8601 format (YYYY-MM-DD). |
|
|
text |
[en] Identifier of the YouTube channel the row refers to. |
|
|
text |
[en] Name (title) of the YouTube channel. |
|
|
text |
[en] Description of the YouTube channel. |
|
|
text |
[en] Custom (vanity) URL of the YouTube channel. |
|
|
text |
[en] URL of the channel thumbnail image. |
|
|
int |
[en] Number of views recorded in the period. Starting on August 24, 2026, YouTube counts a view as soon as the video starts to play, with no minimum watch-time requirement — the methodology was aligned with the one already used for Shorts, and now applies to long-form videos and live streams as well. The previous count (with minimum watch time) remains available on the YouTube API as the engagedViews metric, which Kondado does not collect. |
|
|
int |
[en] Estimated total minutes watched in the period. |
Playlist Items
Replication type: Full
Relationships:
Videos in each channel playlist. Lists all videos belonging to each playlist, with position, title and dates.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] Playlist ID |
|
|
text |
[en] Video ID |
|
|
text |
[en] Playlist title |
|
|
text |
[en] Video title |
|
|
text |
[en] Video description |
|
|
text |
[en] Video thumbnail URL |
|
|
int |
[en] Video position in playlist |
|
|
text |
[en] Video owner channel title |
|
|
text |
[en] Video owner channel ID |
|
|
text |
[en] Playlist channel ID |
|
|
timestamp |
[en] Video publish date |
|
|
timestamp |
[en] Date the video was added to the playlist |
|
|
timestamp |
[en] Extraction date/time |
Playlists
YouTube channel playlists. Includes title, description, privacy status and video count.
| Campo | Tipo | |
|---|---|---|
|
text |
[en] YouTube playlist ID |
|
|
timestamp |
[en] Playlist creation date |
|
|
text |
[en] Channel ID |
|
|
text |
[en] Playlist title |
|
|
text |
[en] Playlist description |
|
|
text |
[en] Channel title |
|
|
text |
[en] Playlist thumbnail URL |
|
|
text |
[en] Privacy status (public, private, unlisted) |
|
|
int |
[en] Number of videos in the playlist |
|
|
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:
Daily per-video YouTube metrics: one row per day per video, with performance indicators such as views, estimated minutes watched, average view duration and average view percentage, likes, dislikes, comments, shares, subscribers gained and lost, plus card and annotation metrics. Includes channel data (id, title, description, custom URL and thumbnail) and video data (title, description and thumbnail).
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date (day) the metrics refer to; one row per day. ISO-8601 format (YYYY-MM-DD). |
|
|
text |
[en] Identifier of the YouTube video the row refers to. |
|
|
text |
[en] YouTube channel identifier. |
|
|
text |
[en] Name (title) of the YouTube channel. |
|
|
text |
[en] Description of the YouTube channel. |
|
|
text |
[en] Custom (vanity) URL of the YouTube channel. |
|
|
text |
[en] URL of the channel thumbnail image. |
|
|
text |
[en] Video title. |
|
|
text |
[en] Video description. |
|
|
text |
[en] URL of the video thumbnail image. |
|
|
int |
[en] Number of views recorded in the period. Starting on August 24, 2026, YouTube counts a view as soon as the video starts to play, with no minimum watch-time requirement — the methodology was aligned with the one already used for Shorts, and now applies to long-form videos and live streams as well. The previous count (with minimum watch time) remains available on the YouTube API as the engagedViews metric, which Kondado does not collect. |
|
|
int |
[en] Number of comments posted in the period. |
|
|
int |
[en] Number of dislikes recorded in the period. |
|
|
int |
[en] Number of likes recorded in the period. |
|
|
int |
[en] Number of times the content was shared in the period. |
|
|
float |
[en] Annotation click-through rate: ratio of clicks to clickable annotation impressions (value between 0 and 1). |
|
|
float |
[en] Annotation close rate: ratio of closed annotations to closable annotation impressions (value between 0 and 1). |
|
|
int |
[en] Average duration of playbacks, in seconds. |
|
|
int |
[en] Estimated total minutes watched in the period. |
|
|
int |
[en] Number of subscribers gained in the period. |
|
|
int |
[en] Number of subscribers lost in the period. |
|
|
int |
[en] Number of views by YouTube Premium members. |
|
|
int |
[en] Estimated minutes watched by YouTube Premium members. |
|
|
float |
[en] Average percentage of each video that was watched (value between 0 and 100). |
|
|
int |
[en] Number of times videos were added to playlists. |
|
|
int |
[en] Number of times videos were removed from playlists. |
|
|
int |
[en] Total number of annotation impressions. |
|
|
int |
[en] Number of annotation impressions that were clickable. |
|
|
int |
[en] Number of clicked annotations. |
|
|
int |
[en] Number of annotation impressions that were closable. |
|
|
int |
[en] Number of annotations closed by viewers. |
|
|
int |
[en] Number of times cards were shown. |
|
|
int |
[en] Number of card clicks. |
|
|
float |
[en] Card click rate: ratio of clicks to card impressions (value between 0 and 1). |
|
|
int |
[en] Number of times card teasers were shown. |
|
|
int |
[en] Number of card teaser clicks. |
|
|
int |
[en] Card teaser click rate: ratio of clicks to teaser impressions (value between 0 and 1). |
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:
Daily per-video YouTube views broken down by a chosen dimension: one row per day, per video and per value of the selected dimension (for example device type, operating system, subscription status or traffic source), with the number of views and estimated minutes watched. Includes channel and video data (title, description and thumbnail).
| Campo | Tipo | |
|---|---|---|
|
date |
[en] Date (day) the metrics refer to; one row per day. ISO-8601 format (YYYY-MM-DD). |
|
|
text |
[en] Identifier of the YouTube video the row refers to. |
|
|
text |
[en] YouTube channel identifier. |
|
|
text |
[en] Name (title) of the YouTube channel. |
|
|
text |
[en] Description of the YouTube channel. |
|
|
text |
[en] Custom (vanity) URL of the YouTube channel. |
|
|
text |
[en] URL of the channel thumbnail image. |
|
|
text |
[en] Video title. |
|
|
text |
[en] Video description. |
|
|
text |
[en] URL of the video thumbnail image. |
|
|
int |
[en] Number of views recorded in the period. Starting on August 24, 2026, YouTube counts a view as soon as the video starts to play, with no minimum watch-time requirement — the methodology was aligned with the one already used for Shorts, and now applies to long-form videos and live streams as well. The previous count (with minimum watch time) remains available on the YouTube API as the engagedViews metric, which Kondado does not collect. |
|
|
int |
[en] Estimated total minutes watched in the period. |
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 classifiedWATCH: playbacks on the video's own page on YouTube or in an official YouTube application, such as the Android appSEARCH: direct playbacks on the YouTube search results pageMOBILE: YouTube mobile site or clients using approved YouTube API clients, including mobile devices. Since 09/10/2013, playbacks are no longer categorized as MOBILEEXTERNAL_APP: third-party application, using a method other than embed. This includes playbacks in applications that use the YouTube Android Player APIEMBEDDED: another website, where the video was embeddedCHANNEL: channel pageBROWSE: 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 resultsYT_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 playlistYT_OTHER_PAGE: views from a link that are not search results or related videosYT_CHANNEL: views on the channel pageSUBSCRIBER: the video was found via the YouTube homepage feed or YouTube subscription functionalitySHORTS: the view occurred due to a vertical swipe from a previous video in the Shorts viewing experienceRELATED_VIDEO: views came from a listing of similar videos on another video's pagePROMOTED: playbacks came from unpaid YouTube promotion, such as the "Spotlight Videos" pagePLAYLIST: 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 playlistNOTIFICATION: the video was referenced from a YouTube email or notificationNO_LINK_OTHER: YouTube did not identify the source. Includes direct traffic and app trafficNO_LINK_EMBEDDED: the video was embedded on another site when it was playedEXT_URL: link on another site (external URL). Includes references from Google search resultsEND_SCREEN: end screen of another videoCAMPAIGN_CARD: card on another videoANNOTATION: annotation on another videoADVERTISING: 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-18MUSIC: Activity that occurred on YouTube Music after 2021-03-01. Data before 2021-03-01 is in CORE. Real-time data is not storedKIDS: Activity that occurred on YouTube KidsGAMING: Activity that occurred on YouTube GamingCORE: 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
Add YouTube as a Data Source on Kondado
Connect your YouTube channel to Kondado to start extracting video analytics, channel stats, and audience metrics into your data warehouse or BI tool.
Check prerequisites before connecting
Ensure you have a YouTube channel associated with the Google account that will authorize the connection. If using a Brand Account, the authorizing user must be the Owner of that account.
Select YouTube from the data sources page
Log in to Kondado, navigate to the add data sources page, and select the YouTube connector. Then click Sign in with Google to begin OAuth authorization.
Authorize Google account permissions
Choose the Google account linked to your YouTube channel, select the specific channel you want to connect, and grant ALL required permissions on the consent screen. Click Continue to proceed.
Name and save your data source
After being redirected back to Kondado with access authorized, give your data source a descriptive name and click SAVE. Data will begin flowing to your destination such as a data warehouse or BI tool.
Allow for API data availability delay
Note that YouTube API data may have up to a 3-day delay before becoming available. Once synced, you can analyze metrics like views, estimated minutes watched, likes, comments, and subscriber changes through Kondado's data visualization capabilities or your connected BI tool.
