Customers dashboard in commercial marketplace analytics

This article provides information on the Customers dashboard in Partner Center. This dashboard displays information about your customers, including growth trends, presented in a graphical and downloadable format.

Note

For detailed definitions of analytics terminology, see Commercial marketplace analytics terminology and common questions.

Customers dashboard

The Customers dashboard displays data for customers who have acquired your offers. You can view graphical representations of the following items:

  • Active and churned customers’ trend
  • Customer growth trend including existing, new, and churned customers
  • Customers by orders and usage
  • Customers percentile
  • Customer type by orders and usage
  • Customers by geography
  • Customers details table
  • Customers page filters

Note

The maximum latency between customer acquisition and reporting in Partner Center is 48 hours.

Access the Customers dashboard

Note

The Partner Center workspaces view gives you a more efficient and productive user experience through logically grouped workspaces. To learn more about the workspaces view and how to turn it on, see Getting around Partner Center.

  1. Sign in to Partner Center.

  2. On the Home page, select the Insights tile.

    Illustrates the Insights tile on the Partner Center Home page.

  3. In the left menu, select Customers.

Elements of the Customers dashboard

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

Month range

You can find a month range selection at the top-right corner of each page. Customize the output of the Customers page graphs by selecting a month range based on the past 6, or 12 months, or by selecting a custom month range with a maximum duration of 12 months. The default month range (computation period) is six months.

Illustrates the month filters on the Customers page.

Note

All metrics in the visualization widgets and export reports honor the computation period selected by the user.

Active and churned customers’ trend

In this section, you will find your customers growth trend for the selected computation period. Metrics and growth trends are represented by a line chart and displays the value for each month by hovering over the line on the chart. The percentage value below Active customers in the widget represents the amount of growth during the selected computation period. For example, the following screenshot shows a growth of 0.92% for the selected computation period.

Illustrates the Customers widget on the Customers page.

There are three customer types: new, existing, and churned.

  • A new customer has acquired one or more of your offers for the first time within the selected month.
  • An existing customer has acquired one or more of your offers prior to the month selected.
  • A churned customer has canceled all offers previously purchased. Churned customers are represented in the negative axis in the Trend widget.

Customer growth trend including existing, new, and churned customers

In this section, you will find trend and count of all customers, including new, existing, and churned, with a month-by-month growth trend.

  • The line chart represents the overall customer growth percentages.
  • The month column represents the count of customers stacked by new, existing, and churned customers.
  • The churned customer count is displayed on the negative direction of the X-Axis.
  • You can select specific legend items to display more detailed views. For example, select new customers from the legend to display only new customers.
  • Hovering over a column in the chart displays details for that month only.

Illustrates the Customers trend widget on the Customers page.

Customers by orders/usage

The Customers by orders/usage chart has three tabs: Orders, Normalized usage, and Raw usage. Select the Orders tab to show order details.

Illustrates the Orders tab of the Customers by orders and usage widget on the Customers page.

Note the following:

  • The Leader board presents details of the customers ranked by order count. After selecting a customer, the customer details are presented in the adjoining “Details”, “Orders by SKUs” and “SKUs by Seats” sections.
  • The Customer profile details are displayed in this space when publishers are signed in with an owner role. If publishers are signed in with a contributor role, the details in this section will not be available.
  • The Orders by SKUs donut chart displays the breakdown of orders purchased for plans. The top five plans with the highest order count are displayed, while the rest of the orders are grouped under Rest all.
  • The SKUs by Seats donut chart displays the breakdown of seats ordered for plans. The top five plans with the highest seats are displayed, while the rest of the orders are grouped under Rest All.

You can also select the Normalized usage or Raw usage tab to view usage details.

  • The Leader board presents details of the customers ranked by usage hours count. After selecting a customer, the details of the customer are presented in the adjoining “Details”, “Normalized Usage by offers” and “Normalized Usage by virtual machine (VM) Size(s)” section.
  • The Customer profile details are displayed in this space when publishers are logged in with an owner role. If publishers are logged in with a contributor role, the details in this section will not be available.
  • The Normalized usage by Offers donut chart displays the breakdown of usage consumed by the offers. The top five plans with the highest usage count are displayed, while the rest of the offers are grouped under Rest All.
  • The Normalized usage by VM Size(s) donut chart displays the breakdown of usage consumed by different VM Size(s). The top five VM Sizes with the highest normalized usage are displayed, while the rest of the usage is grouped under Rest All.

Top customers percentile

The Top customers percentile chart has three tabs, "Orders," "Normalized usage," and "Raw usage." The top customer percentile is displayed along the x-axis, as determined by the number of orders. The y-axis displays the customer's order count. The secondary y-axis (line graph) displays the cumulative percentage of the total number of orders. You can display details by hovering over points along the line chart.

Illustrates the Orders tab of the Top Customer Percentile widget on the Customers page.

Customer type by orders and usage

The Orders/usage by customer type chart displays the number of orders, normalized usage, and raw usage hours split between new customers and existing customers; based on the selection of orders, normalized, and raw usage respectively in the chart.

This chart shows the following:

  • A new customer has acquired one or more of your offers or reported usage for the first time within the same calendar month (y-axis).
  • An existing customer has previously acquired an offer from you or reported usage prior to the calendar month reported (on the y-axis).

Illustrates the Orders tab of the Orders by Customer Type widget on the Customers page.

Customers by geography

For the selected computation period, the heatmap displays the total number of customers, and the percentage of newly added customers against geography dimension. The light to dark color on the map represents the low to high value of the customer count. Select a record in the table to zoom in on a country or region.

Illustrates the Orders tab of the Orders by geography widget on the Customers page.

Note the following:

  • You can move the map to view the exact location.
  • You can zoom into a specific location.
  • The heatmap has a supplementary grid to view the details of customer count, order count, normalized usage hours in the specific location.
  • You can search and select a country/region in the grid to zoom to the location in the map. Revert to the original view by selecting the Home button in the map.

Customer details table

The Customer details table displays a numbered list of the top 1,000 customers sorted by the date they first acquired one of your offers. You can expand a section by selecting the expansion icon in the details ribbon.

Note the following:

  • Customer personal information will only be available if the customer has provided consent. You can only view this information if you have signed in with an owner role level of permissions.
  • Each column in the grid is sortable.
  • The data can be extracted to a .CSV or .TSV file if the count of the records is less than 1,000.
  • If records number is more than 1,000, exported data will be asynchronously placed in a downloads page for the next 30 days.
  • Apply filters to the table to display only the data you are interested in. Filter data by Company name, Customer ID, Marketplace Subscription ID, Azure License Type, Date Acquired, Date Lost, Customer Email, Customer Country/Region/State/City/Zip, Customer Language, and so on.
  • When an offer is purchased by a protected customer, information in Customer Detailed Data will be masked (************).
  • Customer dimension details such as Company Name, Customer Name, and Customer Email are at an organization ID level, not at Azure Marketplace or Microsoft AppSource transaction level.

Table 1: Dictionary of data terms

Column name in
user interface
Attribute name Definition Column name in programmatic
access reports
Marketplace Subscription ID Marketplace Subscription ID The unique identifier associated with the Azure subscription the customer used to purchase your commercial marketplace offer. For infrastructure offers, this is the customer's Azure subscription GUID. For SaaS offers, this is shown as zeros since SaaS purchases do not require an Azure subscription. MarketplaceSubscriptionId
DateAcquired Date Acquired The first date the customer purchased any offer you published. DateAcquired
DateLost Date Lost The last date the customer canceled the last of all previously purchased offers. DateLost
Provider Name Provider Name The name of the provider involved in the relationship between Microsoft and the customer. If the customer is an Enterprise through Reseller, this will be the reseller. If a Cloud Solution Provider (CSP) is involved, this will be the CSP. ProviderName
Provider Email Provider Email The email address of the provider involved in the relationship between Microsoft and the customer. If the customer is an Enterprise through Reseller, this will be the reseller. If a Cloud Solution Provider (CSP) is involved, this will be the CSP. ProviderEmail
FirstName Customer First Name The first name provided by the customer. Name could be different than the name provided in a customer's Azure subscription. FirstName
LastName Customer Last Name The last name provided by the customer. Name could be different than the name provided in a customer's Azure subscription. LastName
Email Customer Email The e-mail address provided by the end customer. Email could be different than the e-mail address in a customer's Azure subscription. Email
Customer Company Name Customer Company Name The company name provided by the customer. Name could be different than the city in a customer's Azure subscription. CustomerCompany Name
CustomerCity Customer City The city name provided by the customer. City could be different than the city in a customer's Azure subscription. CustomerCity
Customer Postal Code Customer Postal Code The postal code provided by the customer. Code could be different than the postal code provided in a customer's Azure subscription. CustomerPostal Code
CustomerCommunicationCulture Customer Communication Language The language preferred by the customer for communication. CustomerCommunicationCulture
CustomerCountryRegion Customer Country/Region The country/region name provided by the customer. Country/region could be different than the country/region in a customer's Azure subscription. CustomerCountryRegion
AzureLicenseType Azure License Type The type of licensing agreement used by customers to purchase Azure. Also known as the channel. The possible values are:
  • Cloud Solution Provider
  • Enterprise
  • Enterprise through Reseller
  • Pay as You Go
AzureLicenseType
PromotionalCustomers Is Promotional Contact Opt In The value will let you know if the customer proactively opted in for promotional contact from publishers. At this time, we are not presenting the option to customers, so we have indicated "No" across the board. After this feature is deployed, we will start updating accordingly. PromotionalCustomers
CustomerState Customer State The state of residence provided by the customer. State could be different than the state provided in a customer's Azure subscription. CustomerState
CommerceRootCustomer Commerce Root Customer One Billing Account ID can be associated with multiple Customer IDs.
One combination of a Billing Account ID and a Customer ID can be associated with multiple commercial marketplace subscriptions.
The Commerce Root Customer signifies the name of the subscription’s customer.
CommerceRootCustomer
Customer ID Customer ID The unique identifier assigned to a customer. A customer may have zero or more Azure Marketplace subscriptions. CustomerId
Billing Account ID Billing Account ID The identifier of the account on which billing is generated. Map Billing Account ID to customerID to connect your Payout Transaction Report with the Customer, Order, and Usage Reports. BillingAccountId
Customer Type Customer Type The value of this field signifies the type of the customer. The possible values are:
  • individual
  • organization
CustomerType

Customers page filters

The Customers page filters are applied at the Customers page level. You can select multiple filters to render the chart for the criteria you choose to view and the data you want to see in the “Detailed orders data” grid / export. Filters are applied on the data extracted for the month range that you selected on the upper-right corner of the Customers page.

Tip

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

Next steps