Activity_EmailClickThrough
Retrieve Email Click Through Activities.
Table Specific Information
Select
If you are not using the Bulk API, ContactId is required to query Activity tables.
Additionally, the COUNT function is supported for this table in bulk mode.
Columns
| Name | Type | Description |
| ID [KEY] | Long | The unique identifier of the email click-through activity. |
| Name | String | The name of the email click-through activity. Not supported in bulk mode. |
| CreatedAt | Datetime | The date and time the email click-through activity was created. |
| Type | String | The type of the email click-through activity. |
| AssetId | Long | The Id of the asset associated with the email click-through activity. |
| AssetName | String | The name of the asset associated with the email click-through activity. |
| AssetType | String | The type of the asset associated with the email click-through activity. |
| ContactId | Long | The Id of the contact who performed the email click-through activity. |
| EmailClickedThruLink | String | The click-through link in the email. |
| EmailName | String | The name of the email. Not supported in bulk mode. |
| EmailWebLink | String | The Web link of the email. |
| SubjectLine | String | The subject line of the email. |
| EmailRecipientId | String | The Id of the recipient of the email. |
| EmailSendType | String | The send type of the email. Only supported in bulk mode. |
| EmailAddress | String | The address of the email. Only supported in bulk mode. |
| IpAddress | String | The IP address of the email activity. Only supported in bulk mode. |
| CampaignId | Long | The Id of the campaign associated with the email click-through activity. Only supported in bulk mode. |
| DeploymentId | Long | The deployment Id associated with the email open activity. Only supported in bulk mode. |
| VisitorId | Long | The Id of the visitor associated with the email open activity. Only supported in bulk mode. |
| VisitorExternalId | String | The ExternalId of the visitor associated with the email open activity. Only supported in bulk mode. |
| ExternalId | String | The ExternalId associated with the email open activity. Only supported in bulk mode. |
| FirstName | String | The FirstName of the contact associated with the email click-through activity. |
| LastName | String | The LastName of the contact associated with the email click-through activity. |
| Company | String | The Company of the contact associated with the email click-through activity. |
| City | String | The City of the contact associated with the email click-through activity. |
| ContactCreatedAt | Datetime | The date and time the contact associated with the email click-through activity was created. |
| ContactModifiedAt | Datetime | The date and time the contact associated with the email click-through activity was created. |
| Address1 | String | The first line address of the contact associated with the email click-through activity. |
| Address2 | String | The second line address of the contact associated with the email click-through activity. |
| Title | String | The Title of the contact associated with the email click-through activity. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ExportToken | String | The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data. |
| Depth | String | The depth of information requested from Eloqua. |