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:

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

359 views 20 10
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