Closed lost - how to deal with multiple opportunities? | Community
Skip to main content
A
Anonymous
June 14, 2013
Question

Closed lost - how to deal with multiple opportunities?

  • June 14, 2013
  • 3 replies
  • 1512 views
Hey all,

Question: right now, our Closed Lost stage in our Revenue model triggers based on whether or not an Opportunity is updated and the value is Closed Lost.
 
But let's suppose a Contact has multiple Opportunities.  Only one is Closed Lost.  Can you suggest a filter for the Smart Campaign to filter out anyone with an Open Opportunity and a Closed Lost opportunity?
 
Is there any Marketo best practice around this issue?

Any thoughts appreciated!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

A
Anonymous
June 14, 2013
I just tried this, so it may not be perfect, but if you use the "Has Opportunity" filter twice, then set one to a stage of "Closed Lost" and the other to every stage that could be open (the green plus makes this quick), and make sure that the filter logic is set to all. This will look for everyone who has an Opportunity with a stage of Closed Lost as well as an Opportunity that is still open. 

Not pretty, but might get the job done!
A
Anonymous
June 14, 2013
Response from support (in case anyone else has this issue):

To do this you'll need to add the filter "Has Opportunity True - Is Open False." This will prevent leads with open opportunities from moving through that transition.
N
Nicole_Mossinge
Level 7
June 17, 2013
I usually build a Smart List, called "Has Open Opportunity". It filters out all records that are associated with an Opportunity where the Stage IS NOT "Closed Lost" or "Closed Won"

Then, in the transition for the model, you can simply trigger off of Opportunity is Updated, where Stage IS "Closed Lost", and add youf filter for Member of Smart List NOT IN "Has Open Opportunity".

This will prevent anyone who is associated with an open opportunity from going into your Lost stage.
Terms & ConditionsAccessibility statement

Loading footer...