0

I'm trying to exclude a data extension where the email addresses are encrypted from a send. Is this possible to do in Salesforce Marketing Cloud?

  • Exclude data extension rows? – Adam Spriggs Jun 20 '16 at 15:52
  • Are you trying to exclude the emails from a send, or are you trying to filter them out of a data extension? Or something else completely? Please provide a bit more info on what you need. – Gortonington Jun 20 '16 at 16:27
  • Sure! I have a data extension with encrypted email addresses (due to security reasons). I'm wondering if ET will recognize the encrypted email addresses and will allow me to use that data extension as an exclusion list. – Hanna Jun 20 '16 at 18:03
0

You could do something like this with a Query Activity:

select
emailAddress
, field2
from DataExtensionName
where emailAddress NOT LIKE '%_@__%.__%'

Source: SQL Script to Find Invalid Email Address

0

There is no native way to automatically do this. There are so many encryption types that it really wouldn't make sense to expect the system to instantly recognize and decrypt it.

Outside of decrypting the file prior to use (doesn't seem to be an option to you), you will likely need to look at having an exclusion script run prior to each send. This is of course assuming you have the key to decrypt/encrypt these.

You would need to either:

  1. Inside the Exclusion script, encrypt each email address and perform a Lookup to see if it matches on the exclusion Data Extension, or
  2. In the Exclusion script, run a for loop that decrypts each email address and then compares it to the email you are looking to send to.

Both of these options are really very inefficient and clunky. I would highly recommend just decrypting the email addresses into another data extension or list and using that to exclude.

For future needs, I would look into utilizing some other unique non-personal identifier to exclude on (SubscriberID, GUID, etc), removing the need for encryption at all.

Exclusion script

Exclusion Script checkbox - Determines whether subscribers are excluded from the send based on script logic. If you select this checkbox, you must provide the exclusion AMPscript.

Examples:

a. ROWCOUNT(LOOKUPROWS("Exclustion_DATA_EXTENSION_NAME","EMAIL_ADDR", EMAIL_ADDR))>0

b. _SubscriberKey == 16172 and _SubscriberKey == 15705

Encrypt Symmetric

EncryptSymmetric(string, algorithm, passwordKey, password, saltKey, salt, initVectorKey, initVector)

Encrypts plain text data using the supplied algorithm and encryption values. You can supply either a value or a valid external key for the password, initialization vector, and Salt.

Decrypt Symmetric

DecryptSymmetric(data, algorithm, passwordKey, password, saltKey, salt, initVectorKey, initVector)

Decrypts encrypted data using the supplied algorithm and encryption values. You can supply either a value or a valid external key for the password, initialization vector, and Salt.

0

If you are talking about SF Shields platform encryption, then it is painful using Script because they tell you there are limitations. One of them is field level encryption doesn't support Auto-suppression Lists and even segmentation. I would recommend to leave it non encrypted.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.