crm_cs_entities_table
The CRM CS Entities table records key events in the customer relationship management system related to customer success entities. By querying this table, users can analyze and categorize CRM CS events across different dimensions, gaining valuable insights into trends and activities over time, as well as identifying patterns related to specific customers or entities.
Note
event_dateis a required field for queries on this table.
Dimensions
Dimensions are immutable properties that can be used for grouping data.
| ID | Type | Description |
|---|---|---|
event_date | date | The date the CRM CS entity event occurred. Based on the time zone of the shop at the moment of the CRM event. |
event_date.day | date | The day the CRM CS entity event occurred. Derived from event_date. |
event_date.week | date | The Sunday of the week during which the CRM CS entity event occurred. Derived from event_date. |
event_date.month | date | The month during which the CRM CS entity event occurred. Derived from event_date. |
event_date.quarter | date | The first month of the quarter during which CRM CS entity event occurred. Derived from event_date. |
event_date.year | date | The year during which the CRM CS entity event occurred. Derived from event_date. |
email | string | The email address associated with the event. |
entity_id | string | The unique ID of the entity associated with the event. |
entity_type | string | The type of entity associated with the event. |
owner_first_name | string | The first name of the owner associated with the event. |
owner_last_name | string | The last name of the owner associated with the event. |
team_name | string | The name of the team associated with the event. |