EmailBounceback
Records bounced email messages along with reasons for delivery failure.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.EmailBounceback;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailBouncebackId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email bounceback event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the bounceback event to the associated account. | |
| bounceBackDateHour | Datetime | Date and time, rounded to the hour, when the bounceback event occurred. | ||
| bouncebackFromAddress | String | Email address from which the bounceback message originated. | ||
| bounceBackMessage | String | Full text or summary of the bounceback message returned by the receiving mail server. | ||
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact for whom the email bounceback occurred. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the bounceback event to the related Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the bounceback event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset that generated the bounceback. | |
| emailSendId | Long | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier of the specific email send instance that resulted in the bounceback. | |
| firstBounceback | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator of whether this was the contact's first bounceback recorded for the email. | |
| isHardBounceback | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag showing whether the bounceback was a hard bounce, indicating a permanent delivery failure. | |
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email send that generated the bounceback. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the original email was sent. | ||
| smtpErrorCode | String | Error code returned by the SMTP server that rejected or bounced the email. | ||
| smtpReplyCode | String | Reply code provided by the receiving mail server in response to the failed email delivery attempt. |