Connect Hotmart to BI TOTVS: Dashboards in Minutes

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

Hotmart
BI TOTVS

Visualize Hotmart Sales Data in BI TOTVS

Connecting your Hotmart account to BI TOTVS allows you to transform raw sales and subscription information into actionable business intelligence without complex technical setup. With Kondado, you can replicate data from your digital product marketplace directly into your TOTVS business intelligence environment without writing a single line of code or managing intermediate databases. This connection helps marketing teams track campaign performance, finance teams monitor commission structures, and operations managers oversee subscription health all in one familiar place.

Kondado connects Hotmart directly to BI TOTVS, replicating 11 data pipelines including Subscribers, Sales Commissions, and Subscription Transactions on a configurable schedule starting at 5-minute intervals.

Setting up this connection takes just minutes through our intuitive interface. Simply select Hotmart as your data source, authenticate your account credentials, and choose BI TOTVS as your destination. Your sales history, student progress from Hotmart Club, and product portfolio data will flow automatically into your reporting environment, keeping your dashboards current and your team aligned with the latest business metrics to support faster decision making.

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

When you combine Hotmart’s digital commerce data with BI TOTVS analytics capabilities, you unlock powerful insights into your online education business and digital product sales. The Subscribers pipeline gives you visibility into active and canceled subscriptions, helping you calculate churn rates and lifetime value, while the Sales Commissions pipeline lets you track exactly how much you are paying affiliates and producers for each transaction. You can also monitor student engagement through the Hotmart Club: Student Progress pipeline to see completion rates across your courses.

This combination enables you to build custom reports that correlate marketing spend with actual subscription revenue, identify your most profitable digital products using the Sales Price Breakdown data, and optimize your course content by analyzing which modules students complete most frequently. Your team gains a complete view of the customer journey from first purchase through educational consumption.

Try out all the features for free for 14 days

Hotmart data available in BI TOTVS

11
available pipelines
202
extractable fields

Available integrations

Integration Description
Subscribers Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions Records of subscription transactions, including fields such as transaction code, product ID, and commission value.
Subscribers
Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions
Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases
Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown
Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History
Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students
Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules
Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress
Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages
Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products
Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions
Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

Try out all the features for free for 14 days

How to create Hotmart dashboards in BI TOTVS

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

1
Connect Your Hotmart Account

Log into Kondado and select Hotmart from the data source catalog, then enter your API credentials to establish the connection. Choose the specific pipelines you need, such as Subscribers or Sales Commissions, to replicate into your environment.

2
Choose BI TOTVS Destination

Select BI TOTVS as your target platform from the available destinations list to route your Hotmart data directly into your business intelligence environment. This creates a direct flow without requiring intermediate databases or complex technical configuration.

3
Configure Updates and Build Reports

Set your preferred update frequency, ranging from 5 minutes to daily, then start building custom dashboards in BI TOTVS using your replicated Hotmart data. You can create visualizations tracking sales performance, subscription metrics, and student progress to support your business decisions.

Access Hotmart 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!

Visualize Hotmart data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Hotmart data in BI TOTVS automatically

How do I connect Hotmart to BI TOTVS using Kondado?
Start by creating a connection to Hotmart in your Kondado account using your API credentials. Then select BI TOTVS as your destination and configure which pipelines you want to replicate, such as Subscribers or Sales History. The entire setup process requires no coding and typically takes less than five minutes to complete.
What types of dashboards can I build with Hotmart data in BI TOTVS?
You can create comprehensive dashboards tracking subscription revenue, affiliate commission performance, and student course completion rates. Many users build reports that monitor churn rates using the Subscribers pipeline alongside marketing campaign data to optimize acquisition costs. You can also visualize Hotmart Club engagement metrics to identify which course content drives the highest student retention.
How frequently can I update my Hotmart data in BI TOTVS?
Kondado offers configurable update schedules ranging from every 5 minutes to daily, depending on your business needs. For sales teams monitoring live launches, 15-minute intervals provide timely insights without overwhelming your system. You can adjust these frequencies anytime as your reporting requirements evolve.
Which KPIs should I track when visualizing Hotmart data?
Focus on metrics like Monthly Recurring Revenue (MRR) from the Subscription Transactions pipeline, commission costs per sale from Sales Commissions, and course completion percentages from Hotmart Club: Student Progress. Tracking subscriber acquisition cost against lifetime value helps you identify your most profitable marketing channels and digital products.
Are there pre-built report templates available for Hotmart and BI TOTVS?
While Kondado does not provide pre-built report templates for this specific combination, the standardized data structure makes it easy to build custom dashboards quickly. You can create reports tailored to your specific product mix and business model, whether you sell courses, ebooks, or software subscriptions. The flexibility allows you to design visualizations that match your exact KPI requirements.
Can I share my Hotmart dashboards with team members who do not have Hotmart access?
Yes, once your data flows into BI TOTVS, you can leverage the platform's native sharing capabilities to distribute reports across your organization. Marketing teams, financial analysts, and course creators can view relevant dashboards without needing direct Hotmart login credentials. This centralizes your digital commerce insights while maintaining appropriate access controls within your BI environment.
Can I send Hotmart data to other tools besides BI TOTVS?
Absolutely, Kondado supports multiple destinations including Power BI, Looker Studio, and Google Sheets. You can replicate the same Hotmart pipelines to different destinations simultaneously to serve various team needs. For example, send detailed transaction data to BigQuery for advanced analysis while keeping summary dashboards in BI TOTVS.

Try out all the features for free for 14 days