Downloading a Searches Report
Written by Soukaina Zemmouri
Updated at July 7th, 2023
If you are a Super Administrator or Administrator, you can download a Searches Report in two main areas of your Knowledge Base: Analytics and Export Data pages
How to Export the Searches Report?
The Analytics Section allows the searches to be filtered and exported by Time Range (custom period or one of the 3 main periods displayed at the top of the page) and by Type (public or internal).
You just need to go to the Analytics Section > Searches > Click on Export XLS or Export CSV.
Here is an example:
The Export Data section returns all searches (public and internal searches for all time).
You just need to go to the Settings page > Export Data section > Click on Export Searches in XLS or Export Searches in CSV.
Here is an example: 
Data Dictionary
| Column | Description |
|---|---|
| id | The id of the search that was performed |
| account_id | The id of the Knowledge Base account |
| query | The user's search terms submitted through the search bar |
| query_without_stopwords | A query without stopwords is a processed version of the query where common and insignificant words have been removed to focus on the most meaningful keywords. Removing stopwords helps improve search accuracy and efficiency. |
| ip |
The IP address of the user who performed the search
|
| search_count | The number of searches |
| found_answer | Found answer is a "Yes/No" metric, which indicates if at least one result/match was found |
| contacted_support |
A contact form is displayed when no result is found in the search bar
|
| created_at | The timestamp when the search was created |
| updated_at | The timestamp when the search was updated |
| clicked | Indicates how many of the searches the user clicked on when there is at least one result |
| indexed | It indicates whether the search was indexed or not on our backend |
| readings | When a user spends at least 10 seconds on that question |
| found_answers | The total results that were found |
| views | When a user accesses the question |
| language_id | The id of the language where the search was performed |
| search_type | Indicates whether searches were made by authenticated users (when the value is 1) or by anonymous users (when the value is 0). |
| user_id | The id of the user that performed the search |