DIM_CUSTOMER_PROFILE
Updated
The DIM_CUSTOMER_PROFILE dimension table stores foundational information about customer profiles, including unique identifiers, creation and modification timestamps, and engagement details. It also maintains versioning for change tracking. This table serves as a central reference for customer identity and profile management, enabling accurate reporting, personalization, and data integrity across the platform. Below are some of the scenarios where this Report is beneficial:
Customer Profile Management and Identity Resolution: Maintain a centralized view of customer profiles using unique identifiers and version history to ensure consistent customer identification across interactions and channels.
Customer Segmentation and Personalization: Leverage profile attributes and engagement data to segment customers, deliver personalized experiences, and support targeted business initiatives.
Customer Lifecycle and Engagement Reporting: Analyze customer creation, modification, and engagement trends to understand customer behavior, track profile evolution, and improve data-driven decision making.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
RECORD_ID | Unique identifier for the record; serves as the primary key. | VARCHAR | NO | No | Yes |
CREATED_TIMESTAMP | Epoch timestamp indicating when the record was initially created. | NUMBER | NO | No | No |
IS_DELETED_FLAG | Flag indicating whether the record has been soft-deleted. | BOOLEAN | NO | No | No |
ENGAGED_ACCOUNT_IDS |
List of account identifiers that have engaged with this profile or entity. Format: ["Value"] |
VARIANT |
NO |
No |
No |
MODIFIED_TIMESTAMP | Epoch timestamp indicating when the record was last modified. | NUMBER | NO | No | No |
PROFILE_CREATED_TIMESTAMP | Timestamp indicating when the customer/profile was created. | NUMBER | NO | No | No |
PROFILE_MODIFIED_TIMESTAMP | Timestamp indicating when the customer/profile was last updated. | NUMBER | NO | No | No |
RECORD_VERSION | Version number of the record used for concurrency control or change t | NUMBER | 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.