แก้ไข

แชร์ผ่าน


Microsoft 365 reports in the Admin Center – Copilot for Microsoft 365 usage

The Microsoft 365 Usage dashboard shows you the activity overview across the Microsoft 365 productivity apps in your organization. It enables you to drill into individual product-level reports to give you more granular insight about the activities within each app. To view all reports, check out the Reports overview article.

In the Copilot for Microsoft 365 usage report, which is in continuous enhancement, you can view a summary of how users’ adoption, retention, and engagement are with Copilot for Microsoft 365, and the activity of every Copilot user in your organization. For Copilot activity on a given day, the report becomes available within 72 hours of the end of that day (in UTC).

How do I get to the Copilot for Microsoft 365 usage report?

  1. In the admin center, go to Reports > Usage.
  2. Select the Copilot for Microsoft 365 page.
  3. Select the Usage tab to view adoption and usage metrics.

Interpret the Copilot for Microsoft 365 usage report

You can use this report to see the usage of Copilot for Microsoft 365 in your organization.

At the top, you can filter by different periods. The Copilot for Microsoft 365 report can be viewed over the last 7 days, 30 days, 90 days, or 180 days.

You can view several numbers for Copilot for Microsoft 365 usage, which highlight the enablement number and the adoption of the enablement:

Screenshot showing Microsoft 365 Copilot usage summary information.

Enabled Users shows the total number of unique users in your organization with Copilot for Microsoft 365 licenses over the selected time period.

Active Users shows the total number of enabled users in your organization who tried a user-initiated Copilot for Microsoft 365 feature, in one or more apps in Microsoft 365 over the selected time period.

Active users rate shows you the number of active users in your organization divided by the number of enabled users.

In Recommendations, the recommended action card highlights Microsoft Copilot Dashboard, where you can deliver insights to your IT leaders to explore Copilot readiness, adoption, and impact in Viva Insights.

You can see the following summary charts in this report as default view:

Screenshot showing Microsoft 365 Copilot usage adoption chart.

The definitions for Enabled Users and Active Users metrics are the same as provided earlier.

The following table lists the features included for active users of Copilot apps:

Copilot app Features How to use Learn more about the feature
Copilot chat Chat Typing a message into the chat window and submitting. Ask questions and get answers using Microsoft Copilot with Graph-grounded chat - Microsoft Support
Try those prompts Selecting a prompt from the Try these prompts section, which will automatically copy the prompt into the chat box, and submitting with or without updating the prompt. Ask questions and get answers using Microsoft Copilot with Graph-grounded chat - Microsoft Support
Catch up Selecting one of the suggestions from the Catch up tab in some platforms (such as Microsoft365.com), and submitting with or without updating the prompt. Catch up on things quickly using Microsoft Copilot with Graph-grounded chat - Microsoft Support
Teams Copilot in Microsoft Teams meetings For example, summarizing key discussion points during meeting using Copilot in Microsoft. Teams Get started with Copilot in Microsoft Teams meetings - Microsoft Support
Summarize chats and channel conversations Typing a prompt or selecting a prompt from More prompt in Copilot compose box in a chat or channel and submitting. Use Copilot in Microsoft Teams chat and channels - Microsoft Support
Rewrite and adjust messages Writing a message in message box, selecting Rewrite/Adjust in Copilot beneath the message box to rewrite/adjust the whole/specific selection of the message. Rewrite and adjust your messages with Copilot in Microsoft Teams - Microsoft Support
Intelligent Recap Selecting Recap tab in the meeting chat for Teams calendar event after the meeting ends (meeting is recorded and transcribed). Meeting recap in Microsoft Teams - Microsoft Support
Word Summarize a Word document Selecting Copilot from the ribbon to open the Copilot pane, and in the Copilot compose box, entering in "summarize this document." Create a summary of your document with Copilot - Microsoft Support
Draft a Word document Using Draft with Copilot box, typing or pasting prompt and selecting Generate to let Copilot generate. content Draft and add content with Copilot in Word - Microsoft Support
Rewrite a Word document Selecting the text you want Copilot to rewrite and from the left margin Copilot menu, selecting Auto-rewrite. Transform your content with Copilot in Word - Microsoft Support
Chat with Copilot Selecting Copilot from the ribbon to open the Copilot pane, and in the Copilot compose box, typing prompts in Copilot compose box and submitting. Chat with Copilot about your Word document - Microsoft Support
Excel Identify insights Selecting Copilot from the ribbon to open the Copilot pane, selecting Analyze and choose a suggested prompt. Or describing what you’d like to know by asking a question about your data in your own words and submitting. Identify insights with Copilot in Excel - Microsoft Support
Selecting the Copilot button in the ribbon, then telling Copilot how you'd like to manipulate the table to better view portions of your data. Highlight, sort, and filter your data with Copilot in Excel - Microsoft Support
Selecting the Copilot button on the ribbon. Selecting Add formula columns or Show suggestions for formula columns from the Copilot chat panel on the right-hand side. Or describing what columns you’d like to add by typing it in your own words and submitting. Generate formula columns with Copilot in Excel - Microsoft Support
PowerPoint Create a PowerPoint presentation Selecting Copilot from the ribbon to open the Copilot pane, and clicking or typing Create a presentation, completing the prompt with what you would like Copilot to help you draft and submitting. Create a new presentation with Copilot in PowerPoint - Microsoft Support
Summarize presentation Selecting Copilot from the ribbon to open the Copilot pane, typing Summarize this presentation**,** and submitting. Summarize your presentation with Copilot in PowerPoint - Microsoft Support
Outlook Summarize an Outlook email thread In an email thread, selecting Summarize by Copilot or Summarize at the top of the email thread. (User experience is slightly different among web, Windows, Mac or mobile.) Summarize an email thread with Copilot in Outlook - Microsoft Support
Generate an Outlook email draft Selecting Copilot icon from the toolbar, selecting Draft with Copilot, typing prompt in Copilot box and submitting. (User experience is slightly different among web, Windows, Mac or mobile.) Draft an email message with Copilot in Outlook - Microsoft Support
Coach Selecting Copilot icon in the email message, choosing ‘Coaching by Copilot’ and Copilot will review email and offer suggestions on improving the tone, clarity and reader sentiment. (User experience is slightly different among web, Windows, Mac or mobile.) Email coaching with Copilot in Outlook - Microsoft Support
OneNote Summarize notes Selecting Copilot from Home ribbon, in Copilot compose box, typing summarize the notes prompt and submitting. Summarize your OneNote notes with Copilot for Microsoft 365 - Microsoft Support
Chat with Copilot Selecting Copilot from Home ribbon, in Copilot compose box, typing prompt and submitting. Chat with Copilot about your notes and research questions - Microsoft Support
Loop Draft page content Typing ‘/’ and selecting Draft page content from the dropdown menu, choosing from pre-suggested prompts or typing own prompt and submitting. Get started with Copilot for Microsoft 365 in Loop - Microsoft Support
Summarize page Typing ‘/’ and selecting Summarize page from the dropdown menu. Get started with Copilot for Microsoft 365 in Loop - Microsoft Support
Rewrite content Highlighting the existing content that you want to rewrite and selecting the menu to the left of the highlighted text. Choosing Refine with Copilot. Rewrite content with Copilot for Microsoft 365 in Loop - Microsoft Support
Chat with Copilot Using the prompt box to ask questions about the content on the page and submitting. Do more with your page content with Copilot for Microsoft 365 in Loop - Microsoft Support

To note, Active users of Word, Excel, and PowerPoint is incomplete prior to Jan 25, 2024.

Important

Your organization must have optional diagnostic telemetry for Office apps enabled for Windows, Mac, iOS, and Android in order for comprehensive usage information to be captured in this report. Learn more about diagnostic telemetry settings.

Summary view shows you the total usage of Copilot for Microsoft 365 among Microsoft 365 productivity apps of the time frame.

Trend view shows you the daily time trend of Copilot for Microsoft 365 among Microsoft 365 productivity apps of the time frame.

You can switch between Summary view and Trend view.

In the hover status in Summary view, you can see the selected time frame and data refresh time.

Screenshot showing the time period view for Microsoft 365 Copilot adoption chart.

When switching to Trend view, you can select one product in the dropdown list to see daily usage.

Screenshot showing the dropdown list of products for Microsoft 365 Copilot adoption chart.

In the Adoption section, you may see a recommendation card:

Screenshot showing the recommendation card for Microsoft 365 Copilot adoption.

To learn more about using organizational messages for Microsoft 365 Copilot, see Microsoft 365 features adoption using organizational messages.

You can also export the report data into an Excel .csv file by selecting the ellipses and then Export in the top-right corner.

You can view a table list to show each Copilot for Microsoft 365 enabled user’s last activity date among Copilot for Microsoft 365 products.

Screenshot showing the activity for the Microsoft 365 Copilot usage report.

Select Choose columns to add or remove columns from the table.

Screenshot showing the columns you can select for the Microsoft 365 Copilot usage report.

You can also export the report data into an Excel .csv file by selecting the Export link. This exports the Copilot for Microsoft 365 usage data of all users and enables you to do simple sorting, filtering, and searching for further analysis.

To ensure data quality, we perform daily data validation checks for the past three days and will fill any gaps detected. You may notice differences in historical data during the process.

User last activity table

Item Description
User name The user's principal name.
Display name The full name of the user.
Last activity date (UTC (Universal Time Code)) The latest date the user had activity in Copilot for Microsoft 365 among all Microsoft 365 products, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Teams Copilot (UTC) The latest date the user had activity in Microsoft Teams Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Word Copilot (UTC) The latest date the user had activity in Word Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Excel Copilot (UTC) The latest date the user had activity in Excel Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of PowerPoint Copilot (UTC) The latest date the user had activity in PowerPoint Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Outlook Copilot (UTC) The latest date the user had activity in Outlook Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of OneNote Copilot (UTC) The latest date the user had activity in OneNote Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Loop Copilot (UTC) The latest date the user had activity in Loop Copilot, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.
Last activity date of Copilot chat (UTC) The latest date the user had activity in Copilot chat, including any of the intentional activities, regardless of the selected time period of past 7/30/90/180 days.

Make the user-specific data anonymous

To make the data in the Copilot for Microsoft 365 report anonymous, you must be a global administrator. This will hide identifiable information (using MD5 hashes) such as display name, email, and Microsoft Entra Object ID in report and their export.

  1. In Microsoft 365 admin center, go to the Settings > Org Settings, and under Services tab, choose Reports.

  2. Select Reports, and then choose to Display anonymous identifiers. This setting gets applied both to the usage reports in Microsoft 365 admin center and Teams admin center.

  3. Select Save changes.

FAQ

How is a user considered active in Copilot for Microsoft 365 usage?

A user is considered active in a given app if they performed an intentional action for an AI-powered capability. For example, if a user selects the Copilot icon in the Word ribbon to open the Copilot chat pane, this does not count towards active usage. However, if the user interacts with the chat pane by submitting a prompt, this action would count towards active usage.

What's the difference between the user activity table and audit log?

The audit log data that powers Microsoft Purview solutions, such as AI hub, are built for data security and compliance purposes, and provide comprehensive visibility into Copilot interactions for these use cases (for example, to discover data oversharing risks or to collect interactions for regulatory compliance or legal purposes). They are not, however, intended to be used as the basis for Copilot usage reporting. Any aggregated metrics that customers build on top of this data, such as "prompt count" or "active user count," may not be consistent with the corresponding data points in the official Copilot usage reports provided by Microsoft. Microsoft cannot provide guidance on how to use audit log data as the basis for usage reporting, nor can Microsoft guarantee that aggregated usage metrics built on top of audit log data will match similar usage metrics reported in other tools.

To access accurate information on Copilot for Microsoft 365 usage, use one of the following reports: the Copilot for Microsoft 365 usage report in the Microsoft 365 Admin Center or the Copilot Dashboard in Viva Insights.

Is Intelligent Recap usage in Teams captured in Usage reports?

Yes. Intelligent Recap has been captured in Teams Copilot in Copilot for Microsoft 365 usage.

What’s the scope of the user-level table?

The user-level table in the report is configured to show all users who were licensed for Copilot for Microsoft 365 at any point over the past 180 days, even if the user has since had the license removed or never had any Copilot active usage.

I assigned the Copilot for Microsoft 365 license to users, but why is 'last activity date' for users empty in rare cases?

Based on system constraints, some users may not have a 'last activity date' in the user-level table of the report under the following conditions:

  1. The user used Copilot for Microsoft 365 within a short time window (less than 24 hours) after the Copilot for Microsoft 365 license was assigned.
  2. The user subsequently had no other Copilot for Microsoft 365 usage up to the date on which the report is viewed.

Why is the 'Last activity date of Word, Excel, PowerPoint, OneNote, or Outlook Copilot (UTC)' sometimes blank or newer than the actual date, even when users have recently used Copilot features?

This may be caused by a known limitation: the uploading of client events data for Copilot features in Word, Excel, PowerPoint, OneNote, and Outlook can be delayed for various reasons, such as when end users disconnect from the internet immediately after taking a Copilot action.

How do the numbers in this report compare to what is shown in the Microsoft Copilot Dashboard in Viva Insights?

The data in these reports is based on the same underlying definitions of active usage, but the population of users included in the analysis and the timeframe displayed may differ. To learn more, see Use Microsoft Copilot Dashboard advanced features with a Viva Insights subscription.