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.
Solved! Go to Solution.
Views
Replies
Total Likes
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 :
Regards,
Adhiyan
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 :
Regards,
Adhiyan
Thanks Adhiyan. seems like your screenshot was taken from campaign standard. for V6.1 would be the same ?
Regards,
Ben
Views
Replies
Total Likes
Hi Ben,
Yes. In fact the screenshot is from V6.1 only
Regards,
Adhiyan
Views
Replies
Total Likes
Views
Likes
Replies