This article explains how various metrics are calculated in the Renewal Center module.
This article explains how Renewal Center calculations are automatically performed in the back end. Summary calculations honor the Global Filters applied and perform calculations only on those Opportunities which match the filter criteria.
Calculation of Metrics
This section explains the calculation method for various metrics used in Gainsight Renewal Center.
- Renewals Due: The dollar value of opportunities available for renewal for the selected time period. Opportunities up for renewal are those that have expired or will expire during the time period. Renewals Due is calculated by adding the Target Amount field of all the opportunities which have their Due Date in the selected quarter. Only those opportunities which have a Booking type as Renewal are selected for calculation.
Renewals Due is the denominator in the calculations for Gross and Net Renewal Rates.
Formula: Renewals Due = Σ (Target Amount of qualifying Opportunities)
- Renewal Forecast: Renewal Forecast = Sum Of(Closed Won + Open Renewals that do not have Upsell + Open Renewals with Upsell - Open Bookings Type Downsell)
To learn about the calculation of this metric, refer to the Forecast section of the Configure renewal Center article.
- Gainsight Forecast: This field is calculated by adding the Gainsight Forecast Amount field of all the renewal opportunities with due dates falling in the forecast period and with their Stage field value set to either Open or Closed Won in the selected quarter. If you are unable to view this section, refer to the Settings section of the Configure Renewal Center article.
- Formula: Gainsight Forecast = Σ (DS Forecast Amount of qualifying Opportunities)
- Gross Renewal Rate (GRR): Gross Renewal Rate is the percentage of opportunities renewed in the period. GRR does not include upsell. It will never be over 100, but the higher the better.
- Formula: GRR = Renewal Forecast / Renewals Due
- Upsell Forecast: Sum of won Opportunity (All upsell + Delta Amount (Final amount - Target Amount) Renewals with Upsell)+ Sum of open Opportunity [Delta Amount (Forecasted amount - Target Amount) Renewals with Upsell + All Upsell)]
- Open Renewals with Downsell: These are the open opportunities that are expected to be won, but not with the targeted amount. The Stage value for these Opportunities is Open and Forecast Amount field has lesser value than the Target Amount field (since some amount of churn is predicted). For these Opportunities, the Forecast Amount is subtracted from the Target Amount (for each qualifying opportunity) and the total difference amount from all the qualifying opportunities is added up to get the value.This value is then added to Open Downsell to get the Forecasted Churn value.
- Open Downsell: Some Companies create a new Opportunity to exclusively track Renewals which are at risk of meeting their Target Amount. The Booking type for these Opportunities is Downsell. The Stage field is set to Open. The Target Amount of all the qualifying opportunities is added to get the required value. This value is then added to Open Renewals with Downsell to get the Forecasted Churn value.
- For instance, if the Target Amount for an Opportunity is $45,000. Consider that a CSM expects that there would be some level of Churn and the Opportunity might be sold for $40000. CSM can now either create a normal opportunity with Target Amount of $45000 and Forecast Amount of $40000 or can create a Downsell Opportunity with Target Amount of $5000.
Net Renewal Rate (NRR): Net Renewal Rate is the rate at which customers are renewing and expanding. It differs from Gross Renewal Rate, which only shows the rate at which customers are renewing and does not take upsells into account. All upsell opportunities with a close date in the selected quarter are considered for calculation. This includes upsells that are associated with renewals in the time period as well as early upsells.
Formula: NRR = [Renewals Due – Churn (both actuals to date and forecasted) + Upsell (both actuals to date and forecasted)] /Renewals Due
Where Forecasted Churn is calculated as in the above case. Forecasted Upsell is calculated as follows.
Forecasted Upsell = (Open Renewals with Upsell + Open upsell)
- Open Renewals with Upsell: These are the open opportunities that are not just expected to be won, but with a higher amount than the targeted amount. The Stage value for these Opportunities is Open and Forecast Amount field has greater value than the Target Amount field (since some amount of upsell is predicted). For these Opportunities, the Target Amount is subtracted from the Forecast Amount (for each qualifying opportunity) and the total difference amount from all the qualifying opportunities is added up to get the value. This value is then added to Open Upsell to get the Forecasted Upsell value.
- Open Upsell: Some Companies create a new Opportunity to exclusively track Renewals with a high probability of exceeding their Target Amount. The Booking type for these Opportunities is Upsell. The Stage field is set to Open. The Target Amount of all the qualifying opportunities is added to get the required value. This value is then added to Open Renewals with Upsell to get the Forecasted Upsell value.
- For instance, if the Target Amount for an Opportunity is $45000. However, if CSM expects that there would be some level of Upsell and the Opportunity might be sold for $48000. CSM can now either create a normal opportunity with Target Amount of $45000 and Forecast Amount of $48000 or can create a Upsell Opportunity with Target Amount of $3000.
- Actuals Won: Total amount of Renewal Opportunities won and the number of companies that contributed to this sum so far in the selected period, based on the Close Date. When an opportunity is closed, the Final Amount field is used to record the amount at which the opportunity was finally closed. Actuals Won calculates the Final Amount for all the Opportunities whose Stage field is set to Closed Won. It also counts the number of Companies that contributed to the sum.
- Actuals Churn: This field calculates the total sum of churn that has occurred in the selected quarter. Churn includes renewals that were completely lost and renewals that were won but below the renewable target amount. Downsells that are created as separate opportunities (mapped accordingly using Opportunity Type) are also accounted for.
Formula: Churn = (Lost renewals + Won Renewals with downsell + Closed Downsell)
- Lost Renewals is the sum of Target Amount from all the Opportunities which experienced total Churn, in the selected quarter (due date is considered for calculation).
- Won Renewals with Downsell is an Opportunity that was closed but with a lesser amount than Target Amount. All the Opportunities whose Final Amount is less than Target Amount and Stage field is set to Closed Won are considered for calculation.
- Closed Downsell is an opportunity that is exclusively created to track Downsell. To avoid double-counting, if a separate downsell opportunity is used, do not also account for the downsell in the original renewal opportunity. The sum of Forecast amount of all such opportunities is considered for the calculation. These are opportunities where the Stage field is set to Closed Won and Booking type is set to Downsell.
- Actual Upsell: This field calculates the total sum of upsell in the selected quarter.
Formula: upsell = (Opportunities won with Upsell + Upsell Opportunities)
- Opportunities Won with Upsell calculates the sum of Final amount of all the Opportunities whose Final Amount is higher than the Target Amount and Stage field is set to Closed Won. The calculation is performed by subtracting the Target Amount from the Final Amount for all the qualifying opportunities and then adding the difference value of all the opportunities.
- Upsell Opportunities is an Opportunity that is created exclusively to track Upsell renewals. The calculation is performed by adding the Final Amount of all the Opportunities whose Booking Type is Upsell and Stage is equal to Closed Won.
- Churn: The Churn pie chart displays the overall churn incurred in the selected quarter and the percentage contribution of various churn types to the overall churn.
In the above image, out of the five churn types, only three types have incurred churn in the current quarter. The overall churn value is displayed in the center of the pie chart.
Data Science (DS) Scores
Gainsight uses a flexible extendable framework that captures disparate aspects of customer health as described below. The major advantage of the score is the 360-degree capture of the various aspects of customer data, that could lead to churn. In the future, we will also take into account the way the opportunity transitions are progressing, to separate out healthy patterns from unhealthy ones.
Gainsight provides you with two fields which are calculated using Data Science:
DS Likelihood Score: This field generates a score based on the success or failure of past renewals (including renewals with upsell and downsell). The score is updated using a technique that learns the pattern of past closed renewals and updates the scores, on a monthly basis. A recursive Bayesian calculation method is used to perform the calculations. The following elements are used for calculations:
- Health Score: Captures the health of a customer as determined by you.
- CS Engagement Score: Captures the effect of customer success activities you implemented for the account. The variables involved in the calculation are:
- Number of success plans
- Number of successfully closed CTAs
- Number of timeline posts
- Number of outreaches
CS Engagement Score is an intermediate score which is not displayed to the customers. It is used as a component in the calculation of the DS Likelihood Score.
- ARR: Captures the fact that high-touch/low-touch and big/small clients are fundamentally different in nature.
- View the Factors Contributing to the DS Likelihood score: Renewal Center also displays the various factors (Gainsight features) which contribute to the DS Likelihood score. You can now get insights about what exactly is driving the Likelihood Score and also understand how much Renewal manager should rely on the score based on a view of what data source supports the score. You can now get information about the aspects of customer health, engagement, and other areas which are impacting the Score.
To view the factors which contributed to the Renewal Likelihood score of an opportunity, you must hover your mouse on the required score. When you hover your mouse on a score, you can view the following:
- Gainsight features contributing to the score
- Level of impact the feature is having on the score (high, medium, low)
- Nature of impact the feature is having on the score (Positive, negative).
From the above image, you can infer that:
- Four Gainsight features Health score, CTAs, Success plans and Outreaches are having an impact on the score.
- Health score and CTAs have a medium impact, Success plans and Outreaches have a low impact on the score.
- Outreaches have a negative impact and rest of the features have a positive impact on the score.
The features contributing to the score and the level of impact of a feature is auto calculated by Data Science. You cannot modify these areas.
- DS Forecast Amount: The DS forecast amount is calculated in an identical manner as DS Likelihood score. However, the historic revenue conversion rates are considered instead of renewal close rates.