work with Array column in AJO

[chrisyan]

Hi Team,

We have recently introduced a new array-type field in the profile schema that stores all past offer codes for each profile. The field contains the offer codes, separated by commas, to avoid the need to load large amounts of data into the contact history event schema.

In the audience segment builder, rather than specifying individual offer codes to suppress sending the same email again, we plan to use this array field to exclude profiles who already received a specific offer. The logic we want to apply is a condition like "does not contain specific offer code" in the audience filter.

While I understand that array-type fields can be useful for storing multiple values in a single field (in this case, past offer codes), I am seeking further clarification on how this approach will work with the audience segmentation logic. Specifically:

1. Will the “does not contain” logic work effectively when comparing array values against a specific offer code?
2. Are there any best practices or considerations we should keep in mind when using array fields for audience segmentation?
3. Do you have documentation or resources that would provide more insight into the effective use of array fields in segmentation?

Thank you for your help and insights!

[SatheeskannaK · Accepted solution]

@chrisyan Take a look at this page for the best practices,

https://experienceleague.adobe.com/en/docs/experience-platform/xdm/schema/best-practices

For the 1st question, specifying the offer code works effectively as opposed to does not contain logic.