ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

VisitorsPageViews

Retrieve visitors page views.

Table Specific Information

Select

The provider will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the provider.

  • 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

Columns

Name Type References Description
Id [KEY] Integer Pardot ID for this visitor page view.
Url String The Url of the page.
Title String The Title column of the VisitorsPageViews object.
VisitId Integer Pardot ID for this visit.
VisitorId Integer Pardot ID for the associated visitor.
CampaignId Integer 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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137