I am trying to put a report together on Partner retention rates.
In our system we create renewal Opportunities with the following Partner Roles:
Incumbent Partner - the partner that closed the deal last time
Reseller - could be more than one reseller involved
When an Opportunity is closed won, a Partner Role (Winning Reseller) is added to the Opporunity (this is also reflected in a field - Winning Partner - on the Opportunity)
I need a report to show the retention rates for our partners.
So, if a partner is the incumbent and they close the business, then they have retained the customer.
If the Opportunity is lost or if another partner closes the business, then the incumbent partner has not retained the customer.
I need to work out the % retention rate for the partners, is it possible in SF?
Regards,
David
2 risposte
Hi David,
At my organiztion, we rely heavily in knowing retention rates. I'll elaborate on our use case and hopefully you can apply it to yours.
For my org, one of our retention rates is based on whether a client has met a specific milestone. In one custom field, we have a boolean field for whether they have met the milestone or not. In another custom field, we have a formula fiend with an IF() statement. Basically IF the client has made the milestone, the formula field will be populated with a numerical 1. IF not, then the number 0.
You may be able to get the numerical values with one field, but for bussiness purposes, we have two.
Then in the report, you will create a Custom Summary Formula. You want the format to be a percent and you want that formula field with numerical values to be included in the report. For the formula in the report, you will want the Average of the field calculated at whatever summary levels you need.
This will give you your retention rate. Hope that helps!
