Really need a report that shows a list of Deals in the Pipeline and how long each individual deal has spent in it's current stage. I can't believe other users aren't clamoring for this... very inportant!!
Hi everyone, we released a set of deal stage properties in March, including "latest time in stage" and "cumulative time in stage." Here is the relevant Knowledge Base article with more details.
That said, I recognize that this solution does not offer the value of an object's time in stage in its current stage. That is a limitation of these properties at this time. It's a highly complex issue to solve, so I appreciate everyone's patience while we explore and navigate this.
We do have plans to introduce this set of properties for Tickets as well; however, I don't think we'll be able to prioritize this in 2024.
I'm leaving this post open, and will report back when I have an update about solving for the current stage issue. Thank you all for sharing your use cases and insights!
👋 Hi everyone, I'm Jeannie, the product manager for Pipelines.
My team and I are working on making Deal stage calculated properties available, so they can be used in reporting and workflows. These will be similar to the Contact lifecycle stage calculated properties that we released last year. I will post more details as we get further into development.
I'm one of the Product Manager for HubSpot's reporting tool. Thank you all for leaving your feedback on this thread. We're still working on a solution to expose this data for deals and other HubSpot properties/objects. At this moment, we do not have a roadmapped solution. This thread will stay open, so please feel free to leave feedback.
@smcmillian it's an absolute disgrace HubSpot haven't got this in place today, especially since your API doesn't capture every entry and exit dates! We need timelines, there are various other threads complaining about the same thing.
this is dissapointing , guess it is time to search for a new solution , Hubspot Sales Hub , is really not a fully baked solution . This key feature is missing , the ability to set sales goals for employees (non-revenue based) and so many other missing features . I like HubSpot , but it is just not there yet as a Sales Solution
Really disappointed to see that this isn't planned - this is a crucial metric for us to be looking at.
Even the ability to export the "time in stage" to a CSV file so I could manually calculate this would be INCREDIBLY helpful. When I create a custom deals report, it shows that I cannot export these fields:
"Some properties in HubSpot contain data that currently cannot be exported, or might not display as expected in your export. The following properties are affected:
You can export the property history for Deal Stage and then match it to to a report of deals from your pipeline along with other Deal properties, but it requires a manual run each time. It's really such a basic metric and disappointing that it can't be displayed in a deal report.
This would be a huge deal for us - trying to create reports on deal age is a bit of a nightmare. Being able to create a calculated field that simply works out number of days from deal creation to todays date would be a perfect fix. Big upvote from me
It's a fundamental tracking tool for any sales or support organisation. Hubspot can already track how long a deal has stayed in a stage once it has exited it. It's only a matter of comparing the 'entered date' to 'today's date'.
@kelseyhamon They do have the fields in the back end already, as we have explored using that to log exit stages, but, it was a mess, only capturing c.60% of changes, we were told the API is buggy.
They have big problems in their back end, this is why we don't have it as a simple feature! The only reason I'm still here is because of the CS.
<complain> C'mon Hubspot team. With all the product can do, why not a simple yet so essential thing like showing Time in Pipeline Stage? Surely somewhere in the system, there is a date flag associated with status change. Today's date minus Status change date = Number of Days in Stage. Simple. Please fix. ASAP. Thanks.
When you have a chance, we would love to discuss with you how you set-up the custom workflows and deal properties to make this report work for you. I could set up a call with my team members at a convenient time for you.
In this article, instead of Step 3 (creating an email alert), you should be able to set up a couple of custom properties/fields to capture the "Time Between" the time stamp and the date the deal moved to another stage.
Here's another blog posting that shows how to do all this for "Contact Status" property, but you should be able to do this exact same thing on a Deal property. It's basically a:
1. Workflow on the Deal to capture Today's Time Stamp on all Deals
2. Custom property to hold onto this Time Stamp for each Stage of the Deal you want to keep track of
3. Workflow to push/update this Time Stamp for each Stage of the Deal you want to keep track of
4. Custom property to calculate the time between today's date and when the Deal entered each Stage.
For a more detailed description and guide on how you can do this, jump down to hack #4 for all the gory details (again, this if for Contact Status, but Deal Stage should work the same).
In the meantime we also figured out a visual workaround to view "Time in Deal Stage" on the deal board view. The HubSpot community blog featured it this month: