Applies to Product - Microsoft Copilot Studio
What’s happening?
Customers are seeking guidance on how to extract or connect to chatbot data stored in Azure Storage Tables to create insightful reports regarding chatbot usage, including metrics such as top users and categories of intents or queries.
Reason:
The underlying cause for the need to extract chatbot data is the transition of the chatbot from Power Virtual Agents to Copilot Studio, where the chat details are now stored in Azure Storage Tables. Additionally, the existing Copilot Analytics does not cover all desired metrics.
Resolution:
- Utilize Application Insights as the most effective method to obtain comprehensive and detailed telemetry data for the chatbot. Sample fields that can be queried using Application Insights can be found in the documentation: "Application Insights telemetry with Microsoft Copilot Studio - Dynamics 365."
- If Application Insights is not available due to cost constraints, download conversation transcripts from the Dataverse Table. Instructions for this can be found in the resource: "Download conversation transcripts in Power Apps - Microsoft Copilot Studio."
- Note that managing and monitoring the data can be challenging due to inconsistent formats. If necessary, manually parse the downloaded conversation transcriptions using programming or development tools.