VisitorsPageViews
Retrieve visitors page views.
Table Specific Information
Select
The connector will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports '=', '<', '<=', '>', '>='.
- VisitId supports '=', '<', '<=', '>', '>='.
- VisitorId supports '=', '<', '<=', '>', '>='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM VisitorPageViews WHERE VisitId = 22 SELECT * FROM VisitorPageViews WHERE Id >= 22 AND VisitorId = 1234
GetDeleted
To retrieve VisitorPageViews that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM VisitorPageViews
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | Pardot ID for this visitor page view. | |
| Url | String | The Url of the page. | |
| Title | String | The Title column of the VisitorsPageViews object. | |
| VisitId | Int64 | Pardot ID for this visit. | |
| VisitorId | Int64 | Pardot ID for the associated visitor. | |
| CampaignId | Int64 | Pardot campaign related to this object. | |
| SalesforceId | String | Salesforce Id of the object. | |
| DurationInSeconds | Integer | Length of this page view. | |
| CreatedAt | Datetime | The timestamp of when this object was created. |