Bitrix24Care

Blend data sources in Google Data Studio reports

In Google Data 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 Data Studio.

Go to the Data sources section in Google Data 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.
This helped
Thanks :)
Optional:
Article feedback
This didn't help
Sorry :(
Could you please tell us why:
Article feedback
I still have questions