How to Retrieve Confluence Analytics Information from the Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the data center platform.
It can be useful to retrieve Confluence Analytics data directly from the database in case you want to inspect or manipulate the information externally.
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';