ClosePlan Win Rate Analysis - with/without a ClosePlan
This report provides users and managers a detailed understanding of how the Scorecard Score correlates to win rates.
Report Parameters
Custom fields creation: Yes
Report Type: Opportunities or Opportunities with/without ClosePlans
Opportunities Report - Requires the creation of custom fields for Scorecard Score / Sales Methodology (MEDDIC, BANT, etc.) on the opportunity level.
Opportunities with/without ClosePlan - Custom report types have some limitations on which Salesforce fields are available e.g. Fiscal Period. Follow these instructions to create a custom report.
Steps to create the Fields and Report
1. Create custom fields
Field | Object | Data Type | Description |
|---|---|---|---|
Scorecard Category score in %:
| ClosePlan | Percent |
2. Sync Scorecard category fields with the template(s) and versions
How to sync the fields: https://peopleai.atlassian.net/wiki/spaces/TMPDOC/pages/57430081539/Create+custom+and+commonly+used+fields+for+ClosePlan+reporting#Sync-the-fields-with-the-template(s)-and-versions
3. Create the report
Go to the Reports tab and click New Report
Select Report Type “Opportunities” or “Opportunities with/without ClosePlan” -> Continue
For an Opportunities report, the custom fields must be created on the Opportunity Object
Custom report names can vary (as seen below)
Open Outline tab and add fields for Groups and Columns setting, remove any unnecessary fields
Edit Columns to summarize
Click on the column field > select correct function and Apply
Set Sum for Amount / ARR
Set Average for the remaining fields
Set up a Bucket Column using the Scorecard Score %
Update the bucket field to Scorecard Score %
Name the Bucket Column and create the bucket categories as required.
Update the Groups section to include the Bucket Column, Stage, and ClosePlan Count
Add appropriate filters to display the correct data.
Set up Conditional Formatting
Click on the Conditional Formatting button in the bottom right corner of the report -> Add Conditional Formatting Rule
Conditional Formatting is limited to 5 fields
select formatting rules for the Scorecard metrics by setting the lower limit to 0 and the upper limit to 50
Field | Description |
|---|---|
Scorecard Score % | Provides the overall Scorecard Score |
IP % - Identify Pain | Identification of a customer’s pain is essential for determining whether or not an Opportunity exists |
EB % - Economic Buyer | Identifying, meeting, and confirming value with the Economic Buyer drastically increases close rates |
Ch % - Champion | A champion selling your product from within increases your probability of closing a deal |
Ensure ‘Update Preview Automatically’ is enabled
Add Chart then select the ‘Toggle Chart’ button
Select the ‘Chart Properties’ icon to update the chart
Select ‘Stacked Bar’ as the chart type
Choose your bucket column (CP: ClosePlan Count) in the Y-Axis field
Choose record count in the X-Axis field
Choose ‘Stage’ as the Stack By field
Select the ‘Stack to 100%’ checkbox
Choose Bottom for legend position
Disable Detail Rows to show the conditional highlighting in the report
Click on Save & Run button to save and run the report
Provide the Report Name and Folder and then Save
we recommended creating a new folder named “ClosePlan” and saving it there
The completed report will show win rate for opportunities without ClosePlan (CP: ClosePlan Count = 0) and opportunities with ClosePlan (CP: ClosePlan Count = 1)
Result: