To view subscribers on lists in your account, query the _ListSubscribers data view in Automation Studio.
Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.
Note When profile attributes are created in Enterprise 2.0 accounts, new columns are
added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0
accounts can return results from profile attribute columns in addition to the
columns listed here.
ListID and SubscriberID are indexed fields.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| AddedBy | The ID of the user who ran the process that added the subscriber | int | Number | |
| AddMethod | The method by which the subscriber was added, including Unspecified, Webcollect, API, FTAF, Import, Move Copy, Application, Salesforce, Segmentation, Generic Extension, and Custom Object | varchar(17) | Text | |
| CreatedDate | The date the subscriber was added to the list | smalldatetime | Date | X |
| DateUnsubscribed | The date the subscriber unsubscribed | smalldatetime | Date | X |
| EmailAddress | The subscriber's email address | nvarchar(254) | Text | X |
| ListID | The list ID number for the list used in the send | int | Number | X |
| ListName | The name of the list containing the subscribers | varchar(50) | Text | X |
| ListType |
Shows whether the type is list or group
|
varchar(16) | Text | |
| Status | The status of the subscriber | varchar(12) | Text | X |
| SubscriberID | The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. | int | Number | X |
| SubscriberKey | The subscriber key for the affected subscriber | nvarchar(254) | Text | X |
| SubscriberType | The type of subscriber | varchar(100) | Text | X |