Home » Download this Free Google Data Studio Template for Small Business
Download this Free Google Data Studio Template for Small Business
What’s the best way to view and track your website’s user data? This free Google Data Studio template for small business was designed to measure the major metrics small business owners need to know. Download it and use the instructions below to connect it to Google Analytics & Google Search Console.
Small businesses can use Google Analytics to gain insight into the performance of their websites. The free tool tracks user traffic and can tell business owners how many people visit their website each month, what people do when they enter their website, what traffic channels are bringing people to the site, and so much more.
Google Search Console is another free tool that lets business owners know how their website is performing with users. GSC contains query data (what people queried when they saw your website in Google search), impression data (how many times people saw your website in search results), click data (how many times people clicked on your site in search results), and more.
But what good is all this data if you can’t easily view it?
Google Data Studio is a platform that lets you connect to data trackers like Google Analytics and Google Search Console then create charts based on that data. These charts can show you exactly what you want to know about the performance of your website.
I have built a Google Data Studio Template for small businesses that you are free to download and use.
If you have never used Google Data Studio, here are instructions for using this template and connecting it to your data sources.
THINGS YOU NEED
A Google Analytics account. If you do not have Google Analytics set-up, you can do so by following the instructions found here.
A Google Search Console account. If you do not have Google Search Console set-up, follow the instructions to do so here.
Download the Small Business Google Data Studio Template by clicking the above button. If you have a Gmail account and you are signed into it, it will open in Google Data Studio.
Make a copy of the report by clicking on this symbol in the top right corner. When it prompts you to import data sources, feel free to import them all (it is dummy data) but you will be changing these later.
Working in the copy you just made, click on “Edit” in the top right corner.
Click on “Resource” then “Manage added data sources”
Click “Add a Data Source” then choose Google Analytics
A list of your Google Analytics accounts will appear. Find the account you want to connect, then find the property, then click on the view you want to connect.
Click “Close” on the Data Sources area, then navigate to the first sheet.
Still in Edit mode, click on the Users graph. In the right-side panel, make sure you’re in the Data tab, then click on “Master View” under Data Source (it might say “Unknown” for you). Find the data view you just added, then click on it.
Repeat step 8 for all the charts on pages 1, 2, and 3. Now, all these charts will be connected to your website’s data.
Connect each of the circled charts to your Google Analytics.
Now you need to connect your Google Search Console, which is very much like what you did in steps 4-8. Go to “Resource” then “Manage added data sources”, click “Add a Data Source” then choose Google Search Console. Pick your property, then click “Close” on the Data Sources area.
In the template, navigate to the last sheet. Click on each chart and just like in Step 8, change the data source to your Google Search Console’s data.
Connect each of the circled charts to your Google Search Console.
Click View in the top right corner. Now you will see your charts in an interactive format, be able to toggle the date range, and be able to filter by device category (desktop, mobile, and tablet).
Digital Dynamo provides Google Analytics services and can build you even bigger and better dashboards than the one featured here. If you are interested, please contact us.