Executive Summary
Start here
Headline KPIs, overall assessment, segment overview, period-over-period comparison, top risks, and prioritised recommendations for leadership. Readable in under 2 minutes.
📊
Usage Analytics
Prompts & Active Days
Total prompts, active usage days, prompt distribution, median and P90 thresholds, top 25 users by prompt volume across the 180-day period.
👤
User Segments
Not using · Regular · Power
Segmentation of all 93 licensed users into three tiers with full user tables, last activity dates, near-threshold watch list, and recommended actions per segment.
💻
App Adoption
Surfaces & Applications
Adoption rates across all 12 Microsoft Copilot surfaces with period-over-period change. Chat (Work) now at 100%. Excel (+4.3pp) and Loop (+5.4pp) showing strongest growth.
📋
Division Report
Usage by Business Division
Prompt volumes, active user counts, and adoption rates by business division. Based on prior 90-day export — the 180-day export does not include a Division field.
📈
Trend Report
2 snapshots · 3 × 60-day periods
Two 180-day snapshots compared (May vs. June 2026) plus 3 × 60-day sub-period analysis within the current window. Adoption and app usage trend interpretation included.
📄
Data Appendix
Sources · Methods · Limits
Source file details, field definitions, metric methodology, segmentation logic, known limitations, and caveats for all reports in this package.

Source Files Used

FileTypePeriodUsersStatus
CopilotActivityUserDetailV46_12_2026_6_42_15_AM.csvCopilot Usage180 days ending 2026-06-0793✓ Primary source — all reports
CopilotActivityUserDetail (90d, prior)Copilot Usage90 days ending 2026-03-3188Division Report only (prior period)

Reporting Periods

PeriodRefresh DateUsersActiveTotal Prompts
180 Days (previous)2026-05-109391 (97.8%)21,985
180 Days (current)2026-06-079392 (98.9%)22,462