Google Data Studio Guide

ultimate google data studio guide

Many marketers aren’t aware that there is actually a powerful reporting tool for marketers that is free and created by Google. It allows you to connect a plethora of data sources to compile in one nice and neat report.

Google Data Studio can allow you to connect and build reports from data sources like Google Analytics, Google Search Console, YouTube and a plethora of other sources that we will go over in the Data Sources section.

In this guide, we are going to learn what Google Data Studio is, what it can do for you and how to use it to create awesome reports.

What is Google Data Studio?

According to Google:

Data Studio turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports. Use the drag and drop report editor to:

  • Tell your data story with charts, including line, bar, and pie charts, geo maps, area and bubble graphs, paginated data tables, pivot tables, and more.
  • Make your reports interactive with viewer filters and date range controls. The data control turns any report into a flexible template report that anyone can use to see their own data.
  • Include links and clickable images to create product catalogs, video libraries, and other hyperlinked content.
  • Annotate and brand your reports with text and images.
  • Apply styles and color themes that make your data stories works of data visualization art.

SEO & PPC Reports for Clients

Save hours every day by automating your SEO, PPC, Keyword and Facebook Ads reports right to your client's email daily, weekly or monthly.

FREE TRIAL

With Data Studio, you can build beautiful marketing reports for clients, employees, executives and even yourself!

Google Data Studio Pricing

.A big question that many marketers ask is, “How much is Google Data Studio?”.

It’s such a powerful tool that most marketers think that it costs money, but it’s actually comptelely free.

Google offers Data Studio to marketers for no charge because it gets more people using their products like Google Analytics, Google Search Console, and YouTube.

You can sign up for Google Data Studio for free here.

Google Data Studio Connectors

Currently, Google Data Studio features 17 Google Connectors and ~177 Partner Connectors. You can add any one of the below integrations to pull in and combine data from these sources.

google data studio connectors

Here are the 17 Google Connectors you can use to pull data for reports:

  • Google Analytics
  • Google Ads
  • Google Sheets
  • BigQuery
  • File Upload
  • Campaign Manager
  • Cloud Spanner
  • Cloud SQL
  • Display & Video 360
  • Extract Data
  • Google Ads manager 360
  • Google Cloud Storage
  • MySQL
  • PostgreSQL
  • SearchAds 350
  • Search Console
  • YouTube Analytics

We can’t list all of the integrations here as there are too many but here are some of the more popular partner data connectors:

  • Adroll
  • Adobe Analytics
  • Adstage
  • Amazon Ads
  • Amazon Seller
  • Asana
  • Bing Ads
  • CallRail
  • Constant Contact
  • Criteo
  • Salesforce
  • eBay Seller Central
  • Facebook Ads
  • Mailchimp
  • PayPal
  • QuickBooks

For the entire list of data sources view their list here.

Using Google Data Studio

So now that you are familiar with what Google Data Studio is and what data you can connect to it, let’s do a walkthrough tutorial on how to set up a Google Data Studio Report.

To make your first report, head to Google Data Studio and click the Create button. Choose Report to start a template from scratch.

data studio create report

You will be directed to your blank report where we will need to add some data sources to pull data from.

Let’s say we want to create an SEO Report to send to our clients.

Click the ‘Create New Data Source’ in the right navigation pane. Choose the data source you want to add to the report. For our SEO Report, let’s add Google Analytics and Search Console.

First, choose analytics to connect your Google Analytics account.

google analytics connector

Now choose which account you want to add to pull data from. Make sure its the correct Account, Property & View.

choose integrations google data studio

Click connect and then confirm that you are adding this data to your report.

add data connector

Next, we will need to add our Google Search Console data from the same domain property so we can pull in that data and connect it to our report.

To add another source, select Resource->Manage added data sources.

add more data sources

Click add new data source like we did before and then select the Search Console connector to pull in all the data.

search console data source google data studio

Find your URL that corresponds to the property we connected to Google Analytics and then choose Site Impression and click Connect to connect Google Search Console.

connect search console

Confirm the connection and you have now connected two data sources to the report. Now, let’s start building our report with the data that we connected.

First, give your report a name by clicking in the report name and choosing a descriptive report name.

google data studio update report name

Now lets choose a theme for our report in the right window pane under the Theme & Layout options.

choose theme for data studio

You can also create your own theme/colors by selecting the ‘Customize’ button and adding your own color and layout settings.

Now that the theme is set, we can start adding widgets for our SEO Report.

All of the elements, graphs, and data that you can add can be found in the ‘Insert’ menu in the toolbar. Here are all of the elements you can add:

  • Time series
  • Bar chart
  • Combo chart
  • Pie chart
  • Table
  • Geo map
  • Scorecard
  • Scatter chart
  • Bullet chart
  • Area chart
  • Pivot table
  • Treemap
  • text
  • Image
  • Line
  • Rectangle
  • Circle

Let’ start by adding a simple time series that will show us the organic traffic from the chosen date range from Analytics. Choose Insert Time Series and then click where you want to add the module in your report.

Once the module is on your report, you can click on the module to edit data sources, metrics, dimensions and even the style of the module. You can also see the available fields you can add to the module.

time series chart google data studio

Next, we need to update the module to only show organic pageviews. To do this, you will need to add a segment to only show traffic from organic visitors.

Click the ‘Add a Segment’ link in the right pane of Google Data Studio.

add a segment data studio

In the segment picker, look for the Organic Traffic segment and select it.

organic traffic

Now your time series will only show pageviews from organic sources. Let’s add a title to the module so we know exactly what data is displaying.

Use the square tool and the text tool to drag and drop a header above your module and add a descriptive header text so we know what data is being shown.

data studio line chart

Now apply the same method to build out other modules, graphs, charts, and tables. If you are not into building one from scratch, check out the templates below.

Google Data Studio Templates

Google provides a gallery of about 10 Google Data Studio Templates that you can start from including a few Analytics Reports, Adwords Reports, and YouTube Reports.

data studio marketing templates

If these templates won’t suffice, there are even more templates you can download below or in the gallery.

Overview of Google Analytics

An overview of your Google Analytics data on a widescreen one-page report.

google analytics overview

This Google Analytics report is perfect for a general overview of your Google Analytics. It shows cool maps, tables and bar charts that give an in-depth view of your traffic.

Download template

Google Ads Monitoring Report

This super cool report template shows a treasure trove of data about your Google Ads Campaign.

Google Ads Monitoring Report

Download template

Facebook Ads KPIs overview

If you are a Facebook Ad Agency and you want to create an amazing report for your clients, then check out this template by M Digital Services.

Facebook Ads KPIs overview

It features spend, CPM, CPC, Impressions and a number of other KPIs to keep a close eye on clients’ success.

Download template

Website & Marketing Performance Report

This amazing marketing report by Aro Digital features a general overview of all marketing aspects of your campaign. You can view site health, sessions, revenue, and even conversion rates.

This Data Studio report template is perfect for e-commerce sites, or SaaS’s generating revenue online.

Download template

SEO & PPC Reports for Clients

Save hours every day by automating your SEO, PPC, Keyword and Facebook Ads reports right to your client's email daily, weekly or monthly.

FREE TRIAL