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. |