Skip to content
Stripe

Creating 3 Valuable MRR Reports with saas•hapily

Learn how to create 3 MRR reports using saas•hapily's reporting capabilities in HubSpot: Current Total MRR, New MRR This Month, and New MRR Last Month.

Using saas•hapily (formerly Zaybra), you can build and view vital reports that quantify metrics like MRR by Persona, Delta Change, Current Totals over Time, Upgrades/Downgrades, Conversions, Customer Lifetime Value, and more.

This guide will explain how to use saas•hapily to build three different MRR reports that reveal valuable insights into your business: Current Total MRR, New MRR This Month, and New MRR Last Month. 

Getting Started with the Reports Builder

Navigate through your HubSpot menu to select the “Reports” page. 

Then click the “Create Report” button in the top right to access the Reports Builder page where you will begin building the reports below.

Current Total MRR, New MRR This Month, or New MRR Last Month 

On the Reports Builder page, create a new report from scratch by choosing the “Single Object” report option at the top.

Choose one object: “saas•hapily Subscriptions”.

Click Next.

In the Data tab, Apply the following properties only: Building Start Date, Started On, MRR, and Subscription Status. 

Select the Visualization tab at the top to access the Chart options. 

Choose the “Summary” chart type. This is indicated by the icon of a circle with a 1 inside. 

Drag and drop the “MRR” property to the “Displaying” section under Configure Summary chart options. This will show an MRR value to the right. 

Click the Filter button above the chart type options. 

Current Total MRR

In the Filter options, Click into the “Object create date/time” filter.

Change this filter to “Started On” in the Date property dropdowns.

Select “is all time” and then click the “Update filter” button.

Click the +Add Filter option and under saas•hapily Subscription properties and search for “Subscription Status”. Select it and choose the “contains exactly” option. 

Then add “active” and “past_due” in the values box here. 

Click Apply filter.

This report now shows your Total Current MRR values.

Name your new report accordingly and click Save. 

New MRR This Month

If you would like to display New MRR This Month only, simply update the “Started On” filter in the Filters options to show “this month so far” instead of “all time”. 

This report now shows your New MRR values for the current month.

Name your new report accordingly and click Save. 

New MRR Last Month

To show data for New MRR Last Month only, confirm the first “Started On” filter  in the Filter Options shows “all time”. Then you will add one extra filter to this report. 

Click the “AND” button to add an additional “Started On” filter that shows “Last Month”. 

Click apply to save the additional filter. 

This report now shows your New MRR values for the prior month.

Name your new report accordingly and click Save. 

 

Jonathan Stevens

Jonathan Stevens

Jonathan is a Product Support Specialist at hapily. He helps professionals power up their HubSpot experience by supporting the most powerful apps in the HubSpot marketplace.

Latest Articles

Simplifying Tax Breakdown for Subscription Services Quotes

Simplifying Tax Breakdown for Subscription Services Quotes

Learn the benefits of providing efficient tax breakdowns in quotes for subscription services. Enhance customer satisfaction and streamline ...

Organize Your SaaS Business: Managing Multiple Stripe Accounts

Organize Your SaaS Business: Managing Multiple Stripe Accounts

Discover why managing multiple Stripe accounts can help SaaS companies organize different services more effectively. Learn how this strateg...

Why Offering Multiple Payment Options Boosts Your Business

Why Offering Multiple Payment Options Boosts Your Business

Learn about different payment methods, their benefits, and how they can expand your customer base. Explore insights on increasing conversio...