Enables 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 driver 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.

Pseudocolumns

Pseudocolumn 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.