Sep 28, 2020

A free Google Data Studio template for YouTube reporting

6-MINUTE READ | By Joy Huynh

DashboardsData VisualizationLooker Studio (Google Data Studio)Social Media AnalyticsYouTube

[ Updated Jun 25, 2024 ]

TL;DR If you want to jumpstart your reporting, simply swipe our free Google Data Studio YouTube template. For more tips on how to build a report from scratch and analyze your data, keep on reading.

Have you ever watched a video from a competitor on YouTube and wondered how they got all their views and engagement?

After all, you and your team probably spend hours on producing high-quality videos. You also promote your YouTube channel everywhere, from social media to emails. Then why aren’t you seeing the same results?

My guess is you don’t yet have a clear idea of what works for your audience and how to allocate your resources accordingly.

The solution: YouTube analytics.

That’s why today, I’m going to show you how to build a YouTube report on Google Data Studio.

If it sounds like your cup of tea, then let’s get right into it.

How to build a YouTube report

Step 1: Know your goals

Don’t fall for the “X YouTube metrics that really matter” trap. What works for others may not work for you. The metrics you measure should always depend on your goals.

And since you’re here, I believe you already know what you want to achieve on YouTube and have an action plan for it. (If not, please take a moment to define your goals and come back to me when you’re done. Don’t worry, I’ll wait.)

Now make a list of your goals. Do you want to build brand awareness, increase engagement, or drive more sales?

For example, if I’m just starting a new channel, my goals can be:

  1. Increase my YouTube channel awareness
  2. Engage with my audience

Step 2: Choose your metrics

When it comes to choosing YouTube metrics to track, the more, the messier. Pick a few metrics that align with your goals and help you understand your performance. Good metrics should:

  1. Tell you if you’ve achieved your goals
  2. Tell you what you can do to improve your performance

If you want to measure awareness, performance metrics like video views, average view duration, subscriber growth are good metrics.

If you want to measure engagement, pay attention to likes, comments, and shares.

If you want to measure revenue, you may find estimated revenue, or estimated ad revenue as the best metrics.

YouTube metrics you should track

Back to my example. Since I want to drive awareness to my channel, I’ll want to know if there are lots of people watching my videos and how much time they’re spending on watching my videos. I’ll then track:

Video views: The number of times people have viewed my videos — the more I have, the better my YouTube SEO ranking will be.

Average view duration: This is calculated by total watch time/total video plays (including replays). A higher average view duration means that my audience finds my video useful.

Estimated time watched: How much time my audience spends watching my videos.

Subscriber growth trend: The number of subscribers I’ve gained and lost over time.

I also want to engage with my audience so I want to see what my engagement metrics look like and where my subscribers come from. That’s why I’ll track:

Likes and dislikes: The number of likes and dislikes on my videos.

Shares: The number of times people have shared my videos.

Video views by traffic source: Where my traffic is coming from.

Video views by device type: Which devices people use to watch my videos.

Video views by country: Which countries (or states) my traffic comes from.

Step 3: Build your report

After you have a list of metrics you want to track, it’s time to put them together in a report. If you’re looking for a tool that offers flexible data visualization options and easy sharing, I would strongly recommend Google Data Studio.

The great news is you can use Supermetrics connectors to pull all the data you want to Google Data Studio and build any types of reports you want.

Think about what types of charts will best present your data:

  • Scorecards to present the key numbers
  • Sparkline charts to show evolution
  • Bar charts to compare or rank values within the same category
  • Maps to visualize how your data is distributed

Psss, if you want to learn how to create a badass marketing reporting dashboard, check out this article for 4 key tips

Now let’s take a look at this YouTube channel dashboard.

Step 4: Analyze your data

Data is nothing but plain numbers unless you analyze and take action on it. Look at your key metrics and think about how they’ve changed overtime. Is there a pattern in the change? Why did something change? Is there anything you can do to improve your performance?

For example, if my video views are declining, I might be able to improve by:

  • Optimizing thumbnails and video description
  • Grasping viewers’ attention with a short and engaging intro
  • Grouping videos to relevant playlists
  • Inviting guests to your videos

And that’s it!

To sum it up, getting good at YouTube analytics can really boost your channel. By following the steps we talked about, you’ll know exactly what’s working and what’s not. This means you can make better videos that more people will want to watch. Tools like Google Data Studio can help make sense of all the numbers, showing you clear ways to improve. Remember, the key is to keep learning from your data and tweaking your approach to keep your audience coming back for more.

Turn your marketing data into opportunity

We streamline your marketing data so you can focus on the insights.

Book Demo