Skip to main content
Skip table of contents

Insight model score feed layout definition

This page provides the feed layout definition for the Insight Model Score Feed Layout. This feed is used to load model scores/segments to the Redpoint CDP based on an associated entity ID. The data is loaded to the appropriate tables in the data model.

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

System of Record Name

sor_name

Name of the system that is the authoritative data source for a record. 

char(100)

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)

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)

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)

Source Model Id

source_model_id

(Required)

This field is the natural primary key.

Uniquely identifies a marketing model.

char(50)

Raw Score Type

raw_score_type

(Required)

This field is the natural primary key.

Supports multiple predictions per individual/model. 

varchar(64)

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)

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

Segment Id

segment_id

Marketing Segment.

varchar(20)

Segment Value

segment_value

Marketing Segment.

varchar(64)

Segment Description

segment_desc

Marketing Segment.

varchar(512)

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

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.