Trouble creating a segment using the state field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
Our audience is simple list, selected by opt-in elsewhere.  The only segments I need to separate are by state.  However, our states are stored by the two-letter abbreviation, and when I use the selector for state, I only get equals or does not equal and then a pre-configured drop-down list of fully-written-out state names.  What I need is contains so I can enter the two-letter abbreviation.  Help! is there a way to do a custom query?

Searching help doesn't yield anything specific to this situation and the forums give 48 pages of results :-(

FF ESR 38.5.2 but I don't imagine that's relevant to this problem.
Photo of Loh

Loh

  • 28 Posts
  • 6 Reply Likes
  • frustrated

Posted 3 years ago

  • 0
  • 1
Photo of Damian Gatta

Damian Gatta, Official Rep

  • 342 Posts
  • 43 Reply Likes
Official Response
Hi there!  

It is true that the State contact field contains the state spelled out completely so when running a segment based on this field, you would need to select either equals, does not equal, is empty or is not empty.  A workaround would be to export your full audience list from Emma then create an additional short answer contact field for State and re-import your list with the abbreviations for state.    Once the abbreviated states are imported to your audience, you would then be able to run a segment with "contains" as part of the criteria.

Let me know if you have any questions or if there is anything else I can do to help!