Customer Dashboard in commercial marketplace analytics

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

To access the Customer dashboard, open the Analyze dashboard under Commercial Marketplace.

Note

For detailed definitions of analytics terminology, see Frequently asked questions and terminology for commercial marketplace analytics.

Customer dashboard

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

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

Customer summary

The Customer summary section displays a count of all customers, including new, existing, and churned, during the selected date range.

  • Total customers is defined as the count of all customers who have purchased your offer and have at least one order that has not been canceled.
  • Customer percentage of growth compared to the previous month is indicated by the number and upward indicator in green or downward indicator in red.
  • Growth trends are represented by bar graphs and will display the value for each month by hovering over the columns of the chart.

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.

Customer by geography

The Customer by geography chart shows the counts of all customers and customers acquired during the selected date range, which are mapped based on the Customer Country/Region. 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/region.

The heat-map displays the customer count and percentage by customer country/region. You can move the map to view the exact location and zoom into a specific location. This map has a supplemental grid that allows you to view the % of customers by location, as well as customers newly added to that location.

The Customer trends chart displays a 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 Y Axis.
  • You can select specific legend items to displayed more detailed views. For example, select new customers from the legend to only display new customers.
  • You can use the slider on the top of the chart to scroll right and left on the x-axis and focus on specific data points to view in more detail.
  • Hovering over a column of the chart will display details for only that month.

Customers by orders and usage

The Customers by orders/usage chart has three tabs, "orders," "normalized usage," and "raw usage." The top customer percentile is displayed along the x-axis, as determined by their 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.

As an example, see the chart below for normalized usage: The top 30th percentile of customers are contributing to 87% of the normalized usage cumulatively. The 30th percentile of customers are only contributing 1.57 million hours of usage.

Customers by plans

The Customers by plans/usage charts are described below.

  1. The Leader board presents details of the top 50 customers ranked by order count. After selecting a customer, the details of the customer are presented in sections 2, 3, and 4 of this leader board.
  2. 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.
  3. The Orders by plans 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'.
  4. The Seats by plans 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.

Orders and usage by customer type

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.

  • 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).

Customer details table

The Customer details table displays a numbered list of the top 1000 customers sorted by the date they first acquired one of your offers.

  • Customer personal information will only be available if the customer has provided consent. You can only view this information if you have logged in with an owner role level of permissions. Learn more about user roles and permissions.
  • Each column in the grid is sortable.
  • The data can be extracted to a TSV file if the count of the records is less than 1000.
  • If records number is over 1000, 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 AppSource transaction level.

Customer 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 'Detailed orders data' grid / export. Filters are applied on the data extracted for the data range you have selected on the top-right corner of the orders page.

Note

Detailed definitions for each of the fields in Customer grid, page filters, and their possible selections are located in the FAQ article noted below.

Next steps