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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。
| 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. |