List of users who have unsubscribed

Question

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

Craig_Thonis · Accepted Answer

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__ · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO