Hello,

Confluence database schema contains the quite useful table called AO_92296B_AORECENTLY_VIEWED. This table contains data about recently viewed pages and we use a set of scripted MySQL queries to get statistics.

Unfortunately, the data in the table is not a pure views history and the distinctions as below:

• Records in this table are stored only for the last 2 months.
• I assumed it just added records to the table each time someone hit a page. Rather it looks like it will add a page hit record if the content_id and user_key combination is unique. If there is already a row for content_id and user_key it will simply update that row.

So, my suggestion is to add a new table into database which will store the same data as AO_92296B_AORECENTLY_VIEWED does but for a longer period (make it configurable via the WebGUI) and views records will be always added instead of updating existing records.