June 22, 2020

YouTube Analytics Dashboard on your Digital Signs

You can create YouTube Analytics Dashboard and assign it to Digital Signs very quickly using Looker Studio. It's free from Google and it already have YouTube Analytics Dashboard template and data integration.

High level steps:

1) Create an account & Log in to Looker Studio (it's free)

2) Link your YouTube account to get your real data

3) Create a YouTube Analytics Dashboard from Template & map your data

4) Put the dashboard into OptiSigns and display on your screens

Here's how your dashboard would look. This template has:

  • Views
  • Avg. Watch Time
  • Shares
  • Top video statistics
  • Interaction (Subscription, Like, Comments)

Of course, you can edit to add data that you'd like to see.

YouTube Sample Channel Report template showing views, watch time, shares and top videos

Let's dive in on how to get this created.

1) Create an account & Log in to Looker Studio (it's free)

Looker Studio (formerly Google Data Studio) is Google's free business intelligence and dashboard tool. Using it, you can connect to a wide range of data sources and create reports, dashboard.

Go to https://lookerstudio.google.com/ and log in with your Google Account.

Google Data Studio overview page with an arrow pointing to the Use It For Free button

2) Link your YouTube account to get your real data

After logging in you will see this page. Click Create

Data Studio home with an arrow pointing to the Create button

Then click "Data Source"

Data Studio Create menu with an arrow pointing to the Data source option

You may need to accept the Google Terms if this is your first time using Looker Studio.

Data Studio terms of service dialog with the Accept button

Then scroll down to find YouTube Analytics and click on it

Data Studio connector list with an arrow pointing to the YouTube Analytics connector

Click "Authorize"

YouTube Analytics connector page with an arrow pointing to the Authorize button

Then select the Account & Report in your YouTube account that you want to use. Google will get data from there & map to this dashboard. Then click Connect.

YouTube Analytics connector with a channel account selected and the Connect button highlighted

You can rename the Data Source by clicking on its name.

When you done click on the Looker Studio Icon on top left to return to home.

YouTube Analytics data source field list in Data Studio after connecting

3) Create a YouTube Analytics Dashboard from Template & map your data

Click on "Report" tab and click on Templates to expand.

Data Studio home with arrows pointing to the Reports tab and the Template Gallery link

Then select "YouTube Channel Report" Template

Data Studio template gallery with an arrow pointing to the YouTube Channel Report template

Then Click "Use Template"

Sample YouTube Channel Report template preview with an arrow pointing to the Use Template button

Select the Data Source that you just created in the previous step, this will tell Google to map your data to this template.

Then click "Copy Report"

Copy this report dialog with YouTube Analytics as the new data source and Copy Report highlighted

Then you can rename the Dashboard.

And feel free to modify the dashboard to your liking, or you can just use it as is.

Copied report open in the Data Studio editor with an arrow pointing to the report title

Once you're done editing, click Share and set the report to Public (required to display it).

Data Studio Share menu with an arrow pointing to the Embed report option

Then click Edit → File → Embed report → Enable embedding → Embed Code

Change Width to 1920, Height to 1080 (best resolution for Digital Signs, you can use 4K if your TV and player support it, it may make the text a bit too small to read).

Then click "Copy to Clipboard"

Data Studio Embed Report dialog showing the iframe embed code with width 1920 and height 1080

Now you are ready to put this Embed Code to OptiSigns and display on your digital signs.

4) Put the dashboard into OptiSigns and display on your screens

First, you will need to have your screens set up and paired. For more information on how to do that, click here.

Then log on to our portal: http://app.optisigns.com/

Go to Files/Assets, Click on "App"

OptiSigns portal Files/Assets page with arrows pointing to the Files/Assets tab and the Apps button

Click YouTube Dashboard app

Screenshot of OptiSigns Digital Signage Software portal highlighting the YouTube Dashboard digital signage app

Enter a name for your assets & paste the Embed Code copied from Looker Studio here.

You can also set refresh interval so OptiSigns will refresh the dashboard for you.

OptiSigns YouTube Dashboard app form with arrows pointing to the Name, Embed Code and Update interval fields

Then click Save.

Your YouTube Dashboard for Looker Studio asset is created in OptiSigns and ready to be assigned to your screen.

Screenshot of OptiSigns Digital Signage Software portal showing YouTube dashboard app created

That's it!

You have created a Looker Studio Dashboard that connected to your live Google Analytics Dashboard, and you have put it in OptiSigns.

You can assign the newly created wall to your screen by going to Screens, click Edit screens and assign the wall to screens that you want.

You can put the created Looker Studio dashboard in a Playlist, Schedule too.

Ready to get started?

If you are not using OptiSigns yet, you can sign up now for a free 14-day trial with full Pro Plus features.

Frequently Asked Questions