The Historical Pipeline Movement Between Stages table displays, for each stage, the beginning pipeline for the analysis period, changes to pipeline, and ending pipeline. You can also drill down on a stage to view the same information for the individual opportunities that contributed pipeline amounts for that stage. |
In this topic |
If the Historical Pipeline Movement Between Stages table is not visible, click the Movement Between Stages tab.
Data Item |
Description |
Beginning pipeline amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities assigned to the stage at the beginning of the first week or month in the analysis period. If you drill down to the opportunity level, this column contains the pipeline amount for the opportunity at the beginning of the first week or month in the analysis period. |
New pipeline amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities that were assigned to the stage when they entered the pipeline during the analysis period. If you drill down to the opportunity level, this column contains the initial pipeline amount for an opportunity that entered the pipeline during the analysis period. Note that if an opportunity moves out the pipeline and then, during the analysis period, is again assigned to a stage that is included in pipeline, the pipeline amount for that opportunity is included as a new pipeline amount. |
Adjustment amount |
At the stage level, this column contains the sum of changes made during the analysis period to pipeline amounts for opportunities assigned to the stage. The changes could be direct changes to the pipeline amounts or, for weighted pipeline, changes to probabilities. If you drill down to the opportunity level, this column contains the net change made during the analysis period to the opportunity's pipeline amount. |
Moved into stage amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities that were moved to the stage from another pipeline stage during the analysis period. If you drill down to the opportunity level, this column contains the pipeline amount for the opportunity when it was moved to the stage from another stage during the analysis period. (A 0 value indicates that the opportunity did not move into the stage during the analysis period.) |
Move out of stage amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities that were moved out of the stage to another pipeline stage during the analysis period. If you drill down to the opportunity level, this column contains the pipeline amount for the opportunity when it was moved out of the stage to another stage during the analysis period. (A 0 value indicates that the opportunity did not move out of the stage to another stage during the analysis period.) |
Moved out of pipeline amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities that moved out of the stage to leave the pipeline during the analysis period. These are opportunities that were moved out of a pipeline stage into a stage not included in the pipeline (won and lost opportunities, for example). If you drill down to the opportunity level, this column contains the pipeline amount for the opportunity when it was moved out of the stage to leave the pipeline during the analysis period. (A 0 value indicates that the opportunity did not move out of the stage to leave the pipeline.) |
Ending pipeline amount |
At the stage level, this column contains the sum of pipeline amounts for opportunities assigned to the stage at the end of the last week or month in the analysis period. If you drill down to the opportunity level, this column contains the pipeline amount for the opportunity at the end of the last week or month in the analysis period. |
For descriptions of the sources of the table data, see Data Sources.
The workflow process added to GovWin Capture Management captures all changes to opportunity stages, probabilities, and pipeline amounts. However, Capture Analytics is an analysis tool, not an audit trail, so complete activity detail is not available through the Historical Pipeline Analytics. In most cases, those analytics reflect the net result of activity for each week or month. Though multiple changes can occur to one of the tracked data items for an opportunity within a single week or month, the analytics only consider the week-ending or month-ending values when displaying historical pipeline data. Those ending values, in turn become the beginning values for the next week or month.
To get a more granular view, go to the Historical Pipeline Change Detail table, which displays pipeline activity by date of change. Even that table, however, does not provide complete detail if the value of a tracked item changes more than once on a given date.
When your firm implements Capture Analytics, it can select two amount fields from opportunity records in GovWin Capture Management to analyze as pipeline. When Capture Analytics stores historical pipeline information, it includes pipeline amounts for each opportunity based on the amounts in each of those fields. As a result, you can use the options under Pipeline Amount to display historical pipeline using amounts from either of those two fields.
The Unweighted and Weighted options under Pipeline Probability Weighting provide the additional option to display either unweighted or weighted historical pipeline amounts. Weighted pipeline amounts are pipeline amounts with the probabilities applied. Capture Analytics calculates the weighted pipeline amount for each opportunity for a given week or month as follows: Historical pipeline amount × (Historical probability ÷ 100).
If your firm has set up grouped stages, use the Detail and Grouped options to view historical pipeline data either for the original GovWin Capture Management opportunity stages (detail stages) or for the grouped stages. When you select the Grouped option, the stage names and amounts in this table change to reflect pipeline amounts for the grouped stages.
To drill down to historical pipeline data for the individual opportunities,
click 
in the Stage
table cell.
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.
You can narrow the focus of this table by selecting a cell in the table:
If you click a cell in the Stage column, the table is filtered to display only rows for that stage.
If you click a cell in the Opportunity column, the table is filtered to display only rows for that opportunity.
If you click an amount cell, the table is filtered to display only that row.
If you focus the table in one of these ways, Capture Analytics applies the same change, as appropriate, to all other analytic objects.
Because this is a pivot table, you cannot change the order of data in the table as you can with most other tables in Costpoint Analytics.
Click 
to send the data underlying
the table to Microsoft Excel. More...
In addition to the actions described above, you can also do the following:
Print the table.
Email the table.
Export table data to a CSV file.
Attach a note to the table.
For more on these actions, see Print, Email, or Export Analytic Data and Attach Notes to Analytics.