What is Google Data Studio?
Why Use Google Data Studio?
Google Data Studio Limitations
How to Use Google Data Studio
Google Data Studio: Practical Tips and Tricks
All great marketing teams know how much information is needed in order to conceptualize a campaign strategy — and to make the appropriate pivots when necessary. Collecting all the myriad data sources, combining insights from cross-channel campaigns, and gathering everything in one easy-to-analyze resource can be a huge pain.
This is where Google Data Studio comes in.
Data Studio is a data visualization tool that gathers all those datasets in one convenient dashboard. Using this tool, you can turn dizzying numbers into an informative report using charts, graphs, data tables, and more. Not only does it enable you to collect and make sense of disparate data; it allows you to generate easy-to-read reports for clients and campaign stakeholders.
Initially, GDS was a paid reporting tool called Google Data Studio 360.
Second, and more important, as a Google product it’s designed to integrate with other Google Marketing Platform essentials like Google Analytics, Google Ads, Google Display, and Youtube. It’s also compatible with other Google tools like Sheets and Search Console.
Third, you can use unlimited widgets with Data Studio, unlike Google Analytics that sets a limit of 12 graphs or charts per report.
Fourth, as a widely used tool, Data Studios boasts a rich array of ready-to-use templates. There are pre-made templates for sources like Youtube or Google Analytics, and there are even templates for different industries, such as eCommerce.
Finally, it allows seamless collaboration. As a fully cloud-based platform, it can be accessed using Google docs, or shared on various social media platforms. What’s more, reports are dynamic and fully customizable.
While Data Studio is one of the most popular data visualization tools, it does have some drawbacks to be aware of:
- Google-centric – Since Data Studio is a Google product, it’s designed for use with the GA360 ecosystem. This is great if your data source is Google Analytics or other Google tools, but anything else not Alphabet-owned might require some SQL or ETL tweaking to be integrated.
- Limited data source – Data Studio only allows one data source for every graph, chart or table. If you want to combine multiple data sources, you’ll have to use a third-party tool (suggest at least 2 such tools, like Supermetrics)
- No auto-refresh – In order to view real-time data, you’ll need to install a third-party browser extension.
- Lack of Excel support – As a Google product, it only supports Sheets. This isn’t the biggest problem as you can obviously convert generated reports to CSV for Excel.
- Online only – As a cloud-based tool, it can only be accessed on the Internet, and it was only recently that Google included PDF export support.
Like most Google products, Data Studio is designed to be fast, easy, and intuitive to use. Here’s how to set up an account.
1. Logging in
- Make sure you’re logged on to your Google work account
- Go to datastudio.google.com
- Click on the “Home” tab to see the dashboard
2. Main menu basics
On top, you will see three tabs:
Reports – This is where you can see all of the reports, the Data Studio equivalent of workbooks in Excel.
Data Sources – You can add up to 500+ sources. Popular ones include Ads, Analytics, Search Console, BigQuery, Google Display, and Youtube Analytics.
Explorer – This is a Preview mode, where you can experiment in a sandbox version of the report without modifying the actual report itself.
In the main window meanwhile, you will see the Template Gallery, which a helpful collection of pre-made templates that cover different data sources or industries.
3. Connecting data sources
There are two ways to add data: you can either create a new report, or you can click on “Connect to Data” from the left menu.
When connecting data, Data Studio uses connectors to fetch the data from their original sources. Some of these connectors are for use with other Google products and are therefore free. However, connectors for non-Google platforms may be paid. All these connectors can be viewed at the Connector Gallery. Like the Template Gallery, it contains a trove of Google-created and third-party connectors that allow connections to over 800 data sets.
4. Creating reports
Charts – These are the main elements of a report that display and visualize data.
- To insert a chart, click “Add a chart” from the toolbar.
- You can also create charts by dragging a field from the “Available fields” panel into the report.
- Dragging a text or number will create a table.
- Dragging a date will create a time series.
- Dropping other metrics will generate a scorecard.
- You can try out different chart types by using the chart icons at the top of the panel. This allows you to determine which type of chart best displays the current data set.
Fields – Each chart can be customized and labeled accordingly.
- To add a field, click the chart and choose the “Data” tab.
- Look for the “Available fields” list on the right and drag it into an empty slot.
Other components – Elements like style components, images, videos, Google docs, and external links can be added to the report.
- To add other elements, click on “Insert” from the top menu.
- Use the different toolbars to search for the appropriate element to add.
Interactive elements – You can make charts interactive and allow viewers to drill down into the data or customize ranges such as dates.
- From the toolbar, click “Add a control”.
- Select the appropriate control type for viewers.
- On the right side, use the options to configure settings such as parameters and dimension values.
5. Data blending
You can blend data from multiple sources to create a more cohesive picture of the campaign. By default, charts only use a single data source, but you can blend data from up to 5 different sources.
- To create a chart with blended data, click on the “Data” panel, then Data Source > Blend Data.
- To create a chart with joined data from multiple charts, select the charts, right-click on one, then click “Blend Data”.
For more information on data blending, you can refer to the Data Studio’s data blending tutorial page.
6. Using calculated fields
You can create new metrics to showcase new information that may not be readily apparent from data sources. This can be done using calculated fields, which is a formula that applies to one or more existing fields from your data sources.
Much like Excel formulas, calculated fields can do math, manipulate ranges, or use branching logic to display new metrics.
- To create a calculated field in a data source, click “Add a field” on the top right.
Enter a name for the field, followed by the formula to be used. Then you modify the Type, Aggregation, and Show As options for the new field.
- To create a calculated field in a chart, choose either “Add Dimension” or “Add Metric” on the right, depending on the type of field you’re aiming for.
A full list of the formulae and functions that can be used can be found on the Data Studio help section.
7. Sharing the report
You can invite specific users or Google groups to access the report.
- To share the report, click “Share” on the top right.
- Access permissions – You can choose between Owner (with full editor permission), Can Edit, and Can View (read only).
- Note that a Google account is needed to view or edit reports.
- For recipients without a Google account, you can email a PDF version of the report by setting up an automated email delivery schedule.
- Reports can also be shared on social media networks like Facebook, Linkedin and Twitter, or IM platforms like Slack, simply by pasting the report URL.
- Most connectors have a live connection to the data, which means they get updated in real time. But some use an in-memory cache for better performance, and you may need to adjust
- Whenever you place new objects on the report, they snap-to-grid. To customize their position outside of the grid lines, hold down the shift key while moving the object with your mouse. The grid size can also be changed in the “Report Layout” menu.
- You can create calculated blended fields, which is a combination of data from different sources that can be filtered. Simply select the blended data source, then click Add Metric > Add New Field.
- Use heatmaps to help with the presentation of the data. A heatmap can highlight the top or bottom figures in the table automatically, so you won’t have to manually do it. On the panel, click Style > Heatmap.
- If the table contains dozens of rows resulting in an overly long table, you can use metric sliders to make the table more compact while allowing viewers to set the range on their own. On the panel, click Data > Metric toggle (on or off).
- Use colors to your advantage, either to reflect your brand or draw more attention to critical metrics. Use eye-catching colors for crucial scorecards, median colors for non-critical information, and client or company palettes in the report template. Remember that each and every element is fully customizable!