Information for: DEVELOPERS   PARTNERS

Data warehouse Segment field types

The data warehouse uses the Segments field layout to describe segments associated with each event for a given person.

The Segments field layout includes the following tables:

segment table

The Segment table contains a list of the segments in Personalization and synchronizes with the configuration database.

Field name Data type Sortable Description
id INT (4 bytes) yes Unique segment ID: Personalization internal value
name VARCHAR (100) no Name of the segment (for example, All article pages)
tracking_id VARCHAR (100) no Shortened machine name of the segment name, from the Personalization segment builder

matched_segment table

The Matched_segment table contains a list of the events and segment information associated with each segment and links the Segment table to the Event table.

Field name Data type Sortable Description
event_id INT (8 bytes) yes Link to an existing ID for an event in the Event table: Personalization internal value
person_id INT (8 bytes) no Link to an existing id for a person Personalization internal value
segment_id INT (4 bytes) yes Link to an existing ID for a segment in the Segments table Personalization internal value
db_last_modified_date TIMESTAMP no The UTC time and date when the row was last modified in the database