WebAnalytics
Allows developers to filter and retrieve web analytics events associated with CRM objects.
View Specific Information
SELECT
EventType, or ObjectType and either ObjectId or ObjectProperty must be specified.
When selecting WebAnalytics, they can only be filtered by the EventType, ObjectType, ObjectId, ObjectProperty, OccurredAfter, OccurredBefore and Sort. For example:
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 a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| 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. |