Cloud product performance reports – Data definitions
Appropriate roles: Report viewer | Executive report viewer
By using the Download Reports hub on the Insights dashboard, you can export the raw datasets.
The various reports, which you can download along with their data definitions, are listed in the following tables:
Partner profile report
| Column name | Data description |
|---|---|
| MPNId | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| PGA_MPNID | Identifier of the partner global account |
| PGA_PartnerName | Partner global account name |
| City | City location of the partner |
| Country | Country/region location of the partner |
| HierarchyLevel | Indicates whether it's a Global ID or Location ID |
Customers and revenue
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| CustomerName | Name of the customer |
| CustomerTenantId | Identifier of the customer tenant |
| CustomerTpid | Identifier of the customer top parent |
| DUNSNumber | Global Data Universal Number System Identifier of customer |
| CustomerSegment | Customer segment |
| TopSegment | Higher-level segment classification of customer |
| CustomerMarket | Geographical market of the customer |
| CustomerStatus | Customer Status (Active or Inactive) |
| CustomerTenantName | Name of customer tenant |
| CustomerTenantCountry | Country/region of customer tenant |
| TenantDomainName | Domain name of customer tenant |
| Product | The product sold to the customer by the partner: Microsoft 365, Dynamics 365, Enterprise Mobility + Security, Power BI, or Microsoft Azure. |
| RawProductName | Detailed product name sold to the customer |
| SKU | Product SKU |
| Month | Month for which usage and revenue are reported |
| MPNId | Identifier of Microsoft AI Cloud Partner Program (formerly MPN) |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical location of partner |
| PartnerAttributionType | Attribution type of the partner |
| SalesChannel | Sales Channel |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| IsDuplicateRowForPGA | For multiple partner attributions under single PGA, this value is set to 0 for only one MPNId. If the value is set to 1, then it indicates a duplicate row |
| AvailableSeats | Available seats |
| BilledRevenueUSD | Billed revenue in US dollar |
| AzureConsumedRevenueUSD | Azure Consumed Revenue in USD |
| CPORRevenue | Revenue from the CPOR Partner attaches type |
| CPORPaidSeats | Paid seats with CPOR Partner attach type |
| CPORActiveUsers | Active users with CPOR Partner attach type |
Reseller performance report
Note
Revenue and Azure consumed revenue (ACR) data are available only to users who are Executive report viewers.
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| ResellerMpnID | Reseller Microsoft AI Cloud Partner Program identifier |
| ResellerName | Reseller name |
| ResellerMarket | Reseller country/region of market |
| IndirectProviderMpnID | Identifier of the indirect provider Microsoft AI Cloud Partner Program |
| IndirectProviderName | Indirect provider name |
| Month | Month for which usage and revenue is reported |
| Product | Product name |
| SubscriptionID | Identifier of the subscription |
| AvailableSeats | Number of seats available |
| AssignedSeats | Number of assigned seats |
| BilledRevenueUSD | Billed revenue in US dollars |
| CustomerName | Name of the customer |
| CustomerTPid | Identifier of the customer top parent |
| CustomerSegment | Customer segment |
| CustomerMarket | Geographical market of the customer |
| ResellerStatus | Reseller status |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
Subscription details report
Note
Revenue and ACR data are available only to users who are Executive report viewers.
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| SubscriptionId | GUID of the subscription |
| SubscriptionStartDate | Start date of the subscription |
| SubscriptionEndDate | End date of the subscription |
| SubscriptionState | State of the subscription (Active or Churned) |
| Month | Month for which usage and revenue are reported |
| IsAutoRenew | Indicates whether the subscription is autorenewed (Yes or No) |
| CustomerName | Name of the customer |
| CustomerTenantId | GUID of the customer |
| CustomerTpid | Customer top parent identifier |
| DUNSNumber | Global Data Universal Number System Identifier of customer |
| CustomerSegment | Market segment of the customer |
| TopSegment | Higher-level segment classification of customer |
| CustomerMarket | Geographical market of the customer |
| ReportingProductName | Granular product name |
| Product | Product sold to the customer by the partner |
| RawProductName | Detailed product name sold to the customer |
| ProductPartNumber | Part number of the product |
| SKU | SKU of the product |
| RevSumDivisionName | Revenue reporting product hierarchy name |
| SolutionArea | Business application classification of the product |
| MPNID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical location of the partner |
| PartnerAttributionType | Attribution type for the subscription |
| SalesChannel | Channel of the sales - Direct, CSP (Cloud Solution Provider), and so on |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| PricingLevel | Price point of the sale |
| EnrollmentNumber | Enrollment number of the subscription |
| IsDuplicateRowForPGA | For multiple partner attributions under single PGA, this value is set to 0 for only one PartnerID. If the value is set to 1, then it indicates a duplicate row |
| SubscriptionStartMonth | Start month of the subscription |
| ResellerID | ID of reseller |
| ResellerName | Reseller name |
| AvailableSeatsEOP | Overall Available seats until End of Period |
| AvailableSeats | Available seat difference Month on month |
| BilledRevenueUSD | Revenue in USD |
| AzureConsumedRevenueUSD | Azure Consumed Revenue in USD |
| CPORRevenue | Revenue from the CPOR Partner attaches type |
| CPORPaidSeats | Paid seats with CPOR Partner attach type |
| CPORActiveUsers | Active users with CPOR Partner attach type |
CSP Direct Partner eligibility
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| PartnerName | Name of the partner |
| MPNID | Microsoft AI Cloud Partner Program ID |
| MPNType | Type of the Partner account: Global or Local account |
| CustomerName | Name of the customer |
| CustomerID | Identifier of the customer |
| CustomerTenantId | Identifier of the customer tenant |
| MonthKey | Month for which usage is reported |
| SubscriptionId | GUID of the subscription |
| ReportingPricingLevel | Serves as a specific grouping used for budgeting and forecasting purposes. A Reporting Pricing Level is the established level for Budget/Forecast to Actual revenue comparisons possible. |
| DetailPricingLevelName | A Detail Pricing Level is assigned to actual revenue based on rules defined and approved by the business. The fields Purchase Type and Detail User Type are determined by the Detail Pricing Level assigned to the transaction. |
| SummaryPricingLevel | Serves as a grouping of Detail Pricing Levels. A Summary Pricing Level has been assigned to each Detail Pricing Level. |
| PartnerAttributionType | Attribution type of the partner |
| ProductPartNumber | Part number of the product |
| Product | Product name |
| IsDuplicateRowForPGA | For multiple partner attributions under single PGA, this value is set to 0 for only one MPNId. If the value is set to 1, then it indicates a duplicate row. |
| BilledRevenueUSD | Billed revenue in US dollars |
Azure usage report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| SubscriptionId | GUID of the subscription |
| SubscriptionStartDate | The date of the start of the subscription |
| SubscriptionEndDate | The date of the end of the subscription |
| FirstUseDate | Date when Azure services were used first |
| SubscriptionState | Current State of the subscription (Active, Disabled, Deprovisioned, Abandoned or In Grace Period) |
| Month | Date aggregated by month |
| ServiceLevel1 | Service Level 1 – Corresponds to Service Pillar such as Containers, Databases, Networking, and so on. |
| ServiceLevel2 | Service Level 2 – Corresponds to the Workload for the Service Pillar |
| ServiceLevel3 | Service name used by Azure.Microsoft.Com to white listing Azure offerings |
| ServiceLevel4 | Logical groupings of high-level feature set differentiations within the service. Such as General Purpose Virtual Machines, Memory Optimized Virtual Machines, Single SQL Database, Elastic SQL Database, and so on. |
| ServiceGroup2 | Field Revenue Accountability (FRA) areas such as AI, App Dev, IoT, and so on |
| ServiceGroup3 | More Detail for FRA such as IoT Hub, Maps for IoT FRA |
| ServiceInfluencer | PaaS services that drive consumption of infra resources, such as Service Fabric, Azure Databricks, AKS, and so on. |
| ComputeOS | Operating System for the Compute |
| ComputeCoreSoftware | Compute Core Software |
| UsageUnits | The number of units that are used during the billing cycle |
| UsageQuantity | Quantity of usage of resource |
| CustomerName | Name of the customer |
| CustomerTenantId | Tenant ID of customer |
| CustomerTpid | Customer top parent ID |
| CustomerSegment | Segment of the customer |
| CustomerMarket | Geographical market of the customer |
| MPNID | PartnerID of the customer |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical country/region location of the partner |
| PartnerAttributionType | Attribution type of the partner |
| SalesChannel | Channel of the sales (Direct/CSP, Indirect/CSP, Direct, and so on) |
| EnrollmentNumber | Enrollment number of the subscription |
| IsACRDuplicateAtPGALevel | For multiple partner attributions under single PGA, this value is set to 0 for only one MPNId. If the value is set to 1, then it indicates a duplicate row |
| ResellerID | ID of reseller |
| ResellerName | Reseller name |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| AdminType | When the Partner Attribution Type is "Partner Admin Link (PAL)," this column indicates the assigned role in the customer's subscription. |
| AssociationType | Type of Association |
| ACR_USD | Azure consumed revenue (ACR) in US dollars |
Office 365 license usage report
| Column name | Data description |
|---|---|
| PGAPartnerID | Identifier of the partner global account |
| CustomerTenantId | Tenant ID of the customer |
| CustomerTpid | Customer top parent ID |
| WorkloadName | Skype for Business, Teams, Exchange Online |
| Month | Month for which usage is reported |
| PaidAvailableUnits | Number of paid available units |
| MonthlyActiveUsers | Number of monthly active users |
| CustomerName | Name of the customer |
| CustomerMarket | Geographical country/region location of the customer's market |
| CustomerSegment | Customer segment |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| PartnerID | Identifier of Microsoft AI Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical location of the partner |
| PartnerAttributionType | Attribution type of the partner |
| IsDuplicateRowForPGA | For multiple partner attributions under single PGA, this value is set to 0 for only one PartnerID. If the value is set to 1, then it indicates a duplicate row |
Enterprise Mobility license usage report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| SubscriptionId | GUID of the Subscription |
| SubscriptionStartDate | The date of the start of the subscription |
| SubscriptionEndDate | The date when the subscription ends |
| SubscriptionStatus | Current state of the subscription (Open, Closed, Active or In Grace Period) |
| Month | Date aggregated by month |
| SKU | Product SKU |
| SKUId | SKU ID of the product |
| FreeVsPaidSKU | Indicates Free or Paid SKU |
| SalesModel | Sales channel used for selling the subscription |
| DetailedSalesModel | Detailed sales model for the subscription |
| CustomerName | Name of the customer |
| CustomerTenantId | Tenant ID of customer |
| CustomerTpid | Customer top parent ID |
| CustomerSegment | Customer segment |
| CustomerMarket | Geographical country/region location of the market of customer |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| MPNID | PartnerID |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical location of partner |
| PartnerAttributionType | Attribution type of partner |
| PartnerHierarchy | Hierarchy of partner (HeadQuarters or Location) |
| PaidAvailableUnits | Number of paid available units |
| MonthlyActiveUsers | Number of monthly active users |
| AATPActiveUsage | Azure Advanced Threat Protection (AATP) active usage |
| MCASActiveUsage | Microsoft Defender XDR for Cloud Apps active usage |
| AADPPaidAvailableUnits | Number of paid available units for Microsoft Entra ID P1 or P2 (AADP) |
| IntunePaidAvailableUnits | Number of paid available units for Intune |
| AzipPaidAvailableUnits | Number of paid available units for Azure Information Protection |
| AADPMonthlyActiveUsers | Number of monthly active users for Microsoft Entra ID P1 or P2 (AADP) |
| IntuneMonthlyActiveUsers | Number of monthly active users for Intune |
| AzipMonthlyActiveUsers | Number of monthly active users for Azure Information Protection. It's a workload reported under EMS. It has recently been renamed to Microsoft Purview Information Protection.) |
| MDM | Mobile Device Management |
| MAM | Mobile Application Management |
| SSPR | Self-Service Password Reset |
Dynamics 365 license usage report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| SubscriptionId | GUID of the subscription |
| SubscriptionStartDate | Start date of the subscription |
| SubscriptionEndDate | End date of the subscription |
| SubscriptionStatus | State of the subscription |
| Month | Month for which usage is reported |
| RevSumDivisionName | Name of the rev sum division |
| RevSumCategoryName | Name of the rev sum category |
| SKU | SKU of the product |
| SKUId | SKU ID of the product |
| FreeVsPaidSKU | Indicates whether it's a free or paid SKU |
| SalesModel | Sales channel that's used for selling the subscription |
| DetailedSalesModel | Detailed sales model for the subscription |
| CustomerName | Name of the customer |
| CustomerTenantId | GUID of the customer tenant |
| CustomerTpid | Customer top parent identifier |
| CustomerSegment | Market segment of the customer |
| CustomerMarket | Geographical market of the customer |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| MPNID | Identifier of Microsoft AI Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical country/region location of the partner |
| PartnerAttachType | Attribution type for the subscription |
| AvailableSeats | Current paid available seats |
| AssignedSeats | Current assigned seats |
| ActiveSeats | Current active seats |
| DeploymentOpportunity | Deployment opportunity is the number of seats that aren't assigned |
| ActiveUsagePercent | Current active usage as a percentage of available seats |
Power BI license usage report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| SubscriptionId | GUID of the subscription |
| SubscriptionStartDate | Start date of the subscription |
| SubscriptionEndDate | End date of the subscription |
| SubscriptionStatus | State of the subscription (Active, Inactive, or In Grace Period) |
| Month | Date aggregated by month |
| SKU | SKU of the product |
| SKUId | SKU ID of the product |
| FreeVsPaidSKU | Free or paid SKU differentiator |
| SalesModel | Sales model that's used to sell the subscription |
| DetailedSalesModel | Detailed sales model for the subscription |
| CustomerName | Name of the customer |
| CustomerTenantId | GUID of the customer tenant |
| CustomerTpid | Identifier of the customer top parent |
| CustomerSegment | Market segment of the customer |
| CustomerMarket | Geographical market of the customer |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| MPNId | Identifier of Microsoft AI Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical country/region location of the partner |
| PartnerAttachType | Attribution type for the subscription |
| PartnerHierarchy | Hierarchy of partner (HeadQuarters or Location) |
| AvailableSeats | Current paid available seats |
| AssignedSeats | Current assigned seats |
| ActiveSeats | Current active seats |
| DeploymentOpportunity | Deployment opportunity is the number of seats that aren't assigned |
| ActiveUsagePercent | Current active usage as a percentage of available seats |
Business applications revenue
| Column name | Data description |
|---|---|
| FiscalMonthName | Month and year information regarding the data |
| GlobalPartnerID | Global partner ID of the partner |
| PartnerName | Name of the partner |
| PartnerAssociationType | Partner association type, for example, CSP T1, DPOR, PAL |
| CustomerID | Unique identifier for a customer in Microsoft record |
| CustomerName | Name of the customer |
| CustomerTenantID | Tenant ID of the customer |
| CustomerTenantName | Name of the customer at the tenant level |
| SubscriptionId | Identifier for the subscription |
| SubscriptionStartDate | Start date of the subscription |
| Country | Country/region of the customer |
| WorkloadCategory | Category of the workload |
| Workloads | Appropriate workload for the subscription, such as AI Builder, Business Central, CE Bundle, Commerce, Customer Insights, Customer Service, F&O Bundle, Field Service, Finance |
| AdjustedRevenueAmtCD | Revenue details for the subscription |
Business applications usage
| Column name | Data description |
|---|---|
| FiscalMonthName | Month and year information regarding the data |
| GlobalPartnerID | Global partner ID of the partner |
| PartnerName | Name of the partner |
| PartnerAssociationType | Partner association type, for example, CSP T1, DPOR, PAL |
| CustomerID | Unique identifier for a customer in Microsoft record |
| CustomerName | Name of the customer |
| CustomerTenantID | Tenant ID of the customer |
| CustomerTenantName | Name of the customer at the tenant level |
| SubscriptionID | Identifier for the subscription |
| SubscriptionStartDate | Start date of the subscription |
| MetricType | Type of the subscription paid or trial |
| WorkloadCategory | Category of the workload |
| Workload | Appropriate workload for the subscription, such as AI Builder, Business Central, CE Bundle, Commerce, Customer Insights, Customer Service, F&O Bundle, Field Service, Finance |
| SkuGroup | Group to which the SKU belongs |
| PAMAU | Partner attached monthly active users |
| MAC | Monthly active capacity |
| MAU | Monthly active users |
Teams meetings and calls report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| CustomerId | Identifier of the customer top parent |
| CustomerTenantId | Tenant ID of the customer |
| CustomerName | Customer name |
| CustomerCountryCode | Country Code of the customer |
| CustomerCountry | Customer country/region |
| CustomerSegment | Type of Customer segment, for example Major Commercial, Major Public Sector, Small, Medium & Corporate Commercial, and so on. |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| DateKey | Date for which usage is reported |
| Subworkload | Subworkload for which usage is reported (meetings, calls, or phone systems) |
| Meeting count | Number of meetings |
| Meeting duration | Total meeting duration in hours |
Teams monthly usage report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| CustomerId | Identifier of the customer top parent |
| CustomerTenantId | Tenant ID of the customer |
| CustomerName | Customer name |
| CustomerCountryCode | Country Code of the customer |
| CustomerCountry | Customer country/region |
| CustomerSegment | Type of Customer segment, for example Major Commercial, Major Public Sector, Small, Medium & Corporate Commercial, and so on. |
| MonthKey | Month for which usage is reported |
| SubWorkload | Subworkload for which usage is reported (Meetings, calls or phone systems) |
| DesktopUsers | Number of users who use Teams on desktop |
| WebUsers | Number of users who use Teams on the web |
| MobileUsers | Number of users who use Teams on mobile |
| AllUpParticipants | Number of unique users of Teams for the month |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
Teams usage 3P apps report
| Column name | Data description |
|---|---|
| PGAMpnID | Identifier of the partner global account |
| CustomerId | Customer top parent ID |
| CustomerTenantId | Tenant ID of the customer |
| CustomerName | Customer name |
| CustomerCountryCode | Country Code of the customer |
| CustomerCountry | Customer country/region |
| CustomerSegment | Type of Customer segment, for example Major Commercial, Major Public Sector, Small, Medium & Corporate Commercial, and so on. |
| IndustryName | Type of Industry the customer belongs |
| VerticalName | Business Vertical within the Industry of the Customer |
| EOU | Enterprise Organizational Unit, Focus areas for Subsidiary levels. For example, SMC Commercial, USA – Northeast, JPN - Kansai |
| DateKey | Date for which usage is reported |
| AppName | Name of the Teams app |
| Usercount | Number of users for the app |
Trainings, exams and certifications
| Column name | Data description |
|---|---|
| PGAMpnId | Identifier of the partner global account |
| TrainingActivityId | Identifier of the training |
| TrainingTitle | Title of the training |
| TrainingType | Type of training (certification or exam) |
| IndividualFirstName | First name of the customer |
| IndividualLastName | Last name of the customer |
| Personal email ID of the customer | |
| CorpEmail | Office email ID of the customer |
| TrainingCompletionDate | Completion date of the training |
| ExpirationDate | Expiration Date of the Certification |
| ActivationStatus | Status of the Certification |
| Month | Month for which the data is reported |
| IcMCP | Indicates whether the user is a Microsoft Certified Professional (MCP) |
| MCPID | MCP ID of the user |
| MpnId | Identifier of Microsoft AI Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerCityLocation | Geographical city location of the partner |
| PartnerCountryLocation | Geographical country/region location of the partner |
Microsoft Learn report
| Column name | Data description |
|---|---|
| PGAMpnId | Identifier of the partner global account |
| UserName | Name of the user |
| UserId | GUID of the user |
| TrainingName | Name of the training |
| TrainingType | Type of training (module or learning path) |
| Products | Product for which the learning module is applicable |
| Roles | Applicable roles of the training |
| CompletionDate | Date of completion of the training |
| MPNId | Identifier of Microsoft AI Cloud Partner Program |
| PartnerName | Name of the partner |
| Country | Geographical country/region location of the partner |
Cloud Ascent - Microsoft 365 propensity report
| Column name | Data description |
|---|---|
| MPNID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| CustomerID | Customer identifier number as defined by Microsoft |
| DUNSNumber | The Dun & Bradstreet number of the customer who's being scored for propensity |
| AccountName | Name of the Customer |
| Domain | Domain of the Customer |
| OrgSize | Size of the organization |
| Industry | Industry that the organization belongs |
| Vertical | The vertical of the customer who's being scored for propensity, as identified by Microsoft, D&B, and other industry standards |
| Area | Geographical area of the Customer |
| Subsidiary | The subsidiary of the customer who's being scored for propensity |
| SalesTerritory | The sales territory of the customer who's being scored for propensity |
| City | Geographical city location of the customer |
| State | Geographical state location of the customer |
| PostalCode | Postal code of the organization of the customer |
| Country | Geographical country/region location of the customer |
| Segment | Market segment as defined by Microsoft |
| SubSegment | Market subsegments as defined by Microsoft |
| SMCTypeSummary | The categorization of a customer as defined by Microsoft: Corporate Scale Businesses meet at least one of the following criteria - High Revenue ($100 K+), High Growth (20%+), High Potential ($100 K+), Org Size 500+, ACR Web Direct > $1000+ per month; Medium businesses are customers with 25 - 300 employees, small are customers with 1-24 employees |
| IsNonprofit | Indicates whether the organization is nonprofit and approved by Microsoft or not: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free SKU and aren't using products, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit |
| MWS__Secure_Productivity__Upsell__CoPilot__GPS | Target customers for upsell of existing M365 products to include CoPilot |
| MW_On Prem Acq_Office 2016_2019 | Target customers with On Prem Office 2016 or Office 2019 for conversion to Cloud |
| MW_On Prem Acq Office_Prod Server 2007_2010 | Target customers with On Prem Office/Prod Server 2007 or 2010 for conversion to Cloud |
| MW_On Prem Acq Office 2021 Office_Prod Server 2019 | Target customers with On Prem Office 2021 or Office/Prod Server 2019 for conversion to Cloud |
| MW_On Prem Acq Office_Prod Server 2013_Office 2019 for Mac | Target customers with On Prem Office/Prod Server 2013 or Office 2019 for Mac for conversion to Cloud |
| MW_Transition Customer - Compete (Endpoint Security) with M365 | Target Customers with Endpoint Security and Microsoft 365 for conversion to MW Cloud Suite SKU with security |
| MW_Transition Customer - Compete (Endpoint Security) without M365 | Target Customers with Endpoint Security but without Microsoft 365 for conversion to MW Cloud Suite SKU with security |
| MW_Transition Customer - Compete (Zoom) with M365 | Target Customers with Zoom and Microsoft 365 for conversion to teams |
| MW_Transition Customer - Compete (Zoom) without M365 | Target Customers with Zoom and without Microsoft 365 for conversion to Microsoft 365/teams |
| MW_Transition Customer - Compete Google Workspace | Target Customers with Google Workspace for conversion to Microsoft 365 |
| MW_Upsell Existing Cloud Customer - EMS Suites_Standalones | Upsell existing EMS Suites/standalone customers to ME3 for sub-300 employee businesses or ME5 for >300 employee businesses |
| MW_Upsell Existing Cloud Customer - ME3_OE5 to ME5 | Upsell existing ME3 or OE5 customers to ME5 |
| MW_Upsell Existing Cloud Customer - MW Standalones_EXO_SPO_etc | Upsell existing modern work standalone customers to ME3 for sub-300 employee businesses or ME5 for >300 employee businesses |
| MW_Upsell Existing Cloud Customer - No MBP_ME3_ME5 | Upsell existing Office 365 Core Products, Microsoft 365 BS, Office 365 E3/E4 for conversion to ME3, ME5, or MBP |
| MW_Upsell Existing Cloud Customer - O365 A1 | Upsell existing Office 365 active A1 Customers to Microsoft 365 |
| MW_Upsell Existing Cloud Customer - O365 A3_A5_M365 A1_A3 | Upsell existing Office 365 A3, A5, Microsoft 365 A1 or A3 customers to ME5 |
| MW_Upsell Existing Cloud Customer - Underpenetrated MBP_ME3_ME5 | Upsell existing Customers with underpenetrated MBP, ME3, and/or ME5 to full penetration of the SKU in their business |
| MW_Upsell Existing Cloud Customer - Teams Essentials | Upsell existing teams essentials customers without Office 365/Microsoft 365 Suites or Standalones to Microsoft Teams Phone System |
| MW_Business Premium_E SKU Attach >50 | Target customers with 50 or more Office 365 Core or Microsoft 365 BP seats to purchase surface |
| MW_EDU for Surface | Target EDU customers with at least 25 licenses of surface for upsell |
| MW_Surface Devices >25 Purchased in the Last 3 Years | |
| FY24 Offers | Promos for FY24, Customers who are eligible for a promo |
| M365Cluster | Identifies a customer's propensity to purchase Microsoft 365. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after Act Now and Evaluate customers are targeted |
| M365Fit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best small or mid-sized businesses (SMBs) to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| M365Intent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| SurfaceCluster | Identifies a customer's propensity to purchase Surface by consolidating the Fit and Intent recommendations into a cluster. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after Act Now and Evaluate customers are targeted. |
| SurfaceFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMBs to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| Surface Intent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| M365UpsellCustomer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| Has_MW_CSP_Annual_Renewal | Target customers with a CSP annual renewal to renew their existing purchase/upsell by the renewal expiration date |
| Has Azure | Identifies Active Azure Customer |
| Has D365 | Identifies Active Dynamics 365 Customer |
| Has M365 | Identifies Active Microsoft 365 Customer |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| HasEA | Identifies whether a renewal is an EA or an EA subscription |
| HasOpen | Identifies whether a renewal is an Open or Open Value agreement |
| Transactedinthelast36months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Dynamics 365 propensity report
| Column name | Data description |
|---|---|
| MPNID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| CustomerID | Customer identifier number as defined by Microsoft |
| DUNSNumber | The Dun & Bradstreet number of the customer who's being scored for propensity |
| AccountName | Name of the Customer |
| Domain | Domain of the Customer |
| OrgSize | Size of the organization |
| Industry | Industry that the organization belongs |
| Vertical | The vertical of the customer who's being scored for propensity, as identified by Microsoft, D&B, and other industry standards |
| Area | Geographical area of the Customer |
| Subsidiary | The subsidiary of the customer who's being scored for propensity |
| SalesTerritory | The sales territory of the customer who's being scored for propensity |
| City | Geographical city location of the customer |
| State | Geographical state location of the customer |
| PostalCode | Postal code of the organization of the customer |
| Country | Geographical country/region location of the customer |
| Segment | Market segment as defined by Microsoft |
| SubSegment | Market subsegments as defined by Microsoft |
| SMCTypeSummary | The categorization of a customer as defined by Microsoft: Corporate Scale Businesses meet at least one of the following criteria - High Revenue ($100 K+), High Growth (20%+), High Potential ($100 K+), Org Size 500+, ACR Web Direct > $1000+ per month; Medium businesses are customers with 25 - 300 employees, small are customers with 1-24 employees |
| IsNonprofit | Indicates whether the organization is nonprofit and approved by Microsoft or not: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free sku and aren't a paying customer, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit |
| D365_BC Customers with no Dynamics 365 SalesPro or Sales Enterprise | Upsell Customers without Business Central but have SalesPro/Enterprise for Business Central |
| D365_CRM On Prem Customers with No Dynamics 365 SalesPro Or Sales Enterprise | Target customers with existing Dynamics On Prem CRM systems but don't have Dynamics 365 Sales Pro or Enterprise for Dynamics 365 Sales |
| D365_M365 Customers with >300 Employees with No Dynamics 365 SalesPro Or Sales Enterprise | Upsell existing MW customers with at least 300 employees to target for Dynamics 365 Sales |
| D365_M365 Customers with <300 Employees with No Dynamics 365 SalesPro or Sales Enterprise | Upsell existing MW customers with fewer than 300 employees to SalesPro or Sales Enterprise |
| D365_Azure Customers with No Power Platform | Upsell existing Azure customers with no Dynamics 365 SalesPro, Sales Enterprise or Power Platforms and target for power platforms |
| D365_BC or Dynamics 365 SalesPro Or Sales Enterprise Customers with No Power Platform | Upsell existing Dynamics 365 SalesPro Or Sales Enterprise Customers with No Power Platform to use Power Platform |
| D365_M365 BP_E1_E3_E5 Customer with No Power Platform | Upsell existing MW customers with BP, E1, E3, or E5 to use Power Platforms |
| D365_AX Customer, No BC/Finance | Target Legacy Customers with AX install base to apply Dynamics 365 BC |
| D365_D365 SalesPro or Sales Enterprise Customers with No BC | Upsell existing SalesPro or Sales Enterprise customers to Business Central |
| D365_GP Customer, No BC/Finance | Target Legacy Customers with GP install base to use Dynamics 365 BC |
| D365_M365 Customer with No BC with <300 Employees | Upsell existing MW Cloud Customers with fewer than 300 employees to use Business Central |
| D365_M365 Customer with No BC No Finance No Supply Chain | Upsell existing MW Cloud Customers with at least 300 employees to Business Central |
| D365_NAV Customers, No BC_Finance | Target Legacy Customers with NAV install base to use Dynamics 365 BC |
| D365_Quickbooks Customers with No BC | Target Compete Customers with Quickbooks for Business Central |
| FY24 Offers | Promos for FY24, Customers who are eligible for a promo |
| D365BCCluster | Identifies the customer's propensity to purchase Dynamics 365 Business Central. Customers who show a propensity for Business Central are in the Medium and Small categories. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after your target Act Now and Evaluate customers. |
| D365BCFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMB to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| D365BCIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| D365FOCluster | Identifies the customer's propensity to purchase Dynamics 365 Finance and Operations. Customers who show a propensity for Finance + Operations are in the top un-managed categories. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after your target Act Now and Evaluate customers. |
| D365FOFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMB to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| D365FOIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| D365CECluster | Identifies the customer's propensity to purchase Dynamics 365 Customer Engagement. Customers who show a propensity for Customer Engagement are in the Medium and Small categories. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after your target Act Now and Evaluate customers. |
| D365CEFit | Indicates Fit for Dynamics 365 Customer Engagement |
| D365CEIntent | Indicates Intent for Dynamics 365 Customer Engagement |
| PowerAppsCluster | Identifies the customer's propensity to purchase Power Apps. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after your target Act Now and Evaluate customers. |
| PowerAppsFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMB to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| PowerAppsIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| DynamicsOnPremAXorCRM_HasOpenRenewal | Identifies whether the customer has an open renewal for Dynamics on-premises AX or CRM |
| M365UpsellCustomer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| Has Azure | Identifies Active Azure Customer |
| HasD365 | Identifies Active Dynamics 365 Customer |
| HasM365 | Identifies Active Microsoft 365 Customer |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| HasEA | Identifies whether a renewal is an EA or an EA subscription |
| HasOpen | Identifies whether a renewal is an Open or Open Value agreement |
| Transactedinthelast36months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Azure propensity report
| Column name | Data description |
|---|---|
| MPNID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| CustomerID | Customer identifier number as defined by Microsoft |
| DUNSNumber | The Dun & Bradstreet number of the customer who's being scored for propensity |
| AccountName | Name of the Customer |
| Domain | Domain of the Customer |
| OrgSize | Size of the organization |
| Industry | Industry that the organization belongs |
| Vertical | The vertical of the customer who's being scored for propensity, as identified by Microsoft, D&B, and other industry standards |
| Area | Geographical area of the Customer |
| Subsidiary | The subsidiary of the customer who's being scored for propensity |
| SalesTerritory | The sales territory of the customer who's being scored for propensity |
| City | Geographical city location of the customer |
| State | Geographical state location of the customer |
| PostalCode | Postal code of the organization of the customer |
| Country | Geographical country/region location of the customer |
| Segment | Market segment as defined by Microsoft |
| SubSegment | Market subsegments as defined by Microsoft |
| SMCTypeSummary | The categorization of a customer as defined by Microsoft: Corporate Scale Businesses meet at least one of the following criteria - High Revenue ($100 K+), High Growth (20%+), High Potential ($100 K+), Org Size 500+, ACR Web Direct >$1000+ per month; Medium businesses are customers with 25 - 300 employees, small are customers with 1-24 employees |
| IsNonprofit | Indicates whether the organization is nonprofit and approved by Microsoft or not: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free sku and aren't a paying customer, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit |
| Azure_Migrate and Modernize Apps with Azure Managed Databases | Target Azure high propensity customers with competitor products for conversion Azure Managed Database |
| Azure_Innovate with AI_Build Intelligent Cloud Native Apps on Azure Managed Databases | Target customers with Power BI or DB's for conversion to Azure Managed Database |
| Azure_Extend Edge Inferencing with Cloud-Based Model Training using Azure AI Infrastructure | Target customers with Microsoft Edge products for conversion to Azure AI Infrastructure |
| Azure_Extend to AVD Workloads Requiring GPU Rendering | Target customers with WVD for AVD workloads |
| Azure_Modernize HPC Workloads with Azure HPC + AI | Target customers with existing HPC products for conversion to Azure HPC + AI |
| Azure_Azure Backup and ASR to Every Production Workload | Target VM customers with no backup for Azure backup and Azure Site Recovery |
| Azure_Backup On Prem Data and SaaS Data | Target Azure High propensity customers with win/SQL Server but no backup for backup |
| Azure_Migrate and Modernize VMware to Azure | Target existing VMware customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Modernize VDI to AVD | Target existing VDI customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Modernize VDI to AVD: Citrix IB | Target existing Citrix customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Modernize VDI to AVD: Cross-sell MW to Azure AVD | Target existing MW customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Modernize VDI to AVD: RDS IB | Target existing RDS customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Modernize VDI to AVD: VMWare IB | Target existing VMware Horizon Cloud customers with High propensity for Azure for conversion to Azure Virtual desktop |
| Azure_Secure Migration_MDC_Network Security_and Monitor: Defender | Target customers with Azure who don't have Defender for Defender attach motion |
| Azure_Secure Migration_MDC_Network Security_and Monitor: Network Security | Target Customers with Azure who don't have security to add a security workload or specialization |
| Azure_Secure Migration_MDC_Network Security_and Monitor: Well Architected Security Go Back | Target Customers with Azure consumption of greater than 1k for security |
| Azure_Windows Server OR SQL Server: Active Annuity | Target Win Server and SQL server customers with Active Annuity for conversion to Azure |
| Azure_Windows Server OR SQL Server: Active Non-Annuity | Target Win Server and SQL server customers with Non-Active Annuity for conversion to Azure |
| Azure_Windows Server OR SQL Server: EOS Prior 2012 | Target Win Server and SQL server customers with End of Service license prior to 2012 for conversion to Azure |
| Azure_Windows Server OR SQL Server: EOS 2012 | Target Win Server and SQL server customers with End of Service 2012 for conversion to Azure |
| Azure_Windows Server OR SQL Server: Inactive Annuity | Target Win Server and SQL server customers with Inactive Annuity for conversion to Azure |
| Azure_Windows Server OR SQL Server: Inactive Non-Annuity | Target Win Server and SQL server customers with Inactive Non-annuity for conversion to Azure |
| Azure_Migrate Linux Estate - Migrate and Modernize Linux_OSS DB to Azure | Target Azure high propensity customers with Linux/OSS DB compete products for conversion to Azure |
| Azure_Migrate Oracle DBs to Oracle on Azure | Target Azure high propensity customers with Linux/OSS DB compete products for conversion to Azure |
| Azure_Extend and Innovate SAP with Microsoft Cloud Services | Target Azure high propensity customers with SAP for Microsoft Cloud Services |
| Azure_Migrate and Modernize to S_4HANA via RISE with SAP | Target Azure high propensity customers with SAP HANA for Microsoft Cloud Services |
| Azure_SQL DW to Azure | Target customers with SQL Data Warehouse for Azure |
| Azure_Modernize Enterprise Applications - Move On Prem .NET apps to Azure App Services | Target Azure high propensity customers with competitor .NET apps for Azure App Services |
| Azure_Power Business Decision with Cloud Scale Analytics - Win New Analytics Scenarios | Target Azure high propensity customers with compete in business intelligence for Azure Analytics |
| FY24 Offers | Promos for FY24, Customers who are eligible for a promo |
| AzureFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMB to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| AzureIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| AzureCluster | Identifies the customer's propensity to purchase Azure by consolidating the Fit and Intent recommendations into a cluster. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after your target Act Now and Evaluate customers. |
| WindowsServerDataCenter_HasOpenRenewal | Identifies whether the customer has an open renewal for Windows Server Datacenter |
| WindowsServerStandard_HasOpenRenewal | Identifies whether the customer has an open renewal for Windows Server Standard |
| Has Azure | Identifies Active Azure Customer |
| Has D365 | Identifies Active Dynamics 365 Customer |
| Has M365 | Identifies Active Microsoft 365 Customer |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| HasEA | Identifies whether a renewal is an EA or an EA subscription |
| HasOpen | Identifies whether a renewal is an Open or Open Value agreement |
| NumberofExistingWorkloads | The number of existing Azure workloads that the customer has |
| Existing Workloads | The existing Azure workloads that the customer has purchased |
| NumberofRecommendedWorkloads | The number of recommended Azure workloads that the customer could be targeted for based on their past purchase history and the propensity recommendations |
| RecommendedWorkloads | The recommended Azure workloads that the customer could be targeted for based on their past purchase history and the propensity recommendations |
| Transactedinthelast36months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - agreement renewal propensity report
| Column name | Data description |
|---|---|
| MPNID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| CustomerID | Customer identifier number as defined by Microsoft |
| DUNSNumber | The Dun & Bradstreet number of the customer who's being scored for propensity |
| AccountName | Name of the Customer |
| Domain | Domain of the Customer |
| OrgSize | Size of the organization |
| Industry | Industry that the organization belongs |
| Vertical | The vertical of the customer who's being scored for propensity, as identified by Microsoft, D&B, and other industry standards |
| Area | Geographical area of the Customer |
| Subsidiary | The subsidiary of the customer who's being scored for propensity |
| SalesTerritory | The sales territory of the customer who's being scored for propensity |
| City | Geographical city location of the customer |
| State | Geographical state location of the customer |
| PostalCode | Postal code of the organization of the customer |
| Country | Geographical country/region location of the customer |
| Segment | Market segment as defined by Microsoft |
| SubSegment | Market subsegments as defined by Microsoft |
| SMCTypeSummary | The categorization of a customer as defined by Microsoft: Corporate Scale Businesses meet at least one of the following criteria - High Revenue ($100 K+), High Growth (20%+), High Potential ($100 K+), Org Size 500+, ACR Web Direct > $1000+ per month; Medium businesses are customers with 25 - 300 employees, small are customers with 1-24 employees |
| IsNonprofit | Indicates whether the organization is nonprofit and approved by Microsoft or not: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free sku and aren't a paying customer, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit |
| FY24 Offers | Promos for FY24, Customers who are eligible for a promo |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| AzureCluster | Identifies the customer's propensity to purchase Azure by consolidating the Fit and Intent recommendations into a cluster. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after you target Act Now and Evaluate customers. |
| D365FOCluster | Identifies the customer's propensity to purchase Dynamics 365 Finance and Operations. Customers who show a propensity for Finance + Operations are in the top un-managed categories. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after you target Act Now and Evaluate customers. |
| D365CECluster | Identifies the customer's propensity to purchase Dynamics 365 Customer Engagement. Customers who show a propensity for Customer Engagement are in the Medium and Small categories. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after you target Act Now and Evaluate customers. |
| D365BCCluster | Identifies the customer's propensity to purchase Dynamics 365 Business Central. Customers who show a propensity for Business Central are in the Medium and Small categories. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after you target Act Now and Evaluate customers. |
| PowerAppsCluster | Identifies the customer's propensity to purchase Power Apps. Target Act Now and Evaluate clusters, because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after you target Act Now and Evaluate customers. |
| M365Cluster | Identifies a customer's propensity to purchase Microsoft 365. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after Act Now and Evaluate customers are targeted |
| License Program | Identifies the license program type for the renewal |
| Agreement ID | Identifier of the agreement as defined by Microsoft |
| Agreement End Date | End date of the agreement |
| Expiration Type | Type of expiration |
| Expiring Revenue | Revenue associated with expiring subscriptions |
| Has EA | Identifies whether a renewal is an EA or an EA subscription |
| Has Open | Identifies whether a renewal is an Open or Open Value agreement |
| Microsoft365UpsellCustomer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| RevSumDivisionName | Identifies the product that's up for renewal |
| TransactedInTheLast36months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Surface propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft AI Cloud Partner Program ID |
| PartnerName | Name of the partner |
| CustomerID | Customer identifier number as defined by Microsoft |
| DUNSNumber | The Dun & Bradstreet number of the customer who's being scored for propensity |
| AccountName | Name of the Customer |
| Domain | Domain of the Customer |
| OrgSize | Size of the organization |
| Industry | Industry that the organization belongs |
| Vertical | The vertical of the customer who's being scored for propensity, as identified by Microsoft, D&B, and other industry standards |
| Area | Geographical area of the Customer |
| Subsidiary | The subsidiary of the customer who's being scored for propensity |
| SalesTerritory | The sales territory of the customer who's being scored for propensity |
| City | Geographical city location of the customer |
| State | Geographical state location of the customer |
| PostalCode | Postal code of the organization of the customer |
| Country | Geographical country/region location of the customer |
| Segment | Market segment as defined by Microsoft |
| SubSegment | Market subsegments as defined by Microsoft |
| SMCTypeSummary | The categorization of a customer as defined by Microsoft: Corporate Scale Businesses meet at least one of the following criteria - High Revenue ($100 K+), High Growth (20%+), High Potential ($100 K+), Org Size 500+, ACR Web Direct > $1000+ per month; Medium businesses are customers with 25 - 300 employees, small are customers with 1-24 employees |
| IsNonprofit | Indicates whether the organization is nonprofit and approved by Microsoft or not: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free sku and aren't a paying customer, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit |
| MW_On Prem Acq_Office 2016_2019 | Target customers with On Prem Office 2016 or Office 2019 for conversion to Cloud |
| MW_On Prem Acq Office_Prod Server 2007_2010 | Target customers with On Prem Office/Prod Server 2007 or 2010 for conversion to Cloud |
| MW_On Prem Acq Office 2021 Office_Prod Server 2019 | Target customers with On Prem Office 2021 or Office/Prod Server 2019 for conversion to Cloud |
| MW_On Prem Acq Office_Prod Server 2013_Office 2019 for Mac | Target customers with On Prem Office/Prod Server 2013 or Office 2019 for Mac for conversion to Cloud |
| MW_Transition Customer - Compete (Endpoint Security) with M365 | Target Customers with Endpoint Security and Microsoft 365 for conversion to MW Cloud Suite SKU with security |
| MW_Transition Customer - Compete (Endpoint Security) without M365 | Target Customers with Endpoint Security but without Microsoft 365 for conversion to MW Cloud Suite SKU with security |
| MW_Transition Customer - Compete (Zoom) with M365 | Target Customers with Zoom and Microsoft 365 for conversion to teams |
| MW_Transition Customer - Compete (Zoom) without M365 | Target Customers with Zoom and without Microsoft 365 for conversion to Microsoft 365/Teams |
| MW_Transition Customer - Compete Google Workspace | Target Customers with Google Workspace for conversion to Microsoft 365 |
| MW_Upsell Existing Cloud Customer - EMS Suites_Standalones | Upsell existing EMS Suites/standalone customers to ME3 for sub-300 employee businesses or ME5 for >300 employee businesses |
| MW_Upsell Existing Cloud Customer - ME3_OE5 to ME5 | Upsell existing ME3 or OE5 customers to ME5 |
| MW_Upsell Existing Cloud Customer - MW Standalones_EXO_SPO_etc | Upsell existing modern work standalone customers to ME3 for sub-300 employee businesses or ME5 for >300 employee businesses |
| MW_Upsell Existing Cloud Customer - No MBP_ME3_ME5 | Upsell existing Office 365 Core Products, Microsoft 365 BS, O365 E3/E4 for conversion to ME3, ME5, or MBP |
| MW_Upsell Existing Cloud Customer - O365 A1 | Upsell existing Office 365 active A1 Customers to Microsoft 365 |
| MW_Upsell Existing Cloud Customer - O365 A3_A5_M365 A1_A3 | Upsell existing Office 365 A3, A5, Microsoft 365 A1 or A3 customers to ME5 |
| MW_Upsell Existing Cloud Customer - Under-penetrated MBP_ME3_ME5 | Upsell existing Customers with under-penetrated MBP, ME3, and/or ME5 to full penetration of the SKU in their business |
| MW_Upsell Existing Cloud Customer - Teams Essentials | Upsell existing teams essentials customers without Office 365/Microsoft 365 Suites or Standalones to Microsoft Teams Phone System |
| MW_Business Premium_E SKU Attach >50 | Target customers with 50 or more Office 365 Core or Microsoft 365 BP seats to purchase surface |
| MW_EDU for Surface | Target EDU customers with at least 25 licenses of surface for upsell |
| MW_Surface Devices >25 Purchased in the Last 3 Years | |
| FY24 Offers | Promos for FY24, Customers who are eligible for a promo |
| M365Cluster | Identifies a customer's propensity to purchase Microsoft 365. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after Act Now and Evaluate customers are targeted |
| M365Fit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best small or mid-sized businesses (SMBs) to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| M365Intent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| SurfaceCluster | Identifies a customer's propensity to purchase Surface by consolidating the Fit and Intent recommendations into a cluster. Target Act Now and Evaluate clusters because they produce higher yield. Target Nurture and Educate customers only if there's still capacity after Act Now and Evaluate customers are targeted. |
| SurfaceFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMBs to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| SurfaceIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| M365UpsellCustomer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| Has Azure | Identifies Active Azure Customer |
| Has D365 | Identifies Active Dynamics 365 Customer |
| Has M365 | Identifies Active Microsoft 365 Customer |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| HasEA | Identifies whether a renewal is an EA or an EA subscription |
| HasOpen | Identifies whether a renewal is an Open or Open Value agreement |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
| SurfaceFit | Internal and external data points that define firmographics. Fit scoring uses a lookalike model to our best SMBs to compare customers and see whether they're a potential fit for Microsoft cloud products. Fit scoring is updated quarterly. |
| SurfaceIntent | Signals related to social media and a customer's online behavior define Intent. Intent scoring is overlaid on Fit to define the clusters. Intent scoring is updated monthly. |
| M365UpsellCustomer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| HasGoogle | Identifies whether the customer shows competitive signals for owning Google products |
| HasAWS | Identifies whether the customer shows competitive signals for owning AWS products |
| HasEA | Identifies whether a renewal is an EA or an EA subscription |
| HasOpen | Identifies whether a renewal is an Open or Open Value agreement |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
CPOR-Microsoft 365 usage report
| Column name | Data description |
|---|---|
| CustomerTenantId | Tenant ID of the customer |
| CustomerName | Name of the customer |
| WorkloadName | Name of the workload |
| MonthlyActiveUsers | MAU (monthly active users) |
| PaidAvailableUnits | PAU (paid available units) |
| ClaimId | Claim ID of the workload |
| MpnId | Microsoft AI Cloud Partner Program ID |
| DateAssociated | Associated date of the workload with the partner |
| PartnerAttributionType | Partner Attribution Type (CPOR) |
| Date | Date (first of month and year) for which the data is exported |
Next steps
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for