Which data view would you query to view subscriber statuses in your account?

Which data view would you query to view subscriber statuses in your account?

• A. _Open data view
• B. _Subscribers data view
• C. _Sent data view
• D. _SMSMessageTracking data view

Answer: (B)

Subscriber status is stored at the subscriber level, not as a per-event detail. The data view that holds this global, per-subscriber information is the _Subscribers data view, which includes a Status field showing whether a subscriber is Active, Unsubscribed, Bounced, Held, etc. This is the source you’d query to see the current state of subscribers across the account. The other data views track interactions and messaging events (opens, sends, and SMS activity). They don’t provide a single, current status for each subscriber, which is why they aren’t suitable for viewing subscriber statuses. For example, you could run: SELECT SubscriberKey, Status FROM _Subscribers; to see each subscriber’s current status, or filter for Status = 'Active' to find active subscribers.

Subscriber status is stored at the subscriber level, not as a per-event detail. The data view that holds this global, per-subscriber information is the _Subscribers data view, which includes a Status field showing whether a subscriber is Active, Unsubscribed, Bounced, Held, etc. This is the source you’d query to see the current state of subscribers across the account.

The other data views track interactions and messaging events (opens, sends, and SMS activity). They don’t provide a single, current status for each subscriber, which is why they aren’t suitable for viewing subscriber statuses.

For example, you could run:

SELECT SubscriberKey, Status FROM _Subscribers;

to see each subscriber’s current status, or filter for Status = 'Active' to find active subscribers.