This behavior-related view contains the bounce data for emails from your account. Use the following _Bounce data view with the Query Activity.
Columns
| Name | Description | DataType | Data Extension Data Type | Nullable |
| AccountID | Your account ID number | int | Number | |
| OYBAccountID | The account ID number for any related On-Your-Behalf accounts. This field applies to enterprise accounts only. | int | Number | X |
| JobID | The job ID number for the email send | bigint | Number | |
| ListID | The list ID number for the list used in the send | int | Number | |
| BatchID | The batch ID number for any batches used in the send | bigint | Number | |
| SubscriberID | The subscriber ID for the affected subscriber. This number represents the unique ID for each subscriber record. | int | Number | |
| SubscriberKey | The subscriber key for the affected subscriber | varchar(100) | Email | |
| EventDate | The date the bounce took place | datetime | Date | |
| IsUnique | Whether the event is unique or repeated | bit | Boolean | |
| Domain | The domain at which the bounce occurred | varchar(128) | Text | |
| BounceCategoryID | The ID number for the bounce category | smallint | Number | |
| BounceCategory | The category of the bounce | nvarchar(50) | Text | X |
| BounceSubcategoryID | The ID number for the bounce subcategory | smallint | Number | X |
| BounceSubcategory | The subcategory of the bounce | nvarchar(50) | Text | X |
| BounceTypeID | The ID number for the bounce type | smallint | Number | |
| BounceType | The type of bounce that occurred | nvarchar(50) | Text | X |
| SMTPBounceReason | The reason for the bounce relayed by the mail system | nvarchar(max) | Text | X |
| SMTPMessage | The message regarding the bounce from the mail system | nvarchar(max) | Text | X |
| SMTPCode | The error code for the bounce from the mail system | smallint | Number | X |
| TriggererSendDefinitionObjectID | The object ID for the triggered send definition | Uniqueidentifier | Number | X |
| TriggeredSendCustomerKey | The customer key for the triggered send | nvarchar(36) | Text | X |
This page was last updated by Josh Cloud on Wed, 02 Nov 2011 15:18:28 GMT.
If you're having an application issue, please contact Global Support. To send Josh direct feedback, fill out the form below:
You are not logged in. Log in 