Win Rate Detail Table

The Win Rate Detail table, by default, displays the lost opportunities that are included in the win rate calculation for the win rate analysis period. You can use the Cycle icon in the Win Status column to switch the table contents to the won opportunities

For each opportunity, the table displays its status (Win or Loss), the month and year in which its win rate analysis date falls, and its pipeline amount.

 

In this topic

Display the Table

Table Data

Won Opportunities and Lost Opportunities

Win Rate Analysis Date and Analysis Period

Pipeline Amounts

Maximize the Table

Sort the Table

Send the Table Data to Excel

Other Table Actions

Display the Table

If the Win Rate Detail table is not visible, click the Detail tab for the win rate analytics.

Table Data

Data Item

Description

Month and year

The month and year in which the opportunity's win rate analysis date falls.

For example, if you use the awarded date as the win rate analysis date, this column displays the month and year in which each opportunity's awarded date falls.

Amount

The unweighted pipeline amount for each lost or won opportunity, depending on which you are viewing.

For descriptions of the sources of the table data, see Data Sources.

Win Rate Analysis Date and Analysis Period

As part of the Costpoint Analytics configuration process, your system administrator specifies the date field from opportunity records in GovWin Capture Management that Costpoint Analytics uses to build the calendar for the win rate portion of the Bid and Win Rate Analytics. That calendar is used to determine which opportunities to include in the win rate calculations when you use the calendar bar to select an analysis period.

For example, your firm could use the opportunity awarded date. When you use the year options above the Win Rate Trended chart to specify an analysis period for win rates, Costpoint Analytics includes all won and lost opportunities with an awarded date that falls within that year.

The win rate analysis date can be, and often is, different than the bid rate analysis date. If the two date fields are the same, however, the analysis period you select for the win rate analytics is automatically applied to the bid rate analytics as well.

Won Opportunities and Lost Opportunities

As part of the Costpoint Analytics configuration process, your system administrator specifies how Costpoint Analytics is to determine which opportunities are won and lost opportunities for the purpose of calculating your firm's win rates. That determination can be based on stage, on a user-defined field from the Opportunity table in GovWin Capture Management, or on a combination of the two.

For more information, see Bid and Win Rate Settings.

Pipeline Amounts

When your firm implements Capture Analytics, it can select two amount fields from opportunity records in GovWin Capture Management to analyze as pipeline. The options under Pipeline Amount enable you to display win rates calculated using amounts from either of those two fields.

The amount displayed in Amount for an opportunity in the Win Rate Detail table is the amount from that field in the opportunity record in GovWin Capture Management.

Pipeline amounts used to calculate win rates are unweighted amounts.

Maximize the Table

Click to display the table at its maximum size so you can read it and interact with it more easily. Click to restore the table to its original size and location on the tab.

Sort the Table

To sort the table based on the values in one of the columns, double-click the column heading for that column.

To change the sort order from ascending to descending or from descending to ascending, double-click the column heading of the current sort column.

Send the Table Data to Excel

Click to send the data underlying the table to Microsoft Excel. More...

Other Table Actions

In addition to the actions described above, you can also do the following:

For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.