Insight model score feed layout sample

The following table provides sample values for the feed layout definition. In this sample, a single record uses the insights model score feed layout, but the sample file contains a few generic examples.

Given the data in this file needs to align with the data in your Redpoint CDP, the IDs need to match. This file can be used as a reference, but cannot be loaded unless the entity IDs exist within your CDP.

cfl - insight model score sample records 202411.csv

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Field description	Field data type/length	Sample values
System of Record Name	`sor_name`	Name of the system that is the authoritative data source for a record.	`char(100)`	`Modeling Vendor A`
Identity Id	`identity_id`	(Required) This field is the natural primary key. Uniquely identifies the record that insight information (model scores or segments) belongs to. Can support any of identity ID types described in the line below.	`char(320)`	`100000000117`
Identity Id Type Code	`identity_id_type_code`	(Required) This field is the natural primary key. Defines the type of identity ID as party profile, email, individual, or household. Valid values: `party_profile_id` when identity ID contains source party profile ID `email_id` when identity ID contains RPG's email ID `individual_id` when identity ID contains RPG's individual ID `household_id` when identity ID contains RPG's household ID	`char(50)`	`individual`
Business Unit Code	`business_unit_code`	Business Unit identifies the structure of brands within an organizational entity. It is the way in which the brands within a company's portfolio are related to, and differentiated from, one another. Values are defined as part of on-boarding, in `BUSINESS_UNIT_LOOKUP`; `NULL` values will default to `org`. Refer to Business unit for details.	`char(50)`	`bu code 2`
Source Model Id	`source_model_id`	(Required) This field is the natural primary key. Uniquely identifies a marketing model.	`char(50)`	`P2P_Individual_01`
Raw Score Type	`raw_score_type`	(Required) This field is the natural primary key. Supports multiple predictions per individual/model.	`varchar(64)`	`Raw Score Type V1`
Raw Score	`raw_score`	Raw model score. (The values or scores that are created can represent predictions of future values, but they might also represent a likely category or outcome.)	`decimal(12,6)`	`60`
Quartile Score	`quartile_score`	Quartile Score.	`decimal(12,6)`
Quintile Score	`quintile_score`	Quintile Score.	`decimal(12,6)`
Decile Score	`decile_score`	Decile Score.	`decimal(12,6)`
Demi Decile Score	`demi_decile_score`	Demi Decile Score.	`decimal(12,6)`
Score Datetime	`score_datetime`	(Required) This field is the natural primary key. Date when the model was run for this resolution: (`YYYY-MM-DD HH:mm:ss`).	`datetime`	`10/12/2024 10:00`
Segment Id	`segment_id`	Marketing Segment.	`varchar(20)`	`MP`
Segment Value	`segment_value`	Marketing Segment.	`varchar(64)`	`2`
Segment Description	`segment_desc`	Marketing Segment.	`varchar(512)`	`Might Purchase`
Segment Datetime	`segment_datetime`	(Required) This field is the natural primary key. Date when the segment was assigned for this resolution: (`YYYY-MM-DD HH:mm:ss`).	`datetime`	`10/12/2024 10:00`
Source Record Create Datetime	`source_rec_create_datetime`	The datetime when the record was created at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Source Record Update Datetime	`source_rec_update_datetime`	The datetime of the latest update of the record at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`