Share via

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 sections.

Partner profile report

  • 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
  • AccountType: Indicates whether it's a Global ID or Location ID

Note

In the partner profile, report HierarchyLevel column has been changed to AccountType

Customers and tenants

  • 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
  • CustomerMarketGeographical 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
  • SubscriptionGuid: Subscription ID
  • IsAutoRenew: Indicates whether the subscription is autorenewed (Yes or No)
  • SKU: Product stock-keeping unit (SKU)
  • Month: Month for which usage and revenue are reported
  • MPNId: Identifier of Microsoft AI Cloud Partner Program (formerly Microsoft Partner Network (MPN))
  • PartnerName: Name of the partner
  • PartnerLocation: Geographical location of partner
  • PartnerAttributionType: Attribution/Association type of the partner. Can be Advisor, Channel Partner, Claiming Partner of Record (CPOR), CPOR - Competency, CPOR - FRP, CPOR OSA, CPOR RevRec, Cloud Solution Provider (CSP) Tier 1, CSP Tier 2, Deal Registration, Distributor, Hosting Partner, Partner Admin Link, Partner As End Customer, Partner of Record, Reseller, or Transacting Partner of Record
  • 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, Small, Medium Enterprises and Channel (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. Priority list (Lowest number = highest preference): Channel Partner (1) < Distributor (2) < Hosting Partner (3) < Non-Partner (4) < Partner of Record (POR) (5) < Reseller (6). For Example: If both Reseller (6) and Distributor (2) are present, Distributor is marked as Original, Reseller as Duplicate - to avoid double counting
  • AvailableSeats: Available licenses
  • BilledRevenueUSD: Billed revenue in US dollar
  • AzureConsumedRevenueUSD: Azure Consumed Revenue in USD
  • CPORRevenue: Revenue from the CPOR Partner attaches type
  • CPORPaidSeats: Paid licenses with CPOR Partner attach type
  • CPORActiveUsers: Active users with CPOR Partner attach type

Reseller Certifications report

Note

This report is only available to the Distributors.

  • IPPartnerGlobalId: Global Partner ID of the Distributor
  • ResellerGlobalPartnerID: Global Partner ID of the Reseller
  • ResellerGlobalPartnerName: Global Partner Name of Reseller
  • PartnerType: Type of Partner: Reseller or Distributor
  • SolutionArea: Solution area
  • CertificationType: Certification type Intermediate or Advanced
  • CertificationName: Name of the Certification
  • IsPrerequisite: If the Certificate part of Prerequisite
  • IndividualsCount: Count of individuals in Partner Org who achieved the certification

Reseller Solutions Partner report

Note

This report is only available to the Distributors.

  • IPPartnerGlobalId: Global Partner ID of the Distributor
  • PartnerType: Type of Partner: Reseller or Distributor
  • ResellerGlobalPartnerID: Global Partner ID of the Reseller
  • ResellerGlobalPartnerName: Global Partner Name of Reseller
  • SolutionArea: Solution area category; for example, Modern Work, Security, and Data & AI
  • TrackName: Track name SMB or Enterprise (if applicable for the Solution area)
  • Pillar: Pillar represents Performance, Skilling, or Customer Success measurement areas
  • SubCategory: Subcategory classification under the pillar; for example, Net Customer Adds for Performance or Usage Growth for Customer Success
  • ResellerSubcategoryContribution: Actual contribution units achieved by reseller in a subcategory; for example, Net Customer Adds, Deployments, and Usage Growth
  • SubcategoryMaxContribution: Maximum possible contribution needed for the subcategory
  • ResellerSubcategoryPoints: Points earned by reseller in a subcategory based on their contribution performance
  • SubcategoryMaxPoints: Maximum possible points available for the subcategory
  • ResellerPillarScore: Total points earned by reseller across all subcategories within a pillar (Performance, Skilling, or Customer Success)
  • PillarMaxScore: Maximum possible points that a reseller can achieve within the pillar
  • ResellerTotalScore: Total points the reseller earned for the solution area (or track of solution area where applicable)
  • TotalMaxScore: Maximum possible points available for the solution area (or track of a solution area where applicable)

Reseller performance report

Note

Revenue and Azure consumed revenue (ACR) data are available only to users who are Executive report viewers.

  • 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
  • IsAutoRenew: Indicates whether the subscription is autorenewed (Yes or No)
  • AvailableSeats: Number of licenses available
  • AssignedSeats: Number of assigned licenses
  • 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
  • PartnerAttachType: Attribution/Association type of the partner
  • SKU: Product SKU
  • 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
  • ACR: Azure consumed revenue (ACR) in US dollars

ResellerEligibility report

Note

This report is only available to the Distributors.

  • GlobalPartnerId: Global Partner ID or Organization ID for the Partner
  • DistributorTenantID: Tenant ID of the Distributor
  • DistributorAccountCountry: Country/region of the Tenant of Indirect Provider
  • DistributorTenantRegion: Region of the Country of the Indirect Provider
  • ResellerPartnerID: Partner ID of the Reseller
  • ResellerPartnerName: Name of the Reseller associated
  • ResellerAccountType: Account Type of the Reseller - whether PLA (Partner Location Account) or Not a PLA
  • ResellerAccountCountry: Country/region of the Reseller
  • ResellerRegion: Region of the Country of the Reseller
  • ResellerAssociatedWithDistributor: States if the Reseller is directly associated with the Distributor Tenant ID
  • ResellerStatus: Account Status of the Reseller
  • RegionMatch: States if the region of the Reseller matches the region of the Distributor
  • ResellerCountryCodeCount: Count of tenants in the same country/region as the Reseller's location. All tenants associated to the Partner Location should belong to same country/region. Ideal count should be one
  • IsCompliant: States if the Reseller's Partner ID is compliant for the Indirect Provider
  • ErrorCodes: Applicable error codes if the Partner ID of the Reseller is noncompliant

Note

All possible error codes for other scenarios can be found in Developer codes

Reseller Status Report

  • Reseller Name: Name of the Reseller Partner
  • Region: Region of the Reseller Partner
  • PartnerLocationID: Partner Location ID of the Partner
  • Status: Whether the Reseller is active (Authorized) or inactive (Unauthorized)
  • EffectiveInactiveData: Applicable for inactive Resellers. It shows the effective date from when the Reseller is inactive

Subscription details report

Note

Revenue and ACR data are available only to users who are Executive report viewers.

  • 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, 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. Priority list (Lowest number = highest preference): Channel Partner (1) < Distributor (2) < Hosting Partner (3) < Non-Partner (4) < POR (5) < Reseller (6). For Example: If both Reseller (6) and Distributor (2) are present, Distributor is marked as Original, Reseller as Duplicate - to avoid double counting
  • SubscriptionStartMonth: Start month of the subscription
  • ResellerID: ID of reseller
  • ResellerName: Reseller name
  • AvailableSeatsEOP: Overall Available licenses until End of Period
  • AvailableSeats: Available license difference Month on month
  • BilledRevenueUSD: Revenue in USD
  • AzureConsumedRevenueUSD: Azure Consumed Revenue in USD
  • CPORRevenue: Revenue from the CPOR Partner attaches type
  • CPORPaidSeats: Paid licenses with CPOR Partner attach type
  • CPORActiveUsers: Active users with CPOR Partner attach type

CSP Revenue Details report

  • 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. Priority list (Lowest number = highest preference): Channel Partner (1) < Distributor (2) < Hosting Partner (3) < Non-Partner (4) < POR (5) < Reseller (6). For Example: If both Reseller (6) and Distributor (2) are present, Distributor is marked as Original, Reseller as Duplicate - to avoid double counting
  • BilledRevenueUSD: Billed revenue in US dollars

Azure usage report

  • 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 or Association type of the partner, which can be CSP Tier 1, CSP Tier 2, Deal Registration, Partner Admin Link, Partner As End Customer, Partner of Record or Transacting Partner of Record
  • 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. Priority list (Lowest number = highest preference): Partner Admin Link (0) < Transacting POR (1) < POR (2) < CSP Tier 1 (3) < CSP Tier 2 (4) < Partner as End-Customer (5). For Example: If both Partner as End-Customer (5) and POR (2) are present, POR is marked as Original, Partner as End-Customer as Duplicate - to avoid double counting
  • 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

Microsoft 365 usage report

  • PGAPartnerID: Identifier of the partner global account
  • CustomerTenantId: Tenant ID of the customer
  • CustomerTpid: Customer top parent ID
  • WorkloadName: SharePoint Online (SPO), Microsoft365Apps, Teams, TeamsApps, Viva Connections, Viva Engage, Viva Insights, Viva Learning, Viva Topics, EXO, TeamsMeetings, TeamsPhoneEnabledUsers
  • 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 or Association type of the partner, which can be CPOR - Competency, CPOR - FRP, CSP Tier1, CSP Tier2, Delegated Admin Privilege, Operator Connect, Partner As End Publisher, Partner of Record or Transacting Partner of Record
  • 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. Priority list (Lowest number = highest preference): Partner of Record (0) < CSP Tier1 (1) < CSP Tier2 (2) < Delegated Admin Privilege (3) < CPOR - FRP (4) < Transacting POR (5) < CPOR - Competency (6) < CPOR (7) < Partner As End Publisher (8) < Operator Connect (9). For Example: If both CPOR (7) and CSP Tier2 (2) are present, CSP Tier2 is marked as Original, CPOR as Duplicate - to avoid double counting

Note

TotalPaidAvailableUnits and TotalMonthlyActiveUsers columns are legacy columns retained for schema consistency. These columns don't contain any data and can be ignored.

EMS usage report

  • 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 or Association type of partner, which can be CPOR - Competency, CPOR - FRP, CSP Tier1, CSP Tier2, Delegated Admin Privilege, Partner of Record or Transacting Partner of Record
  • 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 usage report

  • 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 or Association type for the subscription. Can be CPOR, Delegated Admin Privilege, FastTrack, Partner of Record or Transacting Partner of Record
  • AvailableSeats: Current paid available licenses
  • AssignedSeats: Current assigned licenses
  • ActiveSeats: Current active licenses
  • DeploymentOpportunity: Deployment opportunity is the number of licenses that aren't assigned
  • ActiveUsagePercent: Current active usage as a percentage of available licenses

Power BI usage report

  • 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 licenses
  • AssignedSeats: Current assigned licenses
  • ActiveSeats: Current active licenses
  • DeploymentOpportunity: Deployment opportunity is the number of licenses that aren't assigned
  • ActiveUsagePercent: Current active usage as a percentage of available licenses

Business Applications Revenue report

  • FiscalMonthName: Month and year information regarding the data
  • GlobalPartnerID: Global partner ID of the partner
  • PartnerName: Name of the partner
  • PartnerAssociationType: Partner association type, which can be CPOR OSA, CPOR RevRec, CPOR RevRec Performance, CSP CPOR RevRec Performance, CSP Tier 1, CSP Tier 2, or Digital Partner of Record (DPOR)
  • 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 Copilot Studio, Supply Chain, CCaaS, F&O Bundle, Sales, Sustainability Manager, AI Builder, Omni-Channel, Finance, Customer Voice, Non Workload Specific-F&O, Customer Insights, Power Pages, Commerce, Business Central, Field Service, Intelligent Order Management, Copilot for Service, Power BI, Customer Service, Microsoft Copilot Studio, CE Bundle, Sales Copilot, Mixed Reality, Power Automate, Project Operations, HR, Copilot for Sales, Non-Workload Specific, Power Apps, Copilot Studio
  • AdjustedRevenueAmtCD: Revenue details for the subscription
  • IsDuplicateAtPGALevel: 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

Business Applications Usage report

  • FiscalMonthName: Month and year information regarding the data
  • GlobalPartnerID: Global partner ID of the partner
  • PartnerName: Name of the partner
  • PartnerAssociationType: Partner association type, which can be CPOR OSU, CSP Tier 1, CSP Tier 2, DPOR, or 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 Business Central, Common Data Service, Core HR, Customer Insights Partner, Finance & Operations, Guides, Microsoft Sales Copilot, Portals, Power Apps, Power Apps Per App, Power Automate, Power BI, Retail
  • SkuGroup: Group to which the SKU belongs
  • PAMAU: Partner attached monthly active users
  • MAC: Monthly active capacity
  • MAU: Monthly active users
  • IsDuplicateAtPGALevel: 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

Teams usage meetings and calls report

  • 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 usage workload report

  • 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 (Third-party) apps report

  • 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 (Trainings, exams, and certifications)

  • 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
  • Email: 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
  • 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

  • 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 - AI Business Solutions Propensity report

  • GlobalID: Partner Global Account ID (PGA): Partner Center account structure
  • PartnerName: Partner Global Account Name
  • CustomerID: Unique identifier for Microsoft Customers or Prospects, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID
  • Customer Tenant ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems This is shared externally to partners and should be able to be matched to customer transactions
  • MoodysID: Unique identifier for accounts sourced from Moodys, an external data provider
  • AccountName: The name of the Microsoft Customer or Prospects
  • Domain: Domain (website) of the Customer
  • OrgSize: OrgSize is defined by the number of employees within an Account
  • Industry: Industry that the organization belongs
  • Vertical: Vertical that the organization belongs
  • Area: Geographical physical location of the Customer grouped into 14 Areas within the world.
  • Subsidiary: Geographical physical location of the Customer grouped into 104 subsidiaries within the world
  • 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: Customer Segment as defined by Microsoft
  • SubSegment: Customer Segment as defined by Microsoft
  • SMECTypeSummary: Another Customer Segment defined by Microsoft:
    • Upper Medium 300 - 999 employees
    • Medium includes customers with 25 - 300 employees
    • Small includes customers with 1-24 employees
  • IsNonProfit: Indicates whether the organization is nonprofit and approved by Microsoft or not
  • Secure_AI_Productivity_Cohort: A specific group of customers categorized by their current usage of Microsoft 365 services and the targeted strategy for their upgrade or adoption of additional services. Here’s a breakdown of each cohort:
    • Migrate to Cloud: This cohort targets customers who don't currently have Microsoft 365 and are using on-premises or compete solutions. The primary goal for this group is to transition them to Microsoft cloud services, emphasizing the advantages of cloud-based solutions, enhanced teamwork, and productivity. Key sales pitch: cloud benefits, productivity, and teamwork
    • Upsell Productivity: These are customers with fewer than 10 Microsoft 365 productivity bundles, such as Business Basic, Business Standard, or Business Premium. The main objective is to encourage broader adoption of core productivity workloads and to increase the number of licenses. Key sales pitch: productivity and teamwork
    • Upsell Security: Customers with 10 or more productivity bundles but no security products; for example, Microsoft Entra, Defender, and Business Premium. The focus is on introducing foundational security capabilities. Key sales pitch: basic security
    • Expand Security: Customers with 10 or more productivity bundles and EMS adoption below 50%. These customers started their security journey and are ready to expand into more advanced security solutions. Key sales pitch: advanced security
    • Cross-sell Next Workload: Customers with 10 or more productivity bundles and EMS adoption of 50% or more. These customers are mature in productivity and security and are ideal candidates for cross-selling additional workloads like Copilot, Teams Phone, Viva, or Fabric
  • Surface_Cohort: These cohorts are designed to align Surface device adoption with broader Microsoft 365 and Copilot solution plays:
    • Expand Surface: Customers who already own Surface devices and show potential to expand their deployment. The goal is to deepen Surface adoption across the organization
    • Cross-Sell with M365: Customers with Microsoft 365 licenses but no Surface devices. These customers are ideal for introducing Surface as a productivity-optimized endpoint that enhances the Microsoft 365 experience
    • Cross-Sell with Copilot: Customers with Copilot licenses but no Surface devices. This cohort is targeted for Surface Copilot+ PCs, emphasizing the value of AI-optimized hardware to unlock the full potential of Microsoft Copilot
  • Copilot_&_Agents_at_Work_Cohort: These Copilot cohorts are based on licensing eligibility and the presence of Microsoft 365 apps, helping guide appropriate sales motions and readiness planning:
    • Attach Free Chat: Customers who don't have Microsoft 365 apps but are eligible for the free Copilot Chat experience via browser. This cohort is ideal for introducing AI capabilities and nurturing them toward full Microsoft 365 Copilot adoption
    • Attach M365 Copilot: Customers who have Microsoft 365 desktop applications and hold qualifying licenses, making them ready to adopt the full Microsoft 365 Copilot experience
    • Expand M365 Copilot: Existing Microsoft 365 Copilot customers with potential to deepen usage. This includes expanding Copilot to more users, activating additional features like agents and analytics, or integrating with other Microsoft solutions
    • Attach/Expand M365 Copilot Business: Customers with 25+ licenses of Microsoft 365 Business Standard and/or Business Premium who are strong candidates for upselling or expanding Microsoft 365 Copilot Business. This cohort supports motions to attach Copilot Business to existing licenses or offer bundled solutions, helping SMB customers unlock AI-powered productivity across familiar Microsoft 365 apps
  • Dynamics365 Cohorts: These cohorts are designed to target existing MSFT customers to a specific Dynamics 365 product
    • Modernize Accounting/ ERP Systems with D365 Business Central: This cohort targets existing Microsoft 365 Customers who currently don't use Microsoft Enterprise Resource Planning (ERP) solutions like Dynamics 365 Business Central or Dynamics 365 Finance and Operations, and who are high-propensity customers, to purchase an ERP solution like Dynamics 365 Business Central or Dynamics 365 Finance and Operations. Target these customers to sell Dynamics 365 Business Central or Dynamics 365 Finance and Operations
    • Migrate from Dynamics OnPrem to Business Central: This cohort targets existing customers who are using a Dynamics on-premises solution like NAV, GP or SL and are a target to migrate to a cloud ERP solution like Dynamics 365 Business Central or Dynamics 365 Finance and Operations. Target these customers to sell Dynamics 365 Business Central or Dynamics 365 Finance and Operations
  • FY26_Offers: Promotional offers for FY26. Customers who are eligible for a promotional offer
  • 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
  • M365_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • M365_First_Logical_SKU: When a customer hasn't purchased Microsoft 365 and is whitespace for the product, this indicates the first logical SKU for which you should target this customer
  • M365_CoPilot_Cluster: Identifies a customer's propensity to purchase Microsoft 365 CoPilot. 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
  • M365_CoPilot_Fit: 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
  • M365_CoPilot_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.
  • M365_CoPilot_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • M365UpsellCustomer: Identifies whether the existing customer shows upsell propensity for Microsoft 365
  • M365_Upsell_SKU: When M365UpsellCustomer Column is set to Yes, this is the next logical SKU that is recommended to sell to this customer
  • 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
  • Surface_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • Dynamics365_BusinessCentral_Cluster: Identifies the customer's propensity to purchase an ERP solution like Dynamics 365 Business Central or Dynamics 365 Finance and Operations. 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
  • Dynamics365_BusinessCentral_Fit: 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
  • Dynamics365_BusinessCentralIntent: 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
  • Dynamics365_BusinessCentral_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • M365_Paid_Seat_Range: The estimated number of paid user licenses the customer has for Microsoft products/services; for example, 1-10, and 11-50
  • Transacted_EOS_Products: Indicates whether the customer purchased a Microsoft product nearing its end-of-support date
  • Has_Transacted_Product: Indicates whether the customer currently owns any Microsoft product that they've transacted with you as the partner
  • Has M365 Security SKUs: Yes/No indicator of if a customer an existing Microsoft 365 Security SKU, this can be used to further prioritize Dynamics 365 targeted customers; Business Central in specific
  • Has_MW_CSP_Annual_Renewal: Identify target customers who have CSP subscriptions with annual terms and display those with the earliest upcoming renewal month
  • Has_Compete: Indicates whether the customer uses products or services from Microsoft competitors
  • Has_Pricing_Level: Identifies how a customer purchased Microsoft products by the various Microsoft pricing levels, for example, Enterprise Agreement, Open Value, and CSP; among others
  • M365_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential for Microsoft 365 over a three year average for Microsoft products/services; for example, $0-$10k, and $10k-$50k
  • Dynamics365_BusinessCentral_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential for Dynamics 365 over a three year average for Microsoft products/services; for example, $0-$10k, and $10k-$50k
  • Surface_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential for Surface over a three year average for Microsoft products/services; for example, $0-$10k, and $10k-$50k
  • TransactedInTheLast36Months: Identifies if the customer purchased a Microsoft product in the trailing 36 month period
  • Additional Information: Microsoft uses this to expand upon any new data added throughout the year

Cloud Ascent - Azure propensity report

  • GlobalID: Microsoft AI Cloud Partner Program ID
  • PartnerName: Name of the partner
  • CustomerID: Unique identifier for Microsoft Customers, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID
  • Customer Tenant ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems. This is shared externally to partners and should be able to be matched to customer transactions MoodysID`: Unique identifier for accounts sourced from Moodys, an external data provider
  • AccountName: The name of the Microsoft Customer or Prospects
  • Domain: Domain (website) 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 physical location of the Customer grouped into 14 Areas within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 104 subsidiaries within the world
  • 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
  • SMECTypeSummary: Another Customer Segment defined by Microsoft:
    • Upper Medium 300 - 999 employees
    • Medium includes customers with 25 - 300 employees
    • Small includes customers with 1-24 employees
  • IsNonProfit: Indicates whether the organization is nonprofit and approved by Microsoft or not
  • 1_Attach_Fabric_to_Power_BI: Targeting current Microsoft customers that have Power BI and haven't yet purchased Fabric. Objective is to migrate Power BI to Fabric
  • 2_Migrate_SQL_DW_to_Fabric: Targeting current Microsoft customers that have an on-premises SQL Server product and haven't yet purchased Fabric. Objective is to migrate their SQL Server environments into Fabric OneLake
  • 3_Fabric_as_Next_Logical_Workload: Targeting current Microsoft Azure customers that are predicted to be a good fit for using Fabric as their next logical workload in Azure. This includes customers using Cosmos, Databricks, or Synapse. The objective is to land Fabric as a primary analytics tool based on their current consumption
  • 4_Fabric_BI_Compete: Targeting customers that don't currently have Azure and are using a competing Business Intelligence product. Objective is to replace their current BI product or to migrate their current data solutions into Fabric OneLake for use through their current BI product
  • 5_Azure_AI_Growth: Targeting customers currently consuming AI, Application, or Data workloads in Azure and enabling them to expand their capability through further consumption of Azure AI workloads
  • 6_Azure_Growth_with_ISVs: Targeting ISV customers currently consuming Azure workloads through CSP, or not consuming Azure at, all and enabling them to expand their capability through further consumption of Azure AI workloads
  • 7_Build_New_AI_Apps: Targeting customers using competing DBMS systems such as MySQL, PostgreSQL, Oracle, and Amazon, or customers that show evidence of doing application development through GitHub or MSDN licenses. The objective is to onboard these customers to Azure Application Development environments that support AI solutions
  • 8_Attach_GitHub_CoPilot: Identifies customers currently using Azure DevOps or GitHub Enterprise, or customers using a competing product for Azure DevOps (Atlassian Jira, BitLab, or Jenkins). The objective is to onboard these customers to GitHub Copilot
  • 1_First_Workload_AVD-RDS: Customers using Remote Desktop Services or Microsoft 365 Business Premium/E3 who have potential to adopt Azure Virtual Desktop. Key sales pitch: initial cloud migration and productivity
  • 2_First_Workload_Backup_&_Azure_disaster_recovery: Customers with Modern Work and Compete solutions but no Azure usage and no integrated backup solutions. Key sales pitch: Azure Backup, disaster recovery, initial Azure adoption
  • 3_Migrate_On-prem_Servers_to_Azure: Customers with on-premises Linux VMs, VMware, or older Windows Servers (2012/2012 R2/2016) not yet using Azure. Key sales pitch: infrastructure migration, operational efficiency
  • 4_Migrate_On-prem_databases_to_Azure: Customers running on-premises databases (Linux/OSS like PGSQL, MySQL, Azure SQL, or SQL 2014/2016) without Azure presence. Key sales pitch: database modernization and cost efficiency
  • 5_Arc-enabled_Servers: Customers with Software Assurance (SA), Extended Security Updates (ESUs), or SQL licensing via SPLA, suitable for hybrid cloud via Azure Arc. Key sales pitch: hybrid flexibility, simplified management
  • 6_NLW_Linux_estate,_Windows_Server_migrations_to_Azure: Customers already using some Azure infrastructure but with opportunities to expand database workloads (SQL, PostgreSQL, MySQL). Key sales pitch: workload growth, data modernization
  • 7_NLW_Databases_to_Azure: Customers already using Azure for Windows Server or Linux VMs with potential to increase Azure usage. Key sales pitch: workload expansion, enhanced cloud efficiency
  • 8_NLW_Security_/_Defender_for_Cloud: Customers with Azure presence or on-premises infrastructure (Linux, WS, SQL) lacking Defender for Cloud. Key sales pitch: enhanced security and threat protection.
  • FY26_Offers: Promotional offers for FY26. Customers who are eligible for a promotional offer
  • 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
  • Azure_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • Azure_First_Logical_SKU: If a customer hasn't purchased Azure and is whitespace for the product, the First Logical SKU is the SKU that partners should target this customer for
  • Number_of_Existing_Workloads: The number of existing Azure workloads that the customer has
  • Existing_Workloads: The existing Azure workloads that the customer 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
  • Next_Logical_Workload_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • Azure_Churn_Risk: Azure Churn is dependent on a variance of ACR by the customer. These are the churn categories:
    • Churn: Variance ≤ -6%
    • Growth: Variance ≥ 10%
    • Flat: Variance between -5% to 9%
  • Has_Transacted_Products: Indicates whether the customer currently owns any Microsoft product that they've transacted with you as the partner
  • Transacted_EOS_Products: Indicates whether the customer purchased a Microsoft product nearing its end-of-support date.
  • Has_Compete: Indicates whether the customer uses products or services from Microsoft competitors
  • Has_Pricing_Level: Identifies the pricing level of the customer and if they purchased through CSP, EA, Open, or Open Value
  • Azure_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential over a three year average for Microsoft products/services; for example, $0-$10k, and $10k-$50k
  • TransactedInTheLast36Months: Indicates whether the customer purchased a Microsoft product within 36 months

Cloud Ascent - Agreement renewal propensity report

  • GlobalID: Microsoft AI Cloud Partner Program ID
  • PartnerName: Name of the partner
  • CustomerID: Unique identifier for Microsoft Customers, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID
  • Customer Tenant ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems. This is shared externally to partners and should be able to be matched to customer transactions
  • MoodyID: Unique identifier for accounts sourced from Moodys, an external data provider
  • AccountName: The name of the Microsoft Customer or Prospects
  • Domain: Domain (website) 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 physical location of the Customer grouped into 14 Areas within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 104 subsidiaries within the world
  • 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
  • SMECTypeSummary: Another Customer Segment defined by Microsoft:
    • Upper Medium 300 - 999 employees
    • Medium includes customers with 25 - 300 employees
    • Small includes customers with 1-24 employees
  • IsNonProfit: Indicates whether the organization is nonprofit and approved by Microsoft or not
  • FY26_Offers: Promotional offers for FY26. Customers who are eligible for a promotional offer
  • HasCompete: Indicates whether the customer uses products or services from Microsoft competitors
  • 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
  • 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.
  • 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
  • M365CoPilotCluster: Identifies a customer's propensity to purchase Microsoft 365 CoPilot. 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
  • M365UpsellCustomer: Identifies whether the existing customer shows upsell propensity for Microsoft 365
  • LicenseProgram: Identifies whether a renewal is an EA, Open, or Open Value agreement
  • AgreementID: Identifier of the agreement as defined by Microsoft
  • AgreementEndDate: End date of the agreement
  • ExpirationType: Type of expiration
  • ExpiringRevenue: Revenue associated with expiring subscriptions
  • RevSumDivisionName: Identifies the product that's up for renewal
  • TransactedInTheLast36Months: Identifies if the customer purchased in the trailing 36 month period
  • Additional Information: Microsoft uses this to expand upon any new data added throughout the year

Cloud Ascent - Surface propensity report

  • GlobalID: Microsoft AI Cloud Partner Program ID
  • PartnerName: Name of the partner
  • CustomerID: Unique identifier for Microsoft Customers, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID
  • Customer Tenant ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems. This is shared externally to partners and should be able to be matched to customer transactions
  • MoodysID: Unique identifier for accounts sourced from Moodys, an external data provider
  • AccountName: The name of the Microsoft Customer or Prospects
  • Domain: Domain (website) 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 physical location of the Customer grouped into 14 Areas within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 104 subsidiaries within the world
  • 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
  • SMECTypeSummary: Another Customer Segment defined by Microsoft:
    • Upper Medium 300 - 999 employees
    • Medium include customers with 25 - 300 employees
    • Small include customers with 1-24 employees
  • IsNonProfit: Indicates whether the organization is nonprofit and approved by Microsoft or not
  • Secure_AI_Productivity_Cohort: A specific group of customers categorized by their current usage of Microsoft 365 services and the targeted strategy for their upgrade or adoption of additional services. Here’s a breakdown of each cohort:
    • Migrate to Cloud: This cohort targets customers who don't currently have Microsoft 365 and are using on-premises or compete solutions. The primary goal for this group is to transition them to Microsoft cloud services, emphasizing the advantages of cloud-based solutions, enhanced teamwork, and productivity. Key sales pitch: cloud benefits, productivity, and teamwork
    • Upsell Productivity: These are customers with fewer than 10 Microsoft 365 productivity bundles, such as Business Basic, Business Standard, or Business Premium. The main objective is to encourage broader adoption of core productivity workloads and to increase the number of licenses. Key sales pitch: productivity and teamwork
    • Upsell Security: Customers with 10 or more productivity bundles but no security products; for example, Microsoft Entra, Defender, and Business Premium. The focus is on introducing foundational security capabilities. Key sales pitch: basic security
    • Expand Security: Customers with 10 or more productivity bundles and EMS adoption below 50%. These customers started their security journey and are ready to expand into more advanced security solutions. Key sales pitch: advanced security
    • Cross-sell Next Workload: Customers with 10 or more productivity bundles and EMS adoption of 50% or more. These customers are mature in productivity and security and are ideal candidates for cross-selling additional workloads like Copilot, Teams Phone, Viva, or Fabric
  • Copilot_&_Agents_at_Work_Cohort: These Copilot cohorts are based on licensing eligibility and the presence of Microsoft 365 apps, helping guide appropriate sales motions and readiness planning:
    • Attach Free Chat: Customers who don't have Microsoft 365 apps but are eligible for the free Copilot Chat experience via browser. This cohort is ideal for introducing AI capabilities and nurturing them toward full Microsoft 365 Copilot adoption
    • Attach M365 Copilot: Customers who have Microsoft 365 desktop applications and hold qualifying licenses, making them ready to adopt the full Microsoft 365 Copilot experience
    • Expand M365 Copilot: Existing Microsoft 365 Copilot customers with potential to deepen usage. This includes expanding Copilot to more users, activating additional features like agents and analytics, or integrating with other Microsoft solutions
  • Surface_Cohort: These cohorts are designed to align Surface device adoption with broader Microsoft 365 and Copilot solution plays:
    • Expand Surface: Customers who already own Surface devices and show potential to expand their deployment. The goal is to deepen Surface adoption across the organization
    • Cross-Sell with M365: Customers with Microsoft 365 licenses but no Surface devices. These customers are ideal for introducing Surface as a productivity-optimized endpoint that enhances the Microsoft 365 experience
    • Cross-Sell with Copilot: Customers with Copilot licenses but no Surface devices. This cohort is targeted for Surface Copilot+ PCs, emphasizing the value of AI-optimized hardware to unlock the full potential of Microsoft Copilot
  • FY26_Offers: Promotional offers for FY26. Customers who are eligible for a promotional offer
  • 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
  • M365_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • 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
  • Surface_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • M365_CoPilot_Cluster: Identifies a customer's propensity to purchase Microsoft 365 CoPilot. 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
  • M365_CoPilot_Fit: 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
  • M365_CoPilot_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
  • M365_CoPilot_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • M365UpsellCustomer: Identifies whether the existing customer shows upsell propensity for Microsoft 365
  • Transacted_EOS_Products: Indicates whether the customer purchased a Microsoft product nearing its end-of-support date
  • Paid_Seat_Range: The estimated number of paid user licenses the customer has for Microsoft products/services; for example, 1-10, 11-50
  • Has_Transacted_Product: Indicates whether the customer currently owns any Microsoft product
  • Has_MW_CSP_Annual_Renewal: Identify target customers who have CSP subscriptions with annual terms, and display those with the earliest upcoming renewal month
  • Has_Compete: Indicates whether the customer uses products or services from Microsoft competitors
  • Has_Pricing_Level: Identifies how a customer purchased Microsoft products by the various Microsoft pricing levels; for example, Enterprise Agreement, Open Value, and CSP, among others
  • Surface_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential over a three year average for Microsoft products/services; for example, $0-$10k, and $10k-$50k
  • TransactedInTheLast36Months: Identifies if the customer purchased a Microsoft product in the trailing 36 month period

Cloud Ascent - Security propensity report

  • GlobalID: Microsoft AI Cloud Partner Program ID
  • PartnerName: Name of the partner
  • CustomerID: Unique identifier for Microsoft Customers, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID
  • Customer Tenant ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems. This is shared externally to partners and should be able to be matched to customer transactions
  • MoodysID: Unique identifier for accounts sourced from Moodys, an external data provider
  • AccountName: The name of the Microsoft Customer or Prospects
  • Domain: Domain (website) 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 physical location of the Customer grouped into 14 Areas within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 104 subsidiaries within the world
  • 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
  • SMECTypeSummary: Another Customer Segment defined by Microsoft:
    • Upper Medium 300 - 999 employees
    • Medium includes customers with 25 - 300 employees
    • Small includes customers with 1-24 employees
  • IsNonProfit: Indicates whether the organization is nonprofit and approved by Microsoft or not
  • 1_Advanced_XDR: Customers with >50 ME3 licenses or > 50 OE3 and EMS E3 licenses or >50 BP licenses and are a target to upsell ME5 or E5 Security
  • 2_Sentinel_Expansion: Customers currently using Azure MDC, Azure Network Security and have Microsoft 365 E5 licenses and are targeted for Microsoft Sentinel. Target these customers to sell Microsoft Sentinel and drive Microsoft Sentinel consumption
  • FY26_Offers: Promotional offers for FY26, Customers who are eligible for a promotional offer
  • 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
  • M365_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • SecurityUpsell: Identifies security upsell customers by upsell to Microsoft 365 E5 vs attach E5 Security. Customers aligned to Microsoft 365 E5 Upsell are customers targeted to upsell from Microsoft 365 E3 to Microsoft 365 E5. Customers aligned to BP + E5 Security Attach are existing BP customers targeted to attach E5 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
  • Azure_Propensity_Signal_explanation: Identifies the key factors of why we're recommending a certain propensity level
  • Has_MW_CSP_Annual_Renewal: Target customers with a CSP annual renewal to renew their existing purchase/upsell by the renewal expiration date
  • Has_Transacted_Product: Indicates whether the customer purchased a Microsoft product within 36 months
  • HasCompete: Indicates whether the customer uses products or services from Microsoft competitors
  • Has_Pricing_Level: Identifies whether a renewal is an EA or an EA subscription or an Open or Open Value agreement
  • M365_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential over a three year average for Microsoft products/services; for example, $0-$10k, $10k-$50k
  • Azure_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customers potential over a three year average for Microsoft products/services; for example, $0-$10k, $10k-$50k
  • TransactedInTheLast36Months: Identifies if the customer purchased in the trailing 36 month period
  • Additional Information: Microsoft uses this to expand upon any new data added throughout the year

CPOR-Microsoft 365 usage report

  • 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

Upcoming Subscriptions Renewals report

  • PGAMpnId: Identifier of the partner global account
  • MpnId: Microsoft AI Cloud Partner Program ID
  • PartnerTenantId: Tenant ID of the partner
  • CustomerName: Name of the customer
  • SubscriptionName: Name of the subscription, such as Microsoft 365 Business Standard, or Microsoft Teams Essentials
  • SubscriptionID: GUID of the subscription
  • Product: Product family that the subscription belongs to, such as Azure, Office, Dynamics, Power BI, or EMS
  • SubscriptionType: Type of subscription, such as NCE or Legacy
  • Status: Status of the subscription, such as Active, Suspended, or Deprecated
  • IsAutoRenew: Indicates whether the subscription is autorenewed (Yes or No)
  • LicensesCount: Count of licenses
  • StartDate: Start Date of the subscription
  • SubscriptionEndDate: End Date of the subscription

SPARK Propensity (Enterprise & SMC) report

  • GlobalPartnerID: Partner global account ID (PGA): Account structure
  • Partner Name: Partner global account name
  • Customer Name: Name of the Microsoft customer or prospect
  • Area: Geographical physical location of the customer grouped into 17 areas within the world
  • Sub Region: Geographical physical location of the customer grouped into 66 subregions within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 131 subsidiaries within the world
  • Segment: Customer segment as defined by Microsoft
  • Solution Area: Microsoft Solution areas indicate the six critical domains to which its solutions belong
  • Solution Play: FY25 Mainstream Solution Plays, as defined by Microsoft
  • Objective: Microsoft-defined intended objective of each Solution Play scenario
  • PMC Link: Partner marketing campaign link
  • DMC Link: Digital Marketing Campaign link

SPARK Propensity (Enterprise & SMC) - Reseller report

This report is only available for indirect providers.

  • GlobalPartnerID: Partner Global Account ID (PGA): Account structure
  • Partner Name: Partner global account name
  • Reseller ID: Reseller partner ID
  • Reseller Name: Reseller partner name
  • Customer Name: Name of the Microsoft customer or prospect
  • Area: Geographical physical location of the customer grouped into 17 areas within the world
  • Sub Region: Geographical physical location of the customer grouped into 66 subregions within the world
  • Subsidiary: Geographical physical location of the Customer grouped into 131 subsidiaries within the world
  • Segment: Customer segment as defined by Microsoft
  • Solution Area: Microsoft Solution areas indicate the six critical domains to which its solutions belong
  • Solution Play: FY25 Mainstream Solution Plays, as defined by Microsoft
  • Objective: Microsoft-defined intended objective of each Solution Play scenario
  • PMC Link: Partner marketing campaign link
  • DMC Link: Digital marketing campaign link

Related content

  • Last updated on