Loading
Journeys and Automations in Marketing Cloud Engagement
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Data View: Bounce

            You are here:

            1. Salesforce Help
            2. Docs
            3. Engagement: Journey Builder and Automation Studio

            Data View: Bounce

            To view bounce data for emails sent from your account, query the _Bounce data view in Automation Studio. Bounce data is retained for six months.

            Dates and times are stored in Central Standard Time. Daylight Savings Time isn’t observed. To view time-related data in your time zone, set time zone user preferences.

            Note
            Note When profile attributes are created in Enterprise 2.0 accounts, new columns are added to the _EnterpriseAttribute table. Data view queries in Enterprise 2.0 accounts can return results from profile attribute columns in addition to the columns listed here.
            Note
            Note Data returned for some fields exceeds their character limit. When querying nvarchar fields, use left() function to limit the number of characters to fit the field length in the target data extension.
            Example
            Example left(smtpbouncereason, 4000) left(smtpbouncereason, 4000)

            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. This serves as the primary key. nvarchar(254) Text  
            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 varchar(36) Text X
            TriggeredSendCustomerKey The customer key for the triggered send nvarchar(36) Text X
            IsFalseBounce Indicates a false bounce bit Boolean X
             
            Loading
            Salesforce Help | Article