US English (US)
BS Bosnian

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Book a Demo
  • Product Updates
  • Contact Us
English (US)
US English (US)
BS Bosnian
  • Home
  • Analytics

Downloading a Searches Report

Written by Soukaina Zemmouri

Updated at October 1st, 2024, by Amanda Stançani

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Getting Started
    Users Accessibility New to Helpjuice? Start Here Content Management Multiple Languages/Translations & Localization Multilingual Knowledge Bases Analytics Video Tutorials
  • Customization
    Customization Guides
  • API V2
  • API V3 and Webhooks
  • Article Editor
  • Billing / Subscription
  • Authentication
  • Pricing
  • Swifty AI Chatbot
  • Swifty AI Helpbar
  • What's New
+ More

Table of Contents

How to Export the Searches Report? Data Dictionary

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?

Analytics Section

 

Export Data Section

 
 

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

  • When a search is performed by an external user (non-logged-in user) only their IP address is registered.
  • When the search is done by an internal user (logged-in user) we register their IP address and their name.
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 

  • TRUE: The user submitted the contact form after no results were found
  • FALSE: The user didn't submit the contact form after no results were found
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
data download analytics export

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Articles Tab
  • Users/Groups Tab
  • Overview: Analytics
  • Searches Tab

Copyright © 2025 - Helpjuice

Helpjuice, Inc. is a registered US Corporation, EIN # 45-2275731

Download W9
  • Help
  • Features
  • Pricing
  • About
  • Careers
  • Customers
  • Blog
  • Case Studies
  • Resources
  • Knowledge Base Examples
  • Privacy Policy
  • Terms of Service

Why is the knowledge base important?

With a knowledge base, you can allow your customers to self-help themselves, thus reducing your customer support by up to 60%. Furthermore, you can also have your team get instant answers to the questions they need without having to email themselves all using knowledge base software.

What is the purpose of a knowledge base?

The purpose of knowledge base software is to allow you to host your knowledge base/corporate wiki in one centralized 'hub'. Both your customers, and employees can now access information within seconds!

Made with from Miami, Bosnia, Morocco & Brasil

+1 (833) 387 3877 support@helpjuice.com
Expand