Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I get how I can exclude a certain email using the below script using the key or email. I'm looking to exclude certain email addresses based on it either containing certain characters or because it starts with certain characters. Example: dummy-37464hvxcs@xyz.com. I'd want to exclude any email that starts with dummy or contains dummy.
ROWCOUNT(LOOKUPROWS("Test_Opt_Out_List","SubscriberKey",_subscriberkey)) > 0
If you like to filter based on a subscriber key starting with a certain sting, just put an IndexOf-Check into your exclusion script:
IndexOf(_subscriberkey, "dummy") == 1
If you like to filter out any subscribers that contain "dummy" in the subscriber key no matter where (which most certainly isn't the best idea), you could use the following:
IndexOf(_subscriberkey, "dummy") > 0
The AMPscript that is used in the exclusion script just needs to evaluate to true to exclude the current subscriber from the send. So just check out the string functions in the AMPscript Function Reference and start customizing the script as you wish.
Another option which gives you more control over which email addresses match and which don't is RegExMatch where you can use regular expressions to check if the address qualifies for the send or not:
Length(RegExMatch(_subscriberkey, "^dummy\-.*", 0, "IgnoreCase")) > 0
Further reading:
I would be careful using direct exclusions (e.g. IndexOf(), Contains/Like statements, etc) because it could mean legit emails never get sent.
E.g. Haydummyers@xyz.com would not get your email because it has 'dummy' in it.
As well, if a person has an online alias (notAdummy69@xyz.com) or a business has dummy in its name (mbayter@dummyshop.com) you would exclude them.
<Rant>
It also comes down to the question of "Who are you to judge the legitimacy of personal information a person submits to you?" I believe in most places you are considered 'Innocent until proven guilty' and I think that should apply here as well.
I personally think giving the customer the benefit of the doubt and at least attempting a single send is a far better experience and healthy relationship than automatically excluding them based on preconceived notions.
</Rant>
What you can do to take care of those bad email addresses to ensure deliverability is you check the domains for legitimacy (no @fake.com or @notanemail.com) to prevent hard bounces up front. Then run a daily query or export to find all the soft bounces from the previous day with 'not a real alias at domain' (or whatever the message/code is) and then unsubscribe them.
Through this you would greatly reduce risk (aka damage to sender rep) while increasing value via ensuring all legitimate emails are sent out - essentially creating a greater value to cost, increasing overall ROI.
