Data connector

Send Hotmart data to AI, reports, spreadsheets and ETL

Get started for free

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

or sign up with your email

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

Hotmart

E-commerce and Marketplaces Financial and Payments

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.

Connect Hotmart now →

Try out all the features for free for 14 days

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 with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

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.

Connector schema

Available Hotmart data

available pipelines

202

extractable fields

Available integrations

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.

See all available data → Use this connector in chat (AI + MCP) →

Try out all the features for free for 14 days

How to visualize Hotmart data in 3 steps

Connect Hotmart to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

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.

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.

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

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use Hotmart data

Hotmart > AI (Claude, ChatGPT, MCP)

Hotmart > Looker Studio

Hotmart > Power BI

Other visualizations

Hotmart > Amazon S3

Hotmart > BigQuery

Hotmart > Excel

Hotmart > Google Sheets

Hotmart > MySQL

Hotmart > PostgreSQL

Hotmart > Redshift

Hotmart > SQL Server

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

Hotmart > Airtable

Hotmart > Alteryx

Hotmart > Amazon Quicksight

Hotmart > BIMachine

Hotmart > Cortex

Hotmart > Data Studio

Hotmart > Geckoboard

Hotmart > Grafana

Hotmart > IBM Cognos Analytics

Hotmart > Klipfolio

Hotmart > Looker Studio

Hotmart > Looker

Hotmart > Looqbox

Hotmart > Metabase

Hotmart > Microstrategy

Hotmart > Pentaho

Hotmart > Power BI

Hotmart > Qlik Cloud Analytics

Hotmart > Qlik Sense

Hotmart > Qlik

Hotmart > QlikView

Hotmart > Redash

Hotmart > Superset

Hotmart > Tableau

Hotmart > BI TOTVS

Hotmart > Zoho Analytics

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting Hotmart to AI (Claude/ChatGPT via MCP), 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.

Related on Kondado

Try out all the features for free for 14 days