Read FAQ
NEW
Bitrix24 Support
Registration and Authentication
How to start
My Profile
Feed
Chats and Calls
Calendar
Bitrix24.Docs
Bitrix24.Drive
Bitrix24.Mail
Workgroups
Tasks and Projects
CRM
CoPilot - AI in Bitrix24
Contact Center
Sales Center
CRM Analytics (beta)
BI Builder
Sales Intelligence
Inventory Management
Marketing
Sites
Online Store (beta)
CRM + Online Store
CRM Store (beta)
Bitrix24.Sign
Company
Knowledge base (beta)
Automation
Workflows
Telephony
Market
Subscription
Settings
Enterprise
Mobile App
Desktop App
General questions
Bitrix24 On-Premise

Bitrix24Care

Combine deals with their stage history in Google Looker Studio

In Google Looker Studio you can create a report that combines the data from both deals and their stage history. This will help you to control how well your employees work with the deals.

Also, you can track how many stages the deals actually went through, the date of the last activity, or how many days they were in progress.


How to add deals and stage history to a table

First, select the corresponding entities and create data sources in Google Looker Studio.

Read more about creating a new data source in the article - Transfer entities from CRM to Google Looker Studio.

Then create a table and blend data from different sources.

Read more about blending data sources in the article - Blend data sources in Google Looker Studio reports.

In our example, we used the following dimensions in the table:

  • Unique key - ID number of the deal.
  • Responsible person - name of the responsible person.
  • Deal name - name of the deal.

Also, we manually added these metrics to see how many stages the deals went through and how many days they were in progress:

  • Number of stages - shows the number of times the deal was moved to another stage. It is calculated from the Unique key from stage history (Table 2).
  • The first change of stage - shows the date when the deal was moved to another stage for the first time. It is calculated using the formula DATE(MIN(Created on)). Created on field comes from the stage history and shows date and time when a deal appears in a specific stage.
  • The last change of stage - shows the date when the deal was moved to another stage for the last time. It is calculated using the formula DATE(MAX(Created on)).
  • Total of days spent in the stages - shows the difference between the first and the last change of stage as a number of days. It is calculated using the formula UNIX_DATE(MAX(Created on)) - UNIX_DATE(MIN(Created on)).
Read more about adding metrics in the article - Time zone in Date/time fields in BI Reports.

In this table you can see that the Deal #1712 was in progress for 21 days and went through 3 different stages. Hence, we conclude that there was a significant delay in processing this deal.

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