Personalization
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:
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 |
If this content did not answer your questions, try searching or contacting our support team for further assistance.
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Personalization