Dashboards & Reporting

MPalmer6
Contributor

Monthly Recurring Revenue - reporting

Hi All

 

I think I know the answer as just spent a good hour trying to figure this out but really hoping someone has a cheeky work around or a way to manipulate the system. 

 

I have created a replica property under the company information - called Monthly Recurring Revenue for our new department. 

With the aim of being able to see month on month any differences and therefore track the success of the department across the year.

 

So you could for example, say inJuly 2023 our total monthly revenue was £10,000 

Then Decemeber 2023 it was £15,000 so shows the value of the department. 

 

I have been able to create a simple chart from today/table as well. 

MPalmer6_0-1690559829274.png

 

But my issue is, I have no way of being able to filter this by the month, as the value is not able to be assigned to a month. 

I did try adding a new column - that I put in todays date, which did not work as it would only report on that date, so would mean the values only being assigned to that specific month and not recurring. 

 

I can see hubspot have the same field MRR but in the deals section (which does not crossover) but according to my live chat today, this also does not have the ability to track the differences month on month. 

 

My ideal situation was to have a line graph showing the revenue of each product per month. 

 

But currently, I think the only way to do this, is to download the report once a month and then save in Excel and collate the information offline. 

 

Which is fine, but I wanted to check for any other work arounds? 

 

I also need to do the same for Customer life time value! which I have no idea if the system will be able to do. 

 

Any thoughts welcomed! 

 

Kind regards

 

Matt

 

0 Upvotes
4 Replies 4
KFMcCaughey
Member

Monthly Recurring Revenue - reporting

@MPalmer6 we are exploring the same question. Did you find any solution aside from the offline workaround? Where you say "download the report once a month" is that a custom or default report? If default, which report specifically?

 

Many thanks,

 

Kevin

0 Upvotes
MPalmer6
Contributor

Monthly Recurring Revenue - reporting

Hi Kevin

 

Sorry for my delay, I have been on a bit of annual leave.

 

I made a bit of hybrid solution for us. I created a new property section for each set of clients, like the below:

 

MPalmer6_0-1720612775907.png

You can also make it even more efficient by setting up the Monthly Recurring Revenue as a formula, and have that calculate off your Annual Revenue for example (per client) and this will then automatically show that divided by 12 for example, or whatever formula you want. 

 

Then I created my own reports, not any defaults. 

I selected the products I wanted to see, where MMR is known and then if they are a client 

MPalmer6_1-1720612937575.png

Then I run and download this at the end of month and save each month individually and copy across the final figures to a single excel tracker. 

All in all takes about 15 mins each month. 

 

Not sure if that helps but hopefully provides an idea.

Thanks

 

Matt

christopher-RVO
Key Advisor | Diamond Partner
Key Advisor | Diamond Partner

Monthly Recurring Revenue - reporting

@MPalmer6  I would recommend checking out the Recurring Revenue feature in Hubspot.

 

If you manage recurring services and products in HubSpot, you can analyze and track the projected value of a deal amount over time with the revenue analytics report.

 

The revenue analytics tool enables you to track how much revenue you're generating or losing in a specific time range, to better understand the impact of renewals, upgrades, downgrades, and churns on revenue.

 

If this post helped to solve what you were looking for, please mark this as an accepted solution. Happy HubSpotting!


Christopher Barnett - VP of Revenue at Aptitude 8


MPalmer6
Contributor

Monthly Recurring Revenue - reporting

Hi Christopher

 

Thank you for your reply, sadly this does not solve my problem but appreciate the effort. 

 

We have service hub professional and these analytics referenced on the link refer to the top level package. 

 

I am still looking for a workaround

 

Kind regards

 

Matt