Giuseppe Iannacone Posted December 5, 2018 Share Posted December 5, 2018 is there a way to have a report for the most searched word or sentences in the Service Portal search bar? Link to comment Share on other sites More sharing options...
Steven Boardman Posted December 5, 2018 Share Posted December 5, 2018 Hi @Giuseppe Iannacone The info you need is held in the h_sm_portal_search_history table and the customer search terms are held in the h_search_term column. You can create reports on this in the admin console reports or in advanced analytics, something like below: Hope that helps Steve Link to comment Share on other sites More sharing options...
Giuseppe Iannacone Posted December 5, 2018 Author Share Posted December 5, 2018 @Steven Boardman thank you for the very quick reply, I'll give it a try and get back to you if needed. 1 Link to comment Share on other sites More sharing options...
Giuseppe Iannacone Posted December 5, 2018 Author Share Posted December 5, 2018 @Steven Boardman I fear we don't have the advanced analytics.... but i was able to find out the answer with the standard report function, thank you Link to comment Share on other sites More sharing options...
Steven Boardman Posted December 5, 2018 Share Posted December 5, 2018 @Giuseppe Iannacone you should be able to create the same from the admin console > Service Manager > Reports without the need for advanced analytics Very quick basic report, i've attached the report definition as a start for ten which you could upload, amend, extent etc search-for-terms.report.txt Steve Link to comment Share on other sites More sharing options...
Giuseppe Iannacone Posted December 5, 2018 Author Share Posted December 5, 2018 @Steven Boardman thank you very much i was able to find the solution with your suggestion, but your template looks much better, so i will use it Really appreciated. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now