public.agentcopilotaggregatesdata

public.agentcopilotaggregatesdata

Description

Aggregated agent copilot usage metrics from Genesys Cloud Analytics API with all 24 dimensions

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(200) false SHA256 hash of all 24 dimensions + interval for uniqueness
agentassistantid varchar(100) true Agent assistant ID from groupBy
cannedresponseid varchar(100) true Canned response ID from groupBy
cannedresponselibraryid varchar(100) true Canned response library ID from groupBy
chunkcount integer true Chunk count from groupBy
conversationid varchar(100) true Conversation ID from groupBy
engagementtype varchar(50) true Engagement type from groupBy
externalcontactid varchar(100) true External contact ID from groupBy
feedbackrating integer true Feedback rating from groupBy
hasanswerhighlight boolean true Has answer highlight from groupBy
hasgeneratedanswer boolean true Has generated answer from groupBy
knowledgebasedocumentid varchar(100) true Knowledge base document ID from groupBy
knowledgebasedocumentversionid varchar(100) true Knowledge base document version ID from groupBy
mediatype varchar(50) true Media type (voice, chat, email) from groupBy
messageid varchar(100) true Message ID from groupBy
queueid varchar(100) true Queue ID where copilot was used from groupBy
scriptid varchar(100) true Script ID from groupBy
scriptpageid varchar(100) true Script page ID from groupBy
searchid varchar(100) true Search ID from groupBy
state varchar(50) true State of the copilot interaction from groupBy
suggestionid varchar(100) true Suggestion ID from groupBy
suggestiontype varchar(100) true Type of suggestion made by copilot from groupBy
triggertype varchar(50) true Trigger type from groupBy
userid varchar(100) true User ID of the agent using copilot from groupBy
utteranceid varchar(100) true Utterance ID from groupBy
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
ncannedresponsesuggestions integer 0 true Count of canned response suggestions made by copilot
ndistinctsuggestions integer 0 true Count of distinct suggestions made by copilot
nknowledgeanswersuggestions integer 0 true Count of knowledge answer suggestions made by copilot
nknowledgearticlesuggestions integer 0 true Count of knowledge article suggestions made by copilot
nknowledgesearchsuggestions integer 0 true Count of knowledge search suggestions made by copilot
nscriptsuggestions integer 0 true Count of script suggestions made by copilot
updated timestamp without time zone CURRENT_TIMESTAMP true Timestamp when the record was last updated

Constraints

Name Type Definition
agentcopilotaggregatesdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
agentcopilotaggregatesdata_pkey CREATE UNIQUE INDEX agentcopilotaggregatesdata_pkey ON public.agentcopilotaggregatesdata USING btree (keyid)
agentcopilotaggregatesdata_userid_idx CREATE INDEX agentcopilotaggregatesdata_userid_idx ON public.agentcopilotaggregatesdata USING btree (userid)
agentcopilotaggregatesdata_queueid_idx CREATE INDEX agentcopilotaggregatesdata_queueid_idx ON public.agentcopilotaggregatesdata USING btree (queueid)
agentcopilotaggregatesdata_conversationid_idx CREATE INDEX agentcopilotaggregatesdata_conversationid_idx ON public.agentcopilotaggregatesdata USING btree (conversationid)
agentcopilotaggregatesdata_state_idx CREATE INDEX agentcopilotaggregatesdata_state_idx ON public.agentcopilotaggregatesdata USING btree (state)
agentcopilotaggregatesdata_mediatype_idx CREATE INDEX agentcopilotaggregatesdata_mediatype_idx ON public.agentcopilotaggregatesdata USING btree (mediatype)
agentcopilotaggregatesdata_suggestiontype_idx CREATE INDEX agentcopilotaggregatesdata_suggestiontype_idx ON public.agentcopilotaggregatesdata USING btree (suggestiontype)
agentcopilotaggregatesdata_usagedate_idx CREATE INDEX agentcopilotaggregatesdata_usagedate_idx ON public.agentcopilotaggregatesdata USING btree (usagedate)
agentcopilotaggregatesdata_updated_idx CREATE INDEX agentcopilotaggregatesdata_updated_idx ON public.agentcopilotaggregatesdata USING btree (updated)

    • Related Articles

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

    • public.userinteractionpresencedetaileddata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone ...

    • public.evaldata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) false evaluationid varchar(50) false calibrationid varchar(50) true evaluationformid varchar(50) true evaluatorid varchar(50) ...