Help with activity report within a group

(Bruce Becker) #1

Hi all.

I have a request from one of our group admins, to give them a report on the “activity within the group”. I interpret this to mean a couple of things, but as a first-pass, I would like to be able to have the number “posts per user” and the histogram “pages viewed per user”.

I have very limited experience with sql in general and none at all with the data explorer, but I would like to use the data explorer plugin to do this, not google analytics.

So, TL;DR : can someone give me the sql necessary to obtain these ?

thanks !