2
180d Snapshots
May & June 2026
+477
Prompt Growth
21,985 → 22,462
+1
Active Users
91 → 92
+80
P90 Growth
630 → 710
Snapshot Comparison — 180-Day Windows
Two comparable 180-day exports are now available. The window has shifted by 28 days (ending 10 May vs. 7 June 2026). All metrics below are directly comparable.
| Metric | 180d ending 10 May 2026 | 180d ending 7 Jun 2026 | Change | Direction |
|---|---|---|---|---|
| Total licensed users | 93 | 93 | — | Stable |
| Active users | 91 | 92 | +1 | ▲ Improving |
| Activation rate | 97.8% | 98.9% | +1.1pp | ▲ Improving |
| Not using | 2 | 1 | -1 | ▲ Improving |
| Total prompts (180d) | 21,985 | 22,462 | +477 | ▲ Improving |
| Avg prompts / active user | 242 | 244 | +2 | ▲ Stable/Improving |
| Median prompts | 125 | 130 | +5 | ▲ Improving |
| P90 prompts | 630 | 710 | +80 | ▲ Improving |
| Power users (500+) | 15 | 13 | -2 | Note ¹ |
| Regular users (1–499) | 76 | 79 | +3 | ▲ Growing base |
| Avg active days | 40.0 | 39.2 | -0.8 | Stable |
| Weekly prompt rate (org) | 856 | 874 | +18 | ▲ Improving |
| Chat (work) adoption | 96.8% | 100.0% | +3.2pp | ▲ Complete |
| Excel adoption | 76.3% | 80.6% | +4.3pp | ▲ Improving |
| Loop adoption | 55.9% | 61.3% | +5.4pp | ▲ Growing |
| Agent adoption | 20.4% | 21.5% | +1.1pp | ▼ Slow growth |
¹ The power-user count decline from 15 to 13 reflects the rolling window shift — some users' cumulative 180-day totals fell below 500 as the window moved forward. P90 growth (+80) confirms the upper distribution is actually strengthening.
Snapshot Trend Chart
3 × 60-Day Sub-Period Analysis (Current 180-Day Window)
The 180-day export contains aggregate prompt totals only — it does not include row-level monthly data. Sub-period analysis is based on last-activity dates used as cumulative adoption signals, split into three 60-day bands. This shows when users last became active, not prompt volume within each sub-period.
| Period | Date Range | Users with Last Activity in Period | Interpretation |
|---|---|---|---|
| P1 (Days 121–180) | 9 Dec 2025 – 6 Feb 2026 | 2 | Early window activity only — users who last used Copilot in early December/January and have not been active since |
| P2 (Days 61–120) | 7 Feb 2026 – 7 Apr 2026 | 5 | Mid-window last activity — users who peaked in February–April and have since become less active |
| P3 (Days 1–60) | 8 Apr 2026 – 7 Jun 2026 | 85 | Currently active cohort — 91.4% of licensed users have been active within the last 60 days |
91.4% of users active in the most recent 60 days. Only 7 users (2 + 5) have last activity falling outside the current 60-day window, indicating the vast majority of the user base is consistently engaged. The 7 users with older last-activity dates may be lapsed — cross-reference with the low-activity tail in the Segments report.
Cumulative App Adoption by Sub-Period
This chart shows how many users had at least one recorded activity in each app by the end of each sub-period. The sharp rise in P3 for Chat (work) is expected — Copilot Chat was the primary entry point and most users' last recorded activity is recent. Apps like Word and Excel show earlier adoption curves (many users adopted in P1 and P2), reflecting their use as embedded tools.
Trend Interpretation
Adoption: effectively complete. 92 of 93 users are active — the sole non-user is an x_ account. The adoption growth story is now about depth, not breadth.
Usage intensity: improving. Median (+5), P90 (+80), and weekly rate (+18) all grew in the 28-day window shift. The upper distribution is strengthening faster than the median.
App breadth: expanding. Chat (work) reached 100%, Excel and Loop both showed meaningful growth. The broad-app usage pattern is positive — Omada is not a single-surface deployment.
Agent adoption: stagnant. Only +1 user added to Agent adoption across the full 28-day window. This is the single largest risk in the trend picture — the gap between Agent adoption and all other surfaces is widening relatively.
Power-user count: window artefact. The -2 drop does not reflect a real decline. Several near-threshold users are on track to qualify next period. Monitor the four near-threshold users (Bastin, Fenger, Wedel, Zormpas) as a leading indicator.
Next refresh recommended. A third 180-day snapshot next month, combined with a 30-day supplemental export, would establish a reliable rolling trend for prompt volume by period.
Trend Limitations
Prompt-volume trend between the two snapshots is not fully reliable — each snapshot covers a different 180-day window, with 152 days of overlap. The +477 prompt increase reflects the 28-day window shift, not a direct month-over-month measurement.
Sub-period prompt volumes cannot be calculated from a single 180-day aggregate export. To enable monthly prompt trending, export a 30-day report from M365 Admin Center each month and upload alongside the 180-day file.
App adoption by sub-period uses last-activity date as a signal only. A user with a last-activity date in P1 contributed to cumulative P1 adoption — but may have also been active in P2 and P3. The export does not include per-app activity history.