From Exact Sales to BigQuery: managed, scheduled, no code.
Creating a pipeline that sends data from Exact Sales to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from Exact Sales to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from Exact Sales data and combining it with other data in your BigQuery data warehouse
Kondado provides a direct connection between Exact Sales and BigQuery, enabling you to replicate your sales engagement data without writing code. Simply connect your Exact Sales account, configure your BigQuery destination, and select which pipelines you want to replicate. Kondado handles the data extraction and loading automatically on your chosen schedule, whether you need updates every few minutes or daily batches.
Once your data arrives in BigQuery, you can build custom reports analyzing lead progression, sales rep performance, and opportunity conversion rates. Combine Exact Sales data with other sources to create comprehensive views of your sales funnel and customer journey. The automated replication ensures your analytics reflect the latest interactions and pipeline changes without manual intervention.
Kondado replicates data from Exact Sales to BigQuery automatically on a configurable schedule, offering 17 pipelines including Leads, Calls, and Sales Opportunities with 194 total fields available for analysis.
The Leads pipeline delivers comprehensive prospect information including closing forecast dates and CNPJ data, enabling precise revenue forecasting and territory planning within BigQuery. Combined with the Lead Lifecycle pipeline, you can track how prospects move through origin and destination stages, identifying bottlenecks in your sales funnel.
Sales teams benefit from the Calls and Appointments pipelines, which capture interaction details, sales rep emails, and meeting notes. Analyzing these alongside the Sales Opportunities pipeline, which includes opportunity values and lead associations, allows you to correlate activity volume with deal progression and optimize your engagement strategy.
Try out all the features for free for 14 days
Replicated to BigQuery
Exact Sales data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
17
available pipelines
194
extractable fields
BigQuery
Destination
Available integrations
Appointments
Includes fields such as id, lead_id, and salesrep_email, enabling tracking of scheduled meetings and their notes.
Activities
Contains information about scheduled activities, including id, leadid, and status, facilitating the management of tasks related to leads.
Boxes
Presents data such as id, leadid, and status, allowing management of meetings and their respective notes.
Lead Lifecycle
Includes fields such as lead_id, origin_stage, and destination_stage, tracking the evolution of leads through the funnel.
Lead Stages
Presents information such as id, active, and funnel_id, detailing the different stages a lead can go through.
Leads
Contains data such as id, closing_forecast_date, and cnpj, providing a detailed profile of leads and their status in the funnel.
Discarded Leads
Includes information about leads that have been discarded, with fields such as lead_id and discard_date, allowing analysis of losses.
Leads: Custom Fields
Presents custom fields associated with leads, allowing for more detailed analysis tailored to specific needs.
Leads: Contacts
Includes information about contacts associated with leads, with fields such as contacts_id and email, facilitating communication.
Leads: Pain Points
Presents the main pain points identified in leads, allowing for a more effective approach in sales strategies.
Lead Qualifications
Includes information about the lead such as id, description, and status, allowing for detailed analysis of qualifications and conversion potential.
Calls
Records details of calls made, including id, lead_id, status, and date, facilitating tracking of interactions with leads.
Markets
Provides information about different markets, including id and name, allowing segmentation and analysis of leads by sector.
Sales Opportunities
Contains data on opportunities, including id, lead_id, and value, essential for assessing sales potential and prioritizing leads.
Sources and Sub-sources
Presents information about lead sources, including id and name, helping to understand where leads come from and their effectiveness.
Sales Development Representatives (SDRs)
Includes data on sales development representatives, such as id, name, and email, allowing for management and analysis of sales team performance.
Sales Representatives
Contains information about sales representatives, including id, name, and email, essential for managing the sales team and their interactions with leads.
Sync data automatically — no code, no manual exports.
1
Authenticate Your Exact Sales Account
Enter your Exact Sales API credentials in Kondado to establish a direct connection to your sales engagement data. This grants Kondado read access to the 17 available pipelines containing your leads, calls, and opportunities.
2
Configure BigQuery Destination
Provide your BigQuery project and dataset details where Kondado will load the replicated data. You can specify existing datasets or create new ones to organize your Exact Sales information.
3
Select Pipelines and Schedule
Choose which of the 17 Exact Sales pipelines to replicate and set your preferred update frequency from 5 minutes to daily. Kondado will automatically maintain your selected datasets in BigQuery according to this schedule.
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 Exact Sales data to BigQuery automatically
How does Kondado replicate Exact Sales data to BigQuery?▼
Kondado connects directly to your Exact Sales account using your API credentials to extract data from selected pipelines. The platform then automatically loads this information into your BigQuery dataset on your configured schedule, handling schema mapping and data type conversion without requiring manual intervention.
What Exact Sales pipelines are available in BigQuery?▼
You can replicate 17 different pipelines including Leads, Lead Lifecycle, Calls, Appointments, Sales Opportunities, and Sales Representatives. Each pipeline contains specific fields such as lead IDs, opportunity values, and sales rep emails, providing comprehensive coverage of your sales engagement activities.
How often does Exact Sales data update in BigQuery?▼
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This flexibility allows you to balance data freshness with processing costs based on your specific analytics requirements.
Can I combine Exact Sales data with other sources in BigQuery?▼
Yes, BigQuery serves as a central repository where you can join Exact Sales data with information from marketing or financial systems. This enables comprehensive analysis across your entire business operation using SQL queries or connected visualization tools like Looker Studio and Power BI.
What data format does Exact Sales use when loaded to BigQuery?▼
Data arrives in BigQuery as structured datasets with preserved data types, where each pipeline populates a separate destination containing all 194 available fields. The schema includes standard fields like IDs and timestamps alongside custom fields from your Exact Sales configuration.
Do I need technical skills to set up Exact Sales to BigQuery replication?▼
No coding is required to establish the connection, as Kondado provides a guided interface for authenticating your Exact Sales account and selecting pipelines. Basic familiarity with BigQuery helps for subsequent analysis, but the replication process itself requires only configuration through our web interface.
Can I analyze Exact Sales calls and appointments in BigQuery?▼
Yes, the Calls and Appointments pipelines capture detailed interaction records including status, dates, sales rep assignments, and notes. You can analyze this data to measure activity volumes, response times, and meeting outcomes correlated with opportunity progression.
How do I track lead stage changes from Exact Sales in BigQuery?▼
The Lead Lifecycle pipeline tracks every movement between origin and destination stages, while the Lead Stages pipeline provides the reference data for your funnel definitions. Querying these together in BigQuery reveals conversion rates and time spent at each funnel stage.
'%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)
