WebAnalytics
Allows developers to filter and retrieve web analytics events associated with CRM objects.
View Specific Information
SELECT
When selecting WebAnalytics, the view can be filtered by EventType, ObjectType, ObjectId, ObjectProperty, OccurredAfter, OccurredBefore, and Sort. For those columns, the supported server-side operator is: =.
Specifying EventType, or ObjectType together with either ObjectId or ObjectProperty, is recommended to narrow down results and reduce the number of API requests made.
Note: Querying without filters is supported, but not recommended. The provider will issue one request per available event type, which can significantly impact performance.
SELECT * FROM WebAnalytics WHERE ObjectId = '74924128' AND ObjectType = 'contact' SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND OccurredAfter = '07/02/2020 09:45:50.829' SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND OccurredBefore = '07/02/2020 09:45:50.829' SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND Sort = 'occurredAt'
Columns
| Name | Type | References | Filterable | Description |
| Id [KEY] | String | False | Unique identifier for the event. | |
| ObjectId | String | False | Unique identifier of the associated object. | |
| ObjectType | String | False | Type of the associated object, such as contact, company, or deal. | |
| EventType | String | False | Type of event that occurred, such as page view or form submission. | |
| OccurredAt | Datetime | False | Timestamp indicating when the event occurred. | |
| Properties | String | False | Additional event-related properties or metadata. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| ObjectProperty | String | Required if ObjectId is not provided. Specifies a property and its value to match an object, formatted as 'propertyName_propertyValue'. | |
| OccurredAfter | Datetime | Start time for filtering events, provided as an ISO 8601 timestamp. | |
| OccurredBefore | Datetime | End time for filtering events, provided as an ISO 8601 timestamp. | |
| Sort | String | Field used to sort results. Defaults to ascending by 'occurredAt'; prefix with '_' for descending order. |