Tell me the query syntax that track confluence page views of a certain page.

Question

Please tell me the name of the table where I can check the inquiry information of a specific page in the original DB. A query syntax that allows me to check the viewer information on a specific page is fine.

Thank you in advance for your information.

Shannon S · Answer

Hi @최가영

I wanted to share that there's also an experimental Analytics API you could use.

For example this would give you page views by month for a specific page:

ADMIN_USRNAME=admin
ADMIN_PWD=admin
CONFLUENCE_BASE_URL=http://localhost:27132/c7132
PAGE_ID=2621441
FROM_DATE=2022-01-01T00:00:00.000Z
TO_DATE=2022-03-22T00:00:00.000Z
TIMEZONE=GMT-03:00

curl -u ${ADMIN_USRNAME}:${ADMIN_PWD} \
  ${CONFLUENCE_BASE_URL}'/rest/confanalytics/1.0/content/viewsByDate?contentId='${PAGE_ID}'&contentType=page&fromDate='${FROM_DATE}'&toDate='${TO_DATE}'&type=total&period=month&timezone='${TIMEZONE} | jq -r

In the database, if you're using Analytics for Confluence, AO_7B47A5_EVENT is the analytics table, so here's a simple query you could use:

select COUNT(*)
from "AO_7B47A5_EVENT"
where "NAME" = 'page_viewed'
 and "CONTENT_ID" = 00000

However, using the API is still probably your best bet.

I hope that helps!

Shannon | Atlassian Community SUpport

Shannon S · Answer

Hello @최가영,

Welcome to Atlassian Community! It's nice to have you join us. I hope you are doing well. My name is Shannon, and I'm happy to assist you.

You can refer to the page, How can I find which pages users have recently viewed? Currently, Confluence does not have a native function for tracking historical page views. We have a few open feature requests tracking this behavior:

* CONFSERVER-33386 - Confluence should have a "last viewed date" property for pages.
* CONFSERVER-43461 - Ability to track Confluence Page Views

However, recently viewed pages are stored in the AORECENTLY_VIEWED table in Confluence's database. Please refer to the linked documentation for the full query.

I hope that helps, but please let us know if you have any further questions.

Take care,

Shannon | Atlassian Community Support