Are these metrics possible with the CustomWare Reporting plugin? Or is SQL required?

Scott Rossell1

I apologize most profoundly for the rude interjection of my question without the proper research ahead of time. I have to get this figured out in two weeks or I don't have a job! Please, please help!

Are the following metrics possible with the CustomWare Reporting plugin or will SQL (or something else) be required?

- Top 25 users excluding me.
- Top users by week with number of searches and/or articles accessed back to Jan.
- Overall searches by week back to Jan. (exclude me).
- Top 25 contributors and numbers by week.
- Overall number of articles submitted and published by week.
- Time spent logged in per user.
- Average time spent per page per user.

(Of course, any code examples would be greatly appreciated).

Thank you for your kind endulgence for this rude shout for attention. If I still have a job in August I'll certainly be more attentive to proper forum protocol and try to be as helpful as I can be.

Nic Brough -Adaptavist-

Some of it is possible with the plugin, I think, and SQL can answer more. But there's a couple of quick points:

1) You need to define "top users". Is that contributors? (People who add/edit) or just everyone who wanders around?

2) A lot of this stuff simply isn't logged at all, and you'll need to look at your web access logs

3) Time spent logged in doesn't actually work as a question - ok someone logs in, but then what's the end point if (like most people), they don't click "log out"? 20 minutes after their last page change? Doesn't work if they just close the browser. You're going to have to think about this question

4) Time spent per page is similar to 3, and you'll need to think about people who surf like I do - open page, read, open tabs on to interesting bits, never actually leaving the page I started from, so you can't even say "now reading another page"