Help Wanted: Set ARR on customer tab with multiple opportunities

  • 2
  • Question
  • Updated 5 months ago
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!
Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb

Posted 7 months ago

  • 2
Photo of Brandon

Brandon

  • 184 Points 100 badge 2x thumb
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)?
(Edited)
Photo of Jackie Cofield

Jackie Cofield

  • 1,244 Points 1k badge 2x thumb
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. 
Photo of Brandon

Brandon

  • 184 Points 100 badge 2x thumb
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 closed opportunities and not the open ones.

*Contract Value might be calculated differently.