Hi,
We have multiple opportunities that can be recurring revenue and need to create a rule to update AAR on the customer tab.
Any advice on how to do so when there are multiple opportunities? Customer's and opportunities have different contract start date so I'm finding it tricky to start with the most recent renewal opportunity and anything that falls after that for the year to be included in ARR.
Any help appreciated!
Question
Help Wanted: Set ARR on customer tab with multiple opportunities
Hi Tony,
Off the top of my head you may want to create a roll-up or formula field on the opportunity that calculates that opportunity's MRR (or ARR depending). From there you could use a bionic rule to calculate all opportunities on an account and update the MRR in GS. Would that work for what you're trying to do? That would get around the multiple start dates.
Alternate question, what are you using to manage and track contract (start and end dates or length)?
Off the top of my head you may want to create a roll-up or formula field on the opportunity that calculates that opportunity's MRR (or ARR depending). From there you could use a bionic rule to calculate all opportunities on an account and update the MRR in GS. Would that work for what you're trying to do? That would get around the multiple start dates.
Alternate question, what are you using to manage and track contract (start and end dates or length)?
Hello wanted to follow up on this - what rollup tool do you use to roll up the opportunities? Rollup Helper? If you use the bionic rule to calculate all open opportunities on an account... I don't understand why you would first need to do a roll up in SFDC (or perhaps I am misunderstanding).
We have the same structure with ARR in our SFDC instance, so I'm trying to figure out the best way t do this.
We have the same structure with ARR in our SFDC instance, so I'm trying to figure out the best way t do this.
Hi Jackie,
This was a couple of months ago, I think I should have just suggested a formula field to calculate the MRR for that opportunity and then possibly a rollup on the account that would pull in the MRR values for all closed renewal opportunities. From there MRR can be extrapolated to ARR (MRR *12).* Bionic rules can be tricky, but I believe they could also accomplish the same tasks in a single BR.
Point of clarification - I'm guessing you meant [i]closed opportunities and not the open ones.
*Contract Value might be calculated differently.
This was a couple of months ago, I think I should have just suggested a formula field to calculate the MRR for that opportunity and then possibly a rollup on the account that would pull in the MRR values for all closed renewal opportunities. From there MRR can be extrapolated to ARR (MRR *12).* Bionic rules can be tricky, but I believe they could also accomplish the same tasks in a single BR.
Point of clarification - I'm guessing you meant [i]closed opportunities and not the open ones.
*Contract Value might be calculated differently.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.