Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.