Visits
Retrieve visits.
Table Specific Information
Select
The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Id supports '=', '<', '<=', '>', '>='.
- VisitorId supports '=', '<', '<=', '>', '>='.
- ProspectId supports '=', '<', '<=', '>', '>='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Visits WHERE Id = 22 SELECT * FROM Visits WHERE VisitorId > 234
Columns
| Name | Type | References | Description |
| Id [KEY] | Int64 | ID of the object. | |
| 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 | The timestamp of when this object was created. | |
| UpdatedAt | Datetime | The timestamp of when this object was last updated. |