Chat with your Hotmart data

AI to analyze Hotmart data with Claude and ChatGPT

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
You
How much commission did I earn from Hotmart sales last month?
Commissions
Your Hotmart commissions totaled R$ 47.850 across 1.247 transactions in the last 30 days.
Via Kondado MCP
You
Which digital product has the highest subscriber retention rate?
Subscriptions
The Advanced Marketing Course shows the highest retention at 89% after six months.
Via Kondado MCP
You
How many students completed Module 3 in Hotmart Club this week?
Hotmart Club
342 students completed Module 3, representing a 23% increase from last week.
Via Kondado MCP
You
What was my total recurring revenue from subscriptions yesterday?
Sales
Your subscription transactions generated R$ 12.340 in recurring revenue yesterday.
Via Kondado MCP
Works in Claude, ChatGPT and any MCP client

AI to analyze Hotmart data with Claude and ChatGPT

Connect your Hotmart data to Claude, ChatGPT, or any MCP client and start asking questions in natural language. Query sales performance, track subscription status, or analyze commission trends without writing SQL or opening spreadsheets. Simply chat with your AI assistant to uncover insights about your digital product business.

Kondado provides an MCP server that exposes 11 data pipelines from Hotmart, enabling direct analytical chat through Claude, ChatGPT, and other MCP-compatible clients. The same replicated data also powers ready reports in Power BI and Looker Studio for visual monitoring.

Marketing analysts can investigate which products drive the most recurring revenue, while e-commerce managers monitor subscriber churn and student engagement in Hotmart Club. Finance teams analyze commission structures and sales price breakdowns across transactions. Operations staff check subscription statuses and student progress metrics instantly through conversational queries.

I prefer ready dashboards

Dashboard templates in Power BI and Looker Studio, connected to your Hotmart data by Kondado in minutes.

View Hotmart dashboards →

I want to ask the AI

Claude, ChatGPT and other MCP clients query your Hotmart data in natural language.

View MCP setup →

The eleven available data pipelines contain detailed records spanning your entire Hotmart operation. Query the Subscribers pipeline to identify active versus canceled subscriptions, or examine Sales Commissions to calculate earnings per transaction and user. Analyze Subscriber Purchases alongside Sales Price Breakdown to understand buying patterns and pricing strategies, while Hotmart Club tables like Student Progress and Modules reveal completion rates and learning engagement. Cross-analyze Products data with Subscription Transactions to correlate specific offerings with recurring billing cycles, or join Sales History with subscriber information to map customer lifetime value across your portfolio. With updates on a configurable schedule, your AI assistant always references the latest transaction records and student activity for accurate responses.

How to connect Hotmart to Claude, ChatGPT and other AI clients

MCP is an open standard. Add the Kondado server to the connections of Claude (Web or Desktop), ChatGPT, or any other MCP client you use, and authorize via OAuth at app.kondado.com.br. Setup through the UI, no code.

Kondado MCP server: https://mcp.kondado.io/mcp
Detailed guide: Claude Detailed guide: ChatGPT
AI vocabulary

Hotmart tables and metrics available via Kondado

Each item below is something Claude, ChatGPT or another MCP client already knows how to query — no schema setup, no manual mapping.

11
Tables
202
Fields
∞
Ad-hoc questions
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.
Full docs on the wiki → Connect Hotmart now →

How to connect and use AI with your data

In 3 steps: connect on Kondado, pick dashboard or chat, analyze.

1
Connect Hotmart on Kondado

Connect Hotmart as a data source at app.kondado.com.br and select a 'Via Kondado destination' so your data lands ready for AI access and report templates.

2
Add MCP server in Claude or ChatGPT

In Claude (Web or Desktop) or ChatGPT, add the Kondado MCP server in the connection settings and authorize once via OAuth. The same simple setup works in both clients with no CLI commands needed.

3
Chat about Hotmart or open reports

Ask questions in natural language about your Hotmart data through chat. For visual recurring monitoring, open a ready Power BI or Looker Studio report template.

Other connectors with AI via MCP

Same Kondado data, in chat through Claude, ChatGPT and other MCP clients.

CRM and Sales

ActiveCampaign ActiveCampaign
Bitrix24 CRM Bitrix24 CRM
Exact Sales Exact Sales
Hubspot Hubspot
Infusionsoft (Keap) Infusionsoft (Keap)
Meetime Meetime
NectarCRM NectarCRM
Pipedrive Pipedrive
PipeRun PipeRun
Ploomes Ploomes
RDStation CRM RDStation CRM
Salesforce Salesforce

Marketing and Automation

Google Ads Google Ads
E-goi E-goi
Google Search Console Google Search Console
Hi Platform Hi Platform
Huggy Huggy
Linkedin Linkedin
MailChimp MailChimp
Mandrill Mandrill
Mautic Mautic
Pushwoosh Pushwoosh
RDStation RDStation
Salesforce Marketing Cloud (Exact Target) Salesforce Marketing Cloud (Exact Target)
SenseData SenseData
Taboola Taboola
Twilio Twilio
WordPress WordPress

Advertising and Media

Apple App Store Apple App Store
Bing Bing
Criteo Criteo
Facebook Facebook
Facebook Ads Facebook Ads
Google Play Store Google Play Store
Instagram Ads Instagram Ads
Meta Ads Meta Ads
Microsoft Ads Microsoft Ads
Microsoft Advertising Microsoft Advertising
Pinterest Ads Pinterest Ads
TikTok Ads TikTok Ads
X Ads X Ads
YouTube YouTube

E-commerce and Marketplaces

Bling! Bling!
Loja Integrada Loja Integrada
Mercado Libre Mercado Libre
Nuvemshop (Tiendanube) Nuvemshop (Tiendanube)
Olist Tiny Olist Tiny
Omie Omie
Pagar.me Pagar.me
Shopify Shopify
Tiny ERP Tiny ERP
Tray Tray
VNDA VNDA
VTEX VTEX
Wake Commerce Wake Commerce

Financial and Payments

ASAAS ASAAS
ContaAzul ContaAzul
Fatura Simples Fatura Simples
Granatum Granatum
Superlogica Superlogica
Sympla Sympla

Support and Customer Service

55pbx 55pbx
api4com api4com
Blip (take) Blip (take)
Clockify Clockify
EADBOX EADBOX
Freshdesk Freshdesk
Movidesk Movidesk
Recruiterbox Recruiterbox
Stilingue Stilingue
Wootric Wootric
Zendesk Zendesk
Zendesk Chat (Zopim) Zendesk Chat (Zopim)

Databases

AWS CloudWatch Metrics AWS CloudWatch Metrics
Azure Table Storage Azure Table Storage
BigQuery BigQuery
InfluxDB v1 InfluxDB v1
MongoDB MongoDB
MySQL (& MariaDB) MySQL (& MariaDB)
Oracle Oracle
PostgreSQL PostgreSQL
SQLServer SQLServer
Webhook Webhook

Productivity and Collaboration

ClickUp ClickUp
Google Sheets Google Sheets
Jira Jira
monday.com monday.com
Notion Notion
Pipefy Pipefy
Tangerino Tangerino
Toggl Toggl
Trello Trello

Social Media

Instagram Instagram
TikTok Organic TikTok Organic

User Analytics

Google Analytics GA4 Google Analytics GA4
Mixpanel Mixpanel
Zeeng Zeeng

Storage and Transfer

Amazon S3 Amazon S3
FTP FTP
Google Cloud Storage Google Cloud Storage
See all AI connectors →

Related on Kondado

Frequently asked questions about AI

How ready dashboards and chat via Claude / ChatGPT work together with your data via Kondado.

What business questions can I ask Claude about my Hotmart sales data? ▼
You can ask about monthly recurring revenue trends, subscriber retention rates, commission splits across affiliates, product performance comparisons, and student completion percentages in Hotmart Club. The AI analyzes your replicated data to answer specific questions like which products had the highest churn last quarter or what is the average commission value per transaction.
How do I connect ChatGPT to analyze Hotmart data through Kondado? ▼
In ChatGPT's connection settings, add the Kondado MCP server and authorize via OAuth at app.kondado.com.br. This one-time authentication grants ChatGPT read-only access to your replicated Hotmart pipelines, allowing immediate natural language querying without technical configuration or coding.
Does the AI update my Hotmart data or execute actions like issuing refunds? ▼
No, the AI provides read-only analytical chat. It cannot modify data, process refunds, change subscription statuses, or execute any actions within Hotmart. The MCP connection only allows querying replicated data for insights and analysis.
How often does the Hotmart data update in my AI chat conversations? ▼
Updates occur on a configurable schedule you set in Kondado, ensuring your AI assistant references near-real-time information. You control the frequency of replication from Hotmart to maintain fresh data for accurate conversational analysis.
What is the difference between asking Claude about Hotmart data and using a Power BI report? ▼
Claude and ChatGPT provide conversational exploration and ad-hoc answers through chat, ideal for investigating specific questions on demand. Power BI and Looker Studio report templates offer visual, recurring monitoring through pre-built reports. Both use the same replicated Hotmart data but serve different analytical needs.
Which Hotmart tables are available for analysis in Claude and ChatGPT? ▼
The MCP server exposes eleven pipelines including Subscribers, Sales Commissions, Subscriber Purchases, Sales History, Hotmart Club Students and Modules, Subscription Transactions, and Products. These cover subscriptions, sales, commissions, and educational content progress.
Do I need coding skills to set up the Hotmart connection for AI analysis? ▼
No coding is required. The setup uses graphical interfaces in both Kondado and your AI client. Simply connect Hotmart as a data source in Kondado, then add the MCP server in Claude or ChatGPT settings and authorize via OAuth.

Try out all the features for free for 14 days