Kondado connects Exact Sales (Exact Spotter) directly to BI TOTVS without technical complexity. You can replicate your sales engagement data, lead information, and team activities on a configurable schedule, keeping your reports updated automatically. Business teams gain immediate access to visual analytics that support faster decision-making and improved sales performance.
Kondado provides a direct connection between Exact Sales and BI TOTVS, allowing business users to replicate 17 data endpoints including Leads, Sales Opportunities, and Appointments without coding or intermediate databases.
Marketing and operations teams at SMBs can track lead progression, monitor SDR performance, and analyze conversion funnels directly in BI TOTVS. The platform updates your information every 5 minutes, hourly, or daily based on your business needs, ensuring your dashboards reflect current sales activities.
Each item below is automatically replicated by Kondado from Exact Sales into BI TOTVS — no schema setup, no manual mapping.
17
available pipelines
194
extractable fields
∞
Auto-refresh
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.
With Kondado, you combine data from pipelines such as Lead Lifecycle, Sales Opportunities, and Calls to build comprehensive sales intelligence in BI TOTVS. Track how prospects move through your funnel stages while correlating call outcomes with opportunity values to identify your highest-converting engagement patterns.
Marketing teams can analyze which lead sources generate quality opportunities by connecting Sources and Sub-sources data with Lead Qualifications. Operations managers monitor SDR and Sales Representative performance alongside Appointments scheduled, enabling data-driven coaching and resource allocation decisions that accelerate revenue growth.
Try out all the features for free for 14 days
How to create Exact Sales dashboards in BI TOTVS
Visualize your data automatically — no spreadsheet exports or custom scripts.
1
Connect Exact Sales to Kondado
Log into Kondado and select Exact Sales as your data source. Authenticate your account and choose which sales pipelines to replicate, such as Leads, Calls, or Sales Opportunities.
2
Set BI TOTVS as destination
Choose BI TOTVS as your destination to send the replicated data directly into your analytics environment. The direct connection eliminates the need for intermediate databases or complex technical configuration.
3
Schedule updates and build reports
Configure your preferred refresh frequency from every 5 minutes to daily intervals. Then build custom visualizations in BI TOTVS combining Exact Sales data to track funnel performance, team productivity, and revenue opportunities.
Try out all the features for free for 14 days
Access Exact Sales data in BI TOTVS and combine it with dozens of other data sources
If the source you want is not listed, drop us a chat message. We love to add new sources!
Answers about visualizing Exact Sales data in BI TOTVS automatically
How do I connect Exact Sales to BI TOTVS using Kondado?▼
Start by selecting Exact Sales as your data source in Kondado and authenticate with your account credentials. Then choose BI TOTVS as the destination and select which pipelines to replicate, such as Leads and Sales Opportunities.
What sales metrics can I track in BI TOTVS with Exact Sales data?▼
You can monitor lead conversion rates through the Lead Lifecycle pipeline, track opportunity values and win rates via Sales Opportunities, and measure team productivity using the Calls and Appointments endpoints. These metrics help identify bottlenecks and optimize your sales engagement strategy.
How frequently does my Exact Sales data refresh in BI TOTVS?▼
You configure the update schedule based on your operational needs, choosing from intervals as frequent as every 5 minutes or extending to daily updates. This automated refresh keeps your reports current without requiring manual data exports or spreadsheet maintenance.
Can I build reports showing SDR performance in BI TOTVS?▼
Yes, using the Sales Development Representatives and Calls pipelines, you can create scorecards showing calls made, appointments scheduled, and leads qualified per SDR. Combine this with Lead Stages data to visualize how effectively your team moves prospects through the funnel.
Is it possible to analyze lead sources and marketing attribution?▼
Absolutely, by connecting the Sources and Sub-sources pipeline with Lead Qualifications and Sales Opportunities data, you can determine which channels deliver the highest quality leads and best conversion rates. This supports budget allocation decisions and marketing strategy optimization.
Do I need IT support to maintain the Exact Sales connection?▼
No, once configured, the replication runs automatically on your selected schedule without requiring technical maintenance. Business users can modify pipeline selections or adjust refresh frequencies directly through Kondado's interface without coding knowledge.
Can I share Exact Sales dashboards with executives who don't use Exact Spotter?▼
Yes, BI TOTVS allows you to distribute reports to stakeholders across your organization, providing view-only access to sales metrics and performance indicators. This ensures leadership teams stay informed using visual data without needing direct access to the CRM system.
'%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)