Services used

  Google Sheets
  Google Analytics
   YouTube
   Sheetgo

Department

  Marketing

Time to setup

 17 minutes

Weekly hours saved

± 2-4 hours 

With YouTube being the second most used search engine on the web according to Alexa and Similarweb, it became an important channel for departments such as Marketing, Customer Support, and Sales. For this reason, we created the YouTube Analytics Template in Google Sheets to allow you to better analyze and track YouTube data using technology that you already know.

So if you have been looking for a way to keep historical data that is clean and visually easy to understand, you’ve come to the right place. Here’s the alternative for YouTube Analytic tools. It’s customizable and doesn’t require you to code, use formulas or other technical skills. However, feel free to click on the bottom right chat button if you have any questions. 🙂

What is the YouTube Analytics Template?

The YouTube Analytics Template tracks some of the most important YouTube metrics: Subscribers, Likes, Dislikes, comments, and even compares referred traffic to your website. Essentially, its an automation of the data flow for Youtube metrics and related engagement. In the end, all you need to do is use the YouTube Dashboard to monitor it all. You can even set up an automatic notification when your videos have a high drop-off point.

The YouTube Analytics template explained in a diagram.

Instructions

This template consists of 3 steps:

  1. YouTube API
    Youtube Analytics API Database: this spreadsheet gets all the data needed from Youtube analytics. And to set it up it only requires you to provide your YouTube channel ID.
  2. Youtube (GA Reports)
    This spreadsheet pulls data from your Google Analytics to get your referrals and see how your channel is engaging people on your website.
  3. Youtube Dashboard
    Here you can find all the relevant information from multiple sources. You get a consolidated historic view and some cool graphics!

Step 1) YouTube API

This currently does not work for a branded YouTube account. Please, contact us if you actually need it for a branded account.

  1. Open the advanced settings of your YouTube channel by clicking here and copy the “YouTube Channel ID”.
  2. Copy the first part of the template by clicking here and paste YouTube channel ID into the settings tab.
  3. In the menu, go to “Tools” and open the “Script editor”.
  4. Inside the Script editor, in the menu, click on “Resources” > “Advanced Google services”. In the new window, scroll all the way down to “YouTube Data API” and make sure it is ON.
  5. Now, below click on “Google Cloud Platform API Dashboard”. In the new screen, click on “ENABLE APIS AND SERVICES”.
  6. In the new screen, type “youtube” to search. Next, in the results, click on “YouTube Data API”. Click the option to enable. Note, if you already have done this once, it will say “MANAGE” instead of “ENABLE”. Close this tab and click on “ok” in Google Script.
  7. In the spreadsheet, go to the menu to click on “YouTube Analytics” > “Update data”. Proceed with the logins and authorizations, making sure you choose your account and not your company account.

Awesome! The first step is done. 🙂

Part 2) Setting up Google Analytics

  1. Open your Google Analytics (GA) and copy your “view ID“.
  2. Copy the GA template by clicking here and paste your View ID in the cell.
  3. In the “YouTube Template (GA Reports)” spreadsheet, open the Google Analytics Add-on. If you haven’t installed the Google Analytics Add-on yet, click here.
  4. In the Google Analytics Add-on, click on “schedule reports“, check the box and select “monthly report“.
  5. Connect your spreadsheets using the Sheetgo Add-on.
  • Inside the spreadsheet “YouTube Template (GA Reports)“, open the Sheetgo add-on.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “YouTube Template (GA Reports)“, then select as a source tab “Report Categories“.
    • Below in settings, change the connection name to “Historic_Sources“.
    • In “automatic updates” choose “monthly” and “day 1“.
    • Enable “Append Data“.
    • Enable “Transfer Formatting“.
    • Click on the green check mark to save the connection.

Part 3) Completing the Dashboard by Connecting all Spreadsheets

Configure and connect Template Dashboard.

  • Open “YouTube Dashboard” by clicking here and open the Sheetgo add-on.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Copy of YouTube Template (GA Reports)“, then select as a source tab “Report Categories“.
    • Below in settings, change the connection name to “GA_YT_Report“.
    • In “automatic updates” choose “Monthly” and on Day 1 and “4AM to 5AM“.
    • Click on the green check mark to save the connection.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Youtube Analytics API Database“, then select as a source tab “Videos“.
    • Below in settings, change the connection name to “YT_Videos“.
    • In “automatic updates” choose “Monthly” and on Day 1 and “4AM to 5AM“.
    • Click on the green check mark to save the connection.
  • Click on the green “+” icon to create a new connection.
    • As a “Data source” choose “Youtube Analytics API Database“, then select as a source tab “Channel Info“.
    • Below in settings, change the connection name to “YT_Channel“.
    • In “automatic updates” choose “Monthly” and on Day 1 and “4AM to 5AM“.
    • Click on the green check mark to save the connection.

All done, congrats! 🙂

Make sure to check out our Facebook Analytics Template by clicking here!

Let us know if you have any remarks or questions by commenting down below.

Icon made by Freepik from www.flaticon.com