Time in Ticket Status reporting function

[SarahX]

We really need a way to report on how long a ticket is spending at a particular status before progressing to the next step. I honnestly thought this was part of the functionality I was paying for with Service Pro.

The ability to easily see where the bottle necks in our process are is critical to our service improvement. I can see that the time between function now exists for deals, but it does not appear to be applicable to ticket stages nor can I find a work around.

I know that the data is collected as you can see in individual tickets the history of the ticket status by clicking on the property, but there still seems to be no way to access this in reports or contact filtering.

[SarahX]

Hi everybody,

we have now delivered this functionality.

Service Hub Professional and Enterprise customers will now have access to new data points about the time in ticket status. Each ticket will now have new properties that can be used in report builders and segmentation alike:

• Date entered ticket status
• Date exited ticket status
• Latest time in ticket status (calculated using the two properties above)
• Cumulative time in ticket status (for tickets that re-enter a ticket status multiple times)

Users will also be able to access out-of-the-box reports with these new data points in the Help Desk Analyze Tab as well as the Service Hub Analytics Suite.

Let us know if you have any questions or feedback.

[SarahX]

@LButterfield we are currently in the process of mimicking the current behavior of deals for tickets. They had previously migrated to this new, more powerful system. 

We are planning to launch this in Q1 for tickets and I will update this thread once we do.

[SarahX]

@SGordon531, thanks for reaching out. I just sent you a direct message to dig a bit deeper into your requirements. 

[SarahX]

@SarahX, thanks for sharing these detail, much appreciated. I would like to share some ideas and would love to get your take whether they solve your requirements.

Note: I can totally relate to your requirements and I am open to exploring building out native HubSpot features but it would be very interesting to learn whether existing alternatives would meet your requirements as well.

"I would still appreciate a way to track this time on individual tickets"

-> You could create the report and then embed it via CRM Cards onto a ticket record

"apply it to workflows so that an alert can be created if a ticket exceeds an amount of time"

-> You could create a workflow using delays that should enable this alerting

• Enroll ticket in workflow when it entered stage x
• Wait 5 days (for example)
• Check whether the ticket is still in stage x
• If yes, send an alert e.g. a notification

"filter for tickets that have exceeded a certain amount of time"

-> That's a good one and I can only imagine using the workflow mentioned above to tag tickets (e.g. via a custom property) that are over a certain threshold (that you define). 

Let me know what you think!

[SarahX]

"Only other thing I'd love to see in this is a comparison over the previous period. Thanks, again!"

@CaitlinHaire , thank you for sharing additional requirements, I would like to share an idea with you - let me know what you tink. You could change the axis in the Single Object Report Builder to show the average over time. Would the below report give you that comparison you were looking for?

  

[SarahX]

Hello everybody,

thanks for all your feedback on this. 

Can you tell me more about whether the report "Ticket time in pipeline" in the Report Collection Team Performance section would fulfill your requirements? You can break the report down by rep, team and create date and can add filters to it as well.

We really appreciate your input!

Thanks

Marc

[mollmann]

@LButterfield we are currently in the process of mimicking the current behavior of deals for tickets. They had previously migrated to this new, more powerful system. 

We are planning to launch this in Q1 for tickets and I will update this thread once we do.

[LButterfield]

@mollmann that's great news and music to my ears! I shall look forward to the announcement! 😀

[mollmann]

Hi everybody,

we have now delivered this functionality.

Service Hub Professional and Enterprise customers will now have access to new data points about the time in ticket status. Each ticket will now have new properties that can be used in report builders and segmentation alike:

• Date entered ticket status
• Date exited ticket status
• Latest time in ticket status (calculated using the two properties above)
• Cumulative time in ticket status (for tickets that re-enter a ticket status multiple times)

Users will also be able to access out-of-the-box reports with these new data points in the Help Desk Analyze Tab as well as the Service Hub Analytics Suite.

Let us know if you have any questions or feedback.