7 Replies Latest reply on Nov 22, 2010 4:31 PM by RyanSe

    Getting started with Analytics on a limited budget?


      Hi there,


      we've been into our Jive journey for just under a year and really wanted to know how our people are using the system. We know in some areas it is the tool of choice while others are still not sure. Our small governance group wanted to get the Analytics information and have some hard data complementing the qualitative information we get from talking to people.


      Now our budget for this has been cut and we've been asked to make do.


      My question for you is, what service other than Jive SBS Analytics do people use for getting basic statistics for their Jive Governance?


      Our thinking is along the lines

      • number of active users per week / month
      • number of creators per week/month
      • most active discussions
      • most active spaces
      • most active groups
      • number of new or updated documents


      Basically we've been asked is the Analytics module an overkill for such basic statistics.


      Appreciate your comments.



        • Re: Getting started with Analytics on a limited budget?

          Hi Frank,


          I am not sure if you are hosted by Jive or hosting internally but some of the questions you are asking can be assembled using a bit of elbow grease and the transactional/application database. Currently I live in a bit of a hybrid world where I am using the BusinessObjects BI OnDemand solution for some data (user/community activity) but then working directly with the database for other areas (document/discussion/question reporting).


          My origins for reporting came from an environment where our previous solution vendor didn't provide any sort of reporting/analytics module so I had to build my own from the ground up using only the database.


          The following recommendations assume you define active as "posting/voting of, or on, threads/documents/polls/videos". It isn't an elegant solution but if you only had the transactional/application database and something like MS Access/Excel to do some data massaging afterwords it will get the job done.


          The first phase is to get a table with all the necessary reporting elements on it. To do that:


          1. Extract the data w/ timestamps from the various content type tables  (document, thread, question, vote/rating, comments, etc) keeping a  format that offers you the necessary datapoints like objectID, userID,  container and so on.
          2. Mash all the data together in to one table/sheet and then use some built-in formulas to calculate week of year and month (offshoots of the DATE function).


          Here is how the reports would work then:


          • number of active users per week/month - Pivot table with count of userIDs based on the weekofyear column you calculated above. Plus: You can calculate the same information by container as well.
          • number of creators per week/month - Looking at documents and the root message in a thread, video creator, etc you can calculate against your week/month time interval.
          • most active discussions - Depends on how you define active again, but you could use the above dataset to calculate most replied to threads during the time interval.
          • most active spaces - Basically just swap out the data from the discussion column and replace with the column that identifies the container name (constrain to only container type 14 which is for Spaces).
          • most active groups - Same as most active spaces, just change the constraint to 700 for Groups.
          • number of new or updated documents - Using only the data from the documents, count how many documents had a modify date for the week/month or whatever the time interval.


          As you can see, it does take a bit of work to make happen. The analytics module does address these areas fairly well and eliminates the need to get too deep in the weeds. Personally speaking, having access to both sources extends my capabilities to provide meaningful analysis to my business partners.


          Hope this helps.

          1 person found this helpful
          • Re: Getting started with Analytics on a limited budget?

            If your community is externally facing. (Meaning your not an internal community manager). Google Analytics is free and very robust.