Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Sebastiaan Draaisma
    Tier1 Univ Sessions == session_summary.tot_sessions ?Answered
    Topic posted December 12, 2018 by Sebastiaan DraaismaBlack Diamond: 60,000+ Points 
    11 Views, 2 Comments
    Title:
    Tier1 Univ Sessions == session_summary.tot_sessions ?
    Content:

    Hi all.

    Are the Tier1 Univ Sessions presented in the License Compliance Dashboard the same as those counted in session_summary.tot_sessions? I see a lot more sessions registred in the LCD making me believe I might need to count an aditional/other table.

    License Compliance Dashboard

    Displays the number of sessions used by month and the total used over the current contract term.

    session_summary.tot_sessions

    The total number of visits to Customer Portal pages. A visit represents a visitor interacting with Customer Portal pages for some period of time. The details of the visit are stored in multiple rows of the clickstreams table sharing the same sessionid.

    Best Comment

    Sebastiaan Draaisma

    So, I found a solution for this.

    You have to create a (system) variable and use PHP connect to write an array into this variable that you can retrieve for future reporting through custom script in the exit object :-)

    Comment

     

    • Sebastiaan Draaisma

      It turns out to be count(clickstreams.cs_session_id)

      Unfortunately this is only stored for 2 months. I will have to look into storing this value.

    • Sebastiaan Draaisma

      So, I found a solution for this.

      You have to create a (system) variable and use PHP connect to write an array into this variable that you can retrieve for future reporting through custom script in the exit object :-)