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 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 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 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 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 attach 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 Cloud Partner Program identifier |
| ResellerName | Reseller name |
| ResellerMarket | Reseller country of market |
| IndirectProviderMpnID | Identifier of the indirect provider Microsoft 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 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 attach 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 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 also 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 (Open, Closed Active 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 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 |
| MonthlySubscriptionLevelACR | Monthly Subscription Level ACR |
| 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 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 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 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 365 Defender for Cloud Apps active usage |
| AADPPaidAvailableUnits | Number of paid available units for Azure Active Directory Premium (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 Azure Active Directory Premium (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 Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical country 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 Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerLocation | Geographical country 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 |
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 |
| 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 |
| 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 |
| 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 Cloud Partner Program |
| PartnerName | Name of the partner |
| PartnerCityLocation | Geographical city location of the partner |
| PartnerCountryLocation | Geographical country 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 Cloud Partner Program |
| PartnerName | Name of the partner |
| Country | Geographical country location of the partner |
Cloud Ascent - Microsoft 365 propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft Cloud Partner Program ID |
| Partner Name | Name of the partner |
| Customer ID | Customer identifier number as defined by Microsoft |
| DUNS Number | The Dun & Bradstreet number of the customer who's being scored for propensity |
| Account Name | Name of the Customer |
| Domain | Domain of the Customer |
| Org Size | 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 |
| Sales Territory | 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 |
| Postal Code | Postal code of the organization of the customer |
| Country | Geographical country location of the customer |
| Segment | Market segment as defined by Microsoft |
| Sub Segment | Market subsegments as defined by Microsoft |
| SMC Type Summary | 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 |
| Is Nonprofit | 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 |
| Digital Workforce: Third Party Hosting Service | Target Customers with third party hosting services for Microsoft 365 |
| Digital Workforce: Acquire new customers to Microsoft - High Propensity Prospect for Microsoft 365 (Act Now Evaluate) | Target win client and/or office customers for Microsoft 365 |
| Digital Workforce: Microsoft 365 A3 targeted for A5 | Target A3 customers for upsell to A5 |
| Digital Workforce: On-premises (Skype for Business) | Target customers with Skype for Business for M365/Teams |
| Digital Workforce: On-premises Acquisition (Current Version) | Target customers with on-premises Win Client current version for conversion to Cloud |
| Digital Workforce: On-premises Acquisition (EOS) | Target customers with on-premises Win Client End of Service for conversion to Cloud |
| Digital Workforce: Transition Customer - Compete (Zoom) with Microsoft 365 | Target customers with zoom compete data and active Microsoft 365 for conversation to teams/M365 |
| Digital Workforce: Transition Customer - Compete (Zoom) without Microsoft 365 | Target Customers with zoom compete for conversion to Teams/M365 |
| Digital Workforce: Transition Customer - Compete Google Workspace | Target Customers with Google apps compete for conversion to Teams/M365 |
| Digital Workforce: Upsell existing cloud customer - Intune | Target Intune customers for Microsoft 365 upsell |
| Digital Workforce: Upsell existing cloud customer - Microsoft 365 BB & BS customers targeted for Microsoft 365 BP | Target Existing Business basic and business standard customers for business premium |
| Digital Workforce: Upsell existing cloud customer - Microsoft 365 E3 targeted for Microsoft 365 E5 | Target existing E3 customers for upsell to E5 |
| Digital Workforce: Upsell existing cloud customer - Target Exchange online | Target Exchange online customers for upsell |
| NextGen Windows Experiences: Compete Amazon Workspace (AWS Workspaces) | Target customers with Amazon Workspace compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete Citrix | Target customers with Citrix compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete Google DaaS compete (itopia, Nutanix Frame, Workspot) | Target customers with Google DaaS compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete VMware Horizons | Target customers with VMware Horizon compete products for Microsoft 365 |
| NextGen Windows Experiences: Customer has hardware (and also add last HW purchase >3 years) | Target customers who haven't purchased new hardware in the last three years for surface/W365 |
| NextGen Windows Experiences: Customer has W10 Pro (or earlier versions), W11 Pro - Target W365 | Target Customers with win10 or 11 for W365 |
| Customers with Windows Pro endpoints: Windows 10 Enterprise E3 + EMS E3 or Microsoft 365 F3/E3/E5/BP - Target for W365 | Target customers with one or more of the following products for W365: EMS E3, Microsoft 365 E3, Business Premium, Microsoft 365 F3, Microsoft 365 E5 |
| NextGen Windows Experiences: Google Workspace customers without Windows | Target customers with Google compete products who don't have windows for W365 |
| Users with non-Windows Pro endpoints: Windows VDA E3 + EMS E3 or Microsoft 365 F3/E3/F5/BP - Target W365 | Target customers with E3 VDA and one or more of the following for W365: EMS E3, Microsoft 365 E3, Business Premium, Microsoft 365 F3, Microsoft 365 E5 |
| Refresh your Devices: Business Premium/E SKU Attach >50 | Target customers with significant Business Premium purchase for W365 |
| Refresh your Devices: EDU for Surface | Target EDU customers with surface licenses purchased in the last three years |
| Refresh your Devices: Surface Devices >25 purchased in the last three years | Target customers with surface license purchased in the last three years |
| Refresh your Devices: Target Surface for BS | Target customers with Business standard for surface cross sell |
| Refresh your Devices: Teams Meeting Presence >50 | Target customers with significant teams purchase for Microsoft 365 |
| Seamless Security: Transition Customer - Compete Endpoint Security MDB | Target customers with one of the following Compete products for Microsoft Defender for Business: CrowdStrike, McAfee, Symantec, Trend Micro, Sophos, Carbon Black, Bit Defender, Panda, Palo Alto |
| Seamless Security: Upsell existing cloud customer - Compete Google Workspace | Target Customers with Google apps compete for conversion to Teams/M365 |
| Seamless Security: Upsell existing cloud customer - Microsoft 365 BB & BS customers targeted for Microsoft 365 BP | Target Existing Business basic and business standard customers for business premium |
| Seamless Security: Upsell existing cloud customer - on-premises Acquisition (Current Version) | Target customers with on-premises Win Client current version for conversion to Cloud |
| Seamless Security: Upsell existing cloud customer - Target Exchange Online | Target Exchange online customers for upsell |
| 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. |
| Surface Cluster | 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. |
| Surface Fit | 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 Google | Identifies whether the customer shows competitive signals for owning Google products |
| Has AWS | Identifies whether the customer shows competitive signals for owning AWS products |
| 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 |
| months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Dynamics 365 propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft Cloud Partner Program ID |
| Partner Name | Name of the partner |
| Customer ID | Customer identifier number as defined by Microsoft |
| DUNS Number | The Dun & Bradstreet number of the customer who's being scored for propensity |
| Account Name | Name of the Customer |
| Domain | Domain of the Customer |
| Org Size | 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 |
| Sales Territory | 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 |
| Postal Code | Postal code of the organization of the customer |
| Country | Geographical country location of the customer |
| Segment | Market segment as defined by Microsoft |
| Sub Segment | Market subsegments as defined by Microsoft |
| Summary | 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 |
| Is Nonprofit | 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 leveraging products, "No" defines the customers who aren't a nonprofit |
| Accelerate Innovation with Low Code: Dynamics Compete Base: Mendix, Outsystems, Salesforce (Power Apps/Power Automate Model) | Target customers with one or more of the following compete vendors for Dynamics 365: Mendix, OutSystems, Salesforce.com, inc |
| Connected Sales & Marketing: Unlock Data to Maximize Sales Impact | Cross Sell Microsoft 365 customers Dynamics 365 |
| Enable a Resilient & Sustainable Supply Chain: Cross-Sell Dynamics 365 Supply Chain And/Or Retail/Commerce to existing Dynamics 365 Sales | Target Customers with CE and high potential for Dynamics 365 F&O |
| Cross-Sell Dynamics 365 Supply Chain And/Or Retail/Commerce to existing Dynamics 365 Sales and (Oracle or SAP) Customers | Target customers with Oracle or SAP compete products for Dynamics 365 F&O |
| Win and Activate First Dynamics 365 Workload as Dynamics 365 Supply Chain with Non-Oracle/SAP ERP Customers | Target customers with compete ERP products that aren't Oracle or SAP |
| Modernize the Service Experience: Dynamics 365 Customer Services and Dynamics 365 Field Services (Dynamics 365 Sales Propensity) | Target customers with customer/field service for Dynamics 365 |
| Optimize Financial & Operating Models: Dynamics on-premises Install Base: Great Plains (BC/Finance Propensity Model) | Existing customer with on-premises Great Plains. Partner should target for Dynamics 365 Business Central |
| Optimize Financial & Operating Models: Dynamics on-premises Install Base: Navision (BC/Finance Propensity Model) | Existing customer with on-premises Navision. Partner should target for Dynamics 365 Business Central |
| Optimize Financial & Operating Models: Dynamics on-premises Install Base: Others (BC/Finance Propensity Model) | Existing customer with other on-premises solutions not previously listed. Partner should target for Dynamics 365 Business Central. |
| Optimize Financial & Operating Models: Dynamics on-premises Install Base: Solomon (BC/Finance Propensity Model) | Existing customer with on-premises Solomon. Partner should target for Dynamics 365 Business Central. |
| Optimize Financial & Operating Models: Transform Business Operations Experience | Target customers without any Dynamics 365 products that are showing high potential for Business Central |
| 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 unmanaged 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 Google | Identifies whether the customer shows competitive signals for owning Google products |
| Has AWS | Identifies whether the customer shows competitive signals for owning AWS products |
| 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 |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Azure propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft Cloud Partner Program ID |
| Partner Name | Name of the partner |
| Customer ID | Customer identifier number as defined by Microsoft |
| DUNS Number | The Dun & Bradstreet number of the customer who's being scored for propensity |
| Account Name | Name of the Customer |
| Domain | Domain of the Customer |
| Org Size | 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 |
| Sales Territory | 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 |
| Postal Code | Postal code of the organization of the customer |
| Country | Geographical country location of the customer |
| Segment | Market segment as defined by Microsoft |
| Sub Segment | Market subsegments as defined by Microsoft |
| SMC Type Summary | 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 |
| Is Nonprofit | 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 leveraging products, "No" defines the customers who aren't a nonprofit |
| Data & AI: Innovate with AI and cloud scale databases in every app: Build new intelligent cloud-native applications | ISV Or Corporate Scale Customers with one of the following products in their technology stack: Active PBI, SQL Server, Cosmos DB, Databricks, HDI |
| Data & AI: Migrate and modernize your datacenter: SQL Server IB (Current Version) | Customer who has a current on-prem SQL Server and isn't yet an End of Service Customer |
| Data & AI: Migrate and modernize your datacenter: SQL Server IB (EOS) | Customer who has a current on-prem SQL Server and is an End of Service Customer |
| Data & AI: Migrate and modernize your datacenter: SQL Server 2012 IB (EOS) | Customer who has EOS on-premises SQL Server 2012 |
| Data & AI: Migrate and modernize your datacenter: Homogenous migration of PostgreSQL and MySQL to Azure | Customers with one of the following Competitor technologies: Oracle w/DB Management System Category, PostgreSQL, MySQL, MariaDB, Amazon RDS for MySQL, Amazon Aurora, Google Cloud Storage |
| Data & AI: Migrate and modernize your datacenter: Migrate SQL Server to Azure SQL Managed Instance and VMs | Customers who have win security Annuity or SQL Server |
| Real-time analytics with Azure Synapse Link + PBI for landed data platform workloads | Customers with Active PBI products |
| Data & AI: Power business decisions with Cloud Scale Analytics: Migration: On-premises DW Migration to Azure Synapse | Target SQL Server customers for Azure |
| Data & AI: Power business decisions with Cloud Scale Analytics: Migration: On-premises Hadoop Migration to Azure Databricks | Target Hadoop customers for Azure |
| Net New: Win New Analytic Use Cases with Synapse and PBI and AML | Target customers with Active PBI products for Azure |
| Digital & App Innovation: Accelerate innovation with Low Code: Build and modernize line of business applications | Target customers with Azure and with power apps propensity OR Customers with power apps and Azure propensity |
| Accelerate software delivery through DevSecOps with GitHub and Visual Studio | Target customers who have purchased Developer tools OR have MCA ATP Azure Kubernetes Services in the last 36 months |
| Digital & App Innovation: Enable developer productivity and Accelerate Delivery: Drive developer engagement | Target customers who have purchases Developer tools in the trailing 36 months for Azure |
| Build cloud-native apps with Kubernetes, Serverless and data: Modernize Apps w AKS | Target ISV customers OR customers with trailing three months revenue of >$1k for Azure |
| Build cloud-native apps with Kubernetes, Serverless and data: Modernize Apps w RH Open Shift - High Consuming Linux IB (ISV) | Target ISV customers OR customers with trailing three months revenue of >$1k and customers that have a compete product from Red Hat, Inc. for Azure |
| Digital & App Innovation: Innovate and scale with cloud native apps: Drive developer engagement | Target customers who purchased Developer tools in the past 36mths |
| Digital & App Innovation: Modernize enterprise applications: Modernize .NET apps with data | Target ISV Customers OR Customers with the following compete products: ASP.NET, EPiServer, Sitecore for Azure |
| Digital & App Innovation: Modernize enterprise applications: Modernize Java apps with data | Target ISV Customers OR Customers with the following compete products: Java, Apache Tomcat, Oracle WebLogic, Node.js Foundation, EPiServer, Jboss, WebSphere |
| High Propensity: High Propensity | Target customers with High propensity for Azure |
| Develop, operate, and secure with Azure Arc, Arc-enabled services, and Azure Stack HCI | Target Customers with a third party hosing or system center for Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Attach Monitor, Storage, Networking, and Security | Target customers with high ACR revenue for Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Windows Server IB (Current Version) | Target customers with on-premises Win Server current version for conversion to Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Windows Server IB (EOS) | Target customers with on-premises Win Server end of service for conversion to Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Windows Server 2012 IB (EOS) | Target customers with on-premises Win Server end of service for the 2012 version for conversion to Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Migrate and modernize Linux/OSS DB to Azure | Target customers with one or more of the following compete products for Azure: Red Hat Enterprise Linux Server, SUSE, SUSE Linux Enterprise Server, Canonical Ubuntu, Debian, FreeBSD, CentOS, Oracle Linux, OpenBSD, Elasticsearch, DataStax, Ansible, PostgreSQL, MySQL, MariaDB, Amazon RDS for MySQL, Amazon Aurora, Google Cloud Storage, Cloudera, Inc., Pivotal Software, Inc, JBoss, Oracle with Database Management, System category |
| Infra: Migrate and Modernize your Infrastructure and workloads: Migrate and modernize VMware to AVS | Target customers with compete VMware products for conversion to AVS |
| Infra: Migrate and Modernize your Infrastructure and workloads: Migrate and modernize Windows Server/SQL to Azure | Target Customers with SQL Server or Win Server for conversion to Azure |
| Infra: Migrate and Modernize your Infrastructure and workloads: Modernize VDI to AVD: Migrate Citrix IB | Target customers with Citrix install base for conversion to AVD |
| Infra: Migrate and Modernize your Infrastructure and workloads: Modernize VDI to AVD: Migrate VMware IB | Target customers with VMware install base for conversion to AVD |
| Infra: Migrate and Modernize your Infrastructure and workloads: Modernize VDI to AVD: Cross Sell MW to Azure AVD | Target existing Microsoft 365 customers for AVD |
| Infra: Migrate and Modernize your Infrastructure and workloads: Modernize VDI to AVD: RDS IB | Target customers with RDS install base for conversion to AVD |
| Infra: Modernize SAP on the Microsoft Cloud: Extend and innovate SAP with Microsoft Cloud services | Target existing customers or customers with SAP with Microsoft Cloud Services |
| Infra: Modernize SAP on the Microsoft Cloud: Migrate and modernize to S/4HANA via RISE with SAP or Azure native | Target existing customers or customers with SAP HANA with Microsoft Cloud Services |
| Extend Microsoft Edge Inferencing with cloud-based model training using Azure AI Infrastructure | Target customers with Azure Microsoft Edge service |
| Infra: Modernize your workloads with Azure at any scale with HPC + AI: Extend to AVD workloads requiring GPU rendering | Target existing customers with Azure AVD Service |
| Infra: Modernize your workloads with Azure at any scale with HPC + AI: Modernize HPC workloads with Azure HPC + AI | Target existing customers with Azure HPC Service |
| Attach Azure Backup and Azure Site Recovery to every production VM (new and go-back) | Target existing customers with VM for backup |
| Infra: Protect your data and ensure business resiliency with BCDR: Back up on-premises data and SaaS data to Azure | Target existing SQL Server or win server customers for Azure |
| Security: Defend Against Threats with SIEM +XDR: Drive SIEM + XDR to modernize security op center | Target customers with Microsoft 365 of 25 seats or more that don't have Azure Sentinel |
| Security: Secure multicloud Infrastructure: Cloud workload protection: Defender Attach in Windows Migration | Target customers with revenue for Defender |
| Security: Secure multicloud Infrastructure: Cloud workload protection: Well Architected Security Go Back | Target Existing high revenue Azure customer for security |
| 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 Google | Identifies whether the customer shows competitive signals for owning Google products |
| Has AWS | Identifies whether the customer shows competitive signals for owning AWS products |
| 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 |
| Number of Existing Workloads | The number of existing Azure workloads that the customer has |
| Existing Workloads | The existing Azure workloads that the customer has purchased |
| Number of Recommended Workloads | The number of recommended Azure workloads that the customer could be targeted for based on their past purchase history and the propensity recommendations |
| Recommended Workloads | The recommended Azure workloads that the customer could be targeted for based on their past purchase history and the propensity recommendations |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - agreement renewal propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft Cloud Partner Program ID |
| Partner Name | Name of the partner |
| Customer ID | Customer identifier number as defined by Microsoft |
| DUNS Number | The Dun & Bradstreet number of the customer who's being scored for propensity |
| Account Name | Name of the Customer |
| Domain | Domain of the Customer |
| Org Size | 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 |
| Sales Territory | 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 |
| Postal Code | Postal code of the organization of the customer |
| Country | Geographical country location of the customer |
| Segment | Market segment as defined by Microsoft |
| Sub Segment | Market subsegments as defined by Microsoft |
| SMC Type Summary | 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 |
| Is Nonprofit | 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 leveraging products, "No" defines the customers who aren't a nonprofit |
| Has Google | Identifies whether the customer shows competitive signals for owning Google products |
| Has AWS | Identifies whether the customer shows competitive signals for owning AWS products |
| Microsoft 365 Cluster | 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 |
| Azure Cluster | 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. |
| Dynamics 365 F&O Cluster | Identifies the customer's propensity to purchase Dynamics 365 Finance and Operations. Customers who show a propensity for Finance + Operations are in the top unmanaged 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. |
| Dynamics 365 CE Cluster | 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. |
| Dynamics 365 BC Cluster | 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. |
| PowerApps Cluster | 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. |
| 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 |
| Microsoft 365 Upsell Customer | Identifies whether the existing customer shows upsell propensity for Microsoft 365 |
| RevSumDivisionName | Identifies the product that's up for renewal |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
Cloud Ascent - Surface Propensity report
| Column name | Data description |
|---|---|
| MPN ID | Microsoft Cloud Partner Program ID |
| Partner Name | Name of the partner |
| Customer ID | Customer identifier number as defined by Microsoft |
| DUNS Number | The Dun & Bradstreet number of the customer who's being scored for propensity |
| Account Name | Name of the Customer |
| Domain | Domain of the Customer |
| Org Size | 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 |
| Sales Territory | 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 |
| Postal Code | Postal code of the organization of the customer |
| Country | Geographical country location of the customer |
| Segment | Market segment as defined by Microsoft |
| Sub Segment | Market subsegments as defined by Microsoft |
| SMC Type Summary | 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 |
| Is Nonprofit | 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 leveraging products, "No" defines the customers who aren't a nonprofit |
| Digital Workforce: 3rd Party Hosting Service | Target Customers with third party hosting services for Microsoft 365 |
| Digital Workforce: Acquire new customers to Microsoft - High Propensity Prospect for Microsoft 365 (Act Now Evaluate) | Target win client and/or office customers for Microsoft 365 |
| Digital Workforce: Microsoft 365 A3 targeted for A5 | Target A3 customers for upsell to A5 |
| Digital Workforce: On-premises (Skype for Business) | Target customers with Skype for Business for M365/Teams |
| Digital Workforce: On-premises Acquisition (Current Version) | Target customers with on-premises Win Client current version for conversion to Cloud |
| Digital Workforce: On-premises Acquisition (EOS) | Target customers with on-premises Win Client End of Service for conversion to Cloud |
| Digital Workforce: Transition Customer - Compete (Zoom) with Microsoft 365 | Target customers with zoom compete data and active Microsoft 365 for conversation to teams/M365 |
| Digital Workforce: Transition Customer - Compete (Zoom) without Microsoft 365 | Target Customers with zoom compete for conversion to Teams/M365 |
| Digital Workforce: Transition Customer - Compete Google Workspace | Target Customers with Google apps compete for conversion to Teams/M365 |
| Digital Workforce: Upsell existing cloud customer - Intune | Target Intune customers for Microsoft 365 upsell |
| Digital Workforce: Upsell existing cloud customer - Microsoft 365 BB & BS customers targeted for Microsoft 365 BP | Target Existing Business basic and business standard customers for business premium |
| Digital Workforce: Upsell existing cloud customer - Microsoft 365 E3 targeted for Microsoft 365 E5 | Target existing E3 customers for upsell to E5 |
| Digital Workforce: Upsell existing cloud customer - Target Exchange online | Target Exchange online customers for upsell |
| NextGen Windows Experiences: Compete Amazon Workspace (AWS Workspaces) | Target customers with Amazon Workspace compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete Citrix | Target customers with citrix compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete Google DaaS compete (itopia, Nutanix Frame, Workspot) | Target customers with Google DaaS compete products for Microsoft 365 |
| NextGen Windows Experiences: Compete VMware Horizons | Target customers with VMware Horizon compete products for Microsoft 365 |
| NextGen Windows Experiences: Customer has hardware (and also add last HW purchase >3 years) | Target customers who haven't purchased new hardware in the last three years for surface/W365 |
| NextGen Windows Experiences: Customer has W10 Pro (or earlier versions), W11 Pro - Target W365 | Target Customers with win10 or 11 for W365 |
| Customers with Windows Pro endpoints: Windows 10 Enterprise E3 + EMS E3 or Microsoft 365 F3/E3/E5/BP - Target for W365 | Target customers with one or more of the following products for W365: EMS E3, Microsoft 365 E3, Business Premium, Microsoft 365 F3, Microsoft 365 E5 |
| NextGen Windows Experiences: Google Workspace customers without Windows | Target customers with Google compete products who don't have windows for W365 |
| Users with non-Windows Pro endpoints: Windows VDA E3 + EMS E3 or Microsoft 365 F3/E3/F5/BP - Target W365 | Target customers with E3 VDA and one or more of the following for W365: EMS E3, Microsoft 365 E3, Business Premium, Microsoft 365 F3, Microsoft 365 E5 |
| Refresh your Devices: Business Premium/E SKU Attach >50 | Target customers with significant Business Premium purchase for W365 |
| Refresh your Devices: EDU for Surface | Target EDU customers with surface licenses purchased in the last three years |
| Refresh your Devices: Surface Devices >25 purchased in the last three years | Target customers with surface license purchased in the last three years |
| Refresh your Devices: Target Surface for BS | Target customers with Business standard for surface cross sell |
| Refresh your Devices: Teams Meeting Presence >50 | Target customers with significant teams purchase for Microsoft 365 |
| Seamless Security: Transition Customer - Compete Endpoint Security MDB | Target customers with one of the following Compete products for Microsoft Defender for Business: CrowdStrike, McAfee, Symantec, Trend Micro, Sophos, Carbon Black, Bit Defender, Panda, Palo Alto |
| Seamless Security: Upsell existing cloud customer - Compete Google Workspace | Target Customers with Google apps compete for conversion to Teams/M365 |
| Seamless Security: Upsell existing cloud customer - Microsoft 365 BB & BS customers targeted for Microsoft 365 BP | Target Existing Business basic and business standard customers for business premium |
| Seamless Security: Upsell existing cloud customer - on-premises Acquisition (Current Version) | Target customers with on-premises Win Client current version for conversion to Cloud |
| Seamless Security: Upsell existing cloud customer - Target Exchange Online | Target Exchange online customers for upsell |
| 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 Google | Identifies whether the customer shows competitive signals for owning Google products |
| Has AWS | Identifies whether the customer shows competitive signals for owning AWS products |
| 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 |
| Transacted in the last 36 months | Identifies if the customer has purchased in the trailing 36 month period |
CPOR-M365Usage 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 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 |