Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Unique article views

SNOWPie
Tera Expert

‎10-18-2023 05:30 AM

Is there a way to get the unique view count of a article? 

0 Helpfuls
  • 2,690 Views
9 REPLIES 9

Dr Atul G- LNG
Tera Patron

‎10-18-2023 05:34 AM

Hi @SNOWPie 

 

I dont want to copy any one answer, so posting the link

 

https://www.servicenow.com/community/knowledge-managers/how-do-i-run-a-report-to-see-how-many-unique...

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Raghav Sharma24
Giga Patron

‎10-18-2023 05:35 AM

The views are stored in "kb_use" table.

You can query or use group by to get unique records.


Please mark the answer correct/helpful accordingly.

0 Helpfuls

Raghav Sharma24
Giga Patron
In response to Raghav Sharma24

‎10-18-2023 10:22 PM

@SNOWPie did this work for you?

0 Helpfuls

CelesteTroxell
Tera Contributor

‎10-23-2023 06:00 AM

Did you find a way to do this? I read the responses below and if I'm understanding what you're asking, these responses don't help. I was also looking for a way to have a unique count. Meaning if the article was viewed 30 times, but the same user viewed it 10 of those times - I want to see the count of 20 (so that user that viewed it 10 times is only counted as ONE).  Is this what you're looking for?

0 Helpfuls