Usage dashboard in commercial marketplace analytics
This article provides information on the Usage dashboard in Partner Center. The Usage dashboard displays the insights for usage of your Virtual machines (VM), Software as a service (SaaS), Azure apps and container offers.
Important
The maximum latency between usage event generation and reporting in Partner Center is 48 hours.
Navigating to pages in Usage dashboard
Usage dashboard consists of five different pages to view insights for specific scenarios.
- Virtual Machine
- VM Normalized usage - This page shows insights around Normalized usage for your Virtual Machine (VM) offers.
- VM Raw usage - This page shows insights around Raw usage for your Virtual Machine (VM) offers.
- Custom meters
- Metered usage - This page shows insights around metered usage for your Containers, Azure apps and Software as a service (SaaS) offers.
- Metered usage anomalies - This page shows insights around anomalies in metered usage.
- Containers
- Containers Raw usage - This page shows insights around raw usage for your container offers.
Note
VM normalized usage is the default page when you land on Usage dashboard.
You can navigate to different pages of usage dashboard by selecting the dropdown at the top of the dashboard.
Public and private offer
You can easily filter the insights based on public or private offers. Each page has three tabs.
- All - This tab is the default selection and shows aggregated insights for both Public and Private offers.
- Public Offers - Click on this tab to view the insights for usage related to Public offers.
- Private Offers - Click on this tab to view the insights for usage related to Private offers.
Note
For detailed definitions of analytics terminology, see Commercial marketplace analytics terminology and common questions.
Usage details table
Important
To download the data in CSV, you can use the Download data option, available at the top of the page.
The usage details table displays a numbered list of the top 500 usage records sorted by usage.
- Data in this table is displayed based on the selected page.
- Each column in the grid is sortable.
Click on the ellipsis (three dots '...') to copy the widget image or download the image as a pdf for sharing purposes.
Usage data dictionary
| Column name | Definition |
|---|---|
| MarketplaceSubscriptionId | The unique identifier associated with the Azure subscription that customer used to purchase. This ID was formerly the Azure Subscription GUID. |
| MonthStartDate | Month Start Date represents the month of purchase. |
| OfferType | The type of commercial marketplace offering like VM, SaaS, Azure apps etc. |
| AzureLicenseType | The type of licensing agreement used by customers to purchase Azure. It's also known as the sales channel. The possible values are: - Cloud Solution Provider - Enterprise - Enterprise through Reseller - Pay as You Go |
| MarketplaceLicenseType | The billing method of the commercial marketplace offer. The possible values are: - Billed Through Azure - Bring Your Own License - Free - Microsoft as Reseller |
| SKU | Plan associated with the offer. |
| CustomerCountry | The country/region name provided by the customer. It could be different than the country/region in customer's Azure subscription. |
| IsPreviewSKU | The value lets you know if you tagged the plan as preview. - Yes: The plan is tagged as preview, and only authorized Azure subscriptions can deploy and use. - No: The plan isn't tagged as preview. |
| SKUBillingType | The billing type associated with each plan in the offer. The possible values are: - Free - Paid |
| VMSize | For VM-based offers, this field shows the size of the VM associated with the offer plan. |
| CloudInstanceName | Microsoft Cloud Instance in which a VM deployment occurred. |
| OfferName | Offer name corresponding to the usage. |
| IsPrivateOffer | Flag to identify if it's a private offer. - 0 value indicates false. - 1 value indicates true. |
| DeploymentMethod | This field signifies the method used for deployment. |
| CustomerName | Name of the customer who is billed for the transaction. |
| CustomerCompanyName | Company name provided by the customer. The name could be different than the name in customer's Azure subscription. |
| UsageDate | Date of usage event generation. |
| IsMultisolution | Signifies whether the offer is a Multisolution offer type. |
| IsNewCustomer | Flag to indicate that the customer is new. |
| CoreSize | Number of cores associated with the VM-based offer. |
| TrialEndDate | End date for trial period. |
| CustomerCurrencyCC | Currency used by the customer for the marketplace transaction. |
| PriceCC | Unit price of the plan shown in customer currency. |
| PayoutCurrencyPC | Currency configured by the publisher for receiving payouts. |
| EstimatedPricePC | Unit price of the plan in the payout currency. |
| UsageReference | A concatenated GUID that is used to connect this Usage report with the Payout transaction report. UsageReference is connected with OrderId and LineItemId in the Payout transaction report. |
| UsageUnit | Unit of consumption associated with the plan. |
| CustomerId | The unique identifier assigned to a customer. A customer can have zero or more Azure Marketplace subscriptions. |
| BillingAccountId | Identifier of the account on which billing is generated. Map BillingAccountID to CustomerID to connect your Payout Transaction Report with the Customer, Order, and Usage Reports. |
| NormalizedUsage | The total normalized usage units consumed by the deployed asset. Normalized usage hours are defined as the usage hours normalized to account for the number of VM cores ([number of VM vCPU] x [hours of raw usage]). VMs designated as "SHAREDCORE" use 1/6 (or 0.1666) as the [number of VM vCPU] multiplier. |
| MeteredUsage | Total usage units consumed by the meters configured for deployed asset. |
| RawUsage | The total raw usage units consumed by the deployed asset. It's defined as the hours VMs have been running in terms of usage units. |
| EstimatedExtendedChargeCC | Estimated charges associated with the usage in customer currency. |
| EstimatedExtendedChargePC | Estimated charges associated with the usage in payout currency. |
| EstimatedFinancialImpactUSD | Applicable for offers with custom meter. Estimated financial impact in USD for partner center flagged anomaly in reported usage. |
| MeterDimension | Applicable for offers with custom meter. Metered dimension of the custom meter. For example, user/device - billing unit |
| MeterId | Applicable for offers with custom meter. Meter ID configured for the plan. |
| PartnerCenterDetectedAnomaly | Applicable for offers with custom meter. Flag to indicate if the publisher reported overage usage for the custom meter dimension was flagged as an anomaly by Partner Center. The possible values are: - 0 (Not an anomaly) - 1 (Anomaly) |
| PublisherMarkedAnomaly | Applicable for offers with custom meter. Flag to indicate if the publisher acknowledged the overage usage by the customer for the custom meter dimension as anomaly. The possible values are: - 0 (Publisher marked it as not an anomaly) - 1 (Publisher marked it as an anomaly) |
| NewReportedUsage | Applicable for offers with custom meter. New usage reported by the publisher if there was anomaly. |
| ActionTakenAt | Applicable for offers with custom meter. Timestamp when publisher acknowledged the anomaly. |
| ActionTakenBy | Applicable for offers with custom meter dimensions. Person who acknowledged the anomaly. |
| PlanId | Plan display name associated with the offer. It was originally a number. |
| ReferenceId | A key to link transactions of usage-based offers with corresponding transactions in the orders report. For SaaS offers with custom meters, this key represents the AssetId. For VM software reservations, this key can be used for linking orders and usage reports. |
| ListPriceUSD | Publicly listed price of the offer plan in U.S Dollars |
| DiscountedPriceUSD | Discounted price of the offer plan in U.S Dollars. |
| IsPrivatePlan | Flag to identify if it's a private plan: - 0 indicates false. - 1 indicates true. |
| OfferId | Marketplace offer ID associated with the transaction. |
| PrivateOfferId | Private offer ID associated with the transaction. |
| PrivateOfferName | Private offer name associated with the transaction. |
| BillingId | The Billing ID of the enterprise customer |
| PlanType | Type of Azure App deployed. It can be either Managed Application or Solution Templates and it can't be private. |
| CustomerAccess | This column denotes if customer has Full access or Restricted access for deployment of Azure app. |
| PublisherAccess | This column denotes if publisher access is Enabled or Disabled for deployment of Azure app. |
| CustomerAdjustmentUSD | The price offered by the Channel partner to the billed customer in U.S Dollars. This value is empty for ISV partners, as only channel partners can see the final adjusted price for the customer. |
| MultiParty | Flag indicating whether a private offer transaction involved multiple parties. - 1 indicates that multi parties like ISV and channel partner were involved. - 0 indicates only ISV partner was involved. |
| PartnerInfo | If the value for MultiParty is 1, then this field shows the SellerID and name of the partners involved in transaction. |
| Sales Notes | If the value for MultiParty is 1, then this field shows the sales notes added by ISV or channel partner during private offer creation. ISV can't view Channel Partner’s Sales notes and vice versa. |
| Asset ID | Applicable for offers with custom meter dimensions. The unique identifier of the customer's order subscription for your commercial marketplace service. Virtual machine usage-based offers aren't associated with an order. |
VM Image version data dictionary
| Column name | Definition |
|---|---|
| MarketplaceSubscriptionId | The unique identifier associated with the Azure subscription that customer used to purchase. This ID was formerly the Azure Subscription GUID. |
| Date | Date on which data is aggregated. |
| OfferName | Offer name corresponding to the usage. |
| OfferType | The type of commercial marketplace offering. |
| OSImageVersion | OS Image version being used |
| Region | Geographic location where VM is situated. |
| Plan | Plan associated with the offer. |
| VMSize | For VM-based offers, this field shows the size of the VM associated with the offer plan. |
| InstanceCount | Count of instances running for the subscription. |
Related content
- To view insights around usage for your Virtual Machine (VM) offers, see Usage Dashboard for VM in commercial marketplace analytics.
- To view insights around usage for your Containers offers, see Usage Dashboard for containers in commercial marketplace analytics.
- To view insights around metered usage for your offers, see Metered Usage Dashboard in commercial marketplace analytics.
- To view insights around metered usage anomalies, see Metered Usage anomalies.
- For frequently asked questions about commercial marketplace analytics and for a comprehensive dictionary of data terms, see Commercial marketplace analytics terminology and common questions.