List of users who have unsubscribed | Community
Skip to main content
rajansingh
rajansingh
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

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe 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

    Shubham_Goyal__
    Shubham_Goyal__
    Level 6
    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

     

      Terms & ConditionsAccessibility statement

      Loading footer...