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.
Renewal Rates and Calculations in Reports
Userlevel 7
+7
<cough> Sorry, can't help the self-promotion http://www.insightsquared.com/packages/saas-reporting/
One thing I've learned from helping customers with this: don't beat yerself up, it's [i]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'.
One thing I've learned from helping customers with this: don't beat yerself up, it's [i]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'.
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.
Reply
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.