video

YouTube Analytics in Google Sheets

Alex Black

Alex Black

Overview

The YouTube Analytics API lets you pull analytics data into Google Sheets to automate complex reporting tasks, build custom dashboards and more. You can pull data about a video channel, to find out key metrics including views, comments, likes, minutes watched, view duration, subscribers gained or lost, and you can segment it by video, or by time period such as day, week, month etc.

Get your analytics data

Click Submit to get a preview of your data, then customize it as you see fit using the fields below. You can then click Get Google Sheet to get a live updated dashboard with your YouTube analytics data in it.

YouTube Analytics

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

day
views
comments
likes
dislikes
Videos added to playlists
Videos removed from playlists
shares
estimated minutes watched
average view duration
average view percentage
Annotation click through rate
annotationCloseRate
Annotation impressions
Annotation clickable impressions
Annotation closable impressions
Annotation vlicks
Annotation closes
Card click rate
Card teaser click rate
Card impressions
Card teaser impressions
cardClicks
Card teaser clicks
Subscribers gained
Subscribers lost
                          
                          
                          

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Add data sources

Build reports & dashboards