public.knowledgeaggregatesdata

public.knowledgeaggregatesdata

Description

Aggregated knowledge base usage metrics from Genesys Cloud Analytics API

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(200) false Primary key - SHA256 hash of all dimensions and interval
agentassistantid varchar(100) true ID of the agent assistant (Preview)
appdeploymentid varchar(100) true Deployment ID of the app used for knowledge search
apptype varchar(50) true App type (Assistant, BotFlow, MessengerKnowledgeApp, SmartAdvisor, SupportCenter)
botflowid varchar(100) true ID of the bot flow
conversationchanneltype varchar(50) true Channel type (Call, Callback, Email, GenericObject, Messaging, Social, Webchat)
conversationid varchar(100) true Unique conversation identifier
documentengagementtype varchar(100) true Type of document engagement (Preview)
externalcontactid varchar(100) true External contact identifier
feedbackcategory varchar(50) true Feedback category (Qualitative, Quantitative)
feedbackid varchar(100) true ID of the feedback
feedbackrating varchar(20) true Feedback rating (Negative, Positive)
feedbackratingtype varchar(20) true Feedback rating type (Binary)
feedbackratingvalue double precision true Feedback rating value
feedbackreason varchar(50) true Reason for negative feedback (DocumentContent, SearchResults)
feedbacktype varchar(20) true Feedback type (Explicit, Implicit)
hascomment boolean true True if textual comment was given
hassearch boolean true True if search request in session (Preview)
knowledgebasedocumentid varchar(100) true ID of the document
knowledgebasedocumentvariationid varchar(100) true ID of the document variation
knowledgebasedocumentversionid varchar(100) true Version ID of the document
knowledgebaseid varchar(100) true ID of the knowledge base
languagecode varchar(20) true Language code for the document
mediatype varchar(50) true Media type (Callback, Chat, Cobrowse, Email, Message, Screenshare, Video, Voice)
messagetype varchar(50) true Message type (Apple, FacebookMessenger, WhatsApp, etc.)
presenteddocumentscount integer true Documents presented in single event (Preview)
querytype varchar(50) true Query type (Article, AutoSearch, Category, ManualSearch, Recommendation, Suggestion)
queueid varchar(100) true ID of the queue
searchid varchar(100) true ID of the search event
searchquery varchar(500) true Search query text
selfserved boolean true Whether session was self-served (Preview)
sessionid varchar(100) true ID of the session
surfacingmethod varchar(50) true How knowledge was surfaced (Article, Generative, Highlight, Snippet) (Preview)
userid varchar(100) true ID of the user
intervalstart timestamp without time zone true Start of the aggregation interval
intervalend timestamp without time zone true End of the aggregation interval
usagedate date true Date of the usage for aggregation purposes
ndistinctknowledgesessions integer 0 true Distinct sessions count (Preview)
nknowledgedocumentcopied integer 0 true Times document was copied
nknowledgedocumentfeedback integer 0 true Times feedback was given on document
nknowledgedocumentpresented integer 0 true Times document was presented
nknowledgedocumentsurfaced integer 0 true Times document surfaced in search
nknowledgedocumentviewed integer 0 true Times document was viewed
nknowledgesearch integer 0 true Times knowledge base was searched
nknowledgesearchanswered integer 0 true Times query was answered
nknowledgesearchfeedback integer 0 true Times feedback on search response
nknowledgesearchunanswered integer 0 true Times query was unanswered
nknowledgesessions integer 0 true Number of guest sessions
oknowledgedocumentquery integer 0 true Queries per session
oknowledgedocumentqueryselfserved integer 0 true Self-served queries per session
oknowledgesearch integer 0 true Searches per session
updated timestamp without time zone CURRENT_TIMESTAMP true Timestamp when the record was last updated

Constraints

Name Type Definition
knowledgeaggregatesdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
knowledgeaggregatesdata_pkey CREATE UNIQUE INDEX knowledgeaggregatesdata_pkey ON public.knowledgeaggregatesdata USING btree (keyid)
knowledgeaggregatesdata_userid_idx CREATE INDEX knowledgeaggregatesdata_userid_idx ON public.knowledgeaggregatesdata USING btree (userid)
knowledgeaggregatesdata_knowledgebaseid_idx CREATE INDEX knowledgeaggregatesdata_knowledgebaseid_idx ON public.knowledgeaggregatesdata USING btree (knowledgebaseid)
knowledgeaggregatesdata_usagedate_idx CREATE INDEX knowledgeaggregatesdata_usagedate_idx ON public.knowledgeaggregatesdata USING btree (usagedate)
knowledgeaggregatesdata_updated_idx CREATE INDEX knowledgeaggregatesdata_updated_idx ON public.knowledgeaggregatesdata USING btree (updated)
knowledgeaggregatesdata_queueid_idx CREATE INDEX knowledgeaggregatesdata_queueid_idx ON public.knowledgeaggregatesdata USING btree (queueid)
knowledgeaggregatesdata_conversationid_idx CREATE INDEX knowledgeaggregatesdata_conversationid_idx ON public.knowledgeaggregatesdata USING btree (conversationid)
knowledgeaggregatesdata_sessionid_idx CREATE INDEX knowledgeaggregatesdata_sessionid_idx ON public.knowledgeaggregatesdata USING btree (sessionid)
knowledgeaggregatesdata_apptype_idx CREATE INDEX knowledgeaggregatesdata_apptype_idx ON public.knowledgeaggregatesdata USING btree (apptype)

    • Related Articles

    • public.vwknowledgebase

      Description Comprehensive view of knowledge bases with document, category, feedback, and usage statistics Table Definition CREATE VIEW vwknowledgebase AS ( SELECT kb.id, kb.name, kb.description, kb.corelanguage AS core_language, kb.datecreated AS ...

    • public.vwknowledgeaggregatesdata

      Description Knowledge usage analytics with user and knowledge base context for reporting Table Definition CREATE VIEW vwknowledgeaggregatesdata AS ( SELECT ka.keyid, ka.intervalstart AS interval_start, ka.intervalend AS interval_end, ka.usagedate AS ...

    • public.evalquestiondata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...