Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Unsubscribes in reports?

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

View solution in original post

5 Replies

Avatar

Level 10

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

Avatar

Level 2

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

Correct answer by
Level 3

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

Avatar

Level 2

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

Level 3

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