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

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

Level 2

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

Moderator
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