nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

view count question in confluence activity report

Anderson Hsu_c32qp7

Dear partners,

We found the value of the activity report view count is different in chart and list as shown as below:

Chart Value : 6+2=8

List value: 5+4+2=11

What's the difference between them ? We also use sql command as listed as below. But the result is also different. How can we get the view count value ? Thanks a lot

select * from log0201 where ((d3 like '%viewpage.action%') and (d3 like '%spaceKey=BB%'))

(We import log information into database and analysis the log information)

Accepted answers

All comments

Shannon S

Anderson,

The graph shows all page hits, including multiple visits by the same user.

The chart you've circled is showing most popular content only. This would not include pages that were viewed a single time, for example, if it's not considered a popular page.

I hope that's clear but let me know if you have any questions.

Regards,
Shannon

Anderson Hsu_c32qp7

Dear Shannon,

Thanks for your kindle assistance.

Would it be possible to use sql command to list how many viewed by log information , as listed as below:

SQL command : select * from log0201 where ((d3 like '%viewpage.action%') and (d3 like '%spaceKey=BB%'))

log example:

"[31/Jan/2018:12:23:49 -0800] ft12 Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0 Cyberfox/52.6.1 192.168.37.18 GET GET /chat/start.actioin?spaceKey=NN&currentUrl=http%3A%2F%2Fftconnect.demo.com%2Fpages%2Fviewpage.action%3FpageId%3D47842012&currentTitle=J.+%E5%B8%B8%E7........

(We refer the article of https://confluence.atlassian.com/confkb/audit-confluence-using-the-tomcat-valve-component-223216846.html to analytics the log data)

Shannon S

Anderson,

I'm not too familiar with the SQL command you mentioned as logs aren't generally stored in the Confluence database, so it seems that you may have a custom setup if you are able to find those details in yours.

I would recommend an add-on for this, such as

Tracking Access for Confluence
Or any of the other apps listed: Confluence Analytics add-ons in Marketplace

If you have any questions about that please let me know.

Regards,

Shannon

Anderson Hsu_c32qp7

Dear Shannon,

Thanks for your kindly reply. How do we know the page is popular page refer you mentioned as listed as below: (Does it determine by view count , when the page is viewed in top 10 pages, it will be popular pages?)

This would not include pages that were viewed a single time, for example, if it's not considered a popular page.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

atlassian-marketplace