Members Segments
The current segment membership of every member, exported daily as a full snapshot.
The Members Segments file lists every member who belongs to at least one segment, together with the IDs of all their segments.
Snapshot export. This is not a delta file. Each file contains the complete segment membership at the time the file was produced, not the changes made that day. Replace the previous day's data with the new file; do not merge files together. A member who is no longer in any segment is not included, so they only disappear from the file; no row marks the removal.
File: analytics/Segments/members_segments_YYYY_MM_DD.csv
Primary key: memberId + storeId
The date in the file name is the day before the file was produced. The content reflects segment membership at the time the file was produced, shortly after midnight, not at a precise cut-off.
Available data (in column order):
memberId
uuid
No
ID of the member
storeId
uuid
No
ID of the tenant
segmentIds
json array
No
IDs of the segments the member belongs to
Last updated
Was this helpful?