Data Studio is a powerful and flexible data visualization tool built by Google. You can learn more about it here.
You can use the Insights Tab in Zapp to centralize all of your analytics reporting. We recommend starting with Data Studio and have built a template for you to work with.
This document will walk you through how to utilize the template and set it up.
Note: Please keep in mind the data in the template is based on a QA account we are using, so while the metrics used provide a baseline for what we suggest, the data itself will not be a reflection of what actual production data will look like until you connect it to your account.
- Click the link to our template, which you can find here.
- Open up the template report:
- The numbers you see in the report are likely to be very small as it is simply QA data of a sample account. First thing you’ll need to do is to connect this to your data.
- Go to “Edit”
- Go to File → Report Settings:
- Click on “Data Source” in the configuration panel on the right:
- Click “Create New Data Source” at the bottom right of the screen:
- Click on Google Analytics as your data source:
- When prompted, authorize Data Studio to access your Google Analytics account.
- You will be able to set up the report so that viewers of it will also require access to the same Google Analytics properties in order for the data to populate for them. More on this in step 11.
- Select the correct Account, Property, and View once authorized. This should correspond to how your data is set up in Google Analytics.
- Click “Connect” on the top right of the screen.
- Click “Using Owner’s Credentials:
- Choose an option:
- Keep in mind you’ll be posting this report in Zapp. If you want everyone who has access to your app in Zapp to be able to see this report, leave it as Owner’s Credentials. If you want the report to be limited to those who have access to Zapp AND are added as a user within Google Analytics for the selected property, then select Viewer’s Credentials.
- Rename the Data Source, if you wish:
- And click “Add To Report” in the top right corner:
- Rename the Report however you’d like:
- Customize the header bar:
- Insert your company’s logo into the header
- You can do this by hitting Insert→ Image, creating a box where you want to insert the logo, and then uploading the file.
- You can also change the color of the header bar by simply clicking on it, selecting the image of the paint can, and selecting a new color.
- You can make this header appear on every page of the report by clicking on both the logo and the header and then clicking Arrange → Make report-level:
- The first page includes several valuable KPIs around usage and engagement, such as Sessions, Users, VOD Plays, and Live Plays.
- The second page will show a Top 10 for VOD Items and Shows.
- You need to have Custom Dimensions set up for this page to work. To set up Custom Dimensions, check out the documentation here.
- You will need to have set up “Item Name” and “Show Name” as custom dimensions for the tables on this page to work.
- If you’ve set them up, but named them something else in Google Analytics (i.e. translated to a local language), you’ll need to change the dimension in the table. Do that by clicking on the Dimension in the Table Properties:
- Then click on Custom Variables or Columns:
- Lastly, double click on the Custom Dimension you want to display in the table, however you’ve named it in Google Analytics.
- The remaining pages dive into metrics in more detail and require further customization. On page 3, which provides a deeper dive into video usage, you’ll need to set up the conversion metric:
- At the bottom of page 3, there will be a chart labeled “Configuration Incomplete”. Click it:
- Select the Data tab in the panel on the right:
- In the Metric section, click Invalid Metric:
- Now click Create New Metric:
- Click the blue + button to create a “calculated field”:
- Name the event Conversion Rate and set the formula as Sessions with Event / Sessions:
- Click Create Field:
- Under Type, change it from Number to Percent:
- In the Metric Picker, open Default Group and select Conversion Rate:
- On page 4, multi-select the tables on the right side:
- And then click Invalid Metric on the side panel:
- Again, open Default Group and select Conversion Rate:
- For each widget, scroll down in the panel on the right to the Sort section, and select Conversion Rate as the metric to sort by:
- Now go to the remaining unconfigured widget (in the bottom right of the screen) and replace the metric there with the Conversion Rate metric you created:
- Pages 5 and 6 are the same as 3 and 4, except they focus on Play Channel, an event which tracks LIVE views, instead of VOD. Simply click on any incomplete metric and replace the metric with Conversion Rate, and you’re set.
Now you have a detailed six page report which highlights your usage KPIs, and provides a deeper dive into VOD and LIVE viewing habits.
You can click VIEW to see the results out of edit mode.
Additionally, you can embed this (and any) Data Studio report into Zapp directly. To create an embeddable link:
- Go to File → Embed report
- Change the radio button to “Embed URL”:
- Copy to Clipboard
- Paste into the URL field in the Insights Tab:
- The Insights Tab can be found in the UI Builder. You do not need to be a UI Builder app to use this area of Zapp:
- Click “Add Report” :
- Add the actual report
- Put in the Report Name and paste the Embed URL into the Report URL field. Make sure to leave the “Open in New Tab” field toggled off.
- Click + add report
- You will now be able to see the report embedded in screen:
- You can always reference the “Getting Started” presentation for more info on how this area of Zapp works:
If you want to make this report more customized to your needs or to start building new reports on your own, Google provides several resources to better learn their tool.
First, you can go back to the home page and access their tutorial. To do so, click on the Data Studio icon at any time, and then click on Welcome to Data Studio! :
Additionally, Google provides a series of YouTube videos to teach people more about the tool. You can find that here.