Send Hotmart data to reports, spreadsheets and ETL

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

shape Hotmart

Connect Hotmart Data to Dashboards and Databases

Unlock the full potential of your digital product business by extracting comprehensive Hotmart data into your preferred analytics environment. Access detailed subscription records including subscriber codes, status changes, and cancellation patterns alongside granular sales commission breakdowns tied to individual transactions. Replicate complete Hotmart Club learning analytics covering student progress through course modules, page-level engagement metrics, and completion percentages. Pull product catalogs with pricing details and historical sales transactions to build a complete view of your marketplace performance across all touchpoints.

Kondado’s direct Hotmart data source offers 11 distinct pipelines encompassing 202 total fields, covering everything from subscriber management and sales commissions to Hotmart Club student progress and subscription transactions.

The Kondado platform takes care of refreshing Hotmart data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing Hotmart data in your report, spreadsheet, data warehouse, data lake, or database

Marketing teams can analyze subscriber acquisition patterns and churn rates using the Subscribers and Subscription Transactions pipelines to optimize campaign ROI and lifetime value calculations. Data analysts benefit from cross-referencing Sales Commissions with Sales Price Breakdown data to calculate true net profitability per product and identify high-performing affiliates. Operations teams monitor Hotmart Club student engagement through Modules and Pages data to improve course completion rates, while finance departments track Subscriber Purchases against commission payouts to reconcile revenue recognition and manage cash flow forecasting with precision.

Available Hotmart Pipelines

The available Hotmart pipelines capture every dimension of your digital business operations. The Subscribers pipeline reveals retention trends and lifecycle stages, while Sales Commissions tracks affiliate performance and payout accuracy. Hotmart Club: Student Progress shows completion rates across course modules, and Products data enables portfolio analysis across your entire catalog. Subscription Transactions provides the financial backbone for recurring revenue analysis. By joining Subscriber Purchases with Sales Price Breakdown, you identify which pricing tiers drive the most value, while correlating Hotmart Club: Pages access data with subscriber status reveals content engagement’s impact on retention. Configure automated updates to run every five minutes or daily, ensuring your KPI dashboards reflect current subscription counts, recent commission accruals, and up-to-the-hour sales performance without manual data pulls.

Try out all the features for free for 14 days

Available Hotmart data

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 visualize Hotmart data in 3 steps

Connect Hotmart to dashboards, spreadsheets, or databases — no code required.

1
Add Hotmart as a data source

Log into Kondado and add Hotmart as a new data source using your API credentials to establish the connection.

2
Select pipelines and destination

Choose from 11 available pipelines including Subscribers, Sales Commissions, and Hotmart Club data, then select where to send them such as Power BI, Google Sheets, or BigQuery.

3
Analyze data in dashboards, sheets, and databases

Build executive dashboards in Power BI or Looker Studio, explore metrics in Google Sheets or Excel, and query structured data in BigQuery, PostgreSQL, MySQL, or Redshift.

Try out all the features for free for 14 days

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

Pick a Spreadsheet, Database, Data Warehouse or Data Lake to receive Hotmart data

Choose a tool to visualize your Hotmart data

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

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Hotmart to dashboards, spreadsheets, and databases

What specific Hotmart data can I extract using Kondado?
You can replicate 11 distinct pipelines including Subscribers (with codes, names, and status), Sales Commissions (transaction details and values), Hotmart Club analytics (student progress, module completion, page access counts), Products catalog data, and Subscription Transactions. This covers both your marketplace sales operations and online course delivery metrics.
How do I connect my Hotmart account to Kondado?
Add Hotmart as a data source in your Kondado account and authenticate using your Hotmart API credentials. The setup requires no coding: simply select the pipelines you need from the 11 available options, choose your destination such as BigQuery or PostgreSQL, and configure your update schedule.
How often does Kondado update Hotmart data?
Kondado updates Hotmart data on a configurable schedule ranging from every five minutes to daily, depending on your business needs. This automated refresh capability supports monitoring subscription sign-ups, tracking commission accruals, or maintaining daily financial reconciliation without manual exports.
Can I combine Hotmart data with other business data sources?
Yes, by sending Hotmart data to databases like PostgreSQL or BigQuery, you can join subscription records with advertising spend from Facebook Ads or customer support tickets from Zendesk. This enables analyses like correlating course completion rates with acquisition channels or refund patterns with support interactions.
What analytics can I build with Hotmart Club data?
Using the Hotmart Club pipelines (Students, Modules, Student Progress, and Pages), you can build learning analytics dashboards tracking module completion percentages, student engagement by content page, and course abandonment points. These insights help instructional designers optimize content sequencing and identify at-risk students for intervention campaigns.
Which BI tools work with Kondado's Hotmart data source?
Kondado sends Hotmart data to Power BI, Looker Studio, Google Sheets, BigQuery, PostgreSQL, MySQL, Excel, Redshift, SQL Server, and Amazon S3. This flexibility allows you to use existing tools whether you need executive dashboards, ad-hoc spreadsheet analysis, or data warehouse reporting.
How can I analyze Hotmart subscription revenue trends?
Combine the Subscription Transactions pipeline with Subscribers data to calculate monthly recurring revenue (MRR), churn rates, and lifetime value (LTV) trends. Join this with Sales Commissions to net out affiliate costs and determine true profitability per subscription tier, enabling data-driven pricing decisions for your digital products.

Try out all the features for free for 14 days