Looker Studio

Looker Studio, previously Google Data Studio, is a free tool that transforms data into interactive, customizable dashboards and reports, with a range of visualization options and no need for programming. It connects to a variety of data sources, including databases, Google products, flat files, and social media platforms, and offers features for sharing, collaboration, and access control, making data storytelling accessible to individuals, teams, and organizations.

Looker Studio Implementation Cheat Sheet

Using Dataddo direct connection to Looker Studio might not be an optimal solution for all the cases (e.g. when you need to work with large volumes of data with >150K rows per flow or you need to perform complex SQL transformations). Check the table below to find the optimal implementation for your specific case.

Create a New Data Flow to Looker Studio in Dataddo

Connect Your Flow in Looker Studio

1. In Looker Studio, click on the Google Data Studio connector link and insert the Dataddo API Key.
   If you haven't previously used Looker Studio with your account, you might be asked to allow the following additional permissions:

   • email
   • profile
   • openid
   • script.external_request
2. From the list of flows, select the one you want to connect and confirm.

Add Additional Data Sources to an Existing Looker Studio Dashboard

1. In the dashboard edit mode, click on Resource in the top navigation bar and select Manage added data sources.
2. Click on Add a Data source and in the connector list search and select Dataddo.
3. Select the flow(s) that you want to include and click on Add.

Edit Already Added Data Sources

Dataddo allows you to easily modify data sources which have already been connected to Looker Studio (e.g. add or remove the metric or dimension).

In Dataddo

1. Click on the three dots next to you flow and select Edit.
2. Add more sources through data union or blending.
3. Check the Data Preview tab to ensure that your flow has been configured correctly.

In Looker Studio

1. In the dashboard edit mode click on "Resource" in the top navigation bar and select "Manage added data sources".
2. Click on "Edit" next to the edited source.
3. Click on "Refresh Fields" in the bottom-left corner of the screen. You will see the preview of the changes in the data model.
4. Save the changes and proceed to your dashboard.

Troubleshooting

Data Records Limit

When sending your data to Looker Studio, keep in mind that there is a limit of 150,000 rows.

If you try to load more than 150,000 rows, your data in Looker Studio might be incomplete or Looker Studio will operate very slowly. You can check how much data you're sending in Dataddo. Click on the three dots next to your source and select Data Preview, the total number of records is shown in the top left.

What can you do when you have more data?

1. Limit the amount of data: If you have less than 150,000 rows but are still hitting the limit, check your snapshotting settings. It is possible that due to incorrect snapshotting, you are getting duplicates in your dashboard.
2. Connect the data to a data storage like Google Big Query or Google Sheets first, then send the data to Looker Studio.

Select a Specific Date Range

If you're trying to see data for a specific date range, however, all data since connecting your source is shown, please try the following:

1. Set the date_start field as text.
2. Create a new field named e.g. date.
3. Use this funcion:

   TODATE(date_start,"%Y.%m.%d")