/
ClosePlan Opportunity Coverage Report

ClosePlan Opportunity Coverage Report

Overview

This report provides Users and Managers a view of Opportunities using a Peoplel.ai ClosePlan and those that are not. Each Org is different, so some adjustments to these instructions may be necessary to create a usable and informative Report.

image-20240715-142008.png

Report Parameters

Custom fields creation: No

Custom report type creation: No

  • Report type: Opportunities (Standard Report Type)

Create Report

  • Go to the Reports tab and click New Report

Select Report Type

  1. Select “Opportunities” > Continue

Add Fields

  1. remove any unnecessary fields

Group by:

  • Opportunity Owner

  • Account Name

Columns:

  • Opportunity Name

  • Stage

  • Close Date

  • CP: Has Deal

 

Add Summary Formula Fields

 

a. Summary Formula: % with ClosePlan:

Column Name: % with ClosePlan

Description: % of Opportunities with ClosePlan

Type: Percent

Decimal Points: 0

Formula: Opportunity.TSPC__CPDealCount__c:SUM/RowCount

Click Validate to ensure the formula is valid > Apply

b. Summary Formula Field: % without ClosePlan

Column Name: % without ClosePlan

Description: % of Opportunities without ClosePlan

Type: Percent

Decimal Points: 0

Formula: 1-(Opportunity.TSPC__CPDealCount__c:SUM/RowCount)

Click Validate to ensure the formula is valid > Apply

 

Result:

Save & Run: ClosePlan Opportunity Coverage

 

 

Add Chart

Click on ‘Add Chart’ in the top right of the Report

 

Type: Bar

Chart Title: Up to you

Y-Axis:

Opportunity Owner

X-Axis:

% with ClosePlan

% without ClosePlan

Legend Position: Bottom

 

Related content

ClosePlan Opportunity Adoption Report
ClosePlan Opportunity Adoption Report
More like this
Custom and commonly used Fields for ClosePlan Reporting
Custom and commonly used Fields for ClosePlan Reporting
Read with this
Win Rates
More like this
ClosePlan Win Rate Analysis Report
ClosePlan Win Rate Analysis Report
More like this
Reporting Options with ClosePlan Data
Reporting Options with ClosePlan Data
More like this
ClosePlan Forecast Call Report grouped by Fiscal Period
ClosePlan Forecast Call Report grouped by Fiscal Period
More like this