What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?

Northern Trail Outfitters receives a nightly encrypted unsub file to their Marketing Cloud SFTP from a third-party email platform. These files are used to unsubscribe existing subscribers. They do not use Email Address as Subscriber Key.

What Automation Studio Activity sequence should be used to ensure the appropriate subscribers are unsubscribed from the All Subscriber List?
A . Import File > Data Extract > File Transfer > Import File
B. File Transfer > Import File > Query > Data Extract > File Transfer > Import File
C. Import File > Query > Data Extract > File Transfer > Import File
D. File Transfer > Import File > Data Extract > File Transfer > Import File

Answer: C

Explanation:

Import File activity can be used to import the unsub file from the SFTP to a data extension.

Query activity can be used to query the data extension and update the status of the subscribers in All Subscribers list to Unsubscribed. Data Extract and File Transfer activities are not needed for this process.

References:

https://help.salesforce.com/articleView?id=sf.mc_as_import_file_activity.htm&type=5

https://help.salesforce.com/articleView?id=sf.mc_as_query_activity.htm&type=5

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments