Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Create segment from list or delimited list

Damon_Hall
Level 2
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
Urs_Boller
Correct answer by
Community Advisor
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

0 Replies
Urs_Boller
Correct answer by
Community Advisor
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

BrianTopham
Employee
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.

Damon_Hall
Level 2
Level 2

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