Knowledge Base

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.

Creating your deal duration report

To create a deal duration report, go to Insights and click “+“ > Deal > Duration.

Viewing your deal duration report

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.

Report columns

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.

Table view

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.

Customizing your deal duration report

The data you see in your report can be adjusted using two different methods.

Filters

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.

Report columns

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:

• Users
• Date
• Single option
• Multiple option
• Organization
• Person

For example, here the report columns are being viewed by the linked contact person.

Once you’ve finished creating your report, you can add it to your dashboard or share it with your team.