Power Platform Community Forum Thread Details

While doing some digging here on the forums one user in a semi-related thread: Can I retrieve the thumbs up/down and comment added by user via Application Insights? said that ConversationTranscripts is the go to spot for this data. Other areas of the forums have said it's only housed internally on admin reporting and decoupled from conversation data.

Does anyone have a way to pull this data via Dataverse or is this not possible? I have parsed through ConversationTranscripts extensively and have not seen any feedback data.

Categories:

Bot analytics

Hi @Brozine,

<cite index="72-1">Feedback data is stored in the conversation transcript table in Dataverse.</cite> So the community members saying it's in ConversationTranscripts were correct, but you need to look in the right field within those records.

The feedback isn't a standalone column that's easy to spot. It's embedded inside the transcript content itself as part of the conversation JSON payload. When a user gives a thumbs up/down and adds a comment, that event is recorded as a conversation activity within the transcript record's content field.

To find it: query the ConversationTranscript table and parse the Content field (which is JSON). Look for activity types that represent feedback events. The thumbs up/down and comment will appear as specific activity types in the conversation activity stream.

Comments are available for 28 days. <cite index="71-1">If you have the bot transcript viewer role, you can see the comments in the Analytics page by clicking on the side card in the reactions section.</cite>

For querying via Dataverse API, filter ConversationTranscript records and parse the Content JSON for feedback activity types. There's no dedicated standalone feedback table for Copilot Studio agents separate from the transcript.

Ref: https://learn.microsoft.com/en-us/microsoft-copilot-studio/analytics-improve-agent-effectiveness

Best regards,

Valantis ✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/ 💼 LinkedIn ▶️ YouTube