In this article, I want to share with you how to track your YouTube analytics and fill in my data tracker spreadsheet. I use this to fill in my analytics for each month. This allows me to see how I’ve improved.

I’m also going to go into details on where to find the information so that you can plug it into the spreadsheet. Here’s the link where you can download my spreadsheet.

Having all this information at your fingertips will allow you to see your improvement and it will keep you motivated too.

My Spreadsheet Explained

The screenshot below will show you how I’ve set up the spreadsheet. On it, I track my views, my watch time, my subscribers, how much much I get paid and how many views I get every 48 hours. To get this data, I use VidIQ which I’ll also explain a little later. We’ll also discuss how to add RPM, CPM, view duration, click-through rate and suggested and external traffic. Plus, I’ll explain where you can find all this information in your YouTube analytics.

How To Fill In Your Data

When you’re on your YouTube analytics page, you’ll see a lot of the data that you want to add to the tracker spreadsheet. Ideally, you’ll want to fill in the data for each month.

To find this, you need to select the month on the top right of your analytics page.

As you can see, immediately you can fill in your views, your watch time hours, your new subscribers and your revenue for the month. So, you would grab these values and add them to the spreadsheet. It’s fine to round up or round down the figures as you add them to make it easier.

To get your “total subs”, just look at the figure under “Realtime”.

Then, as I mentioned, to get the average views over 48 hours, I use VidIQ which is a Chrome extension. Once you have it installed, you can just click on the icon and it will give you live stats any time of the day. Be aware though, if you watch your stats constantly that they’ll be going up and down and this is not something to worry about.

Because you’ll be watching this over the course of the month, you’ll have a good idea of the number of views over any 48-hour period. For me, during the month of February, I was averaging around 500 to 600 views every 48 hours. So, that’s what I’m going to put into the tracker.

Finding RPM, CPM and View Duration

Once we get to the RPM column, we’ll be looking at some stats back on our YouTube analytics page, but we’re going to click on “Revenue”.

As you can see, my RPM is $31.23. That is the amount I’ll get paid for every 1000 views. On this page you’ll also find the CPM or cost per 1000 views. This is actually what the advertiser pays to display their ads on my videos. Notice that the figure has gone up for me and that is what you want to try and achieve as well.

For the column headed “view duration” you have to click on “Engagement”.

For the “click-through rate”, you have to click on “Reach” which is to the left of “Engagement”.

As you can see from my stats, things have gone up and some have gone down. This is perfectly fine and nothing to get depressed about. It gives you a chance to see how you’re going and highlights areas that you need to improve in.

And, if you want to get really fancy, you can highlight the numbers in green or red to show you where you’ve gone up or down. It all depends on what works best for you.

Finding Where The Traffic Comes From

To find out where your traffic is coming from, scroll down the page when you’re in the “Reach” and you’ll come to a section headed “Traffic Sources”.

From my stats you can see that 54% of my traffic comes from YouTube Search and 19.8% of traffic came from suggested videos. Plus, the external traffic was 14.6%. External traffic is most likely coming from a social media site where you’ve posted your video.

Once, you have all this information filled in, it will give you a bird’s eye view of all your stats. Now you can quickly track your YouTube analytics and analyze your progress from month to month.

I hope this was helpful.

You’ve Got This!