sfmc // DeliverabilityPRODUCTION
Review Held / Bounced Subscriber State
Inspect current All Subscribers state and bounce count for non-active records.
sqlsubscribersheldbounce
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verified2026-10-05
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.
A technically valid address is not receiving expected email.
SELECT
SubscriberKey,
EmailAddress,
Status,
BounceCount,
DateUnsubscribed
FROM _Subscribers
WHERE Status IN ('held','bounced','unsubscribed')_Subscribers exposes current status and bounce count at enterprise subscriber level.
Subscriber status is not the same thing as BU-level unsubscribe context; use _BusinessUnitUnsubscribes when that distinction matters.