Opened Email Min Number of Times? | Community
Skip to main content
A
Anonymous
May 16, 2013
Solved

Opened Email Min Number of Times?

  • May 16, 2013
  • 3 replies
  • 3884 views
I was wondering how the Min. Number of Times add constraint to the Opened Email Filter worked if I had a list of emails in the filter.

For instance, I list 5 emails from a nurturing program in the Opened Email filter.  I add a constraint for Min Number of Times is 2. Will I get leads that opened any of the emails at least 2 times or will I get leads that opened at least 2 of the 5 emails listed?

I'm basically trying to pull leads that opened emails from a nurturing program, and opened at least 2 of the emails.

Thanks in advance!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by

Lan, I see what you're trying to do.


Unfortunately, you can't do this with Marketo advanced filters. I tried to do the following logic and it wouldn't take either one:

(1 and 2) or (1 and 3) or (1 and 4) or (1 and 5) or (2 and 3) or (2 and 4) or (2 and 5) or (3 and 4) or (3 and 5) or (4 and 5)

(1 and (2 or 3 or 4 or 5)) or (2 and (1 or 3 or 4 or 5)) or (3 and (1 or 2 or 4 or 5)) or (4 and (1 or 2 or 3 or 5)) or (5 and (1 or 2 or 3 or 4))

I think your best bet would be to create 5 smart campaigns and create a new score field. Each smart campaign will look at if a lead was sent the email and +1 to the score if yes.

Then, you can run your filter off the score.

Let me know if you come up with a better way.

3 replies

John_Westley
John_Westley
New Participant
April 28, 2015
Inspired by the direction of Lan's logic I was able to figure out how to create a smart list giving me the people that opened 2 of 5 emails.

The error with Lan's samples was becasue you can't repeat a filter in logic. It can only occur once.

Because of that we had to use 10 filters:

*****
(1 and 2) or (3 and 4) or (5 and 6) or (7 and 8) or (9 and 10)

1 - Opened Email #1 and
2 - Opened either Email #2, 3, 4, or 5

- or -

3 - Opened Email #2 and
4 - Opened either Email #1, 3, 4, or 5

- or -

5 - Opened Email #3 and
6 - Opened either Email #1, 2, 4, or 5

- or -

7 - Opened Email #4 and
8 - Opened either Email #1, 2, 3, or 5

- or -

9 - Opened Email #5 and
10 - Opened either Email #1, 2, 3, or 4

*****
Here's a screenshot of how it works ... sorry for the redacted version but I couldn't have the list names public.




 
    M
    Maci91
    New Participant
    April 27, 2020

    Hi John,

     

    Thanks for this solution, I was just wondering does it needs to be added in the beginning of the smart list the filter member of list, or is it just enough to put open email filters?

    A
    Anonymous
    Accepted solution
    May 16, 2013

    Lan, I see what you're trying to do.


    Unfortunately, you can't do this with Marketo advanced filters. I tried to do the following logic and it wouldn't take either one:

    (1 and 2) or (1 and 3) or (1 and 4) or (1 and 5) or (2 and 3) or (2 and 4) or (2 and 5) or (3 and 4) or (3 and 5) or (4 and 5)

    (1 and (2 or 3 or 4 or 5)) or (2 and (1 or 3 or 4 or 5)) or (3 and (1 or 2 or 4 or 5)) or (4 and (1 or 2 or 3 or 5)) or (5 and (1 or 2 or 3 or 4))

    I think your best bet would be to create 5 smart campaigns and create a new score field. Each smart campaign will look at if a lead was sent the email and +1 to the score if yes.

    Then, you can run your filter off the score.

    Let me know if you come up with a better way.

      A
      Anonymous
      May 16, 2013
      If I understand correctly, the Trigger will be activated in either case -- someone opens one email 2 or 2 of the 5
      Terms & ConditionsAccessibility statement

      Loading footer...