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?
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
- Go to https://studio.youtube.com/
- 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
- 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.
- Still logged into your Google account, go to Google Data Studio (https://datastudio.google.com/)
- 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. Click on this, and then select Download CSV or Export to Sheets
- 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!