How do I set up Bitrix24 CRM as a data source in Data Studio without coding?

Start by adding Bitrix24 CRM as a data source in your Kondado account using your portal credentials. Once authenticated, select Looker Studio (formerly Data Studio) as your destination and authorize the connection. Your pipelines will appear as available fields within minutes, ready for visualization.

What sales KPIs can I track in Data Studio using Bitrix24 CRM data?

You can monitor deal conversion rates by stage, average deal size, and sales cycle length using Deals and Deals: stage history pipelines, plus lead response times through Activity data. Track win rates across different Bitrix24 CRM pipelines and analyze revenue trends by sales rep or product category using the available fields.

How often does my Bitrix24 CRM data refresh in Data Studio?

Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. You select the frequency during setup based on how current your reports need to be, and the system maintains this schedule automatically to keep your Data Studio dashboards updated.

Can I share Bitrix24 CRM dashboards with my sales team in Data Studio?

Yes, once you build your reports in Data Studio , you can share them with team members through standard Google Workspace sharing permissions. Your colleagues can view the dashboards without needing Kondado access, though they will see data based on the refresh schedule you configured.

Are there pre-built report templates available for Bitrix24 CRM data?

Kondado does not provide pre-built report templates for this source, allowing you complete flexibility to design custom dashboards that match your specific sales processes. You can build visualizations that focus on your unique KPIs using any combination of the 20 available pipelines and 450 fields.

How do I visualize deal progression across multiple sales pipelines?

Use the Deals: pipelines and Deals: pipeline stages pipelines to create funnel visualizations showing how opportunities move through each stage. Combine this with Deals: stage history to see transition dates and identify where deals stall, creating comprehensive views of your sales velocity across different business lines.

Can I combine Bitrix24 CRM data with Google Sheets or BigQuery in Data Studio?

Yes, you can blend your replicated CRM data with other sources within Data Studio , or send Bitrix24 data to Google Sheets and BigQuery through separate Kondado connections. This allows you to create unified reports that combine CRM metrics with financial data or marketing analytics from other platforms.

Connect Bitrix24 CRM to Data Studio: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Visualize Bitrix24 CRM Data in Data Studio

How to visualize Bitrix24 CRM data in Data Studio? Kondado provides a direct connection that replicates your sales, marketing, and support data automatically. You can connect your Bitrix24 CRM account and start building visual reports in minutes without any technical setup or intermediate databases. The process requires no coding knowledge, making it accessible for business users and marketing teams who need immediate access to their CRM metrics.

Business teams use this connection to track deal progress across multiple pipelines, monitor lead conversion rates throughout the sales funnel, and analyze customer interactions through interactive dashboards. You can combine data from deals, contacts, and companies to create comprehensive views of your sales performance. The platform updates your information on a configurable schedule, ensuring your reports always reflect current business performance without manual data exports.

Kondado connects Bitrix24 CRM to Data Studio via a direct data source that replicates 20 pipelines including Deals, Contacts, and Companies, with updates available every 5 minutes to keep your sales dashboards current.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With your Bitrix24 CRM data flowing into Data Studio, you can build custom dashboards that reveal insights across your entire sales operation. Analyze your Deals pipeline to track revenue progression and identify bottlenecks in your sales stages, or examine Contacts and Companies data to understand client relationships and account health. Marketing teams can monitor Leads conversion rates while support managers track Activity metrics to measure team responsiveness. By combining Deals: stage history with pipeline data, you can visualize how opportunities move through your funnel and identify which stages cause delays, enabling data-driven decisions that accelerate your sales cycle.

Try out all the features for free for 14 days

Bitrix24 CRM data available in Data Studio

available pipelines

450

extractable fields

Available integrations

Integration	Description
Actitivity
Catalogs	Presents information such as Catalog ID, name, and origin IDs, facilitating data organization.
Companies	Contains fields such as Company ID, address, company type, and annual revenue, essential for client management.
Companies: custom fields (data)	Includes custom fields such as Company ID and additional data, allowing for the customization of information.
Contacts	Features fields such as Contact ID, address, created timestamp, and comments, fundamental for relationship management.
Contacts: companies	Links contacts with companies through fields such as Contact ID and Company ID, facilitating data integration.
Contacts: custom fields (data)	Includes custom fields such as Contact ID and additional data, allowing for the adaptation of information.
Deals	Contains information such as Deal ID, value, status, and created timestamp, essential for sales tracking.
Deals: custom fields (data)	Includes custom fields such as Deal ID and additional data, allowing for the customization of sales information.
Deals: custom fields (meta)	Presents metadata of custom fields such as Deal ID and additional information, facilitating sales analysis.
Deals: pipelines	Includes information on pipeline ID, name, and status, allowing for analysis of the business flow.
Deals: pipeline stages	Presents details on stage ID, name, and order, facilitating the tracking of sales progress.
Deals: products	Contains information on product ID, name, and price, allowing for analysis of the product portfolio in deals.
Deals: quotes	Provides data on quote ID, total value, and status, essential for managing commercial proposals.
Deals: quote products	Includes information on product ID, quantity, and unit price, detailing the items included in quotes.
Deals: stage history	Records stage changes, including deal ID, date, and new stage, allowing for analysis of progress.
Leads	Contains information on lead ID, name, status, and creation date, essential for lead management.
Leads: custom fields (data)	Includes custom data associated with the lead, such as ID and specific values, allowing for more precise segmentation.
Leads: products	Provides information on products associated with the lead, including product ID and quantity, facilitating interest analysis.
Products	Includes details on product ID, name, price, and description, essential for managing the product catalog.

Actitivity

Catalogs

Presents information such as Catalog ID, name, and origin IDs, facilitating data organization.

Companies

Contains fields such as Company ID, address, company type, and annual revenue, essential for client management.

Companies: custom fields (data)

Includes custom fields such as Company ID and additional data, allowing for the customization of information.

Contacts

Features fields such as Contact ID, address, created timestamp, and comments, fundamental for relationship management.

Contacts: companies

Links contacts with companies through fields such as Contact ID and Company ID, facilitating data integration.

Contacts: custom fields (data)

Includes custom fields such as Contact ID and additional data, allowing for the adaptation of information.

Deals

Contains information such as Deal ID, value, status, and created timestamp, essential for sales tracking.

Deals: custom fields (data)

Includes custom fields such as Deal ID and additional data, allowing for the customization of sales information.

Deals: custom fields (meta)

Presents metadata of custom fields such as Deal ID and additional information, facilitating sales analysis.

Deals: pipelines

Includes information on pipeline ID, name, and status, allowing for analysis of the business flow.

Deals: pipeline stages

Presents details on stage ID, name, and order, facilitating the tracking of sales progress.

Deals: products

Contains information on product ID, name, and price, allowing for analysis of the product portfolio in deals.

Deals: quotes

Provides data on quote ID, total value, and status, essential for managing commercial proposals.

Deals: quote products

Includes information on product ID, quantity, and unit price, detailing the items included in quotes.

Deals: stage history

Records stage changes, including deal ID, date, and new stage, allowing for analysis of progress.

Leads

Contains information on lead ID, name, status, and creation date, essential for lead management.

Leads: custom fields (data)

Includes custom data associated with the lead, such as ID and specific values, allowing for more precise segmentation.

Leads: products

Provides information on products associated with the lead, including product ID and quantity, facilitating interest analysis.

Products

Includes details on product ID, name, price, and description, essential for managing the product catalog.

See all available data →

Try out all the features for free for 14 days

How to create Bitrix24 CRM dashboards in Data Studio

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Bitrix24 CRM to Kondado

Add Bitrix24 CRM as a data source in Kondado by entering your portal URL and authentication credentials. Select the specific pipelines you want to replicate, such as Deals, Contacts, or Leads.

Choose Data Studio destination

Select Looker Studio (Data Studio) as your destination and authorize Kondado to send data to your Google account. The system creates a direct data source link without requiring any database configuration or technical setup.

Build dashboards and set refresh schedule

Create your custom reports in Data Studio using the replicated fields, then configure your update frequency in Kondado to run every 5 minutes, hourly, or daily based on your business needs.