Simplify Your Website & Marketing Insights with Aro’s Data Studio Dashboard

Simplify Your Website & Marketing Insights with Aro’s Data Studio Dashboard

Over the years we’ve found that essentially all marketers & businesses desire to be data-driven. However, many find Google Analytics so daunting that their precious data ends up locked away, unloved and gathering dust. We’re here to make obtaining insights into your data heaps easier. So without any further ado – meet your Google Data Studio dashboard.

Google Data Studio is Google’s free reporting tool that allows you to build awesome dashboards and report on all of your site activity, as well as any marketing you are doing (e.g. AdWords, Facebook, LinkedIn). You can combine a bunch of data sources and build all the charts and graphs your business could possibly ever need.

At Aro, we love using GDS for our clients and thought others might like in on the action. That’s why we’re giving away our Google data studio template for free for anyone to use. Our only ask is that if you’re loving it, give this a share.

To start off, we’ve put together a 4-page report, and we think is better than any other data studio template we’ve seen (happy to be proven wrong on this one if you’ve found better).

The Best Google Data Studio Template in the world
A lil’ taste of the data studio dashboard

Get the dashboard


We’re going to continue to improve this data studio template for other marketers and entrepreneurs, so if you have any thoughts on what you’d like to see included – let us know!

Setting up your data studio dashboard

1. Prerequisites

If you want the full power of the reporting you’ll also need:

  • A Search Console account connected to the same Google account
  • Demographic data turned on in your Google Analytics account
  • Be tracking goals/conversions or transactions in Google Analytics
  • An active AdWords account with campaigns running

Let’s Get Started

2. Make a copy and add Google Analytics data

Now you’ve got all of these sorted, it’s time to connect your Analytics account to the data studio template.

  1. Make a copy of the Template
  2. Hit the dropdown menu for the first box, click ‘Create New Data Source’
  3. Give Data Studios access to your data (not shown in video below)
  4. Go to the Google Analytics row
  5. Pick your GA account & view
  6. Hit connect (top right)
  7. Wait a couple of seconds for ‘Using Owners Credentials’ to Disappear
  8. Then click add to report (top right)

 

3. Add Search Console data

It’s the exact same process as adding Google Analytics for adding Search Console – however, you’ll adding ‘Site Impression’ not ‘URL Impression’

4. Add AdWords data 

You should be getting good at this by now – it’s the same process for chucking AdWords in – just make sure to select the correct AdWords account.

Using the dashboard

The report’s actually incredibly easy to use. We’ve added datechannel grouping, country and age filters along the top of the report.

Clicking these allows you to change the data of the report, allowing for a more in-depth analysis of your data.

Just to note, you may have metrics that you wish to report on that aren’t included in this template, or you’re looking for something that focuses on a different channel. If that’s the case you can hit us up directly for help.

 

Pro tip: For the Channel Grouping, Country or Age filters, click the “only” button to save de-selecting every option.

 

What’s Each Page For?

Each page exists to give you insights into an individual metric set. Below is a little video we’ve put together of the different uses of each page.

And here’s a more in-depth breakdown of the pages and questions they can help answer.

Overview

Top level understanding of the visitors and transactions on your site, and how this has changed over time.

  • How many people have visited my site?
  • How many sales did we receive?
  • When were the big spikes in sales?
  • How is my site performing in terms of site health? (e.g. avg. page load time)
  • What proportion of my traffic is coming from mobile?
  • What devices are people converting on?

Transaction Overview

Diving into transactions to break down what’s driving sales & revenue.

  • Traffic Sources – What channel is most traffic coming from?
  • Facebook Performance – What content are users highly engaged with?
  • Adwords Performance –  What products are users purchasing due to Adwords?
  • Organic Visits – Are our organic visits increasing? What city are they coming from?
  • Keyword Rankings – What’s our CTR on Google? What’s our average position for each keyword?

AdWords Overview

Providing a more detailed breakdown of paid search campaign performance.

  • Traffic – How much traffic to the site is being driven by paid search campaigns?
  • Conversion Performance – How much sales revenue are we generating through paid search campaigns
  • Share of Voice – What proportion of my ads are being served in comparison to total available impressions? Where am I losing out?
  • Campaign Performance – What campaigns are my top performing campaigns?
  • Search Queries – What are the search queries that are driving the most traffic to the site?

Search Console Overview

Understanding how the site is performing in Google Search.

  • Overview – How many times did users see and click on our results?
  • Search Terms – What search terms drove visits? What was the click-through rate of those search terms?
  • Search Volume – How has clicks and impressions changed over time?
  • Demographics – Where have clicks arrived from?
  • Device – What device did clicks come from?

Quick note: In the template, we’ve used the Google Merchandise Store data for the Google Analytics and Search Console data, and old Google Adwords account (not optimised at all) for the Adwords data.

We hope this dashboard is helpful to some of you out there, if you’re loving it, feel free to share the love in your favourite digital marketing group!

We’re super keen to continue to improve this, so if you have any suggestions feel free to leave a comment below!

5 thoughts on “Simplify Your Website & Marketing Insights with Aro’s Data Studio Dashboard

  • Shane

    • 6 February 2018 at 12:35 am
    • Reply

    There is no autorefresh feature in GDS, so the dashboards are out of date as soon as they are loaded.

    • Tim Dorrian

      • 7 February 2018 at 5:12 pm
      • Reply

      Great point Shane – however there’s auto refresh and auto pagination Google Chrome addon for it, so the data stays up to date. You can check it out here. Hope that helps!

  • Michael Watson

    • 4 May 2018 at 11:59 am
    • Reply

    Hi Aro,

    We’ve just started using this dashboard for our tertiary course comparison site. First of all, what a beautifully designed dashboard and secondly, what a powerful business tool! This is definitely much easier for us to use than Google Analytics, it reminds me more of something like Microsoft’s Power BI!

    Question, what would be the best way to link in social channels here too like our Facebook campaigns?

    Thanks again for sharing this awesome tool!

    • Saad

      • 28 August 2018 at 9:40 pm
      • Reply

      Hi Michael,

      I guess Aro didn’t notice your comment. In case you still didn’t have an answer, there is supermetrics, a tool which helps you connect Data Studio to your different Social Media accounts. However, the free version of supermetrics allows limited possibilities. Check this out : https://supermetrics.com/pricing/data-studio

      Saad

    • Tim Dorrian

      • 31 August 2018 at 10:41 am
      • Reply

      Hi Michael, sorry just read this. Thanks! We certainly love the dashboards for our business & clients.

      As Saad said below, for pulling social info through to dashboards we use Supermetrics. Definitely worth the price tag for us.

      Thanks!
      Tim

What are your thoughts?

*
*