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

extract unsubscribes data from Adobe Campaign

Avatar

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
binhr47192046
Level 2

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)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
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

Answers (2)

Answers (2)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

04-07-2017

Hi Ben,

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

Regards,

Adhiyan

Avatar

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
binhr47192046
Level 2

Likes

9 likes

Total Posts

14 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
binhr47192046
Level 2

04-07-2017

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

Regards,

Ben