How do I analyze the growth of each audience per month?

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered
I have exported the audience groups I want to analyze. I then try to sort them by "member since", to see how many members were added each month.  Is there a reason that I cannot sort them out from most recent day to less recent day?  It will sort by date, but not by year, i.e. all of my August 31st are together, from 2014, 2015 so it doesn't actually sort by calendar date.  Additionally, I have no recent dates although I know I've been adding members.  I only have a handful of new members in 2016, and I have to find them manually.  Is something wrong with the dating system?  Please assist.
Photo of King Bio

King Bio

  • 19 Posts
  • 2 Reply Likes

Posted 2 years ago

  • 0
  • 2
Photo of Laura Dickerson

Laura Dickerson, Official Rep

  • 778 Posts
  • 64 Reply Likes
Official Response
Hi there, 

First, let me say I am no Excel wizard, but I believe what you will need to do is break the "member_since" column into separate month, date and year columns and sort that way. I know there is a formula for this and I think this will work: https://support.office.com/en-us/article/Distribute-the-contents-of-a-cell-into-adjacent-columns-ce6... but I am thinking there may be an easier way. 

I am checkin on this and I will let you know what I find out!!!!