How to setup Google Data Studio

1. Navigate to your "Settings"

2. Open your Metrics settings for your Workspace

Open Metrics settings in your Workspace settings

If not yet connected, you will need to connect the Google Sheets integration. This integration is either connected in your "Metrics" settings or your "Integrations" settings.

Since this is related to your workspace, only one user needs to connect it for it to be available for all other users of your workspace. We recommend letting the owner of the workspace to set this up, since the generated Google Sheets will be connected to his/her Google account. The person that will configure it, will need to give access to other users.

Connect Google Sheets inside your settings

Once Google Sheets is enabled, you will be able to have access to the generated sheet with all your raw exported metrics. This file will help you generate all the graphics you might need to visualise your data. If you are starting from scratch, you might need some help to get started. For this reason we provide a Google Data Studio template that you can easily plug onto your Google Sheets.

Here are the steps to copy and setup the Google Studio template:

1. Make a copy of the template

2. Bind each data source to your exported Google Sheets

When selecting a "Data Source" you will need to create a new one, select Google Sheets and select the corresponding Spreadsheet / Worksheet. Once selected, all you need to do is click on "Connect" and then "Add to report".

Reproduce these steps for each data source.

Select your Spreadsheet and worksheet then click on Connect

3. Copy the report

When all data sources are linked, you can safely copy the report and start visualising your data. The Google Data Studio will update automatically.