How can I track/get analytics on searches by keywords from the Service Portal?

[Will70]

We have a service portal for users to seek IT Support. The goal is first they browse the articles in the portal to see if they can resolve the issue on their own and if not, they can directly contact IT support via connect support chat. 

I am trying to have a report generated that will show me details for abandoned searches from a search widget in the service portal. This will allow us to know what information users are searching  - for which they are not able to a solution. 

I would be grateful if anyone can steer me in the right direction with any of the following.

1. How to create a report of all searches done from the search widget in a portal (sp_log table, type search?)
2. How to divide this report into showing which searches yielded results and which did not 
3. How to get an (automatic) analytics report on all the keywords used in searches i.e. list of number of times 'keyword' appeared in past month, past year, all time etc
4. How to see which portal page the user was on when they decided to search
5. How to see which portal page the user was on when they decided click a link (for further assistance - connect support chat)
6. Are there any tools in SN that already do any of these?

Anyone with a report similar to this would know which articles need to be created/added to an IT service portal and hopefully reduce the workload of the IT Support staff. 

[mattmm]

G'day Will,

Hoping I somewhat steer you with at least 1 and 2?

1. Service Portal Search Terms- Report on Table: sp_log, Type: Bars, Group by: Text, Stack by: Table. Filter on the report with Type > is > search.

2. this is governed by the 'Count' field, So somewhat of the above report but it may be harder to show the division with one report. I suggest two reports, one that yielded results, and one that didn't. Simply add tot eh filter on the report above and have - 'And > Count  > greater than > 0' for one and 'Count > is > 0' for the other. Compare the two reports for the difference.

[jamesmcwhinney]

Did you ever find a good OOTB report for this?

[kqaloedu]

Any work around to these questions?

[ShivarajG]

you can find in the sys_search_event table