Excel Add-In for Salesforce Pardot

Build 21.0.7930

VisitorActivities

Retrieve visitor activities.

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 '=', '<', '<=', '>', '>='.
  • ProspectId supports '='.
  • VisitorId supports '='.
  • EmailId supports '='.
  • FormId supports '='.
  • FormHandlerId supports '='.
  • LandingPageId supports '='.
  • FileId supports '='.
  • CampaignId supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM VisitorActivities WHERE Id = 16
SELECT * FROM VisitorActivities WHERE ProspectId = 46
SELECT * FROM VisitorActivities WHERE VisitorId = 21

Columns

Name Type Description
Id [KEY] Integer Pardot ID for this visitor activity.
ProspectId Integer Pardot ID for the associated prospect.
VisitorId Integer Pardot ID for the associated visitor.
Type Integer Visitor activity's type number; See listing below.
TypeName String Visitor activity's type name; See listing below.
Details String Details about this visitor activity such as the name of the object associated with this activity, the search phrase used in a site search query, etc.
EmailId Integer Pardot ID of the email associated with this visitor activity Note: This node will only appear if this visitor activity has an email associated with it.
EmailTemplateId Integer Pardot ID of the email template associated with this visitor activity Note: This node will only appear if this visitor activity has an email associated with it.
ListEmailId Integer Pardot ID of the list email associated with this visitor activity Note: This node will only appear if this visitor activity has an email associated with it.
FormId Integer Pardot ID of the form associated with this visitor activity Note: This node will only appear if this visitor activity has a form associated with it.
FormHandlerId Integer Pardot ID of the form handler associated with this visitor activity Note: This node will only appear if this visitor activity has a form handler associated with it.
SiteSearchQueryId Integer Pardot ID of the site search query associated with this visitor activity Note: This node will only appear if this visitor activity has a site search query associated with it.
LandingPageId Integer Pardot ID of the landing page associated with this visitor activity Note: This node will only appear if this visitor activity has a landing page associated with it.
PaidSearchIdId Integer Pardot ID of the paid search ad associated with this visitor activity Note: This node will only appear if this visitor activity has a paid search ad associated with it.
MultivariateTestVariationId Integer Pardot ID of the multivariate test variation associated with this visitor activity Note: This node will only appear if this visitor activity has a multivariate test variation associated with it.
VisitorPageViewId Integer Pardot ID of the visitor page view associated with this visitor activity Note: This node will only appear if this visitor activity has a visitor page view associated with it.
FileId Integer Pardot ID of the file associated with this visitor activity Note: This node will only appear if this visitor activity has a file associated with it.
CampaignId Integer Campaign id.
CampaignName String Campaign name.
CampaignCost Integer Campaign cost.
CreatedAt Datetime Time that visitor activity occurred.

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