JDBC Driver for Salesforce Pardot

Build 22.0.8462

VisitorActivities

Retrieve visitor activities.

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID for this visitor activity.
ProspectId Int64

Prospects.Id

Pardot ID for the associated prospect.
VisitorId Int64

Visitors.Id

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 Int64

Emails.Id

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 Int64

EmailTemplates.Id

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 Int64 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 Int64

Forms.Id

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 Int64 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 Int64 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 Int64 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 Int64 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 Int64 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 Int64 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 Int64 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 Int64

Campaigns.Id

Campaign id.
CampaignName String Campaign name.
CampaignCost Integer Campaign cost.
CreatedAt Datetime Time that visitor activity occurred.

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