Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Create segment from list or delimited list

Avatar

Level 2

Hello,

I was wondering if it is possible to create a segment from a list.

Example, if I wanted to create a segment from the dimension "Products Owned" I would usually have to drag in that dimension several times, define as product equals "x", product equals "y", etc.

This is fin if you are looking at 10 or 20 such rows.  It really becomes time consuming if you are in the hundreds.  Especially if there isn't an opportunity to use "contains", etc.

The specific case that has made this more urgent is a request to create a segment from a list of ID numbers  see the example below:

1740068_pastedImage_1.png

See here that if the list was only 5 line items or 10, this is not an issue to create.  However, this is a list of 250.  So it will be a long process to create.

Is there not a way (as in Target) to use "contains" and separate by commas?  Example: SWID    Contains     SW123,SW1234,SW456, etc.

When I try using contains, contains all of, etc, the data either doesn't come int, or it varies greatly from taking the separate row approach.

My apologies if there is already a string for this.  I searched and couldn't seem to find anything with the terms I was using.

Thanks,

Damon

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

did you try "contains any of" and add the desired strings with space delimeter?

you can find more information here: https://marketing.adobe.com/resources/help/en_US/analytics/segment/seg_operators.html

Remark: maybe it's worth going for a classification. depending how many items you have and many segments you need or how dynamic the values are you could classify the items and create the segments based on the classified value. more here: https://marketing.adobe.com/resources/help/en_US/reference/classifications.html

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

did you try "contains any of" and add the desired strings with space delimeter?

you can find more information here: https://marketing.adobe.com/resources/help/en_US/analytics/segment/seg_operators.html

Remark: maybe it's worth going for a classification. depending how many items you have and many segments you need or how dynamic the values are you could classify the items and create the segments based on the classified value. more here: https://marketing.adobe.com/resources/help/en_US/reference/classifications.html

Avatar

Employee

Assuming you have a rather static list for your search criteria, if you run into any performance issues (which can happen on segments with many or complex contains statements) the other solution is to use classifications.

You can set all desired search criteria to the same classification value. Then do an equals segment criteria based off of the classification. I realize this is more work, but if performance becomes an issue use a contains any of criteria, it is the way to go.

Avatar

Level 2

Coolio, this worked!  Space delimited.  Thanks for all of your help!