4 Replies Latest reply on Jun 2, 2017 8:53 AM by Ryan Rutan

    Separating UserViews from ApiViews in jive_activity_agg_day table

    gedelston

      My team is compiling user reports on our Jive site via the jive_activity_agg_day table. In the report available on the Jive Cloud Admin, we can see UserViews and ApiViews separated out. We would like to replicate this separation in our queries. What tables should we use to do this?

       

      Additionally, is there any way to determine a visitor's referrer URL?

       

      Thank you,

      Greg