Why does Emma append a .0 (dot zero) to some of the ZIP codes on my audience list?

  • 0
  • 2
  • Question
  • Updated 4 years ago
  • Answered
Why does Emma append a .0 (dot zero) to some of the ZIP codes on my audience list?
Photo of Reynolds Journalism Institute

Reynolds Journalism Institute

  • 27 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 0
  • 2
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Official Response
Good morning! I took a closer look at those member fields and noticed zip code is set as a numeric field type which will indeed add a .0 to the end. Emma's default field type for postal code is short answer and this will eliminate that .0 from being tacked on. So a few steps to get that information updated. First you'll want to jump over to your audience page and click on manage fields in the upper right corner. On the pop-up where it says add more fields, you'll want to select postal code from the drop down and then click the add button off to the right.

Next you'll want to export your audience which will generate an Excel file for you with all of the current information. Then import that same list and when mapping your member fields you'll map the zip code information to that new postal code Emma member field. Once you have everything imported back in you can head back over to your audience to delete the old zip code member field. Again clicking on manage fields and then on the pop-up clicking on the red x to the right of zip code.

This will do the trick, but please let me know if you have any questions.

Thanks!