Geographic and size-based analysis of your managed Microsoft 365 tenant base.
Geographic and size-based analysis of your managed Microsoft 365 tenant base.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: Microsoft 365 administrators, security teams, and account managers
How often: Weekly for license management, monthly for adoption reviews, quarterly for optimization
Geographic and size-based analysis of your managed Microsoft 365 tenant base.
EVALUATE ROW("TotalTenants", COUNTROWS('BI_Lighthouse_Tenant'), "Active", CALCULATE(COUNTROWS('BI_Lighthouse_Tenant_Status_Information'), 'BI_Lighthouse_Tenant_Status_Information'[onboarding_status] = "active"), "Ineligible", CALCULATE(COUNTROWS('BI_Lighthouse_Tenant_Status_Information'), 'BI_Lighthouse_Tenant_Status_Information'[onboarding_status] = "ineligible"), "Disabled", CALCULATE(COUNTROWS('BI_Lighthouse_Tenant_Status_Information'), 'BI_Lighthouse_Tenant_Status_Information'[onboarding_status] = "disabled"), "GDAP", CALCULATE(COUNTROWS('BI_Lighthouse_Tenant_Status_Information'), 'BI_Lighthouse_Tenant_Status_Information'[delegated_privilege_status] = "granularDelegatedAdminPrivileges"))Geographic distribution of your managed tenant base.
| Country | Tenants | Total Licenses | Avg Size | MRR | Growth QoQ |
|---|---|---|---|---|---|
| Netherlands | 58 | 28,410 | 490 | $142,050 | +5.1% |
| Germany | 24 | 12,840 | 535 | $64,200 | +3.8% |
| United Kingdom | 19 | 9,310 | 490 | $46,550 | +2.9% |
| Belgium | 15 | 6,750 | 450 | $33,750 | +4.5% |
| United States | 12 | 5,280 | 440 | $26,400 | +6.2% |
| France | 8 | 3,120 | 390 | $15,600 | +1.4% |
The Netherlands remains the core market with 40.8% of tenants and 42.1% of total licenses. Germany and the UK together account for another 30.3%. The US market shows the second-highest growth rate at 6.2% quarter-over-quarter despite smaller tenant count.
EVALUATE
SUMMARIZECOLUMNS(
BI_Microsoft_Licenses[tenant_country],
"TenantCount", DISTINCTCOUNT(BI_Microsoft_Licenses[tenant_id]),
"TotalLicenses", SUM(BI_Microsoft_Licenses[assigned_licenses])
)
ORDER BY [TenantCount] DESCDistribution of tenants across small, medium, and large segments.
| Size Tier | Tenants | Total Licenses | Avg MRR | Churn Risk |
|---|---|---|---|---|
| Enterprise (500+) | 28 | 32,480 | $8,120 | Low |
| Mid-Market (100-499) | 67 | 24,120 | $2,150 | Medium |
| SMB (25-99) | 35 | 8,540 | $610 | Medium |
| Micro (1-24) | 12 | 2,381 | $180 | High |
Mid-Market tenants represent 47.2% of the portfolio by count but only 35.7% of license volume. Enterprise tenants contribute 48.1% of total licenses while making up just 19.7% of the count. The 12 Micro tenants carry the highest churn risk.
EVALUATE
SUMMARIZECOLUMNS(
BI_Microsoft_Licenses[size_tier],
"TenantCount", DISTINCTCOUNT(BI_Microsoft_Licenses[tenant_id]),
"TotalLicenses", SUM(BI_Microsoft_Licenses[assigned_licenses])
)
ORDER BY [TotalLicenses] DESCThe risk matrix shows that most entities fall in the low-risk category, but the high-risk group demands immediate attention. The moderate-risk group shows a declining trend that could escalate without intervention.
| Metric | Value |
|---|---|
| Unique Products | 137 |
| Total Consumed | 4,217 |
| Total Active | 3,255,762 |
| Customers | 38 |
The detailed breakdown shows clear performance differences. The bottom two categories require targeted action to improve overall portfolio health.
Overall portfolio health is strong at 92.4%, but the 87.3% coverage rate suggests that roughly 1 in 8 entities is not fully monitored. The 23 open action items represent a manageable backlog if addressed within 2 weeks.
The gap between top and bottom performers is wider than expected. The bottom 20% scores more than 25 percentage points below the portfolio average, indicating structural issues that require targeted intervention.
Entities in the moderate risk category show a declining trend over the past quarter. Without intervention, 3-4 of these entities may shift to the high-risk category within 60 days.
The top 30% of the portfolio maintains stable performance above target, indicating current best practices are effective and can serve as a model for the rest.
1. Conduct a targeted review of all high-risk entities within 2 weeks. Document the root cause for each entity and create a remediation plan with clear deadlines and accountable owners.
2. Implement automated monitoring for the moderate-risk group. Set thresholds that trigger an alert when performance drops 5 percentage points below target, enabling early intervention before entities slip into high risk.
3. Schedule this report monthly as part of the QBR process. Use the trend data to verify that improvement initiatives are delivering measurable results across multiple quarters.
Micro: 1-24 licenses, SMB: 25-99, Mid-Market: 100-499, Enterprise: 500+. These align with Microsoft partner program segmentation.
Regional distribution affects support coverage hours, compliance requirements, and helps plan localized marketing and sales efforts.
Most profitable MSPs target 100-500 license tenants. Below 25 licenses, management overhead often exceeds the margin.
Tenant and license data syncs daily from Microsoft Partner Center. Country and size classifications update when tenant metadata changes.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started