EmailAutoClick
Tracks automated email click activity generated by bots or automation rather than user actions.
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.EmailAutoClick;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailAutoClickID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the auto-click event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the click event to the associated account. | |
| baseUrlId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the base URL that was clicked within the email. | |
| clickDateHour | Datetime | Date and time, rounded to the hour, when the auto-click event occurred. | ||
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who generated the auto-click event. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the click event to the associated Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset in which the auto-click occurred. | |
| firstClick | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator of whether this was the first click event recorded for the contact within this email. | |
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email send that generated the auto-click. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the email was originally sent. |