Unsubscribes in reports?

Avatar

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

24-07-2017

Hi,

I'm trying to add a column to each report showing how many people have unsubscribed. Ideally it should be on the same report so it is next to the delivery template and we can see how many people are unsubscribing from each specific email. I have managed to place the unsubscribed column but I am struggling to come up with a way to add the total number of unsubscribed in there (at the minute I can only see are just the number of clicks).

The only way I could think to do this was by using the tracking logs and specifying 'Email click'. However, I cannot filter the email click to be for only our unsubscribe link (as shown below). Is anyone able to offer some advice for doing this? Perhaps an alternative approach is needed!

1264320_pastedImage_0.png

Any response is much appreciated.

Thanks,

Rob

Accepted Solutions (1)

Accepted Solutions (1)

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 Rob,

As you are not using OOTB unsubscription link, you need to declare the link you are using as opt-out

1265151_pastedImage_0.png

That will allow you to query url type equal to opt-out. you can also use indicators/@optout from deliveries table in your report.

Thanks

David

Answers (4)

Answers (4)

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

27-07-2017

Hi Rob,

It will work only for the future unsubscribes. But you can change the URL type to "Opt-out" in the old deliveries then recompute delivery and tracking indicators to retrieve the old unsubscribes.

Please do it on a dev/test environment first.

1266647_pastedImage_1.png

Thanks

David

Avatar

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

25-07-2017

Hi Amit,

Thanks for your reply.

Unfortunately we don't use the optOut indicator, so this gave me no results. I believe we are using a custom unsub URL, so filtering for a custom URL would be perfect, how can this be done?

Regards,

Rob

Avatar

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

Avatar
Validate 1
Level 2
robertw59784382
Level 2

Likes

5 likes

Total Posts

15 posts

Correct reply

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

27-07-2017

Thanks David. That seems to be working, but results in the report are 0. I assume that's because changing tracking to opt-out only picks up future unsubscribes?

Regards,

Rob

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
Amit_Kumar
MVP

24-07-2017

Hi Rob,

You are almost there. If you are using the OOTB unsubscription link or a link with label Opt-out in emails, then you should select opt-out from the drop down instead of email click otherwise use your custom URL name to filter the results.

OOTB URL lable and value is like

Opt-outoptout

Regards,

Amit