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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted yesterday in Confluence

Calling all marketing teams who use Confluence - we want to hear from you!

Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...

121 views 3 3
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