Hi Experts,
I am working on a dashboard to analyze user search behavior and would like to retrieve the top 5-10 searched queries from Global Search in ESC.
I am aware of the sys_search_event table, but I am unsure how to determine the most searched queries effectively. Below are some of the key fields I have explored:
- Has Result: Indicates whether a search returned results. If false, it suggests a knowledge gap that may need to be addressed.
- Click Rank: Measures how much effort was needed to find a relevant result.
- Refinement: Counts the number of filtering or sorting actions a user performed to narrow down results (lower values are preferable).
- Click-Through Rate: Reflects how often users find relevant results but does not directly indicate search frequency.
Could you please guide me on the best approach to identify the top search queries based on these fields or any other method? Any insights or best practices would be greatly appreciated!
Thanks & Regards,
Tabassum Sultana
