Confluence page visit statistics from the database

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

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:

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Dec 18, 2018 in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

503 views 3 18
Read article

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