YouTube has become a powerful platform for businesses to reach their target audiences. It offers a unique opportunity to market their products and services. However, gathering meaningful metrics such as channel subscribers and views and importing them into Looker Studio can be difficult.
Two Minute Reports (TMR) offers a solution to get performance data from many sources into Looker Studio without needing to write any code. This guide provides a useful tutorial for pulling YouTube Analytics data into Looker Studio to further maximize your marketing and reporting efforts.
Select YouTube Analytics in the TMR Portal
The first thing to do is to go through our portal and select the data source you want to add.
- Go to apps.gox.ai and Login to your account.
- Choose Two Minute Reports for Looker Studio (the blue one).
- Select your team. If you only have one team, you skip this and TMR automatically redirects you to the connectors page.
You will now see the connectors page.
- In the connectors page, find and select YouTube Analytics.
Authorize Your YouTube Analytics Account
The next series of steps is to configure your YouTube Analytics account with TMR.
Login to Your YouTube Analytics Account
In this section, you need to login to your YouTube Analytics account for authentication making sure it connects with TMR and Looker Studio.
- Under Data Sources, click +Add New button.
- Name your data source
- Click the Sign in with Google button.
- Go through the entire authentication in YouTube. If successful, Two Minute Reports gives a prompt “Signed in! You may close this tab now.“
Configuring Your YouTube Analytics Account with TMR
- In the Query Configs section, click + Add New button. Choose the data source you added earlier. Click Next.
The next following steps is where you configure your YouTube settings to TMR so that you can create reports in Looker Studio. You may configure the following parameters depending on your preference as TMR has imported them.
- Name your query config.
- Select your YouTube Analytics Channel.
- Data Options whether you want to Include missing time values or Replace blank metrics with zeros. This means empty metrics are still being reported as zero values.
- Click Save.
Once everything is finished, click green Create Report button on the right side. The next section is creating reports in Looker Studio.
Create a YouTube Analytics Report with TMR in Looker Studio
After connecting YouTube Analytics, you can create your own custom dashboard in Looker Studio. Looker Studio is a powerful data visualization tool that contains many features to help you reduce time creating reports.
- After clicking Create Report from the previous section, click Create Report from scratch blue button.
- You are redirected to Looker Studio. In Looker Studio, under Select Query Config, choose the configuration you created earlier (it should be the name you gave it). Under Select your Team, choose the appropriate team as well if the dropdown is showed to you.
- Click the blue Connect button in the upper right side of the page.
- You can now view the YouTube Analytics schema on Looker Studio. Click Create Report in the right side of the page.
Once everything is loaded, you are presented with a blank canvas. You can now create custom reports (adding dates and charts) in Looker Studio with your YouTube Analytics data.
If you want to learn about creating your own report, like adding dates and charts, read How to Create a Report in Looker Studio