If you run a YouTube channel, YouTube Analytics (now sitting within YouTube Studio Beta) is an easy way to see how many views each of your videos has had within a given time period. However it only shows the top 50 results. What if you want to see figures on the top 500 videos, or maybe even more than that?
Top 50
First, let's start with how to view your top 50 most viewed videos in YouTube Analytics.
Log in to the Google account associated with your YouTube channel
Click on Analytics in the menu in the left-hand sidebar
The 'Overview' tab and the 'Views' metric should already be selected. Click on the blue SEE MORE link immediately below the graph
Your channel analytics should pop out, showing your top 50 videos most viewed videos in the default time period ('Last 28 days')
Feel free to change the time period using the date picker in the top right
Top 500
Still in your YouTube channel analytics, click on the 'Export current view' icon in the very top right (it looks like a down arrow with a line underneath it)
Select either Google Sheets (new tab) or Comma-separated values (.csv) as you prefer
If you choose 'Comma-separated values (.csv)', you will download a .zip file which you wil need to unzip
Both the Google Sheet and the 'video.csv' file (within the downloaded zip) will list not your top 50 but your top 500 most-viewed videos within the time period
This is all well and good, but what if you are a prolific creator and your channel has more than 500 videos?
More than 500
This is where Google Data Studio comes to your aid. Using this free tool, you can create a dashboard that lets you display and export data on all of your videos. Here's how.
In the top left corner, click on Create then Report
You have a blank report! You will be prompted to 'Add a date source'. Click CREATE NEW DATA SOURCE in the bottom right
In the grey search box, search for 'YouTube'
Hover over 'YouTube Analytics', click the blue SELECT button and then AUTHORIZE
Choose your Google account and YouTube channel when prompted, then ALLOW, CONNECT and finally ADD TO REPORT (twice)
You're now back at your blank report. This time, however, it includes a small blue table with some data from YouTube videos in it. The table has the dimension 'Video Title' and the metric 'Average View Percentage'. That's not what we want!
Make sure the table is selected (it should be, but left-click on it if not), then in the menu on the right click Add metric
Search for 'views' and then select the green 'Views' metric - it will appear in your table
Still in the 'Metric' options, hover over 'Average View Percentage' and click the small 'X' button to remove this metric
The table will change to show you the videos with the highest views rather than the highest average view percentage
Now we just need a way to choose a date range. In the main navigation menu, select Insert > Date Range and then click on your report to add your date picker to it
You're all done building your report! Now to get your data. Click View in the top right
Choose your date range...
Hover over your table, and you will see a small icon with three dots in a vertical line. Left click on this, and then select Download CSV or Export to Sheets. Alternatively you can right click on the table itself, which should bring up the same menu
This download will list not just 500 videos but ALL videos to have received views in your chosen time frame
There is a lot more you can do with your report - not least add other useful metrics and then export that data too. But hopefully this will be enough to get you started. Happy analysing and don't forget to give your report a name!
Subscribe
Connect with
Allow account creation
When you use a social login button for the first time, we collect your public profile information shared by the social login provider based on your privacy settings. We also collect your email address and use this to automatically create an account for you on our website. Once your account is created, you will be logged in to this account.
DisagreeAgree
Allow account creation
When you use a social login button for the first time, we collect your public profile information shared by the social login provider based on your privacy settings. We also collect your email address and use this to automatically create an account for you on our website. Once your account is created, you will be logged in to this account.
DisagreeAgree
10 Comments
Oldest
Newest
Inline Feedbacks
View all comments
Faraz
2 years ago
Thanks, but when I click the ... in the last step I don't see any option to "Download". I just see "Select, cut, copy, paste and some other unrelated things"
Hi Faraz - I've tested again and it's still working for me. It's worth checking that you're in Google Data Studio 'View' mode rather than 'Edit' mode, and that you're left clicking rather than right clicking.
You could also try right clicking on the table itself - that should bring up the same menu as left clicking on the '...'. Good luck!
I'm trying to get CTR and avg. % viewed from the Google Data Studio tool but I don't see those fields available like I do in YouTube analytics through the studio portal.
Hi Adam - I've got good and bad news for you! There is a field in Looker Studio called "Average View Percentage" so you can add that to your table as a metric. But I cannot find any fields related to CTR. I tried to see if I could calculate it from clicks and impressions, but these are not available in Looker Studio either. There are other YouTube connectors available (e.g. from Supermetrics) so perhaps one of these will allow you to pull the data you want? They are paid but you may be able to sign up for a… Read more »
Last edited 6 months ago by James Clark
Steve
10 months ago
Hi James, thanks for the guide. Any idea why there are no revenue-related metrics available to include, or better yet, how I can add them?
Steve - you're right, sadly there are no revenue-related metrics available with the YouTube Analytics connector. You could try the Supermetrics YouTube connector instead, as this promises "Views, engagement, ad revenue, and much, much more" (https://supermetrics.com/connectors/youtube). I haven't tried it myself but you could sign up for a free trial and see whether it suits your purposes.
Hi! I'm James Clark and I'm a freelance web analyst from the UK. I'm here to help with your analytics, ad operations, and SEO issues.
Buy me a coffee
Thanks, but when I click the ... in the last step I don't see any option to "Download". I just see "Select, cut, copy, paste and some other unrelated things"
Hi Faraz - I've tested again and it's still working for me. It's worth checking that you're in Google Data Studio 'View' mode rather than 'Edit' mode, and that you're left clicking rather than right clicking.
You could also try right clicking on the table itself - that should bring up the same menu as left clicking on the '...'. Good luck!
Think I figured it out. Had to click the blue "View" button to switch to "Edit" mode. Then the option came up. So opposite for me..
Thank you, I want to know how to export revenue of more than 500 videos, because it seems to not have "revenue" field in data studio?
How do I basically summarize all of the views for the video while being able to see the video's publishing date in the report?
Hi Den - I've written you a guide to doing this: https://www.technicallyproduct.co.uk/analytics/how-to-display-youtube-video-published-date-in-looker-studio/
I'm trying to get CTR and avg. % viewed from the Google Data Studio tool but I don't see those fields available like I do in YouTube analytics through the studio portal.
Any thoughts?
Hi Adam - I've got good and bad news for you! There is a field in Looker Studio called "Average View Percentage" so you can add that to your table as a metric. But I cannot find any fields related to CTR. I tried to see if I could calculate it from clicks and impressions, but these are not available in Looker Studio either. There are other YouTube connectors available (e.g. from Supermetrics) so perhaps one of these will allow you to pull the data you want? They are paid but you may be able to sign up for a… Read more »
Hi James, thanks for the guide. Any idea why there are no revenue-related metrics available to include, or better yet, how I can add them?
Steve - you're right, sadly there are no revenue-related metrics available with the YouTube Analytics connector. You could try the Supermetrics YouTube connector instead, as this promises "Views, engagement, ad revenue, and much, much more" (https://supermetrics.com/connectors/youtube). I haven't tried it myself but you could sign up for a free trial and see whether it suits your purposes.