Is there a way to find out how long a contact has been in a specific lead status? (time in hs_lead_status?)
Hi @KGoyle,
Thanks for reaching out!
I’ll add some experts from our community to get their input on how you could track the time a contact spends in a specific lead status. Do you have any thoughts on how @KGoyle could achieve this?
@Anonymous, @ChrisoKlepke, @Annie_Birai, @digitalkrewe, @StjepanGrcic
Thanks!
Kristen
Hi @KGoyle,
There is no existing default HubSpot property that would track how long a contact has had a specific Lead Status. You could create some custom properties and workflows to track it, but this is by no means an easy solution because you would need to create a workflow and property to set today’s date, in order to use a calculation property to determine the time between when it was set and today’s date. You would also have to figure out a way to have it stop calculating after it has been changed to a new status.
I would recommend creating a date property that you set through a workflow whenever a status is updated instead (Example: Date Lead Status Was Set to “New”). That way, you can build reports and sort them based on the date the status was set to specific Lead Status without having to build a bunch of complicated workflows to calculate the exact number of days. This would still provide insight because you could build reports for contacts with a specific Lead Status that have a Lead Status Set Date of more than “X” days ago.
Let me know if you need any help with this. I am happy to help.
Best,
Annie
Hi Annie,
How do you set a workflow to set the date when a given lead status is updated?