Dashboards & Reporting

MMetros5
Contributeur

Reporting on Closed Won vs Closed Lost without filter on Stage

Résolue

Is there a field that denotes whether a deal is closed won or close lost that is not a deal stage type field? I want to create an automation that runs whenever a deal is closed. Then the condition I check for is if the deal is won or lost. 

 

How can I do this without using the stage fields so that the automation does not need to be updated everytime we update the deal stages or add a new pipeline?

0 Votes
1 Solution acceptée
MMetros5
Solution
Contributeur

Reporting on Closed Won vs Closed Lost without filter on Stage

Résolue

@Anonymous I am using the Probability field. When it is "1", then I know it is closed won. If it is "0", then I know it is closed lost.

Voir la solution dans l'envoi d'origine

0 Votes
3 Réponses
MMetros5
Solution
Contributeur

Reporting on Closed Won vs Closed Lost without filter on Stage

Résolue

@Anonymous I am using the Probability field. When it is "1", then I know it is closed won. If it is "0", then I know it is closed lost.

0 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Reporting on Closed Won vs Closed Lost without filter on Stage

Résolue

Nice one!

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 Votes
karstenkoehler
Au panthéon de la communauté | Partenaire solutions
Au panthéon de la communauté | Partenaire solutions

Reporting on Closed Won vs Closed Lost without filter on Stage

Résolue

Hi @MMetros5,

 

Great question, I don't think there is another property that would have this information. (You can check this page to find properties which would be updated by HubSpot for won or lost deals. There aren't any.)

 

In this case, it's easiest to update your automation whenever new pipelines are added. If stage names change, those changes won't affect existing workflows.

 

There is of course always the option to create a custom solution via the API but that seems a bit excessive here (unless you create new pipelines daily or weekly).

 

Hope this helps!

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 Votes