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 |
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 |
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 |