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 following sections list the various reports that you can download along with their data definitions.

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, the report HierarchyLevel column was 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
  • CustomerMarket: Geographical market of the customer.
  • CustomerStatus: Customer status (Active or Inactive)
  • CustomerTenantName: Name of customer tenant
  • CustomerTenantCountry: Country/region of customer tenant
  • TenantDomainName: Domain name of customer tenant
  • Product: The product sold to the customer by the partner: Microsoft 365, Dynamics 365, Enterprise Mobility + Security, Power BI, or Microsoft Azure.
  • RawProductName: Detailed product name sold to the customer
  • SubscriptionGuid: Subscription ID
  • IsAutoRenew: Indicates whether the subscription is auto-renewed (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 dollars.
  • 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 authorization report

Note

This report is only available to the distributors.

  • ResellerName: Name of the reseller
  • ResellerTenantID: CSP tenant GUID for the reseller
  • ResellerPartnerGlobalAccountId: Partner Global Account (PGA) for the reseller
  • Status:
    • Inactive - deauthorized: The partner is deauthorized from the Cloud Solution Provider program on "DeauthorizedDate".
    • Active - failed eligibility, risk of deauthorization: The partner lost eligibility for the Cloud Solution Provider program on "AnniversaryMonth" and is deauthorized 30 days after distributor receiving “Notice of CSP Indirect Reseller Eligibility: List of Non-Eligible Indirect Resellers” notification.
    • Active - eligibility at risk: The partner might lose eligibility for the Cloud Solution Provider program on "AnniversaryMonth".
  • AnniversaryMonth: Reseller’s anniversary month.
  • DeauthorizationDate: For those resellers already deauthorized, the effective date.
  • DistributorTenantId: CSP tenant GUID for the distributor.

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 the reseller
  • PartnerType: Type of partner: reseller or distributor
  • SolutionArea: Solution area
  • CertificationType: Certification type, such as intermediate or advanced
  • CertificationName: Name of the certification
  • IsPrerequisite: Indicates if the certification is a prerequisite
  • IndividualsCount: Count of individuals in the partner organization 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 the reseller
  • SolutionArea: Solution area category, such as 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, such as Net Customer Adds for Performance or Usage Growth for Customer Success
  • ResellerSubcategoryContribution: Actual contribution units achieved by reseller in a subcategory, such as 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 auto-renewed (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: Specific grouping used for budgeting and forecasting purposes. A reporting pricing level is the established level for budget and forecast to actual revenue comparisons.
  • DetailPricingLevelName: Detail pricing level 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

Reseller eligibility 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 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 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 auto-renewed (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, either global or local.
  • 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: Specific grouping used for budgeting and forecasting purposes. A reporting pricing level is the established level for budget and forecast to actual revenue comparisons.
  • DetailPricingLevelName: Detail pricing level 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: Grouping of detail pricing levels. A summary pricing level is 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 to
  • 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 to
  • 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 or region location of the market of customer.
  • IndustryName: Type of industry the customer belongs to
  • 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: Partner ID.
  • 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 was recently 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 to
  • 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 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 to
  • 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 for the data.
  • GlobalPartnerID: Global partner ID of the partner.
  • PartnerName: Name of the partner.
  • PartnerAssociationType: Partner association type, which can be CPOR Online Service Advisory (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/Region: 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 for 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/region code of the customer.
  • CustomerCountry: Customer country/region.
  • CustomerSegment: Type of customer segment, such as Major Commercial, Major Public Sector, Small, Medium & Corporate Commercial, and so on.
  • IndustryName: Type of industry the customer belongs to
  • 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, such as 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 to
  • 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 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/region code of the customer.
  • CustomerCountry: Customer country/region.
  • CustomerSegment: Type of customer segment, such as Major Commercial, Major Public Sector, Small, Medium & Corporate Commercial, and so on.
  • IndustryName: Type of industry the customer belongs to
  • 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/Region: Geographical country/region location of the partner

CloudAscent AI Workforce and Security Propensity Report

  • GlobalID: Partner Global Account ID (PGA): Partner Center account structure
  • PartnerName: Partner Global Account Name
  • MoodysID: Unique identifier for customers sourced from Moodys, an external data provider.
  • CustomerTPID: Unique identifier for customers sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one Customer ID.
  • AccountName: The name of the customer.
  • Customer_Tenant_ID: Unique identifier for customer tenant sourced from internal Microsoft systems. This identifier is shared externally to partners and can be matched to customer transactions.
  • Tenant_Name: Customer name based on the Tenant ID which is a unique identifier for customers sourced from internal Microsoft systems. This identifier is shared externally to partners and can be matched to customer transactions.
  • Default_Domain: Website (domain) of the customer listed in the tenant ID as default.
  • Propensity_Domain: Website (domain) of the customer that is used to score the customer for their propensity to purchase Microsoft products.
  • OrgSize: Reflects the total number of employees in an organization. Don't interpret this number as the count of information workers, as some employees might not use a PC or mobile device.
  • Industry: Industry that the organization belongs to.
  • Vertical: Vertical that the organization belongs to.
  • Area: Microsoft-defined geographic area associated with the customer's physical location.
  • Subsidiary: Microsoft-defined subsidiary associated with the customer's physical location, according to Microsoft's subsidiary structure.
  • City: Geographical city location of the customer.
  • State: Geographical state location of the customer.
  • PostalCode: Postal code of the organization of the customer.
  • Country/Region: Geographical country/region location of the customer.
  • Segment: Customer segment as defined by Microsoft.
  • SubSegment: Customer sub-segment 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: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free SKU and aren't using products, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit.
  • M365_Seats_Count: The total number of paid Microsoft 365 user licenses (seats) the customer currently owns across their tenant. Serves as the installed base for sizing Copilot and security upsell opportunities.
  • Free_Copilot_Chat_MAU_Unlicensed: This value provides the MAU that a customer has, based on free chat usage, which doesn't require Microsoft 365 Copilot licenses. MAU is the measure, determined by Microsoft product telemetry, of unique signed-in users who took one or more intentional actions in the last rolling 28 days. The intentional action establishes clear user intent to perform a specific business action.
  • Paid_Copilot_Chat_MAU: Monthly active users (MAU) using Copilot Chat under a paid Microsoft 365 Copilot license (work-grounded chat with access to organizational data). Indicates active engagement among licensed users.
  • Copilot_Paid_Utilization: The share of the customer's purchased (paid) Copilot licenses that are actively being used - active licensed users divided by assigned paid seats. Low utilization flags an adoption or enablement need; high utilization flags readiness to expand.
  • Copilot_Seats_Whitespace: The untapped Copilot opportunity within the account - the number of eligible users who don't yet have a paid Microsoft 365 Copilot seat. Represents the remaining seats a partner can sell into the existing customer.
  • Monthly_Users_Experiencing_Usage_Limits: The monthly active users of Copilot (primarily free tier) experiencing some sort of usage limits due to high demand.
  • Cumulative_License_Request: Cumulative sum of license requests for Copilot. This capability allows users to request a Microsoft 365 Copilot license directly from their admin. This process helps efficiently assign unused licenses or purchase additional ones as needed. Global admins, license admins, and user admins can manage these requests seamlessly in the Microsoft 365 Admin Center. This value is a sum of license requests which can sometimes exceed total eligible M365 Copilot licenses due to customer trials as well as users requesting multiple times, although that request is less frequent.
  • Copilot Trial: Indicates the specific Copilot trial the customer is participating in, or identifies customers prioritized for a trial offer.
  • All_Agents_MAU: The sum of licensed and unlicensed Copilot MAU. Select for a further breakdown of Copilot usage by product, for the tenant.
  • BP_ME3_Whitespace: Users not yet licensed with Microsoft 365 Business Premium (BP) or Microsoft 365 E3 (ME3), representing the foundational productivity opportunity before expanding to E5 Security and Copilot.
  • MCI_Eligibility: Eligibility of the tenant and workload for one or more MCI engagements. This eligibility depends on the eligibility of the partner and customer, taking into account geography as well. Eligibility is automatically calculated based on whether the claiming partner country or region is within a customer's headquarters area*. Partners claiming customers outside of their headquarters area might be paused or removed from Microsoft Commerce Incentives. *See slide 32 "Microsoft Area Mapping" in the Microsoft Commerce Partner Incentives Guide available at Microsoft Commerce Partner Incentives Guide
  • Secure_Productivity_Cohort: Assigns each customer tenant to one of five sequential FY27 productivity-growth cohorts (a maturity ladder). Details by cohort: 1. Migrate to Cloud (Acquire) Who: Customers not using Office 365 yet - the account has no tenant, no O365 seats, or only trial seats. Logic: Net-new cloud wins. They're still on-premises, on a competitor, or never adopted. The motion is to land them on Microsoft cloud productivity for the first time. Sell: Business Family: Business Premium, Business Standard, Business Basic or Apps for Business. 2. Grow M365 Suites (Expand) Who: Customers already on the cloud but shallow - fewer than 25 productivity seats. Logic: They've landed, but are still small or haven't fully adopted O365, therefore hard to justify an upsell or attach motion. The motion is to widen the footprint and drive real adoption before pushing premium tiers. Sell: Sell and expand productivity bundles: Business Premium, Business Standard, or Business Basic. 3. Grow Business Premium (Upsell) Who: Established tenants with 25+ productivity seats, but under-secured (security mix below 75%) AND small in size (below 300 seats). Logic: They have a real productivity base but haven't fully attached security/premium value. Because they're below 300 seats, the right premium destination is Business Premium. Sell: Business Premium (BP). 4. Grow ME3 (Upsell) Who: Established larger tenants with 25+ productivity seats, under-secured (security mix below 75%), but large in size (above 300 seats). Logic: Exact same under-secured gap as Cohort 3 - the only difference is size. Above 300 seats, Business Premium no longer fits; the right destination is Microsoft 365 E3, the enterprise suite. The 300-seat line is the single switch that routes a customer to BP (Cohort 3) vs. ME3 (Cohort 4). Sell: M365 E3 (ME3). 5. Cross-sell Next Workload (Cross-sell) Who: Mature, well-secured tenants - 25+ productivity seats AND security mix exceeds 75% (already highly penetrated on the suite + security story). Logic: They've essentially bought the productivity-and-security narrative - little headroom left to upsell the suite itself. So the motion shifts to selling adjacent workloads that ride on top of that foundation. Sell: Windows 365 (Cloud PC), Microsoft 365 Copilot, ME5 and E5 Security.
  • Copilot_Cohort: Assigns each customer tenant to one of three FY27 Copilot targeting cohorts (an attach-and-expand ladder), where Copilot attach % = Copilot seats / MAX(Exchange Online seats, M365 Apps seats). Details by cohort: 1. Attach Copilot (Attach) Who: Established tenants with 25+ Core or Security bundle seats and no Copilot yet. Logic: They already run a real productivity or security base but haven't adopted AI. The motion is to attach the first Copilot seats onto that installed base. Sell: Microsoft 365 Copilot (first seats) or Copilot trial. 2. Nurture Copilot (Expand) Who: Tenants that have Copilot but at very low penetration - attach below 5% of seats. Logic: They've made a toehold purchase, but adoption has barely started. Pushing more seats now is premature - the motion is to nurture early adoption and prove value before expanding. Sell: Nurture adoption of the existing Copilot footprint, then expand Microsoft 365 Copilot. 3. Expand Copilot (Expand) Who: Tenants that have Copilot at partial penetration - attach between 5% and 80% of seats - with clear room to grow. Logic: Copilot has taken hold on part of the workforce and meaningful headroom remains. The motion is to expand Copilot across more of the eligible seat base. Sell: Additional Microsoft 365 Copilot seats.
  • Security_Cohorts: 1. Upsell from ME3 to ME5 - Targets customers with greater than 50 ME3 seats and has < 75% ME5 Mix 2. Attach Defender & Purview to BP - Targets customers with >25 BP seats and has < 75% Defender and Purview Suite for BP Attach 3. SOC Ready - Targets customers with >150 ME5 Seats and has less than $50 in sentinel ACR
  • Promo_Eligibility: Customers who are eligible for a promo.
  • M365_Propensity: 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
  • M365_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_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_Propensity_Signal_Explanation: Identifies the key factors of why we're recommending a certain propensity level.
  • M365_Copilot_Propensity: 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_Paid_Seat_Range: The estimated number of paid user licenses the customer has for Microsoft products and services (for example, 1-10, 11-50).
  • Transacted_EOS_Products: Indicates whether the customer has 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_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, eg, Enterprise Agreement, Open Value, CSP etc
  • M365_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customer's potential for M365 over a three-year average for Microsoft products and services (for example, $0-$10k, $10k-$50k).
  • Copilot_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customer's potential for Copilot over a 3 year average for Microsoft products/services. (e.g., $0-$10k, $10k-$50k)
  • Azure_Customer_Potential_Revenue_Range: Estimated range of potential revenue represents the customer's potential for Azure over a 3 year average for Microsoft products/services. (e.g., $0-$10k, $10k-$50k)
  • TransactedInTheLast36Months: Identifies if the customer has purchased a Microsoft product in the trailing 36 month period
  • Targeting_Content_Link: Identifies the link to the content available from Microsoft.
  • Additional Information: Microsoft uses this field to expand upon any new data added throughout the year.

CloudAscent Cloud & AI Platform Propensity Report

  • GlobalID: Partner Global Account ID (PGA): Partner Center account structure
  • PartnerName: Partner Global Account Name
  • CustomerTPID: 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 identifier is shared externally to partners and should be able to be matched to customer transactions.
  • MoodysID: Unique identifier for accounts sourced from Moody's, 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 to.
  • 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/Region: 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: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free SKU and aren't using products, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit.
  • Fabric_Migrate_and_Grow: Identifying customers with existing Azure data, AI, analytics, Synapse, Databricks, database, or on-premises SQL Server workloads and limited or no Fabric adoption. The objective is to migrate workloads to Fabric or grow Fabric as the next logical analytics platform.
  • Attach_Fabric_to_PBI: Identifying current Microsoft customers who have paid Power BI products and have not purchased Microsoft Fabric. The objective is to attach Fabric to their Power BI environment and expand their analytics capabilities.
  • Fabric_Trials_to_Paid_Conversion: Identifying customers with an active Microsoft Fabric trial and no paid Fabric usage. The objective is to convert the trial into a paid Fabric subscription.
  • Fabric_Compete: Identifying customers using competing business intelligence or cloud analytics platforms who have not adopted Microsoft Fabric. The objective is to replace the competing platform or migrate its data workloads to Microsoft Fabric and OneLake.
  • Attach_Fabric_to_M365_and_D365: Identifying customers with Microsoft 365, Dynamics 365, or competing ERP platforms who have not adopted Microsoft Fabric. The objective is to attach Fabric and use it as the analytics platform for their business and productivity data.
  • Modernize_OR_Build_New_Applications_on_Azure: Identifying customers with legacy .NET, Java, container, Red Hat OpenShift, or other application development environments that are not fully using Azure application services. The objective is to migrate existing applications or build new cloud-native applications on Azure.
  • Modernize_On_Prem_and_Other_Databases_to_Azure: Identifying customers running on-premises SQL Server, open-source databases, Oracle, or competing cloud databases. The objective is to modernize and migrate these data estates to Azure managed database services.
  • Modernize_On_Prem_Infrastructure_to_Azure: Identifying customers running on-premises Windows Server, Linux, or IIS application infrastructure. The objective is to migrate and modernize these environments on Azure compute services.
  • Modernize_On_Premises_Win_SQL_or_VMWare_Estate_to_Azure_with_DCO: Identifying customers running on-premises Windows Server, SQL Server, or VMware environments, including SPLA and end-of-support estates. The objective is to migrate or extend these workloads to Azure using Azure Arc, Azure virtual machines, Azure VMware Solution, and Azure SQL.
  • Set_Up_Azure_Backup_and_Disaster_Recovery: Identifying Microsoft 365 customers with no Azure usage, or Azure customers without backup and disaster recovery protection. The objective is to establish a first Azure workload or improve resilience with Azure Backup and Azure Site Recovery.
  • Modernize_SAP_on_Azure: Identifying customers running SAP Business One, S/4HANA, SAP RISE, Business Technology Cloud, Business Data Cloud, or Business Warehouse environments. The objective is to migrate, modernize, or expand SAP workloads on Azure.
  • Secure_Workloads_with_Defender_for_Cloud: Identifying Azure customers with eligible workloads and limited or no Microsoft Defender for Cloud usage. The objective is to attach Defender for Cloud to improve security posture and threat protection.
  • Acquire_Foundry_from_M365: Identifying Microsoft 365 or Copilot Studio customers who have not adopted Microsoft Foundry. The objective is to land Foundry as the platform for building and operating AI applications and agents.
  • Fabric_and_Foundry_Unify_Data_and_AI: Identifying customers with limited Fabric and no Foundry usage who are already using databases, Azure application or container services, or Microsoft 365 AI products. The objective is to unify data and AI workloads by growing Microsoft Fabric and attaching Microsoft Foundry.
  • Attach_Foundry_to_Fabric_and_or_DB: Identifying customers using GitHub, Fabric, databases, AI services, or competing AI and DevOps products who have not adopted Microsoft Foundry. The objective is to attach Foundry and enable the development and deployment of AI solutions.
  • Sell_GitHub_Enterprise: Acquire GitHub Enterprise customers using Visual Studio, Azure developer services, Foundry, or competing DevOps platforms. The objective is to migrate their development workflows to GitHub Enterprise.
  • Sell_GitHub_Copilot: Acquire GitHub Copilot customers using developer platforms, Visual Studio, or competing DevOps tools. The objective is to attach GitHub Copilot to accelerate software development.
  • Promo_Eligibility: Customers who are eligible for a promo.
  • Azure_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.
  • Azure_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.
  • Azure_Propensity: 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.
  • 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.
  • 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, the following defines 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 has 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 customer's potential over a three-year average for Microsoft products and services. (For example, $0-$10k, $10k-$50k).
  • TransactedInTheLast36Months: Indicates whether the customer has purchased a Microsoft product within 36 months.
  • Targeting_Content_Link: Identifies the link to the content available from Microsoft.
  • Additional_Information: Microsoft uses this field to expand upon any new data added throughout the year.

CloudAscent AI Business Process Propensity Report

  • GlobalID: Partner Global Account ID (PGA): Partner Center account structure
  • PartnerName: Partner Global Account Name
  • CustomerTPID: Unique identifier for Microsoft Customers, sourced from internal Microsoft systems. Within Cloud Ascent, duplicate accounts are identified and aggregated into one CustomerID.
  • M365_Customer_Tenant_ID: Unique identifier for Microsoft Customers sourced from internal Microsoft Systems. This identifier is shared externally to partners and should be able to be matched to customer transactions.
  • MoodysID: Unique identifier for accounts sourced from Moody's, 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 to.
  • 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/Region: Geographical country/region location of the customer.
  • Segment: Market segment as defined by Microsoft.
  • SubSegment: Market subsegments as defined by Microsoft.
  • SMECTypeSummary: 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: "Nonprofit" defines customers with an industry of nonprofit but they aren't approved by Microsoft. "Approved - Paid" defines the customers that are approved nonprofits and are paying some amount, "Approved - Free Only" defines the customers that are approved as a nonprofit by Microsoft but are only using a free SKU and aren't using products, "Approved - Inactive" defines customers who are approved but aren't using products, "No" defines the customers who aren't a nonprofit.
  • Dynamics365_Cohorts: 1. Migrate from Dynamics OnPrem to Business Central - Targets customers with Dynamics On prem GP, NAV, SL and has no D365 Business Central or Finance & Operations and is a target to sell D365 Business Central 2. Modernize Accounting/ ERP Systems with Business Central for M365 Customers - Targets M365 Customers (BS/ BP/ME3/ME5) with greater than 10 seats and has no D365 Business Central or Finance & Operations and is a target to sell D365 Business Central 3. ERP Compete - Targets customers using Quickbooks/ QB Online/ QB Desktop Pro/ QB Desktop Enterprise/ SAP B1/ NetSuite and has no D365 Business Central or Finance & Operations and is a target to sell D365 Business Central
  • Dynamics365_BusinessCentral_Propensity: 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.
  • 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_BusinessCentral_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.
  • Dynamics365_BusinessCentral_Customer_Potential_Revenue_Range:
  • Dynamics365_BusinessCentral_Propensity_Signal_Explanation: Identifies the key factors of why we're recommending a certain propensity level.
  • Promo_Eligibility: Customers who are eligible for a promo.
  • Has_Transacted_Product: Indicates whether the customer has purchased a Microsoft product through you as the partner.
  • Has_M365_Security_SKUs:
  • M365_Paid_Seat_Range: The estimated number of paid user licenses the customer has for Microsoft products/services for M365. (e.g., 1-10, 11-50)
  • 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, eg, Enterprise Agreement, Open Value, CSP etc
  • TransactedInTheLast36Months: Identifies if the customer has purchased a Microsoft product in the trailing 36 month period
  • Targeting_Content_Link: Identifies the link to the content available from Microsoft.
  • M365_Copilot_Propensity: 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.
  • Free_Copilot_Chat_MAU_Unlicensed: This value provides the MAU that a customer has, based on free chat usage, which doesn't require Microsoft 365 Copilot licenses. MAU is the measure, determined by Microsoft product telemetry, of unique signed-in users who took one or more intentional actions in the last rolling 28 days. The intentional action establishes clear user intent to perform a specific business action.
  • Paid_Copilot_Chat_MAU: Monthly active users (MAU) using Copilot Chat under a paid Microsoft 365 Copilot license (work-grounded chat with access to organizational data). Indicates active engagement among licensed users.
  • Copilot_Paid_Utilization: The share of the customer's purchased (paid) Copilot licenses that are actively being used - active licensed users divided by assigned paid seats. Low utilization flags an adoption or enablement need; high utilization flags readiness to expand.
  • Copilot_Seats_Whitespace: The untapped Copilot opportunity within the account - the number of eligible users who don't yet have a paid Microsoft 365 Copilot seat. Represents the remaining seats a partner can sell into the existing customer.
  • Additional Information: Microsoft uses this field to expand upon any new data added throughout the year.

CloudAscent Agreement Renewals Propensity Report

  • GlobalID: Microsoft AI Cloud Partner Program ID
  • PartnerName: Name of the partner.
  • CustomerTPID: 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 customer tenant sourced from internal Microsoft systems. This identifier is shared externally to partners and can be matched to customer transactions.
  • MoodysID: Unique identifier for accounts sourced from Moody's, 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 to.
  • 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/Region: 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: "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
  • Promo_Eligibility: Promos for FY25, Customers who are eligible for a promo
  • Has_Compete: Identifies whether the customer shows competitive signals for owning Google products
  • Azure_Propensity: 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
  • Dynamics365_BusinessCentral_Propensity: 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.
  • M365_Propensity: 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
  • M365_Copilot_Propensity: Identifies a customer's propensity to purchase 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 the license program type for the renewal
  • 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 field 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 auto-renewed (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 available only 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