ADO.NET Provider for Salesforce Pardot

Build 21.0.8137

Visits

Retrieve visits.

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 '=', '<', '<=', '>', '>='.
  • 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] Integer ID of the object.
VisitorId Integer Pardot ID for the associated visitor.
ProspectId Integer

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137