SOLVED

Re: Filter with Multiple Values - is this 'AND' or 'OR'?

Go to solution
James_Glavin
Level 5

Filter with Multiple Values - is this 'AND' or 'OR'?

Hi there!

In creating a smart list/campaign, if I use the filter "Member of List: Person *NOT* in ..." and I select multiple values, am I creating an AND logic or OR, among those values? So if a person is on one of those lists but not another, will they be included or excluded?

Thanks!

James

1 ACCEPTED SOLUTION

Accepted Solutions
Casey_Grimes
Level 10

Re: Filter with Multiple Values - is this 'AND' or 'OR'?

It is among those values (OR logic), so if you do something like:

Member of List is not in: (3) Apples; Peaches; Pears

It doesn't matter if they are in Apples, Peaches, or Pears; they won't be included. If you want to only remove people who are part of all three, you'd do

Member of List is not in Apples

Member of List is not in Peaches

Member of List is not in Pears

Whenever you have the ability to specify more than one value in a Marketo filter, it's always operating off OR logic.

View solution in original post

2 REPLIES 2
Casey_Grimes
Level 10

Re: Filter with Multiple Values - is this 'AND' or 'OR'?

It is among those values (OR logic), so if you do something like:

Member of List is not in: (3) Apples; Peaches; Pears

It doesn't matter if they are in Apples, Peaches, or Pears; they won't be included. If you want to only remove people who are part of all three, you'd do

Member of List is not in Apples

Member of List is not in Peaches

Member of List is not in Pears

Whenever you have the ability to specify more than one value in a Marketo filter, it's always operating off OR logic.

James_Glavin
Level 5

Re: Filter with Multiple Values - is this 'AND' or 'OR'?

Thanks so much!