Reporting monthly knowledge base article usage

[jctalk]

Hi,

We are looking to report on the number of knowledge base article use's by our users on self service. We have a knowledge base specifically for these users, but looking at the KB_KNOWLEDGE table I see only 'use count' and 'view count', I can't see a way to specify a specific month period to only get the count of use's in say October.

I've read an old post on here suggesting that the counts are on a rolling 30 days by default. Is this correct? If it is, is there any other way of achieving the above?

We don't have Performance Analytics.

Many thanks

[StephLindorff]

I've always used "Created is Last Month" (for example).   If I understand correctly, "created" in this instance refers to when the view was created, not the KA.

[jctalk]

Hi Stephanie,

I'm looking at the kb_knowledge table and testing it with Created it seems to bring back only articles and there create date. May be the kb_use table is what I need to be looking at as suggested by saruppaul but it doesn't look like I currently have access to that table. I will see if I can get permissions to use that table.

[StephLindorff]

I was actually referring to the kb_use table - left out that important detail.

[Sarup Paul]

Please use the kb_use table for historical data. You can create a report using the "viewed" field. This webinar will give you more info on reporting on Knowledge Management - Ask the Expert: Knowledge v3 Reporting, Best Practices .