Extract data from Microsoft copilot agent

Question

I would like to extract data ( how many people use the chatbot, the frequency, most asked questions etc) from my customised copilot agent.

Answer 1

You’ll get the real usage data only by pairing Studio Analytics with a direct query on Dataverse’s ConversationTranscript, filtering by user, intent and timestamp to surface true freq patterns.

Answer 2

To extract data about the usage of your customized Copilot agent, you can utilize the metrics available in the Microsoft Copilot Dashboard. This includes information such as the number of actions taken by users in applications like Outlook, PowerPoint, Teams, and Word. Additionally, you can gather insights on prompts submitted through Copilot Chat in various environments.

For specific data like the frequency of use and most asked questions, you may need to analyze the conversation transcripts stored in the ConversationTranscript table in Dataverse. This table logs interactions between users and the agent, which can help identify frequently asked questions and user engagement patterns.

To summarize, you can:

1. Access the Microsoft Copilot Dashboard for overall usage metrics.
2. Analyze the ConversationTranscript table to identify user interactions and common inquiries.

---

References:

• Export Copilot metrics from the Microsoft Copilot Dashboard (preview)
• Extract and analyze agent conversation transcripts