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

Delivery label associated to an unsubscription

Avatar

Avatar
Validate 1
Level 2
LiviaD1
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 2
LiviaD1
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile
LiviaD1
Level 2

19-02-2019

Hi all,

I set an export of unsubscribers data, i.e. event date, first and last name, email, ...

In this export I would like to add a column that identifies the delivery in which the profile clicked on "unsubscribe" and then unsubscribed via landing page.

I tried a lot of different export but I'm not able to find a way to add this information. For example I added tracking logs to additional data in the query but this column is filled with the delivery of the first unsubscribe. It's not so common, but can happen that a profile unsubscribed, then subscribed and unsubscribed again.

Has anyone an idea to accomplish this purpouse?

I'm quite surprised that there is not an easy way to collect this information.

Thanks,
Livia

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
priyal_b
Level 2

Likes

14 likes

Total Posts

47 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
priyal_b
Level 2

Likes

14 likes

Total Posts

47 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
priyal_b
Level 2

19-02-2019

Are you querying only Address table for this?

You could try to enrich tracking logs and join based on email to find out how many entries you have for an email for unsub link clicks.

That will give you all the opt out/unsub links these people ever clicked.

Thanks!

Avatar

Avatar
Validate 1
Level 2
LiviaD1
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 2
LiviaD1
Level 2

Likes

3 likes

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile
LiviaD1
Level 2

20-02-2019

Hi priyal.b,

I try to clarify. I don't want to know the list of the unsub links that a profile clicks because he can click and then not confirm in landing page.

I would like to export which is the exact delivery that caused unsbuscription, besides other personal information and subscription history (ex. date of unsubscription).
I hope that now it's more clear,
thanks