We came up with an interesting solution to this issue which is working pretty well for us. It doesn’t aleviate the obvious issues around overall reporting, but does help us manage our tickets and deadlines very well.
Basically, we worked out the time that a ticket should hae in each stage (column status) - so for example, data import 3 days, new user setup 1 day etc. Then what we did was setup a workflow that triggered each time a new ticket landed in that particular status that simply gave the ticket a numerical value of 3. Then, added to the workflow a 1 day delay and then reduced the 3 day count down by 1 to leave 2 and so on. Then my team can see how many days left a ticket has before it becomes overdue. We then setup extra days to be added to each ticket on a Monday morning to credit back the 2 days they all lost over weekends and also setup so that once they hit zero, they’d be flagged as overdue.
This is working pretty well for us and has made a huge difference for my team to know what tickets are fast approaching overdue status. I am happy to share more if anyone is interestested.
A workaround would be to download a list and upload it to Excel/Google Sheets and do the calculations there. Made a quick video showing the steps https://www.youtube.com/watch?v=bKsOM5cARVQ
Or to use an integration like G-Accon or Zapier to get the properties into Google Sheet and calculate it there.
The report would provide extremely valuable information for salespeople and marketers alike to identify where the problem lies/where the process is bottlenecked.
This is a great idea. It’s definitely a must-have and the data is already in Hubspoit. The issue is also for contacts who come in directly as MQLs vs. as basic leads.
This is very critical in the sales process to understand how quickly a customer moves through lifecycle stages not only deal stages! Definitely an upvote on this one!
This is a basic feature and extremely valuable for our clients’ sales teams. In fact, this is a requirement of many of our clients. Other platforms have this, so we need to be able to provide it ASAP. Please make it happen soon!
Disappointed to see that this is not a native metric … I made the assumption it would be since the time stamps for lifecycle stage transitions are already there. Days between lifecycle stages is a really important metric for marketing/business development teams! I’ll have to get at this manually for now, but hope to see it soon in the platform.
Great idea! I would also open this feature for Lead Stage property. We would love to know the time between our leads go from “New” to “Contacted” or “Discarded” or any other option., after we qualify it and move to opportunity or costumer directly.
