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