Analyze session information in Copilot Studio

By default, you can download up to seven days of copilot conversation transcripts from the past 30 days directly from the Copilot Studio portal.

You can also download and view conversation transcripts in the Power Apps portal.

See Work with conversation transcripts for more details and tips.

Prerequisites

• To view session transcripts, one needs to have the transcript viewer security role. Only admins can grant this role by Assign the Copilot transcript viewer security role during copilot sharing.

Download copilot session transcripts

1. In the Microsoft Copilot Studio navigation menu, select Analytics.

2. Select the Sessions tab.

   If your copilot has many sessions, they're displayed in multiple rows. Each row contains up to 2,500 sessions.

3. Select a row to download.

   

The download starts immediately. The file is saved to your browser's default download location.

Work with session transcripts

The session transcript is a comma-separated values (CSV) file that contains the following information:

• SessionID: The session's unique identifier

• StartDateTime: The time the session started (by default, sessions are sorted by this column in descending order)

• InitialUserMessage: The first message the user typed

• TopicName: The name of the last authored topic that was triggered in the session

• ChatTranscript: The transcript of the session in the format User says: ; Bot says: ;
  For example:

  User says: store hours; Bot says: Which store are you asking about?; User says: Bellevue; Bot says: Bellevue store is open from 10am to 7pm every day.;
  

  Bot says doesn't include the options presented to the user.

• SessionOutcome: The outcome of the session (Resolved, Escalated, Abandoned, Unengaged)

• TopicId: The unique identifier of the last authored topic triggered in the session

1. In the navigation menu, select Analytics. Go to the Sessions tab.

   If your copilot had a high number of sessions, they'll be broken down into multiple rows. Each row contains 2500 sessions.

2. Select each row to download the session transcripts for the specified time frame.

   

The downloaded file contains the following information:

• SessionID: A unique identifier per session.

• StartDateTime: Time at which the session started. Entries are sorted by this column in descending order.

• InitialUserMessage: First message typed by the user.

• TopicName: Name of the last authored topic that was triggered in this session.

• ChatTranscript: Transcript of the session in the following format, User says: <message-text>; Bot says: <message-text>;.

  • Conversation turns are separated by semicolons

  • Bot says doesn't include the options presented to the user.

    Example:

    User says: store hours; Bot says: Which store are you asking about?; User says: Bellevue; Bot says: Bellevue store is open from 10am to 7pm every day.;
    

• SessionOutcome: Outcome of the session (Resolved, Escalated, Abandoned, Unengaged).

• TopicId: A unique identifier of the last authored topic triggered in this session.