Skip to main content
Level 2
Jun 24, 2017 12:08 PM UTC
Solved

extract unsubscribes data from Adobe Campaign

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Adhiyan
AdhiyanAccepted solution
Adobe Employee
Jun 26, 2017 5:24 AM UTC

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

3 replies

Adhiyan
Adobe Employee
AdhiyanAdobe EmployeeAccepted solution
Adobe Employee
Jun 26, 2017 5:24 AM UTC

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

Translate
Level 2
Jul 4, 2017 12:47 PM UTC

Thanks Adhiyan. seems like your screenshot was taken from campaign standard. for V6.1 would be the same ?

Regards,

Ben

Translate
Adhiyan
Adobe Employee
Adobe Employee
Jul 5, 2017 4:15 AM UTC

Hi Ben,

Yes. In fact the screenshot is from V6.1 only

Regards,

Adhiyan

Translate