[SalesForce] How to import to Suppression list in the Marketing Cloud

Can we import subscribers to the suppression list using an excel spreadsheet? If not, what are the ways to import to suppression list, and do we need to activate anything for this?

I checked the documentation and it seems like it should be possible, but I do not see the option of import activity in the menu that is specified.

Click the Interactions tab on the navigation bar.

Click Activities.

Click Import.

Best Answer

Ok so the documentation on Suppression Lists does have a section on importing:

How to Import into a Suppression List

Refer to Import Activity for information on importing into a suppression list. You can import opt-out subscribers collected out of the Email application. If a subscriber does not exist in the system, the subscriber is added as Active, and then only Opted-out at the suppression list level. The suppression list level is the list to which they were imported. Importing into a suppression list is supported for Enterprise 2.0 only at this time.

Subscriber attributes are not supported for suppression list imports. The system only supports the following:

Email Address

Subscriber Key (If enabled in your account)

Status (active or unsubscribed)

Reason (The unsubscribe/opt-out reason)

The full details of importing are too long to list here but you can find them on the linked page, and they do support both comma and tab delimted files meaning you can use data from Excel.

Related Solutions

[SalesForce] Auto Suppression List – Overwrite but maintain date added field with original posting value

You can certainly order rows by date and select the oldest using a partition. You could also join the results to another data extension to compare dates. Something like this:

select
  y.emailaddress
, y.subscriberkey
, y.insertDate
from (
  select
    x.emailaddress
  , x.subscriberkey
  , x.insertDate
  from (
    select
      d.emailaddress
    , d.subscriberkey
    , d.insertDate
    , row_number() over (partition by d.subscriberkey order by d.insertDate asc) ranking
    from DataExtension d
  ) x
  where x.ranking = 1
) y
inner join DataExtension2 d2 on (d2.subscriberkey = y.subscriberkey)
where y.insertDate > d2.insertDate

I'd also like to throw out the possibility of using a Server-Side JavaScript Script Activity in your Automation to delete the subscriber from the list.

You can retrieve rows in a Data Extension and iterate through them. Then for each subscriber to remove, retrieve their Lists and remove the unsub list from the array. From there you can just Update the Subscriber object with the new list object. I've done this quite a bit in custom preference centers that manage publication list membership. The only difference here is that you're iterating through a data extension to get the subscribers.

If Script Activities aren't enabled in your account, SFMC Support can enable them for you.

Best Answer

Related Solutions

[SalesForce] Auto Suppression List – Overwrite but maintain date added field with original posting value

Related Topic