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 5 years ago

  • 0
  • 2
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Hello! Can you please upload this Excel file to your document library, so I can take a look? To do this, just head over to your campaigns page and then click on documents in the upper right corner. This will prompt you with a pop-up and then allow you to upload a doc. I'll then jump in there to do some research.

Thanks!
Photo of Reynolds Journalism Institute

Reynolds Journalism Institute

  • 27 Posts
  • 0 Reply Likes
What Excel file are you talking about?
Photo of Tyler Scott

Tyler Scott, Employee

  • 805 Posts
  • 39 Reply Likes
Hey there! I saw you had performed an import yesterday and I was curious if zip codes were included in that file. There can sometimes be formatting in the Excel file which can play into a .0 being tacked on upon importing into Emma. I wanted to take a look to see if that could be the culprit.

Thanks!
Photo of Reynolds Journalism Institute

Reynolds Journalism Institute

  • 27 Posts
  • 0 Reply Likes
No, this isn't about imported files (none of the imports I've done included ZIP codes). This happens in Emma with records created in Emma.
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!
Photo of Kiko

Kiko

  • 6 Posts
  • 1 Reply Like
How can I change a field option to include commas but not the decimal? I have a spreadsheet that have large numbers but the short answer removes the thousandth commas (Example: 34,322 changes to 34322)
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Hi Kiko! I'm creating a new conversation for us to research and talk through your question, since it's a bit different from the main topic here. :)

Please reference the new conversation here: Include commas in contact field with numbers