Excel Add-In for Salesforce Pardot

Build 21.0.7930

Visitors

Retrieve visitors.

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

For example, the following queries are processed server side:

SELECT * FROM Visitors WHERE Id = 44
SELECT * FROM Visitors WHERE CreatedAt > '02/03/2019 23:11:33'
SELECT * FROM Visitors WHERE UpdatedAt > '01/03/2018 23:11:33' AND UpdatedAt <= '02/03/2019 23:11:33'

Columns

Name Type Description
Id [KEY] Integer Pardot ID for this visitor.
PageViewCount Integer Number of page views by this visitor.
IpAddress String Visitor's IP address.
Hostname String Visitor's hostname.
CampaignParameter String Visitor's campaign parameter utm_campaign from Google Analytics.
MediumParameter String Visitor's medium parameter utm_medium from Google Analytics.
SourceParameter String Visitor's source parameter utm_source from Google Analytics.
ContentParameter String Visitor's content parameter utm_content from Google Analytics.
TermParameter String Visitor's term parameter utm_term from Google Analytics.
CreatedAt Datetime Time visitor was created in Pardot.
UpdatedAt Datetime Last time visitor was updated in Pardot.
ProspectId Integer Selects visits with the given Prospect IDs.

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