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 campaign.
CampaignId Int64

Campaigns.Id

Pardot ID for the associated campaign.
CustomRedirectId Int64

CustomRedirects.Id

Pardot ID of the custom redirect associated with this visitor activity Note: Appears only if this visitor activity has a custom redirect associated with it.
EmailId Int64

Emails.Id

Pardot ID of the email associated with this visitor activity. Appears only 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.
FileId Int64

Files.Id

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

FormHandlers.Id

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

LandingPages.Id

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

ListEmail.Id

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

Visits.Id

Pardot ID for the associated visit.
VisitorId Int64

Visitors.Id

Pardot ID for the associated visitor.
VisitorPageViewId Int64

VisitorsPageViews.Id

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

Opportunities.Id

Pardot ID for the associated opportunity.
ProspectId Int64

Prospects.Id

Pardot ID for the associated prospect.
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.
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.
PaidSearchAdId Int64 Pardot ID of the paid search ad associated with this visitor activity. Appears only if this visitor activity has a paid search ad 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.
Type Integer Visitor activity's type number.
TypeName String Visitor activity's type name.
CreatedAt Datetime The timestamp of when this object was created.
UpdatedAt Datetime The timestamp of when this object was last updated.

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