Tracking

_Bounce

Hard and soft bounce events with SMTP diagnostics. Six-month retention. Monitor with _Complaint for deliverability health.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _Bounce in the interactive canvas with SQL Sandbox.

Fields (22)

Field Type Flags Relations Description
AccountID Number — — Parent account ID (MID).
OYBAccountID Number NULL — Child Business Unit MID that owns the row; null on parent BU queries.
JobID Number PK, FK _Job.JobID
_Sent.JobID		 Email send job ID.
ListID Number PK, FK _ListSubscribers.ListID List ID used in the send.
BatchID Number PK — Batch ID for multi-wave sends.
SubscriberID Number PK, FK _Sent.SubscriberID
_Open.SubscriberID
_Click.SubscriberID
_Bounce.SubscriberID
_Complaint.SubscriberID
_Unsubscribe.SubscriberID		 Subscriber record ID.
SubscriberKey Text(254) FK _Subscribers.SubscriberKey
_Sent.SubscriberKey
_Open.SubscriberKey
_Click.SubscriberKey
_Bounce.SubscriberKey
_Complaint.SubscriberKey
_Unsubscribe.SubscriberKey		 Subscriber key identifier.
EventDate Date IDX — Timestamp when the bounce occurred.
Domain Text(128) — — Domain associated with the event.
TriggererSendDefinitionObjectID Text(36) FK, NULL _Sent.TriggererSendDefinitionObjectID
_Open.TriggererSendDefinitionObjectID
_Click.TriggererSendDefinitionObjectID
_Bounce.TriggererSendDefinitionObjectID
_Unsubscribe.TriggererSendDefinitionObjectID
_Complaint.TriggererSendDefinitionObjectID
_FTAF.TriggererSendDefinitionObjectID
_SurveyResponse.TriggererSendDefinitionObjectID		 Triggered send definition object ID.
TriggeredSendCustomerKey Text(36) NULL — Triggered send customer key.
IsUnique Boolean — — First bounce occurrence for the subscriber on this job (1 = unique).
BounceCategoryID Number — — Bounce category ID.
BounceCategory Text(50) NULL — Bounce category label.
BounceSubcategoryID Number NULL — Bounce subcategory ID.
BounceSubcategory Text(50) NULL — Bounce subcategory label.
BounceTypeID Number — — Bounce type ID.
BounceType Text(50) NULL — Bounce type label.
SMTPBounceReason Text NULL — SMTP reason from the receiving server.
SMTPMessage Text NULL — SMTP message from the mail system.
SMTPCode Number NULL — SMTP error code (watch 541 and 554).
IsFalseBounce Boolean NULL — True if delivery receipt arrived after a bounce.

Example query

SELECT TOP 100
  JobID, SubscriberKey, SubscriberID, EventDate, ListID, BatchID
FROM _Bounce
WHERE EventDate >= DATEADD(day, -30, GETDATE())
ORDER BY EventDate DESC

Valid 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.