SpamUnsubscribesByEmail
Captures spam-related unsubscribe events, where recipients mark messages as spam.
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.SpamUnsubscribesByEmail;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailUnsubscriptionId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the spam-related unsubscription event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the unsubscription event to the associated account. | |
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who unsubscribed by reporting the email as spam. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the unsubscription event to the related Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the unsubscription event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset that triggered the spam unsubscription. | |
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email send that generated the unsubscription event. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the original email was sent. | ||
| spamUnsubscribedDateHour | Datetime | Date and time, rounded to the hour, when the contact unsubscribed by marking the email as spam. |