Optimizing Microsoft 365 Licenses Using Behavior Data (E3/E1/F3)

On the "no fixed thresholds" point: that's actually correct, and for a good reason. Tier fit (E3 vs E1 vs F3) isn't really a light/standard/heavy *volume* question, it's a *feature-entitlement* question: does the user actually use the capabilities the higher tier uniquely provides? Someone who sends five emails a day but relies on desktop Excel still needs E3. Someone hammering Teams all day but only in the browser could sit on E1. So usage volume is useful to find *candidates*, but the confirming test is feature need.

The two hard discriminators to key off:

1. Desktop Office apps. This is the E1-vs-E3 line. Office 365 E1 has no desktop client apps (web + mobile only); E3 includes them. So if a user never activates or uses desktop Word/Excel/Outlook, E3's main premium is wasted on them and E1 becomes viable.

2. Mailbox size / archive. E3 = 100 GB mailbox + auto-expanding archive (Exchange Online Plan 2). E1 = 50 GB, no archive (Plan 1). F3 = 2 GB (Exchange Online Kiosk), Outlook on the web only. If a mailbox is over 50 GB or relies on archive/hold, that user is effectively locked to E3.

A workable signal-to-tier flow, using data you already have in the M365 usage reports / Graph:

- Pull the Microsoft 365 Apps usage report (desktop vs web activation per app), Exchange activity + mailbox size, and Teams/SharePoint/OneDrive last-activity.

- Then decide by need, not by a raw count:

- Uses desktop Office apps, or mailbox > 50 GB / needs archive -> stays E3.

- Web/mobile only, desk worker, real mail + collaboration, mailbox < 50 GB -> E1 candidate.

- Frontline/shift/mobile pattern, minimal email, shared or mobile device, no real desktop footprint -> F3 candidate (2 GB mailbox, OWA only).

- Teams-only "kiosk" with no mailbox need -> F1, but note F1 has no Exchange mailbox rights at all.

Two things worth baking in before you act on it:

- Use a long enough lookback (90 to 180 days) and treat borderline cases as review, not auto-downgrade. Behavior data misses occasional/seasonal desktop use, e.g. the person who opens Excel once a quarter still needs E3.

- Check mailbox size before any downgrade. E3 -> E1 halves the mailbox cap (100 -> 50 GB), and E1/E3 -> F3 drops it to 2 GB. If the mailbox is bigger than the target tier's cap you'll hit over-quota issues. Mixed plans in one tenant are fully supported, so per-user tiering is legitimate.

Source for the plan differences (desktop apps, Exchange plan per tier): Microsoft 365 and Office 365 plan options (service description):

https://learn.microsoft.com/en-us/office365/servicedescriptions/office-365-platform-service-description/office-365-plan-options