Are there any high-quality SaaS dashboard offerings

"Usage" dashboard in analyzes for the commercial marketplace

  • 13 minutes to read

This article provides information about the Usage dashboard in Partner Center. In this dashboard, all VM offers with metrics for normalized usage, actual usage and usage according to metered billing are displayed on three separate tabs: Normalized usage according to VM size, actual usage according to VM size and usage according to metered billing.

To access the Usage dashboard in the Partner Center, select under Commercial Marketplace the options Analyze > use out.

"Usage" dashboard

In the dashboard use in the menu Analyze the current orders for all your SaaS (Software-as-a-Service) offers are displayed. You can view graphical representations of the following items:

  • Usage trend
  • Normalized usage according to offers
  • Normalized usage according to other dimensions: VM size, sales channels and offer types
  • Usage according to geography
  • Table with detailed usage data
  • Filters for the "Orders" page

Note

The maximum latency between generation of usage events and reporting in the Partner Center is 48 hours.

Elements of the "Usage" dashboard

The following sections describe how to use the Usage dashboard and how to read the data.

Month range

At the top right of each page you will find a month range selection. Customize the output of the charts on the page use by selecting a month range based on the last 6 or 12 months, or a custom month range with a maximum duration of 12 months. The standard month range (calculation period) is six months.

Usage trend

In this section you will find the total hours of use and a trend for all offers that were consumed by your customers during the selected calculation period. Metrics and growth trends are represented by a line chart. You can view the value for each month by pointing to the line on the graph. The percentage value specified under the usage metrics in the widget represents the percentage increase or decrease in the selected calculation period.

The usage hours can be represented in two ways: as normalized VM usage and as actual VM usage.

  • Normalized usage hours are defined as usage hours normalized to account for the number of VM cores ([number of VM cores] x [hours of raw data usage]). For VMs set as “SHAREDCORE”, the multiplier 1/6 (or 0.1666) is used for [number of VM cores].
  • Actual hours of use are defined as the amount of time (in hours) that VMs have been running.

Normalized usage according to offers

This section shows the total hours of use and a trend for your usage-based offerings in the Azure Marketplace. The chart for normalized usage by offerings is described below.

  • In the stacked column chart Normalized usage according to offers the hours for normalized usage are broken down according to the selected calculation period for the five top offers. The top five offers are shown in a chart, while the rest are grouped under the miscellaneous offers category.
  • The stacked column chart shows the growth trend for the selected date range by months. The monthly columns show the hours of use from the offers with the most hours of use for the respective month. The line chart shows the percentage growth trend on the secondary Y-axis.
  • You can select certain offers in the legend to only display these offers in the diagram.

You can select any offer and a maximum of three SKUs from that offer to see the usage trend for the offer and the selected SKUs by month.

Orders based on quotes and SKUs

In the diagram Orders based on quotes and SKUs the measures and trends of all offers are displayed. Please pay attention to the following:

  • The top offers are shown in the chart, while the rest are grouped under the miscellaneous offers category.
  • You can select certain offers in the legend to only display these offers in the diagram.
  • Hovering your mouse over a segment on the chart shows the number of orders and the percentage of that offer versus the total number of orders for all of your offers.
  • The Trend "orders according to offers" shows growth trends by month. The “Month” column shows the number of orders by offer name. The line diagram shows the percentage growth trend on the z-axis.

You can select any offer and a maximum of three SKUs from that offer to see the trend for the offer, SKUs, and seats by month.

Normalized usage according to other dimensions: VM size, sales channels and offer type

There are three tabs for the dimensions: VM Size, Sales Channel, and Offer Type. You can view the usage metrics and monthly trends for each of these dimensions.

Usage according to geography

The thermal image shows the total usage for the geography dimension for the selected calculation period. The brightness of the color on the card corresponds to a low to high number of customers. Select a record in the table to enlarge a country / region.

Please pay attention to the following:

  • You can pan around the map to see the exact location.
  • You can zoom in on a specific location.
  • The thermal image has an additional grid to show details about the number of customers or orders and the hours of normalized usage in a given location.
  • You can search and select a country or region in the grid to zoom in on the location on the map. To return to the original view, select the button on the map Home page out.

"Usage details" table

In the table Usage details displays a numbered list of the top 1,000 usage entries sorted by usage. Please pay attention to the following:

  • Every column in the grid can be sorted.
  • The data can be extracted to a TSV or CSV file if the number of entries is less than 1,000.
  • If the number of entries is over 1,000, the exported data is stored asynchronously on a download page that is available for the next 30 days.
  • Apply filters detailed usage data to show only the data that is of interest to you. Filter data by Country / Region, Sales Channel, Marketplace License Type, Usage Type, Offer Name, Offer Type, Free Trials, Marketplace Subscription ID, Customer ID, and Company Name.

Table 1: Dictionary with data terms

Column name on
user interface
Attribute namedefinitionColumn name in reports for
programmatic access
Marketplace Subscription IDMarketplace Subscription IDThe unique identifier (ID) associated with the Azure subscription that the customer used to purchase your offer in the commercial marketplace. Previously, ID was the Azure subscription GUID.MarketplaceSubscriptionId
MonthStartDateMonthly start dateThe monthly start date represents the month of purchase.MonthStartDate
Offer typeOffer typeThe type of offer in the commercial marketplaceOfferType
Azure license typeAzure license typeThe type of license agreement that customers use to purchase Azure. Also referred to as a "channel". Possible values ​​are:
  • Cloud solution provider
  • Enterprise
  • Enterprise through trading partners
  • Usage-based payment
  • AzureLicenseType
    Marketplace license typeMarketplace license typeThe billing method for the offer in the commercial marketplace. Possible values ​​are:
    • Billing via Azure
    • BYOL (Bring Your Own License)
    • Free
    • Microsoft as a trading partner
    MarketplaceLicenseType
    SKUSKUThe plan associated with the offerSKU
    Country of the customerCountry / Region of the customerThe name provided by the customer for the country or region. The country / region can be different from the country or region specified on a customer's Azure subscription.CustomerCountry
    Preview SKUPreview SKUThe value indicates whether you have marked the SKU as “preview”. The value is “Yes” if you have marked the SKU accordingly and only Azure subscriptions that you have authorized can deploy and use this image. The value is “No” if the SKU has not been defined as “Preview”.IsPreviewSKU
    SKU billing typeSKU billing typeThe billing type associated with each SKU in the listing. Possible values ​​are:SKUBillingType
    IsInternalMarked as obsoleteMarked as obsoleteMarked as obsolete
    Virtual machine sizeVM sizeFor VM-based offer types, this entity indicates the size of the VM that is associated with the SKU of the offer.VMSize
    Cloud instance nameCloud instance nameThe Microsoft cloud in which a virtual machine was deployed.CloudInstanceName
    ServicePlanNameMarked as obsoleteObsolete (same definition as "SKU")ServicePlanName
    Offer nameOffer nameThe name of the offer in the commercial marketplace.OfferName
    DeploymentMethodMarked as obsoleteObsolete (same definition as "Offer Type")DeploymentMethod
    Company name of the customerCompany name of the customerThe company name provided by the customer. The name can be different from what is specified in a customer's Azure subscription.CustomerCompanyName
    Usage dateUsage dateThe date that usage events were generated for usage-based resourcesUsageDate
    IsMultisolutionCorresponds to several solutionsIndicates whether the offer type includes multiple solutions.IsMultisolution
    New CustomerMarked as obsoleteMarked as obsoleteIsNewCustomer
    Core sizeCore sizeThe number of cores allocated to the VM-based offering.CoreSize
    Usage typeUsage typeIndicates whether the usage event associated with the offer is one of the following types:
    • Normalized usage
    • Actual usage
    • Usage-related fees
    UsageType
    Trial end dateTrial end dateThe date on which the trial period for the order ends or has ended.TrialEndDate
    Customer Currency (CC)Customer's currencyThe currency used by the customer for the transaction in the commercial marketplaceCustomerCurrencyCC
    Price (CC)priceThe unit price of the SKU, which is displayed in the customer's currencyPriceCC
    Payout currency (PC)Payout currencyThe publisher is paid for the usage events associated with the resource in the currency configured by the publisher.PayoutCurrencyPC
    Estimated Price (PC)Estimated priceThe unit price of the SKU in the currency configured by the publisherEstimatedPricePC
    Usage referenceUsage referenceA chained GUID used to link the usage report (in analytics for the commercial marketplace) to the payout transactions report. The usage reference is linked to “OrderId” and “LineItemId” in the report for payout transactions.UsageReference
    Usage unitUsage unitThe consumption unit assigned to the SKUUsageUnit
    Customer IDCustomer IDThe unique identifier assigned to a customer. A customer can have zero or more Azure Marketplace subscriptions.CustomerId
    Billing account IDBilling account IDThe identifier of the account for which the statement is generated. Arrange the Billing account ID to customerID to to link your payout transaction report with the customer, order and consumption reports.BillingAccountId
    Usage amountUsage amountThe total usage units consumed by the resource provided by the customer.
    These are based on the element "type of use". If the type of use z. For example, if the normalized usage is, then the usage amount corresponds to the normalized usage.
    UsageQuantity
    NormalizedUsageNormalized consumptionThe total units of normalized usage consumed by the resource provided by the customer.
    Normalized usage hours are defined as usage hours normalized to account for the number of VM cores ([number of VM cores] x [hours of raw data usage]). For VMs set as “SHAREDCORE”, the multiplier 1/6 (or 0.1666) is used for [number of VM cores].
    NormalizedUsage
    MeteredUsageMeasured usageThe total usage units consumed by the usage units configured with the offer provided by the customer.MeteredUsage
    RawUsageRaw useThe total units of actual usage consumed by the resource provided by the customer.
    Actual usage hours are defined as the amount of time, in units of use, that VMs have been running.
    RawUsage
    Estimated Extended Fees (CC)Estimated extended charges in customer currencyIndicates the fees associated with the usage. The column corresponds to the arithmetical product of the price (CC) and the amount used.EstimatedExtendedChargeCC
    Estimated Extended Fees (PC)Estimated extended fees in the payout currencyIndicates the fees associated with the usage. The column corresponds to the calculated product of the estimated price (PC) and the amount used.EstimatedExtended ChargePC
    Consumption unit IDConsumption unit IDIndicates the ID of the consumption unit for the offer.MeterId
    Anomaly detected by Partner CenterAnomaly detected by Partner CenterApplies to offers with custom consumption unit dimensions.
    Indicates whether the publisher has reported an over usage for the supply custom consumption unit dimension that Partner Center has flagged as an anomaly. The following values ​​are possible:
    • 0 (no anomaly)
    • 1 (anomaly)
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column through programmatic access, the value is NULL.
    PartnerCenterDetectedAnomaly
    Anomaly marked by the editorAnomaly marked by the editorApplies to offers with custom consumption unit dimensions.
    Indicates whether the publisher has confirmed the customer's excess usage for the supply's custom consumption unit dimension as an anomaly or no anomaly. Possible values ​​are:
    • 0 (marked as no anomaly by the publisher)
    • 1 (marked as an anomaly by the publisher)
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column through programmatic access, the value is NULL.
    PublisherMarkedAnomaly
    New reported usageNew reported usageApplies to offers with custom consumption unit dimensions.
    The customer overage usage for the custom consumption unit dimension of the offering identified as abnormal by the publisher. This field indicates the new excess usage reported by the publisher.
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column through programmatic access, the value is NULL.
    NewReportedUsage
    Action performed atAction performed atApplies to offers with custom consumption unit dimensions.
    Indicates the time when the publisher confirmed the customer's excess usage for the supply custom consumption unit dimension as an anomaly or no anomaly.
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column through programmatic access, the value is NULL.
    ActionTakenAt
    Action performed byAction performed byApplies to offers with custom consumption unit dimensions.
    Identifies the person who confirmed the customer's overage usage for the supply custom consumption unit dimension as an anomaly or not an anomaly.
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column through programmatic access, the value is NULL.
    ActionTakenBy
    Estimated Financial Impact (USD)Estimated financial impact in USDApplies to offers with custom consumption unit dimensions.
    When Partner Center flags a customer overage usage as abnormal for the supply custom consumption unit dimension, the field indicates the estimated financial impact (in USD) of the abnormal usage.
    If the publisher does not have offers with custom consumption unit dimensions and is exporting this column programmatically, the value is NULL.
    EstimatedFinancialImpactUSD

    Filter for the "Usage" page

    Filters for the page use are applied at the level of the Orders page. You can select one or more filters to render the diagram according to the desired display criteria and the desired data in the grid / export for usage / order data. Filters are applied to the data extracted for the range of months you selected in the upper right corner of the Usage page.

    The actual VM usage widgets and export report are similar to normalized VM usage except for the following differences:

    • Normalized usage hours are defined as usage hours normalized to account for the number of VM cores ([number of VM cores] x [hours of raw data usage]). For VMs set as “SHAREDCORE”, the multiplier 1/6 (or 0.1666) is used for [number of VM cores].
    • Actual usage hours are defined as the amount of time, in units of use, that VMs have been running.

    Usage based on timed billing

    On the tab Measured usage Usage information is displayed for offer types, with usage measured by the consumption unit dimension. The SaaS offer type is currently being exceeded. The tab contains graphical representations of excess trends for SaaS usage after metered billing:

    • Exceeding trend according to the consumption unit dimension: Shows the monthly excess trend for the selected consumption unit dimension of a supply. The X-axis represents the month and the Y-axis represents the usage amount of the excess. The unit of measurement of the user-defined consumption unit is also displayed on the Y-axis.

    • Exceeding trend by SKU: Shows the trend of the usage amount of the selected consumption unit dimension by SKUs / plans. The five top plans with the highest usage amount for the selected offer are displayed.

    • Exceeding trend according to customers: The customer leaderboard is a stacked list of customers with the most hours of use. These are in a Leaderboard and rated according to the highest usage of the user-defined consumption unit. Select a customer from the leaderboard to view the overrun trend in usage of a selected consumption unit dimension.

    If you have multiple offers that use custom consumption units, the metered billing usage report shows usage information for all offers according to their custom consumption unit dimensions.

    tip

    You can use the download icon in the upper right corner of a widget to download the data. You can provide feedback on any of the widgets by clicking the thumbs up or thumbs down icon.

    Next Steps

    Is this page helpful?