DIM_CAMPAIGN_PROPERTY
Updated
This table stores essential details about campaign assets, including unique identifiers, custom properties, and modification timestamps. The purpose of this table is to manage campaign configurations effectively, support auditing, and provide a reliable source for campaign-related metadata. Below are some of the scenarios where this Report is beneficial:
Campaign Asset Management and Reporting: Track and organize campaign assets using identifiers and custom properties to support campaign performance analysis and segmentation.
Configuration Auditing and Change Tracking: Monitor modification timestamps and campaign metadata to maintain an audit trail of campaign updates and configuration changes.
Campaign Metadata Enrichment: Use campaign attributes and custom properties to enrich reporting, filter campaign data, and support business-specific analytics and governance requirements.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
ASSET_ID | Unique identifier of the campaign asset. | VARCHAR | No | No | Yes |
RECORD_ID | Unique identifier for the campaign record; primary key of the table. | VARCHAR | No | No | No |
CAMPAIGN_OWNER_ID | User ID of the agent who owns or manages the campaign. | VARCHAR |
| No | No |
CAMPAIGN_STATUS | Current lifecycle status of the campaign Samples: APPROVED, DRAFT |
VARCHAR |
|
No |
No |
CLIENT_ID | Identifier of the client/tenant associated with the campaign. | VARCHAR |
| No | No |
LAST_MODIFIED_AGENT_ID | User ID of the agent who last modified the campaign configuration. | VARCHAR |
| No | No |
CAMPAIGN_GOAL | Objective or goal defined for the campaign (e.g., Awareness, Conversion). | VARCHAR |
| 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.