Mismatched status on _Subscribers and _ListSubscribers due to sending to unsubscribed subscriber deleted from All Subscribers
Trailblazer Community

Mismatched status on _Subscribers and _ListSubscribers due to sending to unsubscribed subscriber deleted from All Subscribers

Marketing Cloud Email Studio

Last updated 2021-03-01 ·Reference W-8724610 ·Reported By 0 users

In Review

Summary
If a subscriber is deleted from the All Subscribers List who has the status of "Unsubscribed" and that subscriber is then sent to through a Salesforce or Data Extension Send, the subscriber will have mismatched value in the All Subscribers List (or _ListSubscribers data view) and in the _Subscribers data view (or when retrieving the Subscriber object through API). On the list view the subscriber will have an Unsubscribed status but an Active status on the subscriber view.

Repro
For a Salesforce Send:

1. Complete an email send to a SF contact report
2. Unsubscribe one of the subscribers
3. Delete the unsubscribed subscriber from the All Subscribers List
4. Ensure that the contact does not have Email Opt Out enabled
5. Complete a second send to a SF contact report


For Data Extension sends:

1. Complete an email send to a data extension
2. Unsubscribe one of the subscribers
3. Delete the unsubscribed subscriber from the All Subscribers List
4. Complete a second send to the data extension

Workaround
-Import the subscriber as active or unsubscribed into the all subs list.

*You can find the subscribers with the mismatched status with the steps below:

1. Navigate to Email Studio > Subscribers > All Subscribers > Properties
2. Take note of the List ID seen here
3. Navigate to Automation Studio > Activities
4. Create a new SQL Query Activity with the following SQL:

select s.SubscriberKey, s.EmailAddress, s.Status, ls.Status as ListSubStatus
from _Subscribers s
join _ListSubscribers ls
on s.SubscriberID = ls.SubscriberID
where s.Status='Active' and ls.Status = 'Unsubscribed'
and ls.ListID = (Add your list ID)

5. Execute the SQL to write to a target DE
6. Export the target DE as a .csv file and import to All Subscribers with the desired status

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.