EmailClickthrough
Tracks user click-through events from Eloqua emails to linked landing pages or external URLs.
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.EmailClickthrough;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailClickthroughId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email clickthrough event record within Eloqua. | |
| accountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the clickthrough event to the associated account. | |
| baseUrlId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier for the base URL that was clicked within the email message. | |
| clickDateHour | Datetime | Date and time, rounded to the hour, when the clickthrough event occurred. | ||
| clickThroughLink | String | The full URL link that the contact clicked within the email. | ||
| clickthroughQueryStringValue | String | Query string values captured from the clicked URL, often used for tracking and attribution. | ||
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact who performed the email clickthrough. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the clickthrough event to the associated Eloqua campaign. | |
| eloquaLinkedAccountID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the clickthrough event to a related Eloqua linked account record. | |
| emailID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the email asset in which the clickthrough occurred. | |
| firstClick | Int | =,<>,>,<,>=,<=,IN,NOT IN | Indicator showing whether this was the contact's first recorded clickthrough for the email. | |
| segmentID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the segment associated with the email send that generated the clickthrough event. | |
| sentDateHour | Datetime | Date and time, rounded to the hour, when the email was originally sent. |