How to Identify Top 5-10 User Search Queries in Global Search (ESC) using AI Search

[Tabassum22]

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

[Gerard Dwan · Accepted solution]

Hi @Tabassum22 , 

This is the perfect use case for the AI Search Analytics dashboard. Keep in mind, you will need to install the (no cost) Advanced AI Search Management Tools plugin. 

[Lynda1]

I completely forgot about the AI Search Analytics Dashboard!

[Kass3m]

@Gerard Dwan is it possible to copy the reports in AI search analytics dashboard? because we would like to pull in more data? 

1. Which table is the raw data coming from?

2. We are not able to pull sys_search_query into a report hich shows the number of queries, percentage of overall queries etc