DIM_OUTBOUND_AUDIENCE_LEAD
Updated
The DIM_OUTBOUND_AUDIENCE_LEAD dimension table stores detailed information about outbound audience leads, including customer identifiers, demographic data, connectivity status, lead source, and associated attributes. It also tracks timestamps for creation, modification, interactions, and call attempts, along with lead list and segment associations. This table is designed to support outbound engagement workflows by enabling lead segmentation, performance analysis, and campaign optimization, ensuring accurate targeting and effective audience management.
Below are some of the scenarios where this Report is beneficial:
Lead Segmentation & Targeting: Store customer identifiers, demographic data, connectivity status, and lead source to enable precise audience segmentation and targeting.
Workflow & Interaction Tracking: Capture timestamps for creation, modification, interactions, and call attempts, along with lead list and segment associations to support outbound engagement workflows.
Performance & Campaign Optimization: Provide structured data for analyzing lead performance, reducing inefficiencies, and optimizing campaign strategies for effective audience management.
Field Mapping/ Glossary
The report will include the following information:
Expected Name | Definition | Data Type | Nullable & Default Value | Comments | PII Field | Unique Key |
RECORD_ID | Unique identifier of the record. | VARCHAR | No |
| No | Yes |
AGGREGATED_BY_VALUE | Value used for aggregation in reports or analysis. | VARCHAR | No |
| No | No |
CUSTOMER_ID | Unique identifier of the customer. | VARCHAR | No |
| No | No |
FIRST_LEAD_EVENT | First lead event associated with the customer. | VARCHAR | Yes, NULL |
| No | No |
LEAD_LIST_ID | Identifier of the lead list to which the record belongs. | VARCHAR | Yes, NULL |
| No | No |
LEAD_NUMBER | Unique lead number. | VARCHAR | Yes, NULL |
| No | No |
LEAD_SOURCE | Source from which the lead originated. | VARCHAR | Yes, NULL |
| No | No |
SEGMENT_ID | Identifier of the segment associated with the lead. | VARCHAR | Yes, NULL |
| No | No |
SOURCE_NAME | Name of the source for the lead. | VARCHAR | Yes, NULL |
| 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.