Report on time to close opportunities

  • 17 November 2022
  • 1 reply



I’m trying to create a report/insight into how long it is taking opportunites to move through the pipeline. I have created the automation to show the number of days in each stage- but I’m stuck on pulling a report on average time to close. 

1 reply

Userlevel 6
Badge +5

Hi @jtagliaferro, thanks for posting! To clarify, are you looking for the average time from open to close, or the average time an opportunity spent in each stage?

If it’s the average time for each stage, then go ahead and follow the steps in the video below; it walks you through building a report of average days in a stage after you’ve build those workflow automations.

Note: the sounds is not great on that one, so I recommend turning on the captions.


If you need the average days from the day of the Opportunity’s creation all the way to its close, you’ll want to make sure you have a custom field and workflow automation to fill that information in. It sounds like you have automations for filling out the days in a specific stage - this automation is very similar, except it counts the entire lifecycle of the opportunity rather than just one particular stage.


Once you have that set up, follow the same steps in the video below. Except drag and drop the field for Days from Open to Close, rather than the fields for each individual stage.


Let me know if that makes sense!