Customer segment history

Customer segment history dataset. Each customer entry into a segment and each exit from a segment will be represented by separate records in the dataset.

exports.CDP.CustomerSegmentHistory

ColumnTypeDescriptionExample
idint64ID of the event2578932
unmergedCustomerIdint64Internal customer ID at the time of the event12381
segmentationIdintInternal segmentation ID15
segmentIdstringInternal segment ID. NaN - if segment exit occurred23
calculatedDateTimeUtcdatetimeDate when the client entered/exited the segment2025-02-27 11:41:31.890
_isDeletedbool (nullable)Indication that the record has been deletedTrue
_rowversion_tsdatetimeTimestamp when data became available for export2024-10-15 10:00:00.000