Get in touch
Status:

Knowledge Base

Insights reports: Duration

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.           

 


Creating your Deal Duration report

To create a deal duration report, click on the plus '+' sign beside Reports in the sidebar and then select Deal > Deal Duration.

duration.gif
 

 


Viewing your Deal Duration report

Note: The deal duration report will always be measured in days.


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. 

  • Deal created is this year 
  • Pipeline is (your default pipeline)
  • Status is any of lost or won 


It is recommended to view results by won or lost deals, but you can also add open deals to your filter conditions.
Default_filter.png


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. 

Screenshot_2020-04-17_at_15.28.33.png


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. 

Screenshot_2020-04-17_at_15.24.09.png


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. 

Screenshot_2020-04-17_at_17.22.27.png

 


Customizing your Deal Duration report 

 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.

Default_filter.png

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 

Screen_Shot_2020-04-21_at_4.20.17_PM.png

To rename or delete your report, open it and click on the three dots '...' before selecting Rename or Delete.

dele.png

Was this article helpful?
2 out of 2 found this helpful

Questions?    Get in touch