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

Adding unsubscribes stats on reporting

Avatar

Avatar
Validate 10
Level 2
CIGM
Level 2

Likes

8 likes

Total Posts

38 posts

Correct Reply

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

Avatar
Validate 10
Level 2
CIGM
Level 2

Likes

8 likes

Total Posts

38 posts

Correct Reply

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

24-07-2017

Hi there,

I am trying to add an unsubscribe option on the Adobe reports so we can see how many unsubscribes is generating each email. Could you give me any guidance on how to this?

At the minute all our reports are set up to pull the data from the delivery table/schema. We have a scripted unsubscribed link for each email and I would need to know what's the formula/javascript to specify on the report the number.

1264314_pastedImage_1.png

Thanks,

Carlota

Replies

Avatar

Avatar
Validate 1
Level 2
davidk46719882
Level 2

Likes

7 likes

Total Posts

18 posts

Correct Reply

7 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile

Avatar
Validate 1
Level 2
davidk46719882
Level 2

Likes

7 likes

Total Posts

18 posts

Correct Reply

7 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile
davidk46719882
Level 2

25-07-2017

Hi Carlota,

You need to declare your URL as Opt-out in your tracking & images settings. Then It will allow you to use indicators/@optout from deliveries table in your report. (see the example below)

1265152_pastedImage_0.png

Thanks.

Avatar

Avatar
Validate 10
Level 2
CIGM
Level 2

Likes

8 likes

Total Posts

38 posts

Correct Reply

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

Avatar
Validate 10
Level 2
CIGM
Level 2

Likes

8 likes

Total Posts

38 posts

Correct Reply

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

26-07-2017

Hi David,

Thanks for getting back to me on this, it's been really helpful. I have now made the change and I can see the unsubscribe on my reports. I have just a couple of final questions if you could get back to me - and I would stop bothering-.

1) I can see the unsubscribe added on my reports but the count is giving me 0. I believe the formula to pull the data on the field is not correct? Could you shed some light on how should it be? I believe I should specify how many people clicked on the opt ou but I am not sure how to do that on the field (it would be easier if it was a query). Please see below:

1265693_pastedImage_3.png

Results:

1265692_pastedImage_1.png

Thanks a lot,

Carlota