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

Modified on: Thu, 27 Jul, 2023 at 9:33 AM

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.

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

  7. Click Build Report.

Related articles and Documentation

Working with reports






Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
×