Engineering Atlas
☰ Menu
PortfolioAtlasDeploySQLData ViewsEnvBites
PT
Engineering Atlas / Snippets / Current Email Subscriber Status
sfmc // SQLPRODUCTION

Current Email Subscriber Status

Read current All Subscribers status, bounce count and unsubscribe date from _Subscribers.

sqlsubscribersstatusall subscribers
Context Pack →Open Workspace →
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

SELECT
    SubscriberKey,
    EmailAddress,
    Status,
    BounceCount,
    DateUnsubscribed
FROM _Subscribers
WHERE Status IN ('active','held','unsubscribed','bounced')
Operational notes

_Subscribers returns enterprise-level results and does not expose subscriber profile attributes.

Connected knowledge

Keep following the context.

Explicit and inferred relationships from the Atlas model.

View this node in graph →
RecipeDIRECT LINK
120-Day Engaged Audience

Create an explainable engaged-audience dataset from recent opens/clicks while protecting the final grain.

Recipe step
Data View
_Subscribers

Email subscriber addresses and current status at enterprise level.

_Subscribers referenced in snippet
Snippet
Review Held / Bounced Subscriber State

Inspect current All Subscribers state and bounce count for non-active records.

Shared context: subscribers
Production Bite
CloudPagesURL from SMS/Push Has an All Subscribers Trap

A CloudPagesURL link used from SMS or push returns an error for a recipient.

Shared context: all subscribers
Sources / verification
Salesforce — Data View: Subscribers ↗