Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

extract unsubscribes data from Adobe Campaign

binhr47192046
Level 2
Level 2

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.

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

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

View solution in original post

3 Replies
Adhiyan
Correct answer by
Employee
Employee

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

View solution in original post

binhr47192046
Level 2
Level 2

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

Regards,

Ben

Adhiyan
Employee
Employee

Hi Ben,

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

Regards,

Adhiyan