Dashboards & Reporting

johnhenry
Contributeur

Deal Stage before Closed

Résolue

Hi Team,

 

I am enquirying to see if anyone has implemented this as a new property for which at the moment I cannot see anyone has.

 

Basically I want this property to list what stage a deal was in before being Moved to Closed lost or won.

 

eg. Deal 43 was in Proposal Stage, before being closed lost.

Deal 27 was in Enquiry Stage before being closed lost.

 

Which a property such as "Stage before close" would show:

Deal 43 : Proposal

Deal 27: Enquiry

 

Looking forward to thoughts and ideas on this one. Thanks, John

 

1 Solution acceptée
ElyshaShave
Solution
Contributeur de premier rang | Partenaire solutions Platinum
Contributeur de premier rang | Partenaire solutions Platinum

Deal Stage before Closed

Résolue

Hi, 

 

There isn't a field within HubSpot for this but as a work round you could create a workflow (depending on your HubSpot package) to populate a custom property. 

 

I have added instructions on how would do this below:

  1. Locate to "Settings" in the top right hand corner and then chose "Properties" from the menu on the left. 
  2. Under "Deal Properties", create a custom property called "Deal Stage before Close".
  3. With this property, you want to make it a drop down property and add all of your deal stages, excluding "Closed Won", "Closed Lost" etc..
  4. Once you have done this, locate to "Workflows" in the top navigation.
  5. Create a "Deal" based workflow
  6. The enrollment will be that the "Deal Name" is known AND "Deal Stage" does not equal "Closed Won", "Closed Lost" etc..
  7. Then add an if/then branch - The enrollment will be: If the Deal Property, "Deal Stage" is any of {Your first deal stage}, then on the "Yes" side, click "Set Property Value". Choose "Deal" and search for "Deal Stage before Close". Choose {Your first deal stage} and click save. 
  8. You will then need to repeat step 7 for all of your deal stages. 

This workflow will then copy the deal stage information over to "Deal Stage before Close" before it reaches the closed won/ lost stage.

 

Workflow Example.png


If you needed more help or assistance, please let me know. 

 

Elysha Shave

Inbound Specialist 

BBDBoom.com

Voir la solution dans l'envoi d'origine

7 Réponses
bmsfox
Contributeur

Deal Stage before Closed

Résolue

Love this, very helpful, but why not just have a different branch within a single IF/THEN or VALUE EQUALS for each sales stage?

MFalhon
Membre

Deal Stage before Closed

Résolue

Hi,
I had the same issue today and your posts were very helpful. Thank you so much.
As I did not know how to handle the 7th bullet in your list Elysha, I cloned a simple workflow as many times as my active stages instead.

MFalhon_0-1675095481164.png

MFalhon_1-1675095500302.png

...

After this I was wondering how Hubspot could make the link between any LOST or WON stage and the "last stage before close". For example, a LOST deal "Last stage before close" would have been empty. So I decided to create a last workflow to enable a LOST stage to collect the previous "Last stage before close". And it worked!

MFalhon_2-1675095576376.png

In order to check it was ok, I created a deal at 20% stage and turned it into a lost stage right after.
I created a report to track the last stage before LOST with the following parameters:

MFalhon_3-1675096614512.png

MFalhon_5-1675096776722.png

My test deal turned from 80% to LOST was taken into account!

MFalhon_6-1675096830761.png

 

The inconvenient is that the workflow did not work on previous LOST deals as the property did not exist before today. Nevermind, It will be a good report for this new year!
Hope it helps
Martine

 

 

 

 

 

DianaGomez
Gestionnaire de communauté
Gestionnaire de communauté

Deal Stage before Closed

Résolue

Hi @MFalhon, hope you are doing well!

 

¡Thank you so much for sharing!

 

Best,

Diana


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


ElyshaShave
Solution
Contributeur de premier rang | Partenaire solutions Platinum
Contributeur de premier rang | Partenaire solutions Platinum

Deal Stage before Closed

Résolue

Hi, 

 

There isn't a field within HubSpot for this but as a work round you could create a workflow (depending on your HubSpot package) to populate a custom property. 

 

I have added instructions on how would do this below:

  1. Locate to "Settings" in the top right hand corner and then chose "Properties" from the menu on the left. 
  2. Under "Deal Properties", create a custom property called "Deal Stage before Close".
  3. With this property, you want to make it a drop down property and add all of your deal stages, excluding "Closed Won", "Closed Lost" etc..
  4. Once you have done this, locate to "Workflows" in the top navigation.
  5. Create a "Deal" based workflow
  6. The enrollment will be that the "Deal Name" is known AND "Deal Stage" does not equal "Closed Won", "Closed Lost" etc..
  7. Then add an if/then branch - The enrollment will be: If the Deal Property, "Deal Stage" is any of {Your first deal stage}, then on the "Yes" side, click "Set Property Value". Choose "Deal" and search for "Deal Stage before Close". Choose {Your first deal stage} and click save. 
  8. You will then need to repeat step 7 for all of your deal stages. 

This workflow will then copy the deal stage information over to "Deal Stage before Close" before it reaches the closed won/ lost stage.

 

Workflow Example.png


If you needed more help or assistance, please let me know. 

 

Elysha Shave

Inbound Specialist 

BBDBoom.com

contentmarketer
Participant

Deal Stage before Closed

Résolue

Nevermind- I figured this out, but thanks again for such a detailed guide!

 

Hey Elysha, thanks so much for the awesome rundown! I am building this now.

 

Question for you -- if a Deal Stage goes to 20%, then 40%, then closes, will this workflow show the original 20% or the last 40%? I want to make sure it shows the last, so assumingI can do that by just allowing re-enrollment. Let me know - thanks!

0 Votes
johnhenry
Contributeur

Deal Stage before Closed

Résolue

Hi Elysha, 

 

Thanks for your response. I like your idea and agree the workflow would best make sense. Thanks for you help on this one, I will give it a crack and let you know if I have any issues.

0 Votes
ElyshaShave
Contributeur de premier rang | Partenaire solutions Platinum
Contributeur de premier rang | Partenaire solutions Platinum

Deal Stage before Closed

Résolue

Hi,

 

Not a problem, let me know if you need any further help.

 

 

Thanks,

Elysha Shave

Inbound Specialist

BBD Boom.com

 

0 Votes