HubSpot Ideas

ilovehubspot

Add Average time spent in lead status

Would be really cool if we could see the average time a lead stays in a lead status. Right now this is only available at the deal level.  Please add this report 😃

8 Replies
benefitrusso
Member

Yes, I'm coming across this need as well. PLEASE implement!

Esthervand
Member

Same, please add this!!

Esthervand
Member

For those interested, we created a workaround for this using a calculation property to check how many days a contact was in each stage:

 

  • create a date picker property to track each time a contact enters a lead status stage. You can automate this with a workflow.
  • Then you can create a calculation property to show how long they were in each status for and build a report on this.
    (FYI - The datepicker property can only calculate based on days not hours or minutes so there will be a level of rounding up/down)

    Schermafbeelding 2021-06-21 om 15.12.46.png
ilovehubspot
Member

What is the delay for? and why those # of days?

Esthervand
Member

Hi @ilovehubspot sorry I missed your message, but I'm not sure if I understand your question. The goal is to track the amount of time (days) a lead spends in each fase.

ilovehubspot
Member
I think I was referring to the # of days in the workflow that you had. It
says to delay 1825 days.
kreastman15
Participant

On the property value change - what did you put? when is not the current property value?? 

Esthervand
Member

@ilovehubspot basically you want it to infinitely have a delay, but since that's not a possibillity we just went for a lot of days. Does that clear it up?