Re: Using Duplicate Filters in a Smart List

Broderick_Klem1
Level 4

Using Duplicate Filters in a Smart List

I recently ran across a problem where I was trying to find users of a certain account that didn't receive either of two emails. Originally I had this setup as two different "not was sent email" filters but Marketo kept ignoring the second filter. After messing with the smart list for a while, I realized that it would only work if I deleted the second "not was sent email" filter and just added another value to the email name part of the first filter (it support multiple values). Is this a bug? Does this apply to all filters or just this one?

5 REPLIES 5
Erik_Heldebro2
Level 8

Re: Using Duplicate Filters in a Smart List

Hi Broderick,

I'm not sure about using inactivity filters, but wouldn't your query work better if you used two filters:

  1. Was sent email: Email X
  2. Not email was delivered: Email X

Depends what you define as receive, if you mean sent and not delivered or if you mean not sent (if it's the second one you can ignore my comment )

If you use the inactivity filter for Not was sent email you will probably include all in the lead database who was not sent the email (of course depends on which other filters you're applying). Were you using advanced filters, e.g. "1 and (2 or 3)", for this?

/Erik

Josh_Hill13
Level 10 - Champion Alumni

Re: Using Duplicate Filters in a Smart List

Yes.

Screenshot would be helpful. When I encounter these Not Was situations, it is often better to create a Positive smart list and then combine in a Member of Smart List NOT IN X AND/OR NOT IN Y list. This is especially true if you want an OR. But in this case, you want an AND NOT IN

Broderick_Klem1
Level 4

Re: Using Duplicate Filters in a Smart List

I was simply creating a list with 3 filters:

"Account ID" IS "12345"

"not was sent email" - "email A"

"not was sent email" - "email B"

The above did not work, it would never actually filter out people who received email B. The below DID work:

"Account ID" IS "12345"

"not was sent email" - "email A, email B"

Steven_Vanderb3
Marketo Employee

Re: Using Duplicate Filters in a Smart List

How was the logic set up?  AND, OR, or advanced logic?

Broderick_Klem1
Level 4

Re: Using Duplicate Filters in a Smart List

AND logic for all.