Confluence page visit statistics from the database

Chris Solgat
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 17, 2016

I have a customer that is wanting to gather some metrics around their Confluence Space.  The problems and constraints that we have run into is that we have a rather large instance of Confluence, just short of 1 million content items, so we cannot use the built in Confluence Statistics mechanism.  Also, we have not found any plugins that get us the type of information, and more specifically at the Space Admin level, that we are looking for.  The one option that showed some promise was the Google Analytics plugin, but since the information is stored in the Cloud, our IS Security team would not be happy about that. Soooo...

With that long explanation, what I am curious about is where most of this metric data would be stored in the database.  Since Confluence does have the built in mechanism, is the data being stored already, or does it only get stored if the Metrics Gathering feature is enabled?  If it is always being stored, where in the database can it be found?

Additionally, we are using the View Tracker plugin, but it just doesn't provide enough to fulfill what the customer has been asking for.  Here is the requirements that the customer has asked for:

General Reporting:
Total Number of Hits - believe this has already turned this on for the home page
Number of Page Hits by Month (parent & child pages) - we would like to see the trending to highlight the utilization and growth as it's rolled out to all of the users
Users or Departments Hitting the Site/Pages & which pages

And they are looking for this to come in some kind of Report/Graph format that can be rolled up at a Space Level.

Any ideas/thoughts/suggestions are welcome.

1 answer

0 votes
Actual Metrics July 20, 2016

A viable option is to configure Confluence to create an apache access log, and then process the logs with web analytics software.

Confluence doesn't create an access log by default, but here's how to configure it:

https://jira.atlassian.com/browse/CONF-23034

Once you have the log created, you can use a tool like Angelfish to create reports:

http://analytics.angelfishstats.com/solutions/jira-confluence-web-analytics/

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events