Forum Discussion
Bonfire-Champ
2 years agoActive Member II
segment location question
Hey everyone - trying to create a segment that pulls in anyone in a 50mi radius. We have a list of 103 zip codes -- what is the best way to leverage the logic to avoid doing 1 OR 2 OR 3 OR ... 103?
Bonfire-Champ
2 years agoActive Member II
I enter them all into the same cell with pipe delimator. so 55032|55104|10001 I usually copy from a csv or excel into word and do a quick find and replace (find paragraph and replace with pipe) that makes it much easier than copying the codes one by one. There may be some online programs that do this as well. But the filter is equals and then you can use pipes as the OR statements. I will flag that you do not want to do this with “does not match regex” that will be the same as using OR statements with negative filtering. If you are excluding a list of zips like this is is better to create an inclusive segment and then suppress that segment within the overall audience criteria.
Related Content
- 2 years ago