Unique article views

SNOWPie
Tera Expert

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

9 REPLIES 9

Are you then looking to see the number of unique people that viewed the article rather than the total of views? You can achieve this by reporting on the kb_use table, and then under configure use the 'Count Distinct' and 'User' options from Aggregation to sort the data. 

 

But I do not believe you can run a report that has the total number of views that automatically subtracts repeat users.

 

2023-10-23_14-30-43.jpg

Yes! This would be useful to me! Thanks for the info. I am trying this now.

Do you mind backing up a few steps and showing me how you got to this Configure screenshot? I am fairly new to SN. I tried going through the kb_use.LIST and also through 'Create New' under Reports but am running into obstacles.

Sure, if you go the 'Create New' route under reports, and then select Table as your source type, and then Knowledge Use [kb_use] as the table. Just add your conditions for the report using the filters; created, knowledge base etc. (on the knowledge use table, 'Created By' will always mean when the actual view was created, not the article).

 

2023-10-23_15-06-05.jpg

 

Then under the 'Type' section, just pick the type of chart you want to display the data in e.g. bar chart, pie... And then you should be able to use the Configure section as in the post above to display the unique users.

Thank you very much! This was helpful and I was able to see what I was doing wrong. I appreciate your help and time!