Last Updated On: May 05, 2026
This article lists all of the objects and fields related to search in the communities data lake.
search_searches_count (aggregated facts)
This object table contains the total volume of search queries executed within the specified timeframe.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| count | string | The number of all search requests performed within the community ( both tracked and untracked searches are included) |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_no_results_rate (aggregated facts)
This object table contains the ratio of search queries that returned zero matching results.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| count | string | The number of all search requests performed within the community ( both tracked and untracked searches are included) |
| no_results_count | string | The number of search requests that returned no results. |
| no_results_rate | string | The percentage of total searches that yielded no results (no_results_count divided by count). |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_no_clicks_rate (aggregated facts)
This object table contains the ratio of searches that successfully retrieved results but resulted in no user interaction.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| count | string | The number of all search requests performed within the community ( both tracked and untracked searches are included) |
| no_clicks_count | string | The number of search requests that returned results but received no clicks. |
| no_clicks_rate | string | The proportion of total searches that resulted in no user clicks (no_clicks_count divided by count). |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_clicks_rate (aggregated facts)
This object table contains the ratio of tracked searches where a user clicked at least one result.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| tracked_searches_count | string | The number of search requests with `clickAnalytics=true` that returned results |
| clicks_count | string | The number of search requests with `clickAnalytics=true` that returned results and received clicks. |
| clicks_rate | string | The proportion of tracked searches that led to a click (clicks_count divided by tracked_searches_count). |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_conversions_rate (aggregated facts)
This object table contains the ratio of tracked searches that have led to a conversion.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| tracked_searches_count | string | The number of search requests with `clickAnalytics=true` that returned results |
| conversion_count | string | The number of clicks that resulted in users spending up to 30 seconds on the clicked link. |
| conversion_rate | string | The proportion of tracked searches that led to a successful conversion (conversion_count divided by tracked_searches_count). |
| descriptor | string | Astring attached to search events to categorize and segment user interactions |
search_users_count (aggregated facts)
This object table contains the number of unique users that performed a search.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| users_count | string | The total number of unique users (registered and visitors) who performed a search on a specified date |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_top_searches (aggregated facts)
This object table contains the top searches performed by users.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| search | string | Contains the query that was searched |
| search_count | string | Number of times this search query was executed. |
| hits_number_count | string | The average number of hits (results) returned by that query indicates how many records matched it on average. |
| descriptor | string | a string attached to search events to categorize and segment user interactions |
search_top_searches_with_no_results (aggregated facts)
This object contains the top searches performed by users that did not yield results.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| search | string | Contains the query that was searched |
| searches_with_no_results_count | string | Total count of search attempts for that query that returned no results |
| searches_with_filters_with_no_results_count | string | The count of search attempts for that query with one or more filters applied that returned no results. This is useful to understand if the “no result” problem is due to filters rather than the query alone |
| ui_title | string | A summary string that describes the search query, along with the number of searches and the count of filtered results |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_top_results (aggregated facts)
This object contains the most frequently returned search results (i.e., the content that appeared in results), with a count of how often each result was served. This table does not contain the search terms themselves.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| hit | string | A search result returned by a query, representing a specific record in the indexed dataset. Each hit includes a unique object identifier (objectID). |
| results_count | string | The number of times a given result appeared as a search result. |
| result_title | string | The title associated with the result, identified by its objectID. |
| descriptor | string | a string attached to search events to categorize and segment user interactions |
search_top_searches_with_no_click (aggregated facts)
This object table contains shows search terms that didn't lead to any click, with a count of how often each term was searched. It does not contain the results shown.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| search | string | Contains the query that was searched |
| searches_with_no_click_count | string | Count of search without a click |
| hits_number | string | The average number of hits returned for that query, i.e., how many records matched the query on average |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_top_countries (aggregated facts)
This object table contains the geographic distribution of search activity mapped to user locations.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | Contains the community ID where the activity was executed |
| date | string | Refers to the day when the searches took place |
| country | string | A country with a high number of searches |
| count | string | Total number of search queries executed by users within the country. |
| descriptor | string | A string attached to search events to categorize and segment user interactions |
search_content_data
This section lists all of the objects and fields related to search sources.
Community
This object table contains native community platform content, including questions, discussions, knowledge base articles, ideas, and product updates, exported at the post level.
| Field Name | Field Type | Field Description |
| title | string | The title of the topic. The topic can be a question, product update, article, idea, or conversation. |
| topic_public_id | integer | Refers to the public identifier that uniquely identifies a topic across the platform within the community. |
| topic_private_id | integer | Refers to the unique identifier of the topic, which identifies the opening topic within the Content Type. |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| content | string | The body text of the first post that started the topic. This field is only populated for first_post records and is empty for answer and reply records. |
| answer | string | The body text of the accepted or best answer for this topic. This field is only populated for best_answer records and is empty for first_post and reply records. |
| reply | string | The body text of a reply in the thread. This field is only populated for reply records and is empty for first_post and answer records. |
| public_tags_name_list | array of strings | Refers to a list of tags or labels used to categorize and organize content, making it easily searchable and accessible to everyone. |
| locale | string | The language or locale of the content. |
| category_id | integer | Refers to the unique identifier assigned to a specific category within the community |
| category_title | string | Refers to the display name assigned to a specific category within the community. |
| parent_category_id | integer | Refers to the unique identifiers assigned to the parent category within the community. |
| parent_category_title | string | Refers to the display name assigned to a parent category within the community. |
| category_L1_title | string | Refers to the display name assigned to the top-level category within the community |
| category_L2_title | string | Refers to the display name assigned to the second-level category path in "Parent > Child" format. |
| category_L3_title | string | Refers to the display name assigned to the third-level category path in "Grandparent > Parent > Child" format. |
| knowledge_base_categories_L1_title | string | Refers to the display name assigned to the top-level knowledge base category. |
| knowledge_base_categories_L2_title | string | Refers to the display name assigned to the second-level knowledge base category path in "Parent > Child" format. |
| knowledge_base_categories_L3_title | string | Refers to the display name assigned to the third-level knowledge base category path in "Grandparent > Parent > Child" format. |
| product_area_name | string | Refers to the display name assigned to the product or feature area associated with the content. This field is populated for ideas and product updates only. |
| product_area_L1_name | string | Refers to the display name assigned to the top-level product area name. This field is populated for ideas and product updates only. |
| product_area_L2_name | string | Refers to the display name assigned to the second-level product area path in "Parent > Child" format. This field is populated for ideas and product updates. |
| is_article | boolean | Indicates whether the content type is an article within the community. |
| is_federated | boolean | Indicates whether the search result is from an external or federated source. |
| has_answer | boolean | Indicates whether this topic has best answer. This is a topic-level value repeated on all posts within the same topic. |
| last_updated_at | integer (unix timestamp) | Indicates the date and time when the topic was last updated, based on the most recent post. |
| count_of_likes | integer | Indicates the total number of likes on the first post of the topic. |
| count_of_votes | integer | Indicates the number of votes on an idea. This field is populated for ideation content types only. |
| count_of_posts | integer | Indicates the total number of reply conunt of topic (excludes the first post). This is a topic-levle value repeated on all posts within the same topic. |
| count_of_views | integer | Indicates the total number of times the topic has been viewed. |
| helpfulness_score | integer | Refers to the number of times users have marked a post as helpful within the community |
| sticky_topic | boolean | Indicates whether a topic is pinned to the top of its category. |
| created_at | integer (unix timestamp) | Represents the timestamp indicating when the badge was created |
| idea_status_name | string | Refers to the current status of an idea (for example: Open, Under review). On;y populated for ideation content type. |
| public_record | boolean | Indicates whether this record is publicly accessible to unauthenticated users. |
| source | string | Refers to the source where the content resides within the community platform. |
| topic_url | string | Refers to the URL of the topic within the community. |
| full_topic_url | string | The complete, fully-qualified URL to the topic. |
Federated
This object table contains custom content records pushed into the search index through the federated search API by third-party integrations or custom pipelines.
| Field Name | Field Type | Field Description |
| title | string | Refers to the title of the federated content record, set by the external system. |
| content | string | Refers to the body text of the federated content record, set by the external system. |
| tags | array of strings | Refers to the list of tags or labels associated with the federated record. |
| is_federated | boolean | Indicates whether the search result is from an external or federated source. |
| public_record | boolean | Indicates whether this record is publicly accessible to unauthenticated users. |
| source | string | Refers to the source where the content resides. |
| url | string | Refers to the URL of the searched topic. |
Zendesk
This object table contains knowledge base articles imported from Zendesk Help Center.
| Field Name | Field Type | Field Description |
| title | string | Refers to the title of the Zendesk Help Center article. |
| content | string | Refers to the body text of the Zendesk article with HTML tags removed. |
| locale | string | The language or locale of the article. |
| is_federated | boolean | Indicates whether the search comes from an external or federated source. This field is always true for Zendesk articles. |
| public_record | boolean | Indicates whether this article is publicly accessible. This field is always true for exported Zendesk articles. |
| source | string | Refers to the source where the content resides. This field is always "Zendesk" for Zendesk Help Center articles. |
| url | string | Refers to the URL of the article in Zendesk Help Center. |
Salesforce
This object table contains knowledge articles imported from the Salesforce Knowledge Base.
| Field Name | Field Type | Field Description |
| title | string | Refers to the title of the Salesforce Knowledge article. |
| content | string | Refers to the body text of the Salesforce Knowledge article. |
| is_federated | boolean | Indicates whether the search comes from an external or federated source. This field is always true for Salesforce articles. |
| public_record | boolean | Indicates whether this article is publicly accessible. This field is always true for exported Salesforce articles. |
| source | string | Refers to the source where the content resides. This field is always "Salesforce" for Salesforce Knowledge articles. |
| url | string | Refers to the URL of the article in Salesforce. |
Freshdesk
This object table contains solution articles imported from the Freshdesk Solutions portal.
| Field Name | Field Type | Field Description |
| title | string | Refers to the title of the Freshdesk Solutions article. |
| content | string | Refers to the body text of the Freshdesk article. |
| is_federated | boolean | Indicates whether the search comes from an external or federated source. This field is always true for Freshdesk articles. |
| public_record | boolean | Indicates whether this article is publicly accessible. This field is always true for exported Freshdesk articles. |
| source | string | Refers to the source where the content resides. This field is always "Freshdesk" for Freshdesk Solution articles. |
| url | string | Refers to the URL of the article in the Freshdesk support portal. |
Skilljar
This object table contains published training and education courses imported from the Skilljar learning management platform.
| Field Name | Field Type | Field Description |
| title | string | Refers to the title of the Skilljar training course. |
| content | string | Refers to the brief description of the course. |
| is_federated | boolean | Indicates whether the search comes from an external or federated source. This field is always true for Skilljar courses. |
| public_record | boolean | Indicates whether the course is publicly accessible. This field is always true for exported Skilljar courses. |
| source | string | Refers to the source of the course. This field is always "Skilljar" for Skilljar training courses. |
| url | string | Refers to the URL of the course on the Skilljar training portal. |
Tags
This object table contains community tags and labels used to categorize and organize content, with usage statistics.
| Field Name | Field Type | Field Description |
| public_tag_name | string | Refers to the display name of the tag in the community. |
| public_tag_id | integer | Contains a unique identifier assigned to a specific public tag |
| is_federated | boolean | Indicates whether the search comes from an external or federated source. |
| count | integer | Indicates the number of topics or posts that use this tag. |
| public_record | boolean | Indicates whether this tag is publicly visible. This field is always true for exported tags. |
