SSIS Components for Oracle Eloqua

Build 24.0.8963

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963