1 Reply Latest reply on Aug 3, 2010 5:08 PM by shannon_marie

    Weekly Individual/Collective Post count by userID

    mark.schwanke

      I looked at the database schema briefly and I'm not sure if you can get the following information very easily.

       

      I have the following users. I would like to find out their weekly average individual post counts. From this I'd also like to know their collective weekly average post counts. This include replies and root posts. Can this be easily done? And if so and pointers for a Analytics for Dummies user?

       

       

      userId=2004
      userId=2006
      userId=18504
      userId=30550
      userId=4302
      userId=19888
      userId=2603
      userId=3352
      userId=7384
      userId=5821
      userId=8663
      userId=2183
      userId=17939

       

      Mark

        • Re: Weekly Individual/Collective Post count by userID
          shannon_marie

          Hi Mark,

           

          I'm actually looking to do something similar. I'm looking to find some analytics in order to assess who my top performing members month by month are in the overall space. Just something where I can give them a little bit of recognition for their work. Like a "Top Ten Users for July," and then August, Septemer, etc.

           

          DId you make any progress on getting your numbers? If so, I think it might be helpful for me.

           

          Let me know.

           

          Thanks!

          Shannon

           

          (BTW, I use Business Objects for my analytics and don't have access to the SQL editor in the system, for whatever reason.)