Sort audience groups alphanumerically instead of asciibetically

  • 2
  • Idea
  • Updated 3 years ago
  • Not Planned
  • (Edited)
I upload a list of email addresses each week, giving the group a name designating the week the list was uploaded.  The way the data is being displayed is what my database manager calls "ascii-betically" instead of "alpha/numerically".  (I have no idea what that means, but he seemed to think that a programmer would)  Your database isn't sorting by the number, but instead, by the string, so, in that way, 10/26/14 would come before 10/5/14 only because "2" comes before "5", but it doesn't recognize that it's actually "26", which would come after "5".  This isn't a HUGE deal, but it does make it a lot harder and more confusing to find the group I want in a long list.  

See my screenshot below for an explanation.  This sorting happens on the Audience page, and also when you go to send an email out and have to select the group you want to send it out to.  

Photo of Matt Morrisson

Matt Morrisson

  • 5 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 2
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
I see what you mean! I'm checking in with our Product Team to learn what our options are here. I'll keep you posted. :)
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Oh, and I've tweaked this subject line for others searching for the same thing!
Photo of Matt Morrisson

Matt Morrisson

  • 5 Posts
  • 0 Reply Likes
Thanks, Katie!  I'd be willing to bet that "asciibetically" doesn't come up in your search queries all that often, though.  :P
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
I'll admit: I Googled it. :) I've added tags to this conversation behind the scenes to make it more searchable, too, based on keywords and phrases, while I wanted the subject line to reflect your specific request. I think it will help!

Chatting with a couple folks here so far, our suggestion is to rename your groups YYYY/MM/DD, like 2014/11/06, as that's the most reliable for sorting. We don't suggest using single digits and instead advise leading with a zero.

Would that help?
Photo of Matt Morrisson

Matt Morrisson

  • 5 Posts
  • 0 Reply Likes
Probably, even though that kind of formatting is just plain un-American <wink>.  In the long run, though, I can't imagine I'm the only one that formats my dates that way. Seems like it would make more sense, long-term, to have your database sort in accordance to the way people type dates and numbers out.  
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
I hear you! We all format dates differently -- Myself, I'm a fan of 7 November 2014. For database sorting, though, we do recommend the above format.

We don't have plans to change those sorting methods, and I'm glad you got us talking about and thinking through this!
Photo of Prime Health Services

Prime Health Services

  • 5 Posts
  • 0 Reply Likes
I noticed this "issue" this morning when I was renaming my audience group names. I support this idea!