From Bitrix24 CRM to BigQuery: managed, scheduled, no code.
Creating a pipeline that sends data from Bitrix24 CRM to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from Bitrix24 CRM to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from Bitrix24 CRM data and combining it with other data in your BigQuery data warehouse
Kondado enables you to replicate data from Bitrix24 CRM to BigQuery without writing code. Configure your Bitrix24 CRM data source once, select from twenty available pipelines including Deals, Contacts, and Leads, and set your preferred update frequency. Your sales, marketing, and support data flows into BigQuery automatically on a schedule you control, whether every five minutes, hourly, or daily.
Once in BigQuery, you can combine Bitrix24 data with information from other sources to build comprehensive analytics models. Create custom reports that track sales velocity across pipeline stages, analyze lead conversion rates by marketing channel, or monitor support ticket resolution times alongside revenue impact. This centralization eliminates manual CSV exports and ensures your reports always reflect current business performance.
Kondado automatically replicates Bitrix24 CRM data to BigQuery on a configurable schedule, offering twenty pipelines with over 450 fields including Deals, Contacts, Leads, and custom fields, enabling advanced analytics and custom reporting without manual exports.
With the Deals: pipeline stages and Deals: stage history pipelines, you can analyze how opportunities progress through your sales funnel and identify specific bottlenecks causing delays between qualification and closure. The Companies and Contacts: companies pipelines enable you to map complex organizational relationships and calculate accurate customer lifetime value across parent and subsidiary entities. By querying these datasets in BigQuery alongside data from Google Sheets or PostgreSQL, you can build sophisticated attribution models that connect marketing spend to actual revenue closed in Bitrix24, creating a unified view of your customer journey from first touch to final contract.
Try out all the features for free for 14 days
Replicated to BigQuery
Bitrix24 CRM data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
20
available pipelines
450
extractable fields
BigQuery
Destination
Available integrations
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.
Sync data automatically — no code, no manual exports.
1
Connect Bitrix24 CRM
Authenticate your Bitrix24 CRM account in Kondado by providing your portal URL and API credentials. Select the specific pipelines you need from the twenty available options including Deals, Contacts, and custom fields.
2
Configure BigQuery Destination
Enter your BigQuery project ID, dataset name, and service account details to establish the destination warehouse. Kondado will automatically create the necessary tables and schema based on your selected Bitrix24 pipelines.
3
Schedule and Activate
Choose your update frequency from five minutes to daily intervals based on your reporting requirements. Activate the pipeline to begin automated replication of your Bitrix24 CRM data to BigQuery.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Answers about sending Bitrix24 CRM data to BigQuery automatically
How do I replicate Bitrix24 CRM custom fields to BigQuery?▼
Kondado includes dedicated pipelines for custom field data across Companies, Contacts, Deals, and Leads. These pipelines capture your specific field configurations and values, allowing you to analyze segmented data and custom categorizations directly in BigQuery alongside standard fields.
What Bitrix24 CRM data can I analyze in BigQuery?▼
You can replicate twenty different pipelines including Deals, Leads, Contacts, Companies, Products, and Activity records. This includes relational data such as Contacts: companies and Deals: products, enabling you to build queries that analyze product performance, company hierarchies, and deal progression through your sales stages.
How often does Bitrix24 CRM data update in BigQuery?▼
Kondado updates your data on a configurable schedule that you control, with options ranging from every five minutes to daily intervals. You select the frequency during setup based on your reporting needs, ensuring your BigQuery datasets remain current without overwhelming your Bitrix24 API limits.
Can I combine Bitrix24 CRM data with other sources in BigQuery?▼
Yes, BigQuery serves as a central warehouse where you can join Bitrix24 sales data with information from other sources you have connected to Kondado. This allows you to create unified reports that correlate CRM activities with marketing campaigns, financial transactions, or operational metrics stored in the same destination.
How is Bitrix24 CRM data structured when it arrives in BigQuery?▼
Each pipeline becomes a separate dataset table with normalized column names corresponding to Bitrix24 field IDs and values. Relational pipelines like Deals: quote products and Contacts: companies maintain foreign key relationships, allowing you to write SQL joins that reconstruct complete customer and transaction histories.
Does Kondado replicate Bitrix24 CRM stage history for funnel analysis?▼
Yes, the Deals: stage history pipeline captures every transition between pipeline stages including timestamps and stage IDs. This enables you to calculate accurate sales cycle durations, identify stalled opportunities, and measure conversion rates between specific stages in your BigQuery analytics.
Can I send Bitrix24 CRM data to visualization tools after BigQuery?▼
Absolutely, once your data resides in BigQuery, you can connect business intelligence tools like Looker Studio, Power BI, or Google Sheets to create interactive dashboards and shareable reports that refresh automatically with your scheduled updates.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
