Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Export Copilot metrics from the Microsoft Copilot Dashboard (preview)
Important
This feature is for public preview customers only. Features in preview might not be complete and could undergo changes before becoming available in the broader release. This preview feature allows personal data processing. See the "Previews" section of the Microsoft Products and Services Data Protection Addendum for more information.
You can download de-identified user-level, weekly Microsoft 365 Copilot metrics spanning the past six months using the Copilot Dashboard's data export feature. Personal identifiers are removed and replaced with anonymized IDs.
With this feature, you can create custom reports, communications, and insightful analyses to support your organization.
This capability helps you:
Understand Microsoft 365 Copilot adoption across applications and plan adoption strategies.
Track Copilot Chat adoption, including activity and usage from users without Copilot licenses.
Measure and evaluate the impact of Copilot usage across employees.
Gain deeper visibility into Copilot usage trends and patterns.
Prerequisites
License requirement – Your tenant must have at least 50 Copilot or Viva Insights licenses assigned.
Access requirement – You must have global access to the Copilot Dashboard. This includes:
Senior leaders automatically identified through Entra ID data. Learn more about how automatic access is determined.
Users manually assigned global access by admins
Delegates assigned by users with global access. Learn more about how to delegate access to Copilot Dashboard and Copilot Insights.
Viva Insights Analysts with global access
Microsoft 365 Global Administrators
Note
Users with non-global access, such as managers with team-level views, can not access this feature to export data.
Admin management
The feature is on by default for eligible tenants and users. Global admins can disable or re-enable the feature for the tenant or specific groups through Viva Feature Access Management (VFAM) in the Microsoft 365 admin center. Learn more. Changes can take up to 24 hours to appear in the web app.
How to export data
Eligible tenants and users can export directly from the Copilot Dashboard by selecting Export data.
👁 Screenshot showing how export data from the Copilot Dashboard.
After you select Export data, the download starts automatically in your browser.
Example export
👁 Screenshot that shows an example of exported data.
Note
Each export contains six months of weekly aggregated Copilot metrics at the user level (with identifiers removed) across the adoption and impact pages. You can't customize the exports.
Metrics included in the exported data
Note
Zero values might appear for some metrics in the exported data because it includes Copilot usage for users both with and without Copilot licenses. For users with Copilot licenses, Copilot Chat metrics (without Copilot license) remain zero because their activity is counted under Microsoft 365 Copilot metrics. For users without Copilot licenses, the pattern is reversed.
Use the Total Copilot enabled days metric to identify which users have Copilot enabled.
To learn the definitions of the metrics below, refer to the Viva Insights metrics guide.
| Type | Metric |
|---|---|
| Microsoft 365 Copilot metrics | Add content to presentation actions taken |
| Chat (Copilot in Excel) prompts submitted | |
| Chat (Copilot in PowerPoint) prompts submitted | |
| Chat (Copilot in Word) prompts submitted | |
| Compose chat message actions taken using Copilot in Teams | |
| Copilot actions taken in Microsoft 365 Copilot app | |
| Copilot actions taken in Copilot Chat (work) | |
| Copilot actions taken in Excel | |
| Copilot actions taken in Outlook | |
| Copilot actions taken in PowerPoint | |
| Copilot actions taken in Teams | |
| Copilot actions taken in Word | |
| Copilot actions taken in Edge | |
| Copilot actions taken in OneNote | |
| Copilot Chat (web) prompts submitted | |
| Copilot Chat (web) prompts submitted in Teams | |
| Copilot Chat (web) prompts submitted in Outlook | |
| Copilot Chat (web) prompts submitted in Word | |
| Copilot Chat (web) prompts submitted in PowerPoint | |
| Copilot Chat (web) prompts submitted in Excel | |
| Copilot Chat (work) enabled days | |
| Copilot Chat (work) prompts submitted | |
| Copilot Chat (work) prompts submitted in Outlook | |
| Copilot Chat (work) prompts submitted in Teams | |
| Copilot Chat (work) prompts submitted in Word | |
| Copilot Chat (work) prompts submitted in PowerPoint | |
| Copilot Chat (work) prompts submitted in Excel | |
| Copilot enabled days for Intelligent Search | |
| Copilot enabled days for Power Platform connectors | |
| Copilot enabled days for Productivity App | |
| Copilot enabled days for Teams | |
| Create Excel formula actions taken using Copilot | |
| Excel formatting actions taken using Copilot | |
| Excel analysis actions taken using Copilot | |
| Excel clean data actions taken using Copilot | |
| Excel chat helper actions taken using Copilot | |
| Excel formula by example actions taken using Copilot | |
| Create presentation actions taken using Copilot | |
| Suggest presentation actions taken using Copilot | |
| Translate presentation actions taken using Copilot | |
| Rewrite presentation actions taken using Copilot | |
| Days of active Copilot Chat (web) usage | |
| Days of active Copilot Chat (work) usage | |
| Days of active Copilot usage in Excel | |
| Days of active Copilot usage in Loop | |
| Days of active Copilot usage in OneNote | |
| Days of active Copilot usage in Outlook | |
| Days of active Copilot usage in PowerPoint | |
| Days of active Copilot usage in Teams | |
| Days of active Copilot usage in Word | |
| Draft Word document actions taken using Copilot | |
| Coach Word document actions taken using Copilot | |
| Email coaching actions taken using Copilot | |
| Generate email draft actions taken using Copilot in Outlook | |
| Highlight rewrite email actions taken using Copilot | |
| Suggested reply email actions taken using Copilot | |
| Intelligent recap actions taken | |
| Meeting hours recapped by Copilot | |
| Meeting hours summarized by Copilot in Teams | |
| Meetings recapped by Copilot | |
| Rewrite text actions taken using Copilot in Word | |
| Summarize chat actions taken using Copilot in Teams | |
| Summarize email thread actions taken using Copilot in Outlook | |
| Summarize meeting actions taken using Copilot in Teams | |
| Summarize presentation actions taken using Copilot in PowerPoint | |
| Summarize Word document actions taken using Copilot in Word | |
| Total chat conversations summarized by Copilot in Teams | |
| Total Copilot actions taken | |
| Total Copilot active days | |
| Total Copilot enabled days | |
| Total emails sent using Copilot in Outlook | |
| Total meetings summarized by Copilot in Teams | |
| Visualize as table actions taken using Copilot in Word | |
| Total meetings summarized or recapped by Copilot | |
| Total meeting hours summarized or recapped by Copilot | |
| Copilot Chat metrics (without Copilot license) | Days of active Copilot Chat usage (without Copilot license) |
| Days of active Copilot Chat usage in Edge (without Copilot license) | |
| Days of active Copilot Chat usage in Copilot app (without Copilot license) | |
| Days of active Copilot Chat usage in Teams (without Copilot license) | |
| Days of active Copilot Chat usage in Outlook (without Copilot license) | |
| Days of active Copilot Chat usage in Word (without Copilot license) | |
| Days of active Copilot Chat usage in Excel (without Copilot license) | |
| Days of active Copilot Chat usage in PowerPoint (without Copilot license) | |
| Copilot Chat prompts submitted (without Copilot license) | |
| Copilot Chat prompts submitted in Edge (without Copilot license) | |
| Copilot Chat prompts submitted in Copilot app (without Copilot license) | |
| Copilot Chat prompts submitted in Teams (without Copilot license) | |
| Copilot Chat prompts submitted in Outlook (without Copilot license) | |
| Copilot Chat prompts submitted in Word (without Copilot license) | |
| Copilot Chat prompts submitted in Excel (without Copilot license) | |
| Copilot Chat prompts submitted in PowerPoint (without Copilot license) | |
| Usage intensity and returning users metrics | Returning Copilot Chat user (most recent and prior 28 days) |
| Returning Copilot Chat user (most recent and prior 7 days) | |
| Returning Microsoft 365 Copilot user (most recent and prior 28 days) | |
| Returning Microsoft 365 Copilot user (most recent and prior 7 days) | |
| Number of weeks active in Microsoft 365 Copilot (most recent 28 days) | |
| Number of weeks active in Copilot Chat (most recent 28 days) |
HR attributes included in the exported data
| Attribute name | Description |
|---|---|
| Organization | Determined by Entra ID or through an organizational data file uploaded by admins. |
| FunctionType (Job function) | Determined by the organizational data file uploaded by admins. If the file doesn't include this field, the column appears blank in the export. |
Learn more about the attributes used in the Copilot Dashboard.
FAQs
Q1: My organization only wants certain users to access the data export feature. Can I configure that?
The data export feature is available by default to users with global access to the Copilot Dashboard. Global admins can disable or re-enable access for specific tenants or groups through VFAM in the Microsoft 365 admin center at any time. Allow up to 24 hours for changes to appear in the web app.
Q2: I'm a senior leader with access to the data export feature. If I delegate my access to my chief of staff, will they automatically have access too?
Yes. Delegates of users with global access automatically inherit data export access, unless your organization's admin policy disables it. Admins can adjust these settings at any time through VFAM in the Microsoft 365 admin center.
Q3: I have access to the Copilot Dashboard, but I don't see the data export option. Why?
Data export is available only to users with global access to the Copilot Dashboard. Managers or their delegates with team-level views don't have access. If you do have global access and still can't see the feature, your admins might have disabled it. Contact them for details.
Q4: How often is the export data updated?
The export includes the past six months of weekly Copilot metrics at the user level (anonymized IDs), up to the most recent complete week (Sunday–Saturday) for which metrics are available.
For example, if metrics are available through October 22 (Wednesday), a partial week, the export includes data through the week of October 12–18.
The dataset refreshes weekly.
Q5: Why doesn't the data in my export match what I see on the Copilot Dashboard?
The export and the dashboard might show different numbers because they cover different time periods. The export only includes data for completed weeks, while the dashboard includes partial week(s) along with completed weeks. For example, if the current week is still in progress and is counted as a partial week, the totals between the two won't match.
Q6: How should I interpret the usage intensity and returning user metrics?
These metrics show whether users are engaging with Microsoft 365 Copilot or Copilot Chat over consecutive 7- or 28-day periods.
For example:
Returning Microsoft 365 Copilot user (28 days): This metric shows whether a user performed any Copilot activity during two consecutive 28-day periods. For example, if a user was active between Aug. 31 and Sept. 27 and again between Sept. 28 and Oct. 25, they would be counted as a returning user. This helps identify users who are maintaining ongoing engagement with Copilot.
Number of weeks active in Copilot Chat (28 days): This metric shows how many weeks within the past four weeks a user was active in Copilot Chat. For example, if a person used Copilot Chat for three out of the past four weeks, the metric value would be 3. This helps assess how consistently users interact with Copilot Chat.
Q7: How do these metric values compare with metrics in advanced analysis for Viva Insights Analysts?
Metric definitions remain consistent across both experiences, as long as the same time period and filters are used.
Exported data, however, includes additional metrics – such as Copilot Chat (without license) and usage intensity metrics – that can help deepen your understanding of Copilot adoption and support AI transformation across your organization.
Q8: We're a large organization, and the export file is sometimes very large. What's the best way to open it?
For smaller datasets, you can open the export file directly in supported applications such as Microsoft Excel.
However, for larger files, use business intelligence (BI) tools such as Power BI to import and analyze the data. These tools are better suited for handling large datasets efficiently and provide more flexibility for analysis, filtering, and visualization.
Q9: We don't see the "Copilot assisted hours" metric in this export. Will it be available in the future?
The data export feature is focused on Copilot actions and usage metrics. Additional metrics will be included over time.
Q10: I don't see the download, or the download seems stuck. What should I do?
Large files might take additional time to process and download. If the browser download doesn't start right away, stay on the page and avoid closing it until the download begins. If you see an error message, wait a little bit, then select Export data again later.
If the download still appears to be stuck, check for any network connectivity issues.
Related topics
Feedback
Was this page helpful?