Forum Discussion

Bonfire-Champ's avatar
Bonfire-Champ
Active Member II
2 years ago

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?

3 Replies

  • Bonfire-Champ's avatar
    Bonfire-Champ
    Active Member II

    are you able to enter multiple zip codes in the same cell? or do you need to use "OR" for each zip code?

  • Bonfire-Champ's avatar
    Bonfire-Champ
    Active 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.