Table Type:
Stores search queries made against knowledge bases with counts of answered and unanswered searches. The search_query field contains the actual text that users searched for. Use this to identify top questions asked and gaps in knowledge base content.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| application_type | string | Primary Key | The application type where the search was performed (e.g., SupportCenter, MessengerKnowledgeApp, BotFlow, Assistant, SmartAdvisor) |
| end_interval | datetime | Primary Key | The end date/time of the measurement interval |
| knowledgebase_id | string | Primary Key | The knowledge base identifier |
| search_query | string | Primary Key | The actual search query text that users entered |
| start_interval | datetime | Primary Key, Required | The start date/time of the measurement interval |
| answered_count | int64 | The number of times this search returned results (answered) | |
| unanswered_count | int64 | The number of times this search returned no results (unanswered) | |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | Required | When this record was created in UTC. |
| db_when_deleted | datetime | When this record was deleted in UTC or NULL. |