Unique article views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2023 05:30 AM
Is there a way to get the unique view count of a article?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 06:32 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 06:45 AM
Yes! This would be useful to me! Thanks for the info. I am trying this now.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 06:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 07:12 AM
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).
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 07:21 AM
Thank you very much! This was helpful and I was able to see what I was doing wrong. I appreciate your help and time!