topic Re: Forecast: One off vs recurring revenue in Data Hub

Forecast: One off vs recurring revenue

LWu8 — Thu, 15 Jun 2023 09:12:38 GMT

Hi team,

my revenue can be broken down into one off vs recurring revenue. I would like to break that down and assign different probabilities to both and then also forecast both seperately. How can I set this up?

Thank you

Re: Forecast: One off vs recurring revenue

MiaSrebrnjak — Fri, 16 Jun 2023 10:32:05 GMT

Hi @LWu8,

Thank you for reaching out to the Community!

I wanted to tag in a couple of subject matter experts to see if they have any advice:

Hi @Teun, @johnelmer, @louischausse, do you have any tips for @LWu8? Thank you! ⭐

Cheers
Mia, Community Team

Re: Forecast: One off vs recurring revenue

ArdenM — Fri, 16 Jun 2023 19:52:01 GMT

I'm not sure that this is the most helpful answer, but it sounds like the easiest way to achieve your goal would be to separate out your one-off sales and recurring sales into different deal pipelines, and forecast them separately that way!

Re: Forecast: One off vs recurring revenue

KimM — Fri, 30 Jun 2023 10:10:17 GMT

Hi @LWu8 ,

I would probably tend to agree with @ArdenM here. The hubspot reporting for forecasting is centred around pipeline stage probabilities so separate pipelines make the most sense for a no-code solution.

However, if this is not possible, you could create an alternative version of this with custom code workflows and custom properties if you have operations hub.

You would need to create a workflow that triggers off change in deal stage. Then write some custom code that calculates the 'projected revenue' for each deal that would apply different probabilities depending on whether it's recurring or one-off, which would be stored in a custom property. Then you could report on this custom property.

If you decide to go down this route and need some help writing the custom code let me know.

Re: Forecast: One off vs recurring revenue

ArdenM — Fri, 30 Jun 2023 21:27:13 GMT

Absolutely agree with KimM's points here.

I would stress, however, that you do some very careful consideration before going the custom code route. Custom code in Hubspot can be finnicky, especially if you're not experienced with Javascript or Python, and often requires a fair amount of maintence as your system continues to grow and change.

Additionally, any time you move away from HubSpot's intended functionalities for things, you're going to find doing other things in HubSpot harder and require more customized solutions (which also slowly make it harder to use third party apps). This is not an idle warning - I've done this myself, and it's often a giant pain!

Best of luck with whichever solution you pursue, and don't hesitate to ask any further related questions.