Confluence Analytics Data Model
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
This guide is for informational purposes and is not eligible for support as part of the Atlassian Support Offerings. If you have any questions about the information on this page, please reach out to our Atlassian Community for help.
Summary
Most of the information used by Confluence Analytics is stored in few AO tables created to store the information used by this plugin. The AO tables for Confluence Analytics will follow the syntax of AO_7B47A5_TABLENAME as explained in Atlassian Developer > Table names
Check KB List of Confluence Server/Data Center Active Objects (AO) table names and vendors for full list of Plugins with the AO tables associated
This document provides a diagram of the Confluence Analytics schema and a conceptual overview of the data model.
Database tables and references
Expand the link below to see a table of the foreign keys for each table.
AO Tables
This section describes the tables involved in storing Confluence Analytics information:
Table | Description |
|---|---|
AO_7B47A5_EVENT | Information of the events, categorised by type, space, user and modification date |
| Different settings related to Confluence Analytics, such as Data Retention settings or Instance restrictions |
You can use the SQL statements listed in KB Retrieving Confluence Analytics information directly from the Database for few examples about mining data in the Confluence Analytics tables