EmailAutoOpen
Captures system-registered email opens that may not represent genuine user activity.
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.EmailAutoOpen;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailAutoOpenID [KEY] | Long | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the auto-open event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the auto-open event to the associated account. | |
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact whose email triggered the auto-open event. | |
| deviceInfoId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier referencing device information related to the open event, such as browser or platform details. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the auto-open event to the related Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the auto-open event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset that was automatically opened. | |
| firstOpen | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator showing whether this was the contact's first recorded open for the email. | |
| openDateHour | Datetime | Date and time, rounded to the hour, when the auto-open event occurred. | ||
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email send that generated the auto-open. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the email was originally sent. |