TDV Adapter for Oracle Eloqua

Build 22.0.8462

Activity_PageView

Retrieve Page View Activities. This table is only supported in bulk mode.

Table Specific Information

Select

COUNT is supported for this table.

Columns

Name Type Description
ID [KEY] Long The unique identifier of the page view activity.
CreatedAt Datetime The date and time the page view activityactivity was created.
Type String The type of the activity associated with the page view activity.
ContactId Long The Id of the contact who performed the page view activity.
IPAddress String The IP address of the sender.
Url String The URL of the page view activity.
CampaignId Long The Id of the campaign associated with the page view activity.
ReferrerUrl String The referrer URL of the page view activity.
VisitorId Long The visitor Id of the page view activity.
VisitorExternalId String The visitor external Id of the page view activity.
WebVisitId Long The Web visit Id of the page view activity.
IsWebTrackingOptedIn Boolean Whether the visitor who performed the page view activity has opted into Web tracking.
ExternalId String The ExternalId associated with the page activity. Only supported in bulk mode.
FirstName String The FirstName of the contact associated with the page view activity.
LastName String The LastName of the contact associated with the page view activity.
Company String The Company of the contact associated with the page view activity.
City String The City of the contact associated with the page view activity.
ContactCreatedAt Datetime The date and time the contact associated with the page view activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the page view activity was created.
Address1 String The first line address of the contact associated with the page view activity.
Address2 String The second line address of the contact associated with the page view activity.
Title String The Title of the contact associated with the page view 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462