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?
- In the admin center, go to Reports > Usage.
- Select the Copilot for Microsoft 365 page.
- 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:
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:
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 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 | |
| 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 after the meeting ends (meeting is recorded and transcribed). | Get started with Copilot for Microsoft 365 in Teams - Microsoft Support | |
| Copilot chat | 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 Copilot for Microsoft 365 in Teams - Microsoft Support | |
| Word | All Copilot in Word features are automatically included in the Copilot for Microsoft 365 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 Copilot for Microsoft 365 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 Copilot for Microsoft 365 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 Copilot for Microsoft 365 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 Copilot for Microsoft 365 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 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.
When switching to Trend view, you can select one product in the dropdown list to see daily usage.
In the Adoption section, you may see a recommendation card:
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.
Select Choose columns to add or remove columns from the table.
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.
In Microsoft 365 admin center, go to the Settings > Org Settings, and under Services tab, choose Reports.
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.
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 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 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:
- 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.
- 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.