extract unsubscribes data from Adobe Campaign

binhr47192046

24-06-2017

Hi, could you please advise a best way to extract unsubscribes data from Adobe Campaign. I am looking to extract the member number, type of unsubscribes, email addresses and date of unsubscribe. Also would like to do this on a weekly basic, assume a workflow can help to automate this task?

Thanks and regards.

Accepted Solutions (1)

Accepted Solutions (1)

Adhiyan

Employee

25-06-2017

Hi bin,

Here is what you can do.

Add a query activity and filter the unsubscribers like :

Query: no longer contact by email and action of History of service subscription equal to Unsubscription.

Then we can add additional data and add the columns you want to extract . Then add a data Extract activity and save the exported data in a csv file in your server location/Sftp location.

Please refer to the screenshot on how the query would look like :

forum.JPG

Regards,
Adhiyan