Skip to content
hapily

Creating 3 Valuable MRR Reports with Zaybra

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

Using 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 Zaybra 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: “Zaybra 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 Zaybra 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 A8 Labs. He helps professionals power up their HubSpot experience by supporting the most powerful apps in the HubSpot marketplace.

Latest Articles

Zaybra on HubSpot Pro VS. HubSpot Enterprise

Zaybra on HubSpot Pro VS. HubSpot Enterprise

Zaybra syncs your Stripe with your HubSpot differently depending on if you're using HubSpot Pro or Enterprise. Let's see how!

5 Ways Zaybra Keeps Your HubSpot And Stripe Data Up to Date

5 Ways Zaybra Keeps Your HubSpot And Stripe Data Up to Date

Zaybra can do more than integrate Stripe with HubSpot. It can keep your data up to date and clean! Let's take a look at some of the ways it...

How to Map Stripe Products to HubSpot Using Zaybra

How to Map Stripe Products to HubSpot Using Zaybra

You can map your Stripe products to HubSpot using Zaybra! This will allow you to use our Custom Quote and get sales moving faster. Here's h...