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:
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) | ![]() |
Unique segment ID: Personalization internal value |
name | VARCHAR (100) | ![]() |
Name of the segment (for example, All article pages ) |
tracking_id | VARCHAR (100) | ![]() |
Shortened machine name of the segment name, from the Personalization segment builder |
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) | ![]() |
Link to an existing ID for an event in the Event table: Personalization internal value |
person_id | INT (8 bytes) | ![]() |
Link to an existing id for a person Personalization internal value |
segment_id | INT (4 bytes) | ![]() |
Link to an existing ID for a segment in the Segments table Personalization internal value |
db_last_modified_date | TIMESTAMP | ![]() |
The UTC time and date when the row was last modified in the database |