CRM

Kjappenzeller
Participant

Calculating cumulative time in deal stages?

SOLVE

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! 

0 Upvotes
1 Accepted solution
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Calculating cumulative time in deal stages?

SOLVE

@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/...

 

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
5 Replies 5
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Calculating cumulative time in deal stages?

SOLVE

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:

  1. Date entered {stage id}
  2. Date exited {stage id}
  3. Latest time in {stage id}
  4. 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!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Kjappenzeller
Participant

Calculating cumulative time in deal stages?

SOLVE

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? 

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

Calculating cumulative time in deal stages?

SOLVE

@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/...

 

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
Kjappenzeller
Participant

Calculating cumulative time in deal stages?

SOLVE

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. 

karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Calculating cumulative time in deal stages?

SOLVE

@Kjappenzeller just updated my previous reply!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes