List of users who have unsubscribed

[rajansingh]

From which query we can get the list of users who have unsubscribed in a delivery template?

[Craig_Thonis · Accepted solution]

Hi Rajan,

I would recommend starting from your trackinglogrcp table and looking for anyone who selected the Opt-Out or Unsubscribe for the delivery in question then link that back to your recipient table.

Regards,

Craig

[Shubham_Goyal__]

Hi @rajansingh ,

The subscribers/un-subscribers information for service in delivery is stored in the Subscription (nms:subscription) schema. (screenshot)
So, you can use a Query activity in the workflow and use this table, and then in the Filtering condition add your desired delivery from the linked table 'broadLog' and get the list of all unsubscribers.

Br,

Shubham