JDBC Driver for Salesforce Pardot

Build 22.0.8462

VisitorsPageViews

Retrieve visitors page views.

Table Specific Information

Select

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

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462