How to include multiple exclusion under "Send Email Activity > Advanced Exclusions"

Question

I have an automation to send out the list of form submission in email to a list of internal contacts. The DE looks something like this:

Email | Campaign | Date
[email protected] | Campaign One | 1 Jun 22
[email protected] | Campaign Two | 10 Jun 22
[email protected] | Campaign Two | 10 Jun 22

I created a "Send Email Activity" and filtered out contacts from "Campaign One" under "Advanced Exclusions > Exclusion Script". However, it seems like [email protected] was filtered out because the record is duplicated in the DE.

Question:

1. What should I do to include contacts that appeared multiple times in the DE?
2. How do I add multiple conditions? I tried using sometime like (AttributeValue("Campaign") != "Campaign One" AND AttributeValue("Date") != "1 Jun 22") but it doesn't work.

Any advice would be appreciated. Thank you.

Answer 1

If you'd like to prevent sends to anyone that has a Campaign value of "Campaign One" or if they have multiple entries in the DE, then you could do something like this in your Exclusion Script:

AttributeValue("Campaign") == "Campaign One" 
OR rowcount(lookuprows("YOURDENAME","Email", AttributeValue("emailaddr"))) > 1

Since negative logic is confusing, I always use this mnemonic preceding my exclusion script conditional:

Exclude the send to this subscriber if ___ is true

Reference:

• LookupRows
• RowCount

20220627 UPDATE

You can test exclusion script logic in your email by like this:

%%[

if AttributeValue("Campaign") == "Campaign One" 
   OR rowcount(lookuprows("YOURDENAME","Email", AttributeValue("emailaddr"))) > 1 then
  set @excluded = "true"
else
  set @excluded = "false"
endif

output(concat("<br>excluded: ", @excluded))

]%%

Once you've achieved the desired results, move what's between the if and then to your Exclusion Script.