Google Data Studio 360: How to get Facebook, Bing & Twitter data in 3 minutes

Think Google Data Studio 360 only supports Google Analytics and AdWords? Think twice!

Google recently released a really cool dashboarding tool called Google Data Studio, which lets you easily gather all of your marketing data into one place and build great-looking, interactive dashboards (see for example this web analytics dashboard). It’s a major step forward from the old Google Analytics dashboards, and a game changer for PPC marketers. There’s a free version called Google Data Studio, which lets you create up to five reports, and a paid version called Google Data Studio 360, which is part of the Google Analytics 360 Suite (formerly Google Analytics Premium).

Google Data Studio has built-in connectors to a few Google data sources (Google Analytics, AdWords, YouTube, BigQuery, Attribution 360). Today, expanding PPC campaigns beyond AdWords is mandatory to stay competitive, and most marketers actively use other PPC channels such as Facebook Ads, Bing Ads and Twitter Ads. These non-Google channels are not supported by Data Studio. But no worries, Supermetrics has a solution for you!

Supermetrics empowers Google Data Studio to its full potential. With the Supermetrics Google Sheets add-on, you can easily add many more sources to Google Data Studio, including Bing, Facebook, Twitter, MailChimp, SEMrush, Moz and even Adobe SiteCatalyst. Just follow these steps (also outlined in the video above):

1. Create a new Google Sheet

2. If you don’t have the Supermetrics add-on, install it from the menu bar Add-ons: Get add-ons, or using this link.

3. Launch Supermetrics and run a query for the data you want.

Screen Shot 2016-05-25 at 12.47.23

4. Launch Data Studio

5. Go to DATA SOURCES and click the plus button in the lower-right corner

Screen Shot 2016-05-25 at 12.53.02

6. From connectors, select Google Sheets and the file you just created, click CONNECT

Screen Shot 2016-05-25 at 12.57.05

7. Next, Google shows you a list of fields imported from Google Sheets. Click CREATE REPORT, and in the next window, ADD TO REPORT.

8. You now have a blank report where you can start working with the data. Try adding a table or a chart.

Screen Shot 2016-05-25 at 12.59.59

9. In Google Sheets, you can set the Supermetrics queries to refresh automatically every day, so your Data Studio report will always have the latest data. Go to Add-ons: Supermetrics: Schedule refresh & emailing.

Screen Shot 2016-05-25 at 13.39.37

 

You can add multiple Google Sheets connectors to the same Data Studio report, to fetch data from different sources or with different metrics & dimensions. 

As you see, Supermetrics and Google Data Studio are a great combo! In the future, we hope to integrate more deeply with Data Studio, so you wouldn’t even need to have Google Sheets in between.

We hope you found this tutorial handy. If so, please tweet it!

 

 

  • Mathieu Tremblay

    Hi, I’m currently using Supermetrics to pull data from Facebook and I’m looking for a way to display the most recent number of Facebook fans on Google Data Studio.

    The metric “Fans” can be aggregated with COUNT, UNIQUE COUNT, SUM, AVERAGE, MAX, MIN. I’d be looking for LAST.

    That way, I’d be able to display the latest number of fans while also being able to set a Score Card to compare with previous month.

    Any tips on how this can be done? Perhaps I’m not using the right reasoning for this.

    Many thanks in advance!

    Mathieu

    • Mikael Thuneberg

      Approved.