Search signal tables

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 3 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Search Signal Tables

    The Search Signal Tables in ServiceNow store important data about user searches, including interactions and refinements, referred to as search signals. This information is crucial for enhancing the relevancy of search results within your system.

    Show full answer Show less

    Key Features

    • Search Signal Event Table: Records data from user search submissions, including search events, browser details, geographic coordinates, matched query intents, first-page results, response times, and query language.
    • Search Signal Result Event Table: Captures data on selected search results, such as the search query, user details, result identifiers, descriptions, source tables, and domain information.
    • Search Signal Result Event Action Table: Logs user interactions with search results, including the type of interaction (e.g., click) and the corresponding index of the selected result.
    • Search Autocomplete Query Event Table: Stores data for auto-complete suggestions chosen by users, including the selected query, click index, and geographic coordinates.
    • Genius Result Event Action Table: Tracks user actions on Genius Result answer cards, including action identifiers, types, values, and matched intents.

    Key Outcomes

    Utilizing the search signal tables allows ServiceNow customers to analyze user behavior and search performance, leading to improved search functionalities and user experience. This data-driven approach helps in refining search algorithms and ensuring more relevant results for end-users.

    Search uses tables to store details from user searches, search refinements, and interactions with search results. These details are called search signals. Data from the search signal tables helps improve the relevancy of search results in your system.

    Search signals refer to user, query, and similar data stored in columns on search suggestion tables. For a guide to search suggestion tables and their columns, see Search Suggestions tables.
    Note:
    Because the search signal tables are system tables, they are excluded from the Reporting module by default. To learn about enabling reporting on system tables, see Reporting on system tables.

    Search Signal Event table

    The Search Signal Event [sys_search_signal_event] table stores signal data produced when users submit a search.

    Table 1. sys_search_signal_event
    Column Description
    Search event Reference to the record for the search event on the Search Event [sys_search_event] table.
    Browser User browser agent string.
    Latitude Latitude coordinate of the user location in decimal degrees.
    Longitude Longitude coordinate of the user location in decimal degrees.
    Matched Query Intents List of query intents matched in the user search query.
    First page results JSON array of objects in which each node represents a single result returned in the first page of results for the search. The result order is preserved. Each object includes the unique record identifier (sys_id) of a result and the table where the result is located.
    Note:
    The first page results aren't updated when you refine a search.
    Search Response Time(ms) Time taken by the search, in milliseconds.
    User Query Language Language of the user search query.

    Search Signal Result Event table

    The Search Signal Result Event [sys_search_signal_result_event] table stores signal data for search results that users select.

    Table 2. sys_search_signal_result_event
    Column Description
    Search query Search query that led to the search result selection.
    User User that selected the search result.
    Result DocID Source table and record names for the selected search result.
    Description Short description for the selected search result.
    Source Table Source table for the selected search result.
    AIS DocID Source table name and record sys_id for the selected search result.
    Result Type Type of search result selected. For example, REGULAR for a regular search result or GENIUS for a Genius Result answer card.
    Search Signal Event Reference to the record for the search on the Search Signal Event [sys_search_signal_event] table.
    Number Record number for the selected search result.
    Domain Domain to which the selected search result belongs.
    Use for Suggestions Option indicating whether AI Search uses this result selection when computing auto-complete suggestions. For more details, see Auto-complete suggestions in AI Search applications
    Source URL URL for the selected search result.
    Action Data JSON array of objects representing the search result selection action.

    Search Signal Result Event Action table

    The Search Signal Result Event Action [sys_search_signal_result_event_action] table stores signal data for user interactions with search results.

    Table 3. sys_search_signal_result_event_action
    Column Description
    Signal Type The type of user interaction signal recorded for the search result. For example, CLICK indicates that the user selected a search result.
    Signal Value The value for the user interaction signal. For example, when the signal type is CLICK, the signal value is the numeric index for the search result that the user selected.
    Search Signal Result Event Reference to the record for the search result on the Search Signal Result Event [sys_search_signal_result_event] table.

    Search Autocomplete Query Event table

    The Search Autocomplete Query Event [sys_search_autocomplete_query_event] table stores signal data for auto-complete suggestions that users select from the search input field.

    Table 4. sys_search_autocomplete_query_event
    Column Description
    Selected Query The auto-complete suggested query that the user selected in the search input field.
    Click Index The numeric index of the auto-complete suggestion that the user selected in the search input field.
    Latitude Latitude coordinate of the user location in decimal degrees.
    Longitude Longitude coordinate of the user location in decimal degrees.
    Search Profile Reference to the search profile used for the search query.

    Genius Result Event Action table

    The Genius Result Event Action [sys_search_genius_result_event_action] table stores signal data for user interactions with Genius Result answer cards.

    Table 5. sys_search_genius_result_event_action
    Column Description
    Action Id The identifier for this Genius Result event action signal.
    Action Type The type of action taken from the Genius Result answer card.
    Action Value The value, if any, for the action taken from the Genius Result answer card.
    Matched Genius Result Intents
    List of NLU model intents matched by the action taken from the Genius Result answer card.
    Note:
    This field is only populated for Genius Result configurations with NLU triggers.
    Card Type The type of Genius Result answer card that the user interacted with.
    Search Signal Result Event Reference to the record for the Genius Result answer card on the Search Signal Result Event [sys_search_signal_result_event] table.