ODBC Driver for Salesforce Marketing Cloud Account Engagement

Build 23.0.8839

VisitorsPageViews

Retrieve visitors page views.

Table Specific Information

Select

The 本製品 will use the Salesforce Marketing Cloud Account Engagement API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id supports '=', '<', '<=', '>', '>='.
  • VisitId supports '=', '<', '<=', '>', '>='.
  • VisitorId supports '=', '<', '<=', '>', '>='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM VisitorPageViews WHERE VisitId = 22
SELECT * FROM VisitorPageViews WHERE Id >= 22 AND VisitorId = 1234

Columns

Name Type ReadOnly References Description
Id [KEY] Int64 True

Pardot ID for this visitor page view.

Url String True

The Url of the page.

Title String True

The Title column of the VisitorsPageViews object.

VisitId Int64 True

Pardot ID for this visit.

VisitorId Int64 True

Pardot ID for the associated visitor.

CampaignId Int64 False

Pardot campaign related to this object.

SalesforceId String True

Salesforce Id of the object.

DurationInSeconds Integer True

Length of this page view.

CreatedAt Datetime True

The timestamp of when this object was created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839