How to Retrieve Confluence Analytics Information from the Database

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Data Center Only - This article only applies to Atlassian products on the data center platform.

Purpose

It can be useful to retrieve Confluence Analytics data directly from the database in case you want to inspect or manipulate the information externally.

Solution

Analytics data and settings are stored on the following tables:

 public | AO_7B47A5_EVENT                           | table    | admin
 public | AO_7B47A5_EVENT_ID_seq                    | sequence | admin
 public | AO_7B47A5_SETTINGS                        | table    | admin
 public | AO_7B47A5_SETTINGS_ID_seq                 | sequence | admin

The AO_7B47A5_EVENT table is used to store each of the events, so the following query will retrieve all of them:

select * from "AO_7B47A5_EVENT";

If looking for a specific type of event, the NAME column can be used. Here is an example for page views:

select * from "AO_7B47A5_EVENT" where "NAME" = 'page_viewed';
Last modified on Apr 17, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.