This Report is part of the ClosePlan Managed Package installation and can be found in the 'ClosePlan Package Reports' folder
Overview
The Win Rate Based on ClosePlan Report is used in the ClosePlan ROI Overview Dashboard
Report Parameters
Custom fields creation: No
Report type: Opportunities
Groups, Columns and Filters
Group Rows
ClosePlan Adoption
Stage
Close Date
Columns:
Owner Role
Opportunity Owner
Account Name
Opportunity Name
Fiscal Period
Amount
Expected Revenue
Age
Created Date
Lead Source
Type
Summary Formula Columns
Win Rate (Summary Formula)
Set the following fields to ‘Average’:
Amount
Expected Revenue
Age
Filters
Example Filters:
Filters for the PBO Dashboard
Show Me: All Opportunities
Close Date: All Time
Opportunity Status: Closed Won
Probability: All
Close Date: equals LAST 11 QUARTERS
Filters for the ROI Dashboard
Filtering is very dependent on Org Settings and desired outcome. This Report is often built with widely varying filters and filter logic. Ask your CSM if you have any questions.
Example Filters
Show Me: All Opportunities
Close Date: Current and Previous FY
Opportunity Status: Closed
Probability: All
Type: New Customer
(or as needed according to your Org settings)
Type: equals Existing Customer - Upgrade, Existing Customer - Replacement
(Or as needed according to your Org settings)
CP: Has Deal: greater than 0
Step 2: Add filter logic
Click the down arrow to the right of Filters > Add Filter Logic
Add Formula: Include Rows Matching: 2 AND (1 OR (3 AND 4))
Click Apply
Result:
Another option for filtering:
Chart Properties
Display As: Bar
Chart TItle: As needed
Y-Axis: ClosePlan Adoption
X-Axis: Average Amount
Show Values