List Membership and Status Audit with _ListSubscribers

List vs. global subscriber status

_ListSubscribers holds list-level membership and status. _Subscribers reflects the All Subscribers list at enterprise scope. A subscriber can be active globally but unsubscribed on a specific list.

Join both when building hygiene reports that respect list context.

Active members on a list

SELECT
  l.ListName,
  ls.SubscriberKey,
  ls.Status AS ListStatus,
  sub.Status AS GlobalStatus,
  ls.DateJoined
FROM _ListSubscribers ls
INNER JOIN _List l ON ls.ListID = l.ID
INNER JOIN _Subscribers sub ON ls.SubscriberID = sub.SubscriberID
WHERE ls.Status = 'active'
  AND sub.Status = 'active'
  AND ls.DateJoined >= DATEADD(day, -30, GETDATE())

Hygiene use cases

• Find globally active subscribers unsubscribed on a marketing list.
• Identify stale list members who have not received a send recently.
• In child BUs, use Ent._Subscribers when global status is required.