4 Replies Latest reply on Jul 19, 2017 12:23 PM by Josh Hill

    "Has Opportunity" Filter with Trigger

    Dan McGinn

      Hi Marketing Nation,


      I'm trying to create smart campaigns to update our lead data in Marketo. One of which requires us to look to see if an opportunity closes, but check to see if the lead has other existing opportunities currently open. Here is my smart list consideration:



      Opportunity is updated: Trigger Attribute - Stage = Closed/Won

      Added to Opportunity: Opportunity is Any, Stage = Closed/Won



      Has Opportunity = False

      Stage NOT = Closed/Won, Closed/Lost


      If the lead has an opportunity closed won, but they still have existing opportunities open, I want them to go through the flow. As it sits now, all people go through the flow if an opportunity closes, it seems the filter is being ignored. As a work around, I can create a batch campaign that looks for people who have open opportunities, but this is not ideal.


      Any help would be greatly appreciated.



        • Re: "Has Opportunity" Filter with Trigger
          Nick Hajdin

          Hi Dan,


          The smart campaign will move the lead through the flow step if the activity is triggered. Can you add a constrain to the triggers rather than using filters?

          • Re: "Has Opportunity" Filter with Trigger
            Josh Hill

            Your filter is set to FALSE. You need to set to TRUE.


            Trigger: Opp becomes Closed Won OR Added to Opp; Stage=Closed Won.

            Filter Constraint:

            Has Opp=TRUE in Stage=Not Closed Won


            Run a smart list on this to see if there are such people and if Marketo really can find them. The problem with Marketo and Opps is that I can use


            Has Opp=TRUE


            and it will come up with any Lead associated to ANY opp ever on that Account. No # of Opps, etc. So one has to be careful how to use this when multiple Opps exist in diff stages. I find this filter has issues in this scenario.


            You may want to instead create a smart list of everyone with an Open Opp and use that as the Filter in your flow as IN this list.