Bitrix24Care

Blend data sources in Google Looker Studio reports

In Google Looker Studio, you can blend data sources and build reports from different entities, for example, from deals and their custom fields.

Blend data sources

First, create suitable data sources. You can read more information in the article: Transfer entities from CRM to Google Looker Studio.

Go to the Data sources section in Google Looker Studio. You will see the list of all data sources you have created.

Then open the Reports tab and create a Blank Report.

Select your data source and click Add.

Then open the File tab and select Report Settings.

In the settings, set the data source and the date range so that it includes deals for the desired period.

After that, click on the table and on the Blend data option in the Setup tab.

You need to drag and drop the Unique Key field to Metrics.

Then join another table with the desired data source.

Also move the Deal ID field to the parameter field.

Open the Join configuration block. Here you can see how the tables are related.

In the Join conditions block, add Unique key and Deal ID parameters to link the data sources.

After that, add the necessary parameters to the table. For example, the deal name and custom fields.

During the creation of a report in the Setup section an error Invalid indicator may appear. You need to delete the indicator and the report will be generated.

When you're done with the settings, click Save. You'll have a table with the data from deals and custom fields.

Read more about this feature in the Google article: How blends work.
Was this information helpful?
Integration specialist assistance
That's not what I'm looking for
Complicated and incomprehensible text
The information is outdated
It's too short. I need more information
I don't like the way this tool works
Go to Bitrix24
Don't have an account? Create for free