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 |
53 State Street, 10th Floor
Boston, MA 02109
United States
Phone: 888-922-7842