Commercial marketplace analytics Frequently Asked Questions

When I access the analytics pages, I see the following message.

Why you might be seeing this message:

• No acquisitions currently exist for your published offers in the commercial marketplace. This message could mean that your offers are live in the commercial marketplace, but customers didn't click on the offer.
• Your offer might be in the process of being published but isn't live yet. Customers can purchase only live offers. To check the status of your offers, see the Summary page in Partner Center. For more information, see Summary dashboard in commercial marketplace analytics.
• Your offers are listed as Contact Me, which are list-only offers. Customers can't purchase such offers directly through marketplace. You receive the lead when a customer clicks on Contact Me. To check your offer listing type, go to the setup page for your offer.

Why you might be seeing this message:

• You don't have analytics data for the select period, try selecting a different period.
• Check if you applied some filters on the page. Try resetting the filter or make different selections from the filter.

There are two ways to create an account:

• If you're new to Partner Center, then you must have a Microsoft AI Cloud Partner Program account, continue to Create a Partner Center account and enroll in the commercial marketplace.
• If you're already enrolled in the Microsoft AI Cloud Partner Program or a developer program, create an account directly from Partner Center. See Use an existing Partner Center account to enroll in the commercial marketplace.

1. Go to the commercial marketplace offers Overview page.
2. Select + New offer.
3. Select the type of offer to create.

Learn how to create, publish, and manage your offers, See Publishing guide by offer type.

To learn more about roles required to view commercial marketplace analytics reports, see Assign user roles and permissions.

No, currently we only provide ratings and reviews reporting to offers listed in the commercial marketplace program. For more information, see Ratings and Reviews dashboard for the commercial marketplace. Reviews and ratings of Office apps will be available soon.

Commercial marketplace offers are listed on Microsoft AppSource and Azure Marketplace. They include Azure applications, Azure containers, Azure virtual machines, Dynamics 365 apps on Dataverse and Power Apps, Dynamics 365 Operations Apps, Containers, and Software as a Service.

The billed charges for current customer usage in an open month can have adjustments due to things like discounts and refunds. The accurate estimated charges in the usage report are reflected on the fourth day of the month following use of the offer.

See Prerequisites to programmatically access analytics data.

Yes, the system queries are only for reference purposes. You can either use system queries or create a custom query by selectively querying on specific attributes.

Gross revenue is the amount billed to the customer who purchased an offer or consumed services. This amount is shown in customer invoice against the transaction.

This list defines the different payout status:

• Sent: Represents the revenue amount that is paid out to the partner.
• Upcoming: Represents the revenue amount that is eligible for upcoming payout. This amount moves to Sent state after the payout is processed.
• Unprocessed: Represents the revenue amount that is not yet picked up for processing. This amount is picked up in next cycle and move to Upcoming state.
• Collection in progress: Represents the revenue amount that is generated by non-EA customers who didn't clear their invoice. This amount move to Unprocessed state once the customer pays the invoice to Microsoft.

Revenue column shows the billed sales amount. This is shown in customer invoice. TransactionAmount column shows the amount that customers paid to Microsoft against the invoice. If the customer made partial payment, then Revenue and TransactionAmount could be different. EarningAmount column shows the amount that is considered for payout. This amount is calculated after deducting listing fees.

Yes, the Purchase record ID refers to the same “Order ID” data field.

Customer information such as email or customer name could be blank due to a customer not providing consent to share their personally identifiable information. In some cases, this could be due to a known technical limitation being addressed.

CustomerName column represent the end-customer's details. Refer the reseller related columns for reseller information.

Yes, customer related columns show the end-customer's details. Refer the Reseller related columns to get reseller information if a reseller was involved in the transaction.

Yes, the download report has details for end-customer. Refer the customer related columns like CustomerCity, CustomerState, CustomerCountry, CustomerPostalCode.

If a partner selects offer listing as “Free” as the dashboard filter, all offer purchases or consumption with free trial is displayed in the dashboard with revenue for the first month as $0.

Yes. You can download the reports on the Seventh day of each month to view accurate revenue figures for the offer purchases and consumption from the previous month. For example, if a customer used a consumption or usage-based offer in the month of January, on February 7, you can download an accurate January-billed revenue report.

MonthStartDate refers to the order purchase month or the offer usage month for which the revenue was calculated.

The steep drop could be due to the open month for usage-based offers for which revenue isn't yet generated.

Yes, you sort a column in the widget in ascending or descending order.

Revenue timeline view provides the eligible amount for last month and future month's payout. This widget doesn't change based on filters or period.

To download the reports, go to the Insights > Downloads Hub section. Click on Create new report and select Marketplace offers tile. You can now do the instant download or schedule a download. To learn more, see Downloads hub.

Yes. To learn about the analytics APIs, see Get started with programmatic access to analytics data.

Yes. You can use the dashboard filters to view the widgets on the dashboard based on the filtered criteria you choose.

To reconcile with Earnings report use purchaseRecordID, lineItemID, and EarningID in the revenue report as the unique identifier. See this information on the data dictionary.

Revenue report for current month captures the billed amount for previous month offer consumption or usage. You can download the revenue report on or after the seventh of every month to verify accurate revenue figures for the customer's offer usage in the previous month.

See the payout schedules for Enterprise agreement, Microsoft customer agreement, or CSP transactions at Payout schedules and processes.

This dashboard helps business teams understand customer behavior in terms of retention and churn after a customer has deployed your marketplace offer. Use it to answer questions like, “How many customers am I retaining, and for how long?” and “Compared to other offers in a category, are my retention numbers good or bad?”

Use the monthly tab to look at a group of users over a longer time frame. For example, if you run a promotional campaign in a certain month, you can see whether that month had higher retention than months when you didn't run the campaign.

Discover whether customers are continuing to use your VM offer over a period of time and whether they churn right away. When you identify which customers are churning, you can contact them or include them in a campaign.

Determine if your investments in marketing are working: the monthly view shows if months when you ran campaigns out-perform months when you didn't.

Read Retained customers in the Customer retention dashboard. The data shown here's a normalized view of 18 months of customer data, and so isn't “to” or “from” a specific date.

No. As the documentation indicates, it's a normalized view of 18 months of data. The retention heat map shows monthly views, but you can't filter to specific dates.

Total offers is how many there are in the entire category. For example, if you set the “category” filter to security, it's showing how many offers there are in the marketplace under the category Security. Offer count shows the count of offers in the category whose retention scores are above zero. So if you have the Category filter set to Security, the Y axis of the graph is showing how many offers in security have retention scores above 0.

The arrow shows the change in your retention rank. The time period is determined by the filter at the top; choose days, weeks, or months.

Customers shows this information.

Dormant means a customer hasn't used that offer for several days. They aren't labeled Churned because they could reengage and start using the offer again.

The best way to get that information is to download details from the orders or usage reports and cross-check based on a shared field: customer name.

Note the Cohort column. This tells you how many customers started using your offer in a month. If the column says 60 users in the cohort, then the percentage is calculated month-over-month by dividing the total number of users still using the offer by 60. If it's showing 35%, for example, that means 21 users are still using the offer. If the next month shows 40%, that means that three users came back (24/60). Retention percentages increase when users come back.

A Cohort is the number of customers who started using your offer in a given month.

A customer is one billing account ID.

No, you can only view one offer at a time.

No, you can only look at the offer level.

There's no quarterly filter. However, looking at the monthly view will help you see patterns over a quarterly time frame.

No, the only identifier available for these users would be email domain; we can't know with confidence whether or not they're internal to your company.

No, the functionality to filter only paid customers isn't available yet.

Next steps

• For an overview of analytics reports available in Partner Center, see Access analytics reports for the commercial marketplace in Partner Center.
• For information about your orders in a graphical and downloadable format, see Orders dashboard in commercial marketplace analytics.
• For Virtual Machine (VM) offers usage and metered billing metrics, see Usage dashboard in commercial marketplace analytics.
• For detailed information about your customers, including growth trends, see Customers dashboard in commercial marketplace analytics.
• For a list of your download requests over the last 30 days, see Downloads hub in commercial marketplace insights.
• To see a consolidated view of customer feedback for offers on Azure Marketplace and Microsoft AppSource, see Ratings & reviews analytics dashboard in Partner Center.