Calculate time to close....

Highlighted
Regular Contributor

Hi,

 

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.


Joe 

8 Replies 8
HubSpot Moderator

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


Did my post help answer your query? Help the Community by marking it as a solution
Reply
0 Upvotes
New Contributor

Any updates on this request? 

HubSpot Moderator

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

 

Ed


Did my post help answer your query? Help the Community by marking it as a solution
Occasional Contributor

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.

Regular Contributor

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

Reply
0 Upvotes
Occasional Contributor
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.
Reply
0 Upvotes
Visitor

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. 

Reply
0 Upvotes
Occasional Contributor

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?