- 3 Minutes to read
- DarkLight
Looker Studio
- 3 Minutes to read
- DarkLight
Looker Studio, previously Google Data Studio, is a dashboarding tool for converting data into customizable informative reports and dashboards.
Prerequisites
- You already have a Google account.
- You already created at least one Source.
Creating a New Data Flow to Looker Studio
In Dataddo
Click on Flows at the top of the page and proceed with Create Flow in the top right corner.
Click on Connect Your Data and choose the source you'd like to include in the flow. You can type the source or connector's name into the search bar to find it faster.
DATADDO TIPOnce you select your data source, click on Connect Your Data Destination. Navigate to the Dashboarding Apps tab and select Looker Studio.
Name your flow and check the Data Preview tab to double-check your configuration.
Click on Create Flow.
In Looker Studio
After saving flow in Dataddo, a window with configuration details will appear.
DATADDO TIPIf you need to see the configuration details again, click on the electric plug icon next to your source.
Follow the instruction and click on the Google Data Studio connector link and copy paste the Dataddo API Key.
If you haven't previously used Looker Studio with your account, you might be asked to allow additional permissions. The permissions that will need to be allowed are: email, profile, openid and script.external_request.
All available flows will be automatically populated in the select box, so select the flow that you just created.
Click on Connect in the top right corner.
Click on Save and congratulations, your data has been sent to Looker Studio!
Adding Additional Data Sources to Existing Looker Studio Dashboard
In Dataddo
First create a new data flow (or multiple) with all the new sources that you would like to connect to your Looker Studio dashboard.
In Looker Studio
- In the dashboard edit mode, click on "Resource" in the top navigation bar and select "Manage added data sources".
- Click on "Add a Data source" and in the connector list search and select "Dataddo".
- Select the flow(s) that you want to include and click on "Add".
Give your data sources unique labels in Looker Studio for easier navigation.
Editing 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
- Click on the three dots next to you flow and select Edit.
- Add more sources through data union or blending.
- Check the Data Preview tab to ensure that your flow has been configured correctly.
In Looker Studio
Dataddo is using column name as an identifier, which is why you need to make sure that all metrics and dimensions that are actively used in your dashboard are present in the flow.
- In the dashboard edit mode click on "Resource" in the top navigation bar and select "Manage added data sources".
- Click on "Edit" next to the edited source.
- Click on "Refresh Fields" in the bottom-left corner of the screen. You will see the preview of the changes in the data model.
- Save the changes and proceed to your dashboard.
Limitations and 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 100,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?
- Limit the amount of data.DATADDO TIP
If you have less than 100,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.
- Connect the data to a data warehouse like Google Big Query first, then to Looker Studio.
Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.