Bitrix24 Helpdesk

Bitrix24 has a new interface. The images in the articles might differ from the current account design. We will update them soon.

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
Get your Bitrix24 set up by local professionals
FIND BITRIX24 PARTNER NEAR ME
implementation_helper_man
Go to Bitrix24
Don't have an account? Create for free
Related articles
Set permissions and send reports to clients in Google Looker Studio Refresh report data in Google Looker Studio Manage calendar and embed report pages from Google Looker Studio Limit access to Google Looker Studio report Monitoring and sending reports to email in Google Looker Studio Blend data on deals and employees in Looker Studio Use product item datasets in leads and deals Transfer entities from CRM to Google Looker Studio Connect Google Looker Studio Filter deals by date in Google Looker Studio