article_metrics

Table Type:

Stores hourly knowledge base analytics metrics at the article/document level. Data is aggregated by application type (e.g., SupportCenter, MessengerKnowledgeApp, BotFlow, Assistant, SmartAdvisor). When knowledgebase_document_id is populated, metrics are article-specific; when empty, represents aggregate knowledgebase-level metrics. Use SQL aggregation to calculate knowledgebase-level metrics from this granular article-level data.

Columns

Column Type Modifiers Notes
application_type string Primary Key The application type where the metric was recorded (e.g., SupportCenter, MessengerKnowledgeApp, BotFlow, Assistant, SmartAdvisor)
end_interval datetime Primary Key The end date/time of the hourly measurement interval
article_id string Primary Key The knowledge base article/document ID for article-level metrics, or empty string for aggregate/knowledgebase-level metrics
metric string Primary Key The metric name (e.g., nDistinctKnowledgeSessions, nKnowledgeDocumentCopied, nKnowledgeDocumentFeedback, nKnowledgeDocumentPresented, nKnowledgeDocumentSurfaced, nKnowledgeDocumentViewed, nKnowledgeSearch, nKnowledgeSearchAnswered, nKnowledgeSearchFeedback, nKnowledgeSearchUnanswered, nKnowledgeSessions, oKnowledgeSearch, oKnowledgeDocumentQuery, oKnowledgeDocumentQuerySelfServed)
start_interval datetime Primary Key, Required The start date/time of the hourly measurement interval
max double The maximum value of the metric during the interval
min double The minimum value of the metric during the interval
count int64 The total count of occurrences of the metric during the interval
count_negative int64 The count of negative values (e.g., negative feedback) during the interval
count_positive int64 The count of positive values (e.g., positive feedback) during the interval
sum double The sum of all metric values during the interval
current double The current or most recent value of the metric
ratio double The ratio value (numerator/denominator) for ratio-based metrics
numerator double The numerator value for ratio-based metrics
denominator double The denominator value for ratio-based metrics
target double The target value for the metric if applicable
p95 int64 The 95th percentile value of the metric during the interval
p99 int64 The 99th percentile value of the metric during the interval
knowledgebase_id string Primary Key The ID of the knowledgebase associated with the metric
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.