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 | Sortable | Description | |
|---|---|---|---|
id | INT (4 bytes) | ✓ | Unique segment ID: Personalization internal value |
name | VARCHAR (100) | 𐄂 | Name of the segment (for example, |
tracking_id | VARCHAR (100) | 𐄂 | 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 | 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 |