JDBC Driver for Salesforce Pardot

Build 22.0.8462

Visits

Retrieve visits.

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 '=', '<', '<=', '>', '>='.
  • VisitorId supports '=', '<', '<=', '>', '>='.
  • ProspectId supports '=', '<', '<=', '>', '>='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Visits WHERE Id = 22
SELECT * FROM Visits WHERE VisitorId > 234

Columns

Name Type References Description
Id [KEY] Int64 ID of the object.
VisitorId Int64

Visitors.Id

Pardot ID for the associated visitor.
ProspectId Int64

Prospects.Id

Pardot ID for the associated prospect.
VisitorPageViewCount Integer Number of page views for this visit.
FirstVisitorPageViewAt Datetime Time of first page view for this visit.
LastVisitorPageViewAt Datetime Time of last page view for this visit.
DurationInSeconds Integer Length of this visit.
CampaignParameter String Visit's campaign parameter utm_campaign from Google Analytics.
MediumParameter String Visit's medium parameter utm_medium from Google Analytics.
SourceParameter String Visit's source parameter utm_source from Google Analytics.
ContentParameter String Visit's content parameter utm_content from Google Analytics.
TermParameter String Visit's term parameter utm_term from Google Analytics.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.

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