3 Replies Latest reply on Dec 16, 2011 3:07 PM by kwameahene

    Reporting at the User Level?

    wengla02

      Hello!

       

      We have a request for our Intranet to report object views by user -- how many discussions did this user view; which users viewed this document etc.

       

      Is this possible with any SBS analytics plugin?

       

      What specific data is available?

       

      Thank you,

       

      Will England

        • Re: Reporting at the User Level?
          wengla02

          Any ideas?

            • Re: Reporting at the User Level?
              bcswissre

              Hi Will,

               

              It should be possible to retrieve this information from the analytics database.

               

              Not sure of the report time frames, but there are various aggregation tables which could be used and which group the data including the user id.

               

              e.g. JIVEDW_ACTIVITY_AGG_DAY groups the datase by day, user, activity type and object

              You could create a query of the form select from JIVEDW_ACTIVITY_AGG_DAY where user = youruser and direct_object_type=discussiontype and activity_type=VIEW

              OR for your other query example

              select unique user_id from JIVE_DW_ACTIVITY_AGG_DAY where direct_object_type=DOCUMENT and direct_dw_object_id=DOCUMENT_DW_ID

               

              There also weekly and monthly aggregate tables depending on your needs. You should also ensure that your query scales as these tables may grow and grow depending on your settings.

               

              Hope this helps.

              Ben.

            • Re: Reporting at the User Level?

              Hi William,

               

              In the case of discussions, you can do this by placing the Username, Object Type Name, and Activity Count into the Result Objects

               

              In the Query Filters box, place Activity Type ID, specificing 10 for Views, and Object ID, specifying 1 for discussion threads.

               

              The end result should look something like this:

              pic1.png

               

              Click Run Query should generate the report.

               

              Cheers,

              Kwame