You need to track how your organization uses Copilot to measure adoption and identify training needs. The Microsoft 365 admin center provides a dedicated Copilot activity report that shows daily active users, total interactions, and engagement trends. This article explains how to access that report, interpret the key metrics, and filter data by date range or user group. You will also learn how to export the raw data for deeper analysis in Excel or Power BI.
Key Takeaways: Accessing Copilot Activity Reports
- Microsoft 365 admin center > Reports > Usage > Copilot: The direct path to open the Copilot activity dashboard.
- Date range filter (7, 30, 90, 180 days): Controls how far back the report shows daily active user and interaction data.
- Export button (CSV format): Downloads raw data for each metric so you can analyze trends in external tools.
What the Copilot Activity Report Shows
The Copilot activity report is a prebuilt dashboard inside the Microsoft 365 admin center. It aggregates telemetry from all Copilot-enabled Microsoft 365 apps, including Word, Excel, PowerPoint, Outlook, Teams, and the Copilot web interface. The report does not require any additional licensing beyond an active Copilot for Microsoft 365 subscription. You must have the Reports Reader, Global Reader, or Global Admin role to view it.
The main dashboard displays two primary charts:
- Daily active users — the number of unique users who performed at least one Copilot action on a given day.
- Total interactions — the sum of all Copilot queries, prompts, and commands executed across apps.
Below the charts, a table lists each user with their display name, email, last activity date, and total interaction count. This table is sortable by any column. You can also filter the table by product, such as showing only interactions from Word or only from Teams.
Steps to View the Copilot Activity Report
- Sign in to the Microsoft 365 admin center
Open your browser and go to admin.microsoft.com. Sign in with an account that has the Reports Reader, Global Reader, or Global Admin role. - Navigate to Reports
In the left navigation pane, select Reports. If the menu is collapsed, click the hamburger icon at the top left to expand it. - Open the Usage section
Under Reports, click Usage. This opens the Usage reports overview page. - Select the Copilot report
Scroll down the list of product reports until you see Copilot. Click it to load the Copilot activity dashboard. The report may take a few seconds to generate. - Adjust the date range
At the top of the dashboard, click the date range dropdown. Choose 7 days, 30 days, 90 days, or 180 days. The charts and table will refresh automatically. - Filter by product if needed
To see data for a specific app, click the Filter button above the table. Select a product from the list, such as Word, Excel, or Teams. The table will show only interactions from that product. - Export the data
Click the Export button at the top of the dashboard. The report downloads as a CSV file. Open the file in Excel or import it into Power BI for custom analysis.
If the Copilot Report Is Missing or Empty
Copilot report does not appear in the Usage list
This usually means your tenant does not have any active Copilot for Microsoft 365 licenses assigned to users. Go to Billing > Licenses in the admin center and verify that at least one Copilot license is assigned to a user. After assignment, the report can take up to 48 hours to show data.
Report shows zero daily active users
If users have licenses but the report shows no activity, confirm that Copilot is enabled in the Microsoft 365 apps. In Word or Excel, check that the Copilot icon appears on the Home ribbon. Also verify that network policies do not block the telemetry endpoints required by Copilot. The required endpoints are listed in the Microsoft 365 URLs and IP address ranges documentation.
Data is delayed or incomplete
The Copilot activity report updates once every 24 hours. Data from the current day will not appear until the following day. If data for a past date is missing, wait 48 hours and refresh the report. Persistent gaps may indicate a connectivity issue between your tenant and the Microsoft telemetry service.
Copilot Activity Report vs User Adoption Report: Key Differences
| Item | Copilot Activity Report | User Adoption Report |
|---|---|---|
| Purpose | Tracks daily usage of Copilot features | Measures overall adoption of Microsoft 365 apps |
| Metrics shown | Daily active users, total interactions, per-user activity | Active users, app launches, feature usage per app |
| Data source | Copilot telemetry from Word, Excel, PowerPoint, Outlook, Teams | Aggregated telemetry from all Microsoft 365 workloads |
| Filtering options | Date range, product (Word, Excel, Teams, etc) | Date range, product, group, user |
| Export format | CSV | CSV |
The Copilot activity report focuses exclusively on Copilot interactions. The User Adoption report covers broader app usage. Use both reports together to correlate Copilot adoption with overall Microsoft 365 engagement. For example, if Copilot usage is high but overall Word usage is low, users may be using Copilot in other apps more frequently.
You can now access the Copilot activity report in the Microsoft 365 admin center, apply date and product filters, and export data for offline analysis. Try comparing the 30-day and 90-day views to spot adoption trends. For advanced reporting, connect the exported CSV to Power BI and build a dashboard that combines Copilot data with other Microsoft 365 usage metrics.