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

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.

3 answers

0 votes

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"

Nic, thank you so very much for such a quick response. :@)

Management is only concerned with whether Confluence is being used and by whom and how often (metrics that, as you mentioned, are not that easily determined.) I have the free, simple Google Analytics reporting installed but that doesn't seem to be enough.

I can easily enough report on the number of contributed pages, comments and such, but they're looking for data on which technicians are using the knowledge base on Confluence and how long.

I'm not sure that can be answered. That would require tracking specific login ID's or IP addresses, right? (Hence the web logs?)

So, how about just counting the number of searches per week and by whom? Is that possible?

Thanks again!

This plugin may provide some of what you are looking for:




Thanks! I forgot all about that one. I installed it a while back and promptly forgot all about it. It looks like the onus is on me to prove that the knowledge base is actually being used. In fact, I may only have to prove it this one time. Between this plugin and the Google Analytics data, I may just be able to present my case effectively. Thanks for your help. Much appreciated!

You are welcome, Scott. Good luck!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,102 views 56 8
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you