Microsoft 365 reports in the admin center – Microsoft 365 Copilot 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 Microsoft 365 Copilot usage report, which is in continuous enhancement, you can view a summary of how users’ adoption, retention, and engagement are with Microsoft 365 Copilot, 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 Microsoft 365 Copilot usage report?

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

Interpret the Microsoft 365 Copilot usage report

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

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

You can view several numbers for Microsoft 365 Copilot 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 Microsoft 365 Copilot licenses over the selected time period.

Active Users shows the total number of enabled users in your organization who tried a user-initiated Microsoft 365 Copilot 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
Business Chat (work) Chat Typing a message into the chat window or selecting a suggested prompt and submitting. Ask questions and get answers using Microsoft Copilot with Graph-grounded chat - 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
Business Chat (work) Going to the left side of Outlook web app, selecting Copilot from the apps list, typing a prompt and sending. This feature is included in the Outlook app level and all up Microsoft 365 active usage count effective August 28th, 2024. Get started with Microsoft 365 Copilot Business Chat
App Chat Going to top right corner of Outlook web app, selecting Copilot placed next to settings option, typing a prompt and sending. This feature is included in the Outlook app level and all up Microsoft 365 active usage count effective August 17th, 2024. Frequently asked questions about Copilot in Outlook
Teams Summarizing key points during meetings 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 and viewing the AI Notes section after the meeting ends (meeting is recorded and transcribed). Get started with Microsoft 365 Copilot in Teams - Microsoft Support
Business Chat (work) Going to Chat on the left side of Teams, selecting Copilot from the top of your Teams chat list, typing a prompt and sending. Get started with Microsoft 365 Copilot in Teams - Microsoft Support
Word All Copilot in Word features are automatically included in the Microsoft 365 Copilot usage report. Usage of any Copilot in Word feature counts towards the Active users metric and is indicated in the per-user Last activity date (UTC). To learn more about Copilot in Word features, refer to Welcome to Copilot in Word - Microsoft Support.
Excel All Copilot in Excel features are automatically included in the Microsoft 365 Copilot usage report. Usage of any Copilot in Excel feature counts towards the Active users metric and is indicated in the per-user Last activity date (UTC). To learn more about Copilot in Excel features, refer to Get started with Copilot in Excel - Microsoft Support.
PowerPoint All Copilot in PowerPoint features are automatically included in the Microsoft 365 Copilot usage report. Usage of any Copilot in PowerPoint feature counts towards the Active users metric and is indicated in the per-user Last activity date (UTC). To learn more about Copilot in PowerPoint features, refer to Welcome to Copilot in PowerPoint - Microsoft Support.
OneNote All Copilot in OneNote features are automatically included in the Microsoft 365 Copilot usage report. Usage of any Copilot in OneNote feature counts towards the Active users metric and is indicated in the per-user Last activity date (UTC). To learn more about Copilot in OneNote features, refer to Welcome to Copilot in OneNote - Microsoft Support.
Loop All Copilot in Loop features are automatically included in the Microsoft 365 Copilot usage report. Usage of any Copilot in Loop feature counts towards the Active users metric and is indicated in the per-user Last activity date (UTC). To learn more about Copilot in Loop features, refer to Get started with Microsoft 365 Copilot in Loop - Microsoft Support.

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

Important

The metrics displayed in this report are powered by data that is classified as required service data. Optional diagnostic data is not required for comprehensive information, although this may change in the future. Learn more about required service data.

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

Trend view shows you the daily time trend of Microsoft 365 Copilot 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 Microsoft 365 Copilot enabled user’s last activity date among Microsoft 365 Copilot 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 Microsoft 365 Copilot 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 Microsoft 365 Copilot 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 Microsoft 365 Copilot 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 Microsoft 365 Copilot 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 Microsoft 365 Copilot usage, use one of the following reports: the Microsoft 365 Copilot usage report in the Microsoft 365 Admin Center or the Copilot Dashboard in Viva Insights.

Is Copilot chat in Outlook usage counted towards active users of Outlook Copilot active users?

No. Meanwhile, Copilot chat in Outlook usage is counted towards Copilot chat active users.

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 Microsoft 365 Copilot 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 Microsoft 365 Copilot 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 Microsoft 365 Copilot within a short time window (less than 24 hours) after the Microsoft 365 Copilot license was assigned.
  2. The user subsequently had no other Microsoft 365 Copilot 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.