JDBC Driver for Salesforce Marketing Cloud Account Engagement

Build 24.0.9062

Visits

Retrieve visits.

Columns

Name Type References Description
Id [KEY] Int64 Pardot ID for this visit.
VisitorId Int64

Visitors.Id

Pardot ID for the associated visitor.
ProspectId Int64

Prospects.Id

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062