Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This Report is part of the ClosePlan Managed Package installation and can be found in the 'ClosePlan Package Reports' folder. Check to see if this Report exists before you do double work!

Overview

The Win Rate - Scorecard Scores Report is used in the ClosePlan ROI Overview Dashboard

...

Report Parameters

Custom fields creation: No

Report typeStandard Report Type: Opportunities with ClosePlans - (Standard Report Type)

Report Name: Win Rate - Scorecard Scores

Save to: ClosePlan Package Reports

Groups, Columns and Filters

...

Group Rows

  • Scorecard Score (Bucket Column, see below)

  • Stage

Columns:

  • Scorecard Score %

  • Owner Role

  • Opportunity Owner

  • Account Name

  • Opportunity Name

  • Fiscal Period

  • Amount

  • Expected Revenue

  • Age

  • Close Date

  • Created Date

  • Lead Source

  • Type

Set the following Fields to Average:

  • Scorecard Score %

  • Amount

  • Expected Revenue

  • Age

Filters

...

Filter as needed.

...

Example filters for the ROI Dashboard:

  • Show Me: All Opportunities

  • Close Date: All Time

  • Opportunity Status: Closed

  • Probability: All

  • Scorecard Score %: greater than 1%

Chart Properties

...

  • Display As: Stacked Bar

  • Chart TItle: As needed

  • Y-Axis: Scorecard Score

  • X-Axis: Record Count

  • Stack By: Stage

  • Stack to: 100%

  • Legend Position: Right

Additional Items

Create the Bucket Column