Insights reports: deal duration
Pipedrive’s Insights deal duration report shows the average time it takes a deal to make it through your pipeline.
This information lets your team see where your sales are slowing down, so you can make improvements and speed up your sales process.
To create a deal duration report, go to Insights and click “+“ > Deal > Duration.
The duration report has the following filter conditions by default.
- Deal created > is > this year
- Pipeline > is > [your default pipeline]
- Status > is any of > lost or won
However, you can always adjust the filters to reflect the data you want to see.
Average sales cycle
You’ll 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 reflect the breakdown of your average sales cycle by days according to what you’ve selected to view on the X-axis.
By hovering over a column in the graph, you’ll 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 data you see in your report can be adjusted using two different methods.
You can edit the existing filters or click the ”+“ to add an additional condition.
You can also hover your cursor over a condition and click the trash can icon to remove it.
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:
- Single option
- Multiple option
For example, here the report columns are being viewed by the linked contact person.