To view email subscribers and their statuses, query the _Subscribers data view in Automation Studio. Subscriber attributes aren’t available. This data view only returns results at the Enterprise level, and not for child business units.
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.
Columns
The SubscriberID, EmailAddress, and SubscriberKey columns are indexed.
| Name | Description | DataType | Data Extension Data Type | Nullable |
|---|---|---|---|---|
| SubscriberID | The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. | bigint | Number | |
| DateUndeliverable | The date an email for the subscriber was returned as undeliverable | smalldatetime | Date | X |
| DateJoined | The date the subscriber joined your list | smalldatetime | Date | X |
| DateUnsubscribed | The date the subscriber unsubscribed from your list | smalldatetime | Date | X |
| Domain | The domain of the subscriber | nvarchar(254) | Text | X |
| EmailAddress | The subscriber's email address | nvarchar(254) | ||
| BounceCount | The total number of bounces accrued by the subscriber | smallint | Number | |
| SubscriberKey | A potential alternate identifier for subscribers. Defaults to the value of Email Address. | nvarchar(254) | Text | |
| SubscriberType |
The subscriber type for the affected subscriber
|
varchar(100) | Text | |
| Status | The status of the subscriber: active, held, unsubscribed, or bounced. | varchar(12) | Text | X |