HubSpot Ideas


Calculate time to close....



I want to do some analysis on how long it takes deals to close.  Clearly, I have access to "create date" for a deal and I know when it moves to "closed won."   I can create a report, export it to excel and run a DATEDIF formula to calculate days to close.   Can I do this within Hubspot so I don't have to do all the manual reporting?   If not, this would be a great thing to have from a sales mgt and sales rep perspective.


Thanks for any advice.


18 Replies
HubSpot Employee

Hi @jbarrow this functionality is not yet available in the tool.  Great suggestion though. Can you add this as a post to our ideas forum for further comment?


Thank you,

Ed Justen


Any updates on this request? 

HubSpot Employee

If this was added to the Ideas Forum, any update would be noted there.




There is now a deal property "Days to Close" which can be used for this. You can now create reports about the minimum, average and max days it takes for a deal to be closed.


Thanks for the note....when I search for 'days to close' on deal properties nothing comes up.  Is it called something else?   Thanks for your help!   Joe

I'm not sure if the property is listed in the properties, but at least it was available in the new report builder when I was adding a report/widget to one of our dashboards today.

One step further than this would be the ability to report on the average number of days to close for deals that are "Closed/Won" versus those that are "Closed/Lost."


There's a huge difference in the insight gained through that distinction. I want to inform finance what the average sales cycle is for deals we win to help drive headcount/budget planning discussions.


It would also be helpful to report on the last deal stage prior to a deal moving to "Closed/Lost." What stage are my deals going off the rails? How can I train/enable my team to overcome the hurdles at that deal stage?


It seems that the Days to close field is not based on the history of the closed deals. This simply calculates the days left based on Close Date for future deals. 


Any update here @edjusten 


Here's the solution I came up with:


  • Create a calculated property that measures time between create date and close date (I called this property "Time to close")
  • Create a custom report using a KPI style report
    • Add the "Time to close" property as your value
    • Change your aggregation from Sum to Average

And... Ta-da! You could easily add a filter to this report to show average time to close by rep or by product/service 


👍Thanks for the suggestion, I will check that out!

HubSpot Product Team

Building off of @MDonelan 's post, we're currently trying to report on the time it takes to go from our "Assessment Call Complete" Deal Stage (meaning their first call with Sales) to "Closed Won." And on the other side, "Assessment Call Complete" to "Closed Lost." 


Since BDRs create most deals in the pipeline and don't pass it off to technical sales consultants until the sales call is booked, time to close doesn't give us the data we're looking for (we want to focus on the time to close once handed to our technical sales consultants). The Closed Won vs Closed Lost distinction is also important. 


So generally, the request would be to be able to track "Average Time to Closed Won" from a specific Deal Stage, and "Average Time to Closed Lost" from a specific Deal Stage. 

Contributor | Platinum Partner

@torysher, we had a similar situation with one of our clients. I created date fields for each of the date stages then through a workflow time stamped them when the stage was updated. You would have to still export to excel to calculate the number of days between the close date and the date the deal moved to the specific stage.


I'm struggling with the same issue. This is also linked to other thread and suggestions on calculating Deal Velocity across deal stages. It will be very helpful to have this feature.


Yes!!!! Time to close is a standard sales metric and I'm surprised that HubSpot doesn't support it. 


Any update here?

Contributor | Elite Partner

Hey everyone!


For those who are still looking for a way to calculate how long it takes for a deal to close, I might have a solution that goes an extra step. I'm part of Aptitude 8's product team (A8 Labs) and we're currently in Beta for a new SLA Tool called Timerman SLA. This app allows you to assign SLA Policies to both tickets and deals via workflows. It also tracks time in each stage down to the minute and lets you create reports/dashboards within HubSpot!


We're releasing the app to beta users so shoot me a message if you'd like to learn more!