sfmc // SQLPRODUCTION
Recent Bounce Diagnostics
Extract recent bounce category and SMTP details for deliverability investigation.
sqlbouncesmtpdeliverability
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,
JobID,
EventDate,
Domain,
BounceCategory,
BounceType,
SMTPCode,
LEFT(SMTPBounceReason, 4000) AS SMTPBounceReason
FROM _Bounce
WHERE EventDate >= DATEADD(day,-7,GETDATE())Constrain long SMTP text to the destination DE field length.
Use a recent window when diagnosing temporary blocks.