Activity_EmailOpen
Retrieve Email Open Activities.
Table Specific Information
Select
If you are not using the Bulk API, ContactId is required to query Activity tables.
Columns
| Name | Type | Description |
| ID [KEY] | Long | The unique identifier of the email open activity. |
| Name | String | The name of the email open activity. Not supported in bulk mode. |
| EmailAddress | String | The email address of the contact. |
| CreatedAt | Datetime | The date and time the email open activity was created. |
| Type | String | The type of the activity associated with the email open activity. |
| AssetName | String | The name of the asset associated with the email open activity. |
| AssetId | Long | The Id of the asset associated with the email open activity. |
| AssetType | String | The type of the asset associated with the email open activity. |
| ContactId | Long | The Id of the contact who performed the email open activity. |
| EmailName | String | The name of the email. Not supported in bulk mode. |
| EmailWebLink | String | The Web link 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. |
| IPAddress | String | The IP address of the sender. |
| SubjectLine | String | The subject line of the email. |
| CampaignId | Long | The Id of the campaign associated with the email open 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 open activity. |
| LastName | String | The LastName of the contact associated with the email open activity. |
| Company | String | The Company of the contact associated with the email open activity. |
| City | String | The City of the contact associated with the email open activity. |
| ContactCreatedAt | Datetime | The date and time the contact associated with the email open activity was created. |
| ContactModifiedAt | Datetime | The date and time the contact associated with the email open activity was created. |
| Address1 | String | The first line address of the contact associated with the email open activity. |
| Address2 | String | The second line address of the contact associated with the email open activity. |
| Title | String | The Title of the contact associated with the email open 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. |