SSIS Components for Oracle Eloqua

Build 24.0.8963

Activity_WebVisit

Retrieve Web Visit 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 Id of the Web visit activity.
Name String The name of the Web visit activity. Not supported in bulk mode.
CreatedAt Datetime The date and time the Web visit activity was created.
Type String The type of Web visit activity.
AssetId Long The Id of the asset associated with the Web visit activity. Not supported in bulk mode.
AssetType String The type of the asset associated with the Web visit activity. Not supported in bulk mode.
ContactId Long The Id of the contact who performed the Web visit activity. Not supported in bulk mode.
Duration String The duration of the Web visit activity.
QueryString String The query string of the Web visit activity. Not supported in bulk mode.
QueryStringDisplay String The query string display of the Web visit activity. Not supported in bulk mode.
Thread String The thread of the Web visit activity. Not supported in bulk mode.
URL String The URL of the Web visit activity. Not supported in bulk mode.
ReferrerUrl String The Referrer URL of the Web visit activity. Only supported in bulk mode.
VisitorId Long The Id of the visitor associated with the Web visit activity. Only supported in bulk mode.
VisitorExternalId String The visitor external Id of the Web visit activity. Only supported in bulk mode.
ExternalId String The ExternalId associated with the Web visit activity. Only supported in bulk mode.
NumberOfPages String The number of pages of the Web visit activity. Only supported in bulk mode.
IpAddress String The IP address of the Web visit activity. Only supported in bulk mode.
FirstPageViewUrl String The first page view URL of the Web visit activity. Only supported in bulk mode.
FirstName String The FirstName of the contact associated with the Web visit activity.
LastName String The LastName of the contact associated with the Web visit activity.
Company String The Company of the contact associated with the Web visit activity.
City String The City of the contact associated with the Web visit activity.
ContactCreatedAt Datetime The date and time the contact associated with the Web visit activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the Web visit activity was created.
Address1 String The first line address of the contact associated with the Web visit activity.
Address2 String The second line address of the contact associated with the Web visit activity.
Title String The Title of the contact associated with the Web visit 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