DIM_CLIENT_GROUP
Updated
DIM_CLIENT_GROUP is a dimension table that stores metadata and grouping information for clients, including group membership details, ownership, naming attributes, and lifecycle timestamps. It enables analysis, segmentation, and management of clients organized into logical groups. Below are some of the scenarios where this Report is beneficial:
Client Segmentation and Portfolio Analysis: Group clients into logical business units, regions, or customer segments to enable consolidated reporting and comparative performance analysis.
Client Group Management and Governance: Track client group ownership, membership, and lifecycle changes to support administration, auditing, and organizational oversight.
Group-Based Reporting and Operational Insights: Analyze business metrics, engagement trends, and operational performance at the client-group level to identify opportunities for optimization and strategic decision-making.
Field Mapping/ Glossary
The report will include the following information:
Expected Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
CLIENT_GROUP_ID | Unique identifier of the client group | VARCHAR | No | No | Yes |
CLIENT_GROUP_CONTAINED_IDS | Variant object containing the list of client or entity IDs that are part of the client group Format: ["Value"] |
VARIANT |
No |
No |
No |
CLIENT_GROUP_MODIFIED_TIMESTAMP | Timestamp indicating when the client group record was last modified | TIMESTAMP_LTZ | No | No | No |
CLIENT_GROUP_NAME | Name assigned to the client group for identification and reporting | VARCHAR | No | No | No |
CLIENT_GROUP_OWNER_AGENT_ID | Identifier of the agent who owns or manages the client group | VARCHAR | No | No | No |
CLIENT_ID | Identifier of the client or tenant associated with the client group | VARCHAR | No | No | No |
CREATED_TIMESTAMP | Timestamp indicating when the client group record was created | TIMESTAMP_LTZ | No | No | No |
GROUP_NAME | Display or alternate name used for the client group | VARCHAR | No | No | No |
IS_DELETED_FLAG | Flag indicating whether the client group record has been soft-deleted Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
Intended Use and Prohibited Uses
DataStream is intended solely to support operational efficiency, service delivery, business intelligence, and process optimisation. The product is not designed or intended for employee monitoring, workplace surveillance, performance evaluation, profiling of individuals, or making decisions that materially affect an individual's employment, rights, opportunities, or access to services.
DataStream does not process biometric data for the purpose of identifying individuals and does not perform emotion recognition, affect detection, or emotion inference in the workplace.
Customers must not use DataStream in a manner inconsistent with these intended purposes and remain responsible for ensuring compliance with applicable legal and regulatory requirements as well as with Sprinklr's Acceptable Use Policy.