Count URL clicks on specific label for multiple deliveries (for a report)
Hi all,
I implemented a workflow that queries several KPIs from past deliveries (like delivery date, number of recipients, open rate etc) and creates a report, which is uploaded to an SFTP server.
As we have 2 different unsubscription links in our newsletters, the number of optouts found in ACC delivery indicators is not sufficient (it fetches the sum of both links). I would like to add the number of clicks (and derived click rates) per each of the links to the report - and that's where I struggle.
The label for the links is always the same, so I thought I can just add a field that counts the clicks per URL label for each of the deliveries, but I don't know how to fetch the data.
I might need some count-function with a condition to only count the clicks on the URL with the according label, but don't know how to integrate it into my workflow.
(also I am not particularly skilled with JavaScript, which might have limited my efforts)
Grateful for any ideas from the crowd, also let me know if I more information is required.
Cheers!

