M365 Copilot Productivity ROI Projections

Transform your usage data into actionable insights

View more reports on the Analytics Hub →

View Demo Report Demo dataset · 300 people · 7 organizations · 14 weeks

Getting Started

1

Export Your Viva Insights Data

The calculator accepts a single file format: a Viva Insights person query export. It is the only export with one row per person per week, which is what true Usage Threshold cohorts require.

▶ Export directly from Viva Insights

Gives one row per person per week, so the calculator can compute true Usage Threshold cohorts (Power, Habitual, Novice, Low, Non-users) using the same 12-week rolling average and 9-of-12-weeks habit rule as the Super User Adoption report.

  1. Go to analysis.insights.cloud.microsoft and open the Analysis results page
  2. Click Create analysis, select Person query, then Set up analysis
  3. Configure the query — Time period: Last 6 months (rolling) · Group by: Week · Filter: Is Active = True
  4. Add Attributes: Organization, FunctionType, TimeZone (these become your grouping options)
  5. Under metrics, select Microsoft 365 Copilot — all metrics (Collaboration network, working-hours and focus metrics are optional)
  6. Run the query, then download the result as CSV from Analysis results
Group by Week is required. Cohort tiers need at least 12 consecutive weekly rows per person, so keep the 6-month rolling window rather than shortening it.
Expected columns: PersonId, MetricDate, Total Copilot actions taken are required; Organization, FunctionType, Region, active/enabled days, assisted hours and per-app action columns are used when present.
British and Spanish column headers are translated automatically.
2

Configure Your Analysis

Set your organization's parameters for Productivity ROI calculation:

Total licenses procured (including unassigned). Leave 0 to use enabled count from data.
Average fully-loaded cost per employee hour
1 min 6 min 15 min
Average time saved per Copilot action
Optional - Additional productivity from Intelligent Recap feature
Intelligent Recap Usage Guidance

Microsoft does not publish an industry-wide benchmark for Intelligent Recap actions per 1,000 employees. However, observed usage shows active users average ~1.6 Intelligent Recap actions per week. When normalized by adoption rate, this typically equates to ~700–2,000 recap actions per 1,000 employees per month, depending on enablement and meeting load.

3

Upload Your Data

Select your exported CSV file below. Your CSV is parsed entirely in your browser - the file and its contents are never uploaded.

Set your configuration first. Adjust your Industry, License Cost, Hourly Rate, and Minutes Saved in Step 2 above before uploading your file.

Dropping the file is not the last step. Once it is loaded, click Calculate Productivity ROI to build your report. Larger exports hold a lot of history, so give it a few seconds to work through every person and week — your results will appear as soon as it finishes.

Drop your CSV file here

or

Your Privacy is Protected

• All data processing happens locally in your browser
• Your CSV file and its contents are never uploaded
• Data is stored temporarily in browser memory only
• All data is cleared when you close this tab
• This hosted site uses Microsoft Clarity for product analytics — the local version makes zero external requests (privacy details)