Connect Hotmart to Looker: 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
Looker

Visualize Hotmart Data in Looker with Kondado

Visualizing your Hotmart data in Looker is simple with Kondado. You connect your Hotmart account as a data source, select Looker as your destination, and choose which information to replicate. Kondado handles the transfer directly through a Via Kondado connection, which means you do not need intermediate databases, complex scripts, or technical support to start building reports in Looker. Business teams can access subscription trends, commission breakdowns, and student engagement metrics without writing any code, making it easy to turn sales and education data into clear visual insights.

Kondado lets you replicate Hotmart data directly into Looker on a configurable schedule, with update frequencies ranging from every 5 minutes to daily, giving business teams automated access to subscription, sales, and student progress data for 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

With your Hotmart information in Looker, you can combine the Subscribers pipeline with Sales Commissions to see which subscription plans generate the most affiliate revenue. The Hotmart Club: Student Progress pipeline lets operations teams monitor completion rates across courses, while the Sales History pipeline helps marketing teams identify seasonal buying patterns and top-performing products. By bringing these datasets together in Looker, you create unified reports that show the full customer journey, from first purchase to student engagement, helping your team spot growth opportunities and optimize pricing strategies without manual data preparation.

Try out all the features for free for 14 days

Hotmart data available in Looker

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 Looker

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

1
Connect Hotmart as Data Source

Inside Kondado, add Hotmart as a new data source and authenticate with your account credentials to grant access to your sales and subscription information. This makes the eleven available pipelines visible so you can choose exactly what to replicate.

2
Select Looker as Destination

Choose Looker from the destination list and configure your connection settings so Kondado knows where to deliver your replicated Hotmart data. You can also send the same information to Google Sheets or BigQuery if your team uses multiple reporting tools.

3
Build Dashboards and Configure Data Refresh

Open Looker and start building custom reports using your Hotmart Subscribers, Sales History, and Hotmart Club data. Return to Kondado to choose how often your data updates, from every 5 minutes to daily, keeping your reports current automatically.

Access Hotmart data in Looker 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 Looker automatically

How do I set up the Hotmart to Looker connection in Kondado?
Log into Kondado and add Hotmart as a data source by entering your platform login details. Next, choose Looker as the destination and select the pipelines you want to replicate, such as Products or Subscription Transactions. Kondado then prepares your selected information and makes it available in Looker so you can begin creating custom reports right away.
What kind of Looker dashboards can I create using Hotmart data?
You can create reports that monitor student completion rates by combining the Hotmart Club: Modules and Hotmart Club: Student Progress pipelines to see where learners drop off. Sales teams can track purchase trends and seasonal demand by visualizing the Sales History and Subscriber Purchases pipelines together. You can also analyze your product catalog performance using the Products and Sales Price Breakdown pipelines to optimize pricing and inventory decisions.
How frequently does my Hotmart data refresh in Looker?
Inside Kondado, you decide how often your information updates, with options from every 5 minutes up to once per day based on what your team needs. This means your Looker charts and reports stay up to date automatically, whether you are monitoring live launch sales or reviewing weekly subscription trends. Your business users save hours previously spent downloading CSV files and rebuilding spreadsheets.
What KPIs should I track when visualizing Hotmart data in Looker?
Focus on metrics that drive revenue decisions, such as active subscriber count, average commission per transaction, course completion percentage, and repeat purchase rate. By combining the Subscription Transactions pipeline with Subscriber Purchases, you can calculate customer lifetime value and identify your highest-performing digital products. Monitoring these indicators in Looker helps you adjust pricing, refine affiliate strategies, and improve course content based on actual student behavior.
Do I need to build Hotmart dashboards from scratch in Looker?
Yes, Kondado provides the structured data and you design your own Looker views based on your business goals. You can combine any of the eleven available pipelines, such as Subscription Transactions and Hotmart Club: Pages, to create personalized reports that track exactly what matters to your team. This gives you full control over layout, metrics, and filters without being limited by predefined views.
Can I share Hotmart Looker dashboards with my team or clients?
Yes, once your Hotmart data is visualized in Looker, you can distribute reports to team members, stakeholders, or clients through Looker’s built-in sharing and scheduling features. Your colleagues receive updated views automatically as Kondado refreshes the underlying data on your chosen schedule. This makes it simple to keep everyone aligned on subscription growth, sales performance, or student engagement without sending manual spreadsheet attachments.
Can I send Hotmart data to other tools besides Looker?
Yes, Kondado lets you replicate your Hotmart data to multiple destinations beyond Looker, including Power BI, Google Sheets, BigQuery, and PostgreSQL. You can also send information to MySQL, Excel, Redshift, SQL Server, or Amazon S3 for different workflows. This flexibility allows you to maintain consistent metrics across your entire reporting stack.

Try out all the features for free for 14 days