How to Track Real Subscription Metrics on Hotmart

If you sell subscriptions on Hotmart, you've likely felt the frustration: the dashboard shows sales, commissions, and refunds. But when you need to know your real churn, how much your MRR is growing, or your subscribers' LTV, the panel goes silent.

Hotmart was built as a sales platform, not an analytics tool. This creates a dangerous blind spot for anyone running a recurring revenue business.

What the Hotmart Dashboard Shows

Let’s acknowledge what Hotmart does well. The native dashboard offers:

• Total sales for the selected period
• Number of transactions (approved, canceled, refunded)
• Affiliate commissions paid
• Subscriber reports with status (active, canceled, overdue)
• Available balance for withdrawal

For an infopreneur selling one-off courses, this might be enough. But for those with a recurring business — communities, monthly mentorships, content clubs — this information is just the beginning.

What Hotmart Doesn’t Show (And You Need)

MRR (Monthly Recurring Revenue)

Hotmart shows total sales for the period but doesn't separate one-time sales from recurring ones. If you sold $30,000 in a month — with $18,000 from subscription renewals and $12,000 from one-time course sales — the panel just shows $30,000. You don't know your real MRR.

Churn Rate

Hotmart lists canceled subscribers but doesn't calculate the cancellation rate. You see that 47 people canceled, but you have to open a spreadsheet to find out that this represents 9.4% of your 500-subscriber base. You also need to differentiate voluntary cancellations from payment failures.

LTV (Lifetime Value)

There is no LTV calculation in Hotmart. To know how much a customer is worth over time, you would have to export every subscriber's history, calculate the average tenure, and multiply it by the ticket price. With 200 subscribers, this takes hours. With 2,000, it’s impractical.

NRR (Net Revenue Retention)

The concept of NRR doesn't even exist in the Hotmart vocabulary. If subscribers upgraded or downgraded their plans, it appears as separate transactions without consolidation.

Segmented Churn

You can't tell if cancellations are concentrated in the first month (onboarding problem), after 3 months (content problem), or if they are evenly distributed. This information completely changes your retention strategy.

The Spreadsheet Method: It Works, But Has Limits

Many infopreneurs bypass Hotmart’s limitations with spreadsheets. The process is:

1. Export the transaction report from Hotmart
2. Filter by type (subscription, renewal, cancellation)
3. Calculate MRR by summing active renewals
4. Count cancellations and divide by the base for churn
5. Cross-reference data to calculate LTV

Does it work? Yes, for those with time and patience. But it has serious problems:

Data lag: You only update it when you sit down to do the spreadsheet. Until then, you might be losing subscribers without noticing.

Human error: One wrong formula, one swapped column, and all the numbers are distorted. I’ve seen infopreneurs making investment decisions based on incorrectly calculated MRR.

Doesn't scale: With 100 subscribers, it takes 30 minutes. With 500, it takes 2 hours. With 2,000, a whole day. And it needs to be redone every month.

No visual history: Spreadsheets don't show visual trends easily. You need to create charts manually to see if MRR is going up or down over 6 months.

3 Numbers Every Hotmart Seller Should Know

Before any sophisticated dashboard, make sure you know at least these 3 numbers:

1. Your Real MRR (Excluding One-Time Sales)

Take last month’s transaction report. Filter only for approved subscription renewals. Sum the values. This is your gross MRR.

Example: 380 renewals of $97 = $36,860 MRR.

Now deduct the Hotmart fee (typically 9.9% + $1 per transaction for the most common plan): Net MRR of approximately $32,830.

2. Your Monthly Churn

Divide the number of cancellations in the month by the total active subscribers at the start of the month.

Example: 42 cancellations ÷ 380 subscribers = 11% churn.

3. Your Average Tenure

If your monthly churn is 11%, the average tenure is approximately 1 ÷ 0.11 = 9 months.

With these 3 numbers, you already know more about your business than 90% of infopreneurs.

The Alternative: A Dashboard Connected to Hotmart

Instead of manually exporting spreadsheets, there is another approach: connecting Hotmart to an analytics dashboard that calculates everything automatically.

Groware integrates directly with the Hotmart API and processes all transactions in real-time. The result is a dashboard that shows:

• MRR broken down by components (new, expansion, contraction, churn)
• Churn rate segmented by subscriber lifecycle
• LTV by plan and acquisition channel
• NRR with monthly trends
• Net revenue after platform fees

The integration takes less than 2 minutes. You authorize access via API, and Groware pulls the complete transaction history. In minutes, you have a dashboard with all the metrics Hotmart doesn't show you.

When You Need These Metrics

If you are in any of these situations, you need urgent visibility:

• Selling more but not growing: Segmented MRR will show if churn is neutralizing new sales.
• Investing in traffic without knowing the real return: LTV by channel will reveal if the investment makes sense.
• Feeling like many people are canceling: Segmented churn will show exactly when and why cancellations happen.
• Thinking about creating new plans: Expansion MRR and NRR data will show if upgrades work for your audience.

Conclusion

Hotmart is excellent at what it does: processing payments and delivering content. But to manage a recurring business, you need metrics it doesn't offer.

Don't settle for knowing only how much you sold. Know how much you are retaining, what each customer is worth, and if your business is truly growing. These answers are in your data — you just need the right tool to reveal them.