All Subscribers list: status, email, and lifecycle dates. Enterprise-level; use Ent._Subscribers from child BUs. No six-month retention limit.
Schema last reviewed 2026-06-17
Opens _Subscribers in the interactive canvas with SQL Sandbox.
| Field | Type | Flags | Relations | Description |
|---|---|---|---|---|
SubscriberID |
Number | PK | — | Unique subscriber record ID. |
DateUndeliverable |
Date | NULL | — | Date email was returned undeliverable. |
DateJoined |
Date | NULL | — | Date the subscriber joined. |
DateUnsubscribed |
Date | NULL | — | Date the subscriber unsubscribed. |
Domain |
Text(254) | NULL | — | Email domain of the subscriber. |
EmailAddress |
Text(254) | — | — | Subscriber email address. |
BounceCount |
Number | — | — | Total bounces accrued by the subscriber. |
SubscriberKey |
Text(254) | IDX | — | Alternate subscriber identifier; defaults to email. |
SubscriberType |
Text(100) | — | — | Subscriber type (e.g. ExactTarget, Salesforce Contact). |
Status |
Text(12) | NULL | — | Subscription status: active, held, unsubscribed, or bounced. |
Locale |
Number | NULL | — | Locale code for the subscriber. |
SELECT TOP 100
SubscriberKey, SubscriberID, EmailAddress, DateUndeliverable, DateJoined, DateUnsubscribed
FROM _Subscribers
WHERE DateJoined >= DATEADD(day, -30, GETDATE())
ORDER BY DateJoined DESCValid 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.