Jan 25, 2022 3:07 PM
I am sure if this is the right location for this question, please let me know if there is a more appropriate board.
I am trying to determine the length of time that a ticket has been in the current pipeline stage (status). I suspect that I can find a way to make this work using a customer calculated property....however I know that this information is already an attribute of the ticket within HubSpot. In late 2020, there was a short week of time in october, where the export of all ticket properties was not restricted and showed there were actually almost 270 properties available.
Specifically there were
Date entered 'stagename (Pipeline Name)'
Time in 'stagename (Pipeline Name)' (HH:mm:ss)
Date exited 'stagename (Pipeline Name)'
For each stage / pipeline that we have as well as for the current stage pipeline as a separate set of properties.
Unfortunately, these were only temporarily available and were no longer included in the export of all properties after a few days of public exposure. Further unfortunate is the fact that these have never been exposed to then reporting or workflow parts of the product.
Which brings me to my question. Are any of these properties exposed to the API as properties? Is there an hs_pipeline_stage_time_in_stage_current or something similar that I can access that will give me the current duration that a ticket has been in the current stage (status)?
Feb 3, 2022 6:41 PM
Is there any indication from Product Management that they might expose the existing properties that track this information already. I have created properties previously that mirror exiting properties that are not exposed already. It seems to me that making users create a property, then build a workflow that monitors tens of thousands of tickets in order to provide information that is already available but not yet exposed is redundant and frankly a bit irritating.
Jan 27, 2022 12:51 PM
Thank you for reaching out to the Community!
You are right - there currently isn't a default Ticket property that would record the date when a ticket has entered a certain stage.
Mia, Community Team