Docs

Reports and Analytics Articles & FAQ

MRR, customer, Monthy, trend, report

Can I build a report for MRR based on Customer monthly trends?

40823640

2023-06-30T16:56:15Z

2023-07-27T04:03:51Z

82

0

0

260029

Can I build a report for MRR based on Customer monthly trends?

Can I build a report for MRR based on Customer monthly trends? 

This article covers 

Report builder - MRR based on Customer monthly trend

Summary

You might need a report to check the monthly trend of a customer based on MRR, this is currently not available by default. However, you could build it using Report Builder in Chargebee Revenue Story.

Solution

This report displays the MRR trend across customers. To create this report:

  1. Click RevenueStory > Report Builder.

  2. Select Create a Summary Report.

  3. Select “Monthly Subscription History” as your base data source.

  4. In Row grouping, add Customer ID / Company from the Customers data source.

  5. In Column grouping, add MRR Changed Date from Monthly Subscription History and group by Month and Year.

  1. In Summarization (aggregation/measure), add MRR (Monthly) from Monthly Subscription History and aggregate using the Sum function.

  2. Click Build Report.

Related Articles 

Can MRR of a past subscription update be changed?
MRR Calculation in one-time coupons
How to calculate the MRR value for the customers whose subscription change is in the Future?
How is metered billing calculated in MRR?
Why should MRR not be used for GAAP accounting?
What is MRR Retention Cohort?
How to build a custom MRR retention cohort?
How is MRR calculated?
What is included/excluded in the MRR calculation?
What is new MRR?
What is upgrade MRR? How is it calculated?
How are subscriptions moved from free plans to paid plans calculated in MRR
How is reactivation MRR calculated?
How is expansion MRR calculated?
How is Downgrade MRR calculated?
What is Pause MRR and Cancellation/Churn MRR?
What is total MRR by plan in RevenueStory?
What is Cancellation MRR by Plan metric in RevenueStory?
What is Cancellation MRR Rate metric in RevenueStory?
What is Downgrade MRR by Business Type in RevenueStory?
What is Downgrade MRR by Customer Type in RevenueStory?
MRR Distribution by Metered and Non-metered components metric in RevenueStory
What is net MRR growth metric in RevenueStory?
What is Upgrade MRR by Customer Type metric in RevenueStory?
How is total MRR metric in RevenueStory calculated?
MRR per month by customer report
How Limited coupons are calculated for Yearly subscriptions' MRR calculations?
How is MRR calculated if coupons are included along with Flexible MRR?
What is NRR (Net Revenue Retention) and where to check this metric in Revenue Story?
MRR for previous month is considered in current month
MRR for previous month is considered in current month. Why?
Recurring addons are not included in MRR calculations. Why?
Total MRR shows value while Total MRR By Plan is empty
Current MRR VS MRR VS MRR Impact in Report Exports
What is Involuntary Cancellation MRR metric report?
What is Voluntary Cancellation MRR metric report?
Was this article helpful?
Loading…