_ListSubscribers

Current list and publication list membership and status for subscribers. No six-month retention limit.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _ListSubscribers in the interactive canvas with SQL Sandbox.

Fields (12)

Field	Type	Flags	Relations	Description
`AddedBy`	Number	—	—	User or process ID that added the subscriber.
`AddMethod`	Text(17)	—	—	How the subscriber was added (Import, API, WebCollect, etc.).
`CreatedDate`	Date	NULL	—	Date added to the list.
`DateUnsubscribed`	Date	NULL	—	Date unsubscribed from the list.
`EmailAddress`	Text(254)	NULL	—	Subscriber email address.
`ListID`	Number	PK, FK	_ListSubscribers.ListID	List ID.
`ListName`	Text(50)	NULL	—	List name.
`ListType`	Text(16)	—	—	List type: List, Group, Publication list, Suppression list, etc.
`Status`	Text(12)	NULL	—	Subscriber status on this list.
`SubscriberID`	Number	PK, FK	_Subscribers.SubscriberID	Subscriber record ID.
`SubscriberKey`	Text(254)	FK, NULL	_Subscribers.SubscriberKey	Subscriber key.
`SubscriberType`	Text(100)	NULL	—	Subscriber type.

Example query

SELECT TOP 100
  SubscriberKey, SubscriberID, EmailAddress, ListID, AddedBy, AddMethod
FROM _ListSubscribers
WHERE CreatedDate >= DATEADD(day, -30, GETDATE())
ORDER BY CreatedDate DESC

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.