Welcome to part 5 of the Google Data Studio series, where I’m guiding you through connecting your data source to your first report, adding visualizations and making basic styling adjustments.
Google Data Studio Series Index
In part 4, we walked through adding Google Analytics Dimensions and Metrics to your Data Studio tables and charts. We also covered adjusting the table styles and added a report-level footer to all pages. In this post, I’m going to show you how to set up a table that displays traffic by U.S. state.
Set Up a Traffic by State Table
Start by adding a table just as we’ve done in previous posts in this series.
Locate the “Dimension” section in the right sidebar.
Click the “Medium” dimension to display the pop-up list of available dimensions.
Enter “Region” in the search field to filter the list of available dimensions.
Click the “Region” dimension to select it.
In the right sidebar in the “Metric” section, click the “Add metric” button.
Select the options for “Pages / Session” and “Bounce Rate,” using the search field just as we did above. Your list of metrics should look the same as the image below.
At this point, your table should match the table below.
This table shows global data and we’re now going to filter it by states in the U.S. only. In the top menu, click “Resource” and then select “Manage Filters” from the drop-down menu.
In the Filter Manager, click the “Add a Filter” button to create a new filter.
Enter a descriptive name for the filter in the “Name” field. In the below example, I’ve named this filter “US states only”.
In the filter criteria section, click the “Select a field” drop-down menu.
In the search field, enter “Country” to filter the list of options. Then select “Country” from the list.
To the right of the Country selection, click the “Select a condition” drop-down menu in the filter criteria.
In the drop-down list of conditions, select the “In” option.
In the value field, enter “United States” since we’re only going to display states within the United States.
Click the blue “Save” button in the lower right corner to save the filter.
Now that the filter has been created, it’s time to add it to the table that we set up above. With the table selected, click in the right sidebar and use your tab key to locate the “Filter” section as shown below.
Click the “Add a Filter” button.
In the Filter picker, click the filter we previously created.
The report will refresh and the table will now show only U.S. states in the Region column.
Finally, it’s a good idea to adjust the styling of the table to make it more visually appealing. Including your brand-standard color scheme and fonts will help the report shine.
In part 6 of this series, I’ll walk you through adding a second Google Analytics Dimension to your report so that you can work with pivot tables to help view data from different perspectives.
Connector: Connectors are software components that enable communications between your data and Data Studio. Connectors exist for many services such as Google Analytics, Facebook, YouTube and MailChimp. Some connectors are free, while others require a one-time license or subscription purchase.
Data Set: A data set is the information that will be displayed in the report. An example of a data set is the information contained in the rows and columns of an Excel spreadsheet.
Data Source: A data source is created by the connector and enables you to select the fields and options through the connector that will be used to create the Data Studio Report. A data source also provides a secure way to share reports and collaborate with other people.
Dimensions: Dimensions are attributes of your data. For example, the dimension City indicates the city, for example, “Paris” or “New York”, from which a session originates. The dimension Page indicates the URL of a page that is viewed.
Metrics: Metrics are quantitative measurements. The metric Sessions is the total number of sessions or visits. The metric Pages/Session is the average number of pages viewed per session.
Reports: Reports are the visualizations you’ve created, which are like workbooks in Excel. Reports can have multiple pages, while displaying data from multiple sources.
Explorer: This option gives you a way to experiment with changes to a report without modifying the report itself. It’s a great way to safely add, remove or change tables, charts and other visualizations.