Pipedrive's Insights Deal Duration Report shows the average time of your sales cycle. This information makes it easier for your team to see where your sales are slowing down, allowing you to make improvements to speed up your sales process.
To create a deal duration report, click on the plus '+' sign beside Reports in the sidebar and then select Deal > Deal Duration.
The duration report generated will have the following filter conditions by default. However, you can always adjust the filters to reflect the data you want to see.
It is recommended to view results by won or lost deals, but you can also add open deals to your filter conditions.
Average time spent in your sales cycle
You will see the average amount of time it takes for a deal to go through your sales cycle at the top of the report. This number is calculated by dividing the total amount of time your deals have spent in all stages by the total number of deals generated by your filter.
The columns in the report will reflect the breakdown of your average sales cycle by days according to what you have selected to view by in the X-axis. The report will default to Stage entered.
By hovering over a column in the graph, you will see the number of deals that contributed to the average time in each stage.
At the bottom of the page, you also have a table containing a breakdown of the deals displayed in the report along with the information from their respective fields.
The deals you see in your reports can be adjusted in the filtering section at the top of the report. You can edit the existing filter, or select Add condition to add more criteria.
In your report, the View by option (X-axis) will have Stage entered selected by default, but you can choose to view your report by various default Pipedrive fields as well as any custom fields of the following types: