Renewal Rates and Calculations in Reports

  • 3
  • Question
  • Updated 9 months ago
  • Acknowledged
Is anybody able to share ideas on how they created Reports showing Renewal Rates for different time periods? And those Renewal Rates would change if i filter on Q1 Renewals, or Q1 + Q2, or Q4 Renewals, or 2016 Renewal Rates? 

I've been creating rules to count the number of Renewal Opps, then load those numbers into an MDA calculated field, & calculate the Renewal Rate in Percentages. But I also want to be able to show Renewal Rates if i were to filter on Renewals that Closed in Q1 or Q2, or closed in 2016 or 2017.
Photo of Johnny Burtchaell

Johnny Burtchaell, Champion

  • 2,506 Points 2k badge 2x thumb
  • like my brain will explode

Posted 9 months ago

  • 3
Photo of Seth

Seth, Employee

  • 14,490 Points 10k badge 2x thumb
<cough> Sorry, can't help the self-promotion

One thing I've learned from helping customers with this: don't beat yerself up, it's hard math. You might be able to steal a technique from NPS-land -- see the comments on Scott Morris' comment here. If each Opp had a score of "1" (won) or "0" (lost), then averaging that field could give you a highly flexible way of reporting on the win rate of your renewals. Not exactly the same as renewal rate, which can be calculated in more complex ways like in our product, but it's somethin'.
Photo of Venkateswara Reddy Kasireddy

Venkateswara Reddy Kasireddy, Product Manager

  • 2,444 Points 2k badge 2x thumb
For the calculated fields, like ratios, to respond to filters,  on the fly formula evaluation should happen in reporting. Formula fields in Reporting is on our roadmap, though ETA is not known yet. Will update here at right time.