List of users who have unsubscribed | Community
Skip to main content
rajansingh
rajansingh
New Participant
October 27, 2022
Solved

List of users who have unsubscribed

  • October 27, 2022
  • 2 replies
  • 874 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

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

2 replies

Shubham_Goyal__
Shubham_Goyal__
New Participant
November 1, 2022

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

 

    Craig_Thonis
    Craig_ThonisAccepted solution
    Employee
    October 27, 2022

    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

      Terms & ConditionsAccessibility statement

      Loading footer...