topic Re: Calculating cumulative time in deal stages? in CRM

Calculating cumulative time in deal stages?

Kjappenzeller — Wed, 20 Mar 2024 14:52:04 GMT

I am trying to calculate TOTAL cumulative time in my deal stages that we consider "working a deal". Since we have "Qualified Lead" as Stage 0 (no I don't want advice on this part) I want to calculate cumulative time in the following stages Discovery, Solicitation, Decision Making, and Contracting.

I thought this would be possible with a custom calculation, but my output was not calculating.

We are on Sales Enterprise. Thanks!

Re: Calculating cumulative time in deal stages?

karstenkoehler — Wed, 20 Mar 2024 14:59:09 GMT

Hi @Kjappenzeller,

HubSpot just introduced this, no need for a custom property 🙂

Deals

Deal Stage Calculated Properties

Mar 14, 2024

What is it?

Professional or Enterprise customers will now have access to four (4) new HubSpot-defined deal properties, to track the progression of a deal as it moves through a sales pipeline:

Date entered {stage id}

Date exited {stage id}

Latest time in {stage id}

Cumulative time in {stage id}

Rollout will begin in early March and eligible customers will receive access on a rolling basis.

Why does it matter?

With access to these properties, you can easily identify bottlenecks in your sales process. For example, you can assess a deal pipeline's velocity by looking at the average "latest time" and "cumulative time" of each deal stage.

How does it work?

These properties will be automatically updated as a deal moves through a pipeline. You can:

View the history of these properties on any deal record

Use the properties in reporting, to gain deeper insights into how your business is converting deals

Build the properties into automated workflows, to scale your sales process (e.g. when "latest time in {stage id}" > 3 days, send follow up email)

See Knowledge Base article for more.

Who gets it?

CMS Pro, CMS Enterprise, Marketing Pro, Marketing Enterprise, Ops Pro, Ops Enterprise, Sales Pro, Sales Enterprise, Service Pro, Service Enterprise

Best regards!

Re: Calculating cumulative time in deal stages?

Kjappenzeller — Wed, 20 Mar 2024 15:00:39 GMT

Thanks for the quick reply. I should have been more specific, I am trying to add up all the cumulative time in those stages since HubSpot introduced the individual time in each stage. Does that make sense?

Re: Calculating cumulative time in deal stages?

karstenkoehler — Wed, 20 Mar 2024 15:06:16 GMT

@Kjappenzeller how would that be different from the "Cumulative time in {stage id}"? (see the product update, numbered list item 4)

Edit: I think I just realized what you mean. So you would like to see the duration since deal creation?

If so, should you want this for reporting, I'd recommend checking the "Deal velocity" report in the sales analytics: https://knowledge.hubspot.com/reports/create-sales-reports-with-the-sales-reports-analytics-tool

If you want this on a by-deal basis, you would have to create a today's date property first - either with Operations Hub Professional (leveraging daily scheduled workflow) or with this workaround: https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Setting-Today-s-Date-with-Workflows/m-p/883062#M7076

You can then create a calculation property to calculate the time between "Create date" and this "Today's date" property.

Re: Calculating cumulative time in deal stages?

Kjappenzeller — Wed, 20 Mar 2024 15:04:29 GMT

I want to clauclate the following:

Cumulative time in "Discovery" Stage + Cumulative time in "Solicitation" Stage+Cumulative time in "Decision Making" Stage+Cumulative time in "Contractice" Stage

This will then give me a TOTAL time in working stages in my pipeline.

Re: Calculating cumulative time in deal stages?

karstenkoehler — Wed, 20 Mar 2024 15:06:37 GMT

@Kjappenzeller just updated my previous reply!