Insights reports: deal progress
The Insights deal progress report will give you the ability to see the deal advancement through stages in the time frame specified, so you can see how well your deals have been progressing through your sales cycle.
To create a deal progress report, go to the Progress tab > Insights, click the plus "+" sign next to the search bar, then Report > Deal > Progress.
The progress report will default to the following filters:
- Date of entering stage is This year
- Pipeline is (your default pipeline)
You can always adjust or add filters according to the data you want to see. The Date of entering stage condition will be locked in since it is the default field needed to assess deal progress.
How is deal progress measured?
If you choose to measure by the number of deals, you will see the number of deals that have entered each stage in the timeframe selected. Other deal progress measures such as deal value and deal weighted value can also be selected. Hovering over each column will show the breakdown of the field you have chosen to segment by.
The entered stage deal count will also include deals that have skipped that stage while moving on to a future stage. For example, if one deal has moved from stage two directly to stage five in the time frame selected, it will show as having entered stages three, four and five.
Insights reporting offers a lot of flexibility in customizing your reports to reflect the data you want to see. The progress report will always show you the stage entered field since it's important to know where your deals advance to, but you can group how you want to view this data in a number of ways.
Measure by (y-axis)
You can choose the field you want to measure your deals by on the left-hand side of the chart.
- Deal value
- Deal weighted value
- Number of deals
- Number of products
- Product value
- Any numerical or monetary custom fields
View by (x-axis)
The View by tab will allow you to group your data by a specific field in your Pipedrive account. You can group by various default Pipedrive fields as well as any custom fields of the following types:
- Single option
- Multiple option
Given that this report measures the progress through the pipeline, the Segment by filter will be locked into Stage entered to show the breakdown by stage. If you choose to view by Stage entered, no segment will be applied.