Which field should be selected to include both Active and Expired members in incremental exports?

To include both Active and Expired members in incremental exports, the correct field to select is segmentMembership.status. This field is specifically designed to indicate the membership status of segments within the Adobe Real-Time Customer Data Platform.

Using segmentMembership.status allows you to filter for members regardless of their current activity status, capturing the full range of users who may have belonged to a particular segment, including those who are currently active and those who have expired. This is crucial for analyses that require a comprehensive understanding of user engagement over time.

The other fields listed do not serve the same function. For example, userStatus may be more focused on the overall user account health but may not specifically delineate between members of segments. Meanwhile, accountStatus might pertain to user account integrity but won't necessarily provide the specific segmentation details, and membershipCategory might classify users but lacks the clarity regarding their current participation in a segment. Thus, segmentMembership.status is the appropriate choice for achieving a comprehensive export of both active and expired members within the context of segmented data analysis.