public.copilotusagedata

public.copilotusagedata

Description

Copilot feature usage analytics data with full groupBy dimension support

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(200) false Composite primary key: conversationid|summaryid|queueid|userid
conversationid varchar(100) true Conversation GUID from groupBy
summaryid varchar(100) true Summary GUID from groupBy
queueid varchar(100) true Queue GUID from groupBy
userid varchar(100) true User GUID from groupBy
triggersourceid varchar(100) true Trigger source ID from groupBy
copied boolean true Whether summary was copied (from groupBy)
presented boolean true Whether summary was presented (from groupBy)
summarygenerated boolean true Whether summary was generated (from groupBy)
wrapupcodesgenerated boolean true Whether wrap-up codes were generated (from groupBy)
wrapupcodesuggestionselected boolean true Whether wrap-up code suggestion was selected (from groupBy)
editedfield varchar(100) true Field that was edited (from groupBy)
errortype varchar(100) true Error type if any (from groupBy)
language varchar(10) true Language detected (from groupBy)
mediatype varchar(50) true Media type (from groupBy)
messagetype varchar(50) true Message type (from groupBy)
triggersourceoutcome varchar(100) true Trigger source outcome (from groupBy)
triggersourcetype varchar(100) true Trigger source type (from groupBy)
summaryrating integer true Summary rating (from groupBy)
wrapupcoderating integer true Wrap-up code rating (from groupBy)
usagedate date true Derived usage date for aggregation (UTC)
nconversationsummaries integer true Number of conversation summaries (metric)
nconversationsummaryengagements integer true Number of conversation summary engagements (metric)
tconversationsummary integer true Time spent on conversation summary (metric)
updated timestamp without time zone true Date row was last updated (UTC)

Constraints

Name Type Definition
copilotusagedata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
copilotusagedata_pkey CREATE UNIQUE INDEX copilotusagedata_pkey ON public.copilotusagedata USING btree (keyid)
ix_copilotusagedata_usagedate CREATE INDEX ix_copilotusagedata_usagedate ON public.copilotusagedata USING btree (usagedate)
ix_copilotusagedata_queueid CREATE INDEX ix_copilotusagedata_queueid ON public.copilotusagedata USING btree (queueid)
ix_copilotusagedata_userid CREATE INDEX ix_copilotusagedata_userid ON public.copilotusagedata USING btree (userid)
ix_copilotusagedata_conversationid CREATE INDEX ix_copilotusagedata_conversationid ON public.copilotusagedata USING btree (conversationid)
ix_copilotusagedata_summaryid CREATE INDEX ix_copilotusagedata_summaryid ON public.copilotusagedata USING btree (summaryid)

    • Related Articles

    • public.vwcopilotsummaryinsights

      Description Comprehensive view combining conversation summaries, AI-generated voice summaries, and copilot usage analytics for insights into summary effectiveness and usage patterns Table Definition CREATE VIEW vwcopilotsummaryinsights AS ( SELECT ...

    • public.vwcopilotusagedata

      Description Comprehensive view of Copilot usage analytics with user and queue context for reporting and analysis Table Definition CREATE VIEW vwcopilotusagedata AS ( SELECT cu.keyid, cu.conversationid, cu.summaryid, cu.usagedate, cu.userid, ud.name ...

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • 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.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 ...