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!

Create Segments by Uploading a CSV

Avatar

Level 1

Hi,

 

Every month, the marketing team produces monthly marketing materials promoting various products (around 200-300). Is it possible to upload a CSV to create a segment with these product values instead of manually adding this in?

 

Thanks,

David

2 Replies

Avatar

Community Advisor and Adobe Champion

As far as I know, there isn't a way to upload a CSV into a segment, but you don't have to do each item on the same line. There are two different types of comparison operators that you can use - equals any of or contains any of. If you have 200-300 products, you probably wants "equals any of" since you can have up to 500 items per row. In your csv file, put a comma after each item, and then just copy it all and paste it into the single line, the comma will delimit the products for you.

If you want it to be space delimited instead you can use the "contains any of", but that only lets you do 100 per line. You can have more than one line and just use a hit container with an "or" operator if you wanted to do it that way.

 

Mandy_George_0-1663188062444.png

Mandy_George_1-1663188092012.png

 

Avatar

Community Advisor
Mandy_George is spot on here.
One more option is to create or group the products using classification and create the segment based on the classification value.
Thank You, Pratheep Arun Raj B (Arun) | NextRow Digital | Terryn Winter Analytics