Excel Add-In for Salesforce Pardot

Build 21.0.7930

Visits

Retrieve visits.

Table Specific Information

Select

The add-in will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

  • Id supports '=', 'IN'.
  • VisitorId supports '=', 'IN'.
  • ProspectId supports '=', 'IN'.

For example, the following queries are processed server side:

SELECT * FROM Visits WHERE Id = 22
SELECT * FROM Visits WHERE Id IN (22, 34, 57)

Columns

Name Type Description
Id [KEY] Integer Pardot ID for this visit.
VisitorId Integer Pardot ID for the associated visitor.
ProspectId Integer 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 Time visit was created in Pardot.
UpdatedAt Datetime Last time visit was updated in Pardot.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930