Commercial marketplace analytics Frequently Asked Questions

This article addresses frequently asked questions about analytics messages in Partner Center.

General

Why am I unable to view my analytics data in Partner Center?

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

No data for your offers yet.

Why you may be seeing this message:

  • No acquisitions currently exist for your published offers in the commercial marketplace. This can mean that your offers are live in the commercial marketplace and customers are seeing your product listing pages, but customers haven't yet taken action to purchase and deploy them.
  • Your offer might be in the process of being published but isn't live yet. Only live offers can be acquired by customers. 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 may be listed as Contact Me, which are list-only offers and cannot be purchased by customers in the commercial marketplace. Although these offers generate leads and are shared with you, orders aren't created for these offers as they cannot be purchased. To check your offer listing type, go to the setup page for your offer.

I know I have analytics data, so why does the No Analytics Available message appear?

No data for your offers yet.

Why you might be seeing this message:

  • If you're receiving this message, it means you have analytics data but there isn't data for the computation period that you have selected. Select a different computation period or month range to view any data since 2010.
  • If you have selected one or more categories from the various dimensions in the filter selection, you may not have analytics data for the selection. Try resetting the filter or make different selections from the filter.

How do I enroll in the commercial marketplace?

There are two ways to create an account:

Where can I create a commercial marketplace offer?

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

I can't register and publish an offer using my personal email ID.

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

What roles are required to view commercial marketplace analytics?

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

Can I view ratings and review of my offers listed in the Office store?

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, IoT Edge Modules, and Software as a Service.

Why do I see daily adjustments to estimated charges in my usage report?

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 4th day of the month following use of the offer.

How do I get started with programmatic access to commercial marketplace analytics reports?

Can I create custom queries apart from the listed system queries?

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.

Revenue

Is estimated revenue the billed sales or amount invoiced to customers?

Estimated revenue is the amount billed to the customer who purchased an offer or consumed services.

What does Total revenue and Other revenue mean?

Total revenue represents the billed sales of purchases or consumption that have entries in the transaction history report. This represents the total billed sales for the following statuses only:

  • Sent
  • Unprocessed
  • Upcoming

You can find corresponding detailed earnings entries in the transaction history report.

There can be some revenue portion that is not yet processed by Microsoft and sent to partners. These revenue amounts are also not captured in the existing transaction history report. The Other revenue section brings visibility to this revenue portion.

What do different transaction statuses under “Total” mean?

This list defines the different transaction statuses under Total:

  • Sent: Represents the revenue portion for which earnings have been sent to the partners
  • Unprocessed: Represents the revenue portion for which earnings are in an unprocessed state
  • Upcoming: Represents the revenue portion for which earnings are in an upcoming state

What do different transaction statuses under “Others” mean?

This list defines the different transaction statuses under Others:

  • Uncollected: Represents the billed sales of an offer purchase or consumption for which a customer has not made full payment or has defaulted. This status represents a revenue portion yet to be collected from customers.
  • Unreconciled: Offer purchase or consumption with entries that cannot be reconciled between the revenue dashboard and the transaction history report are marked with the unreconciled status. It means that these entries have purchase record id and line-item id entries in the revenue dashboard but not in the transaction history report. status can occur for multiple reasons:
    • Estimated revenue is generated but earnings are not yet posted
    • Some issues with software systems
  • Rejected: The revenue for which payments or safe approval were rejected.
  • Reprocessed: The revenue was under-reprocessed due to various reasons. For example, invoice cancellation or safe approval cancellation, and so on.
  • Not eligible: The overall revenue for which a partner isn't eligible to receive pay outs. To learn more about eligibility, see Payout statements.

Is Purchase record id the same as Order id in the transaction history report?

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

How can I reconcile payout reports with orders, usage, and the customer report?

The revenue dashboard provides a unified view of all analytic and payout reports. All transactions in the dashboard and downloaded report represent an aggregated summary of billed sales, orders, usage, and payments. You can verify the entries across reports using a combination of Purchase record id and Order id key.

Why is customer information blank in many rows of the revenue report?

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.

Does customer name represent bill to account, the end-customer, or the reseller information?

Customer name represents the bill to account details. For individuals, the customer name will be the end-customer’s name. For a cloud service provider (CSP), the customer name will be the name of the CSP.

Is it possible to use an API to download data from the revenue dashboard?

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

How does the first-free month appear in the report?

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

Is there a suggested specific date for us to download the reports every month?

Yes. You can download the reports on the fourth day of each month to view accurate revenue figures for the offer purchases and consumption from the previous month.

Note

Revenue figures for subscription-based products are available in the same month of purchase.

Can the revenue dashboard show who is the end-user customer, the reseller, and the distributor?

You can use the Sales channel field to infer whether the customer was an end-customer or a cloud solution provider.

Do we have “ship-to” address information (country, state, city, zip code) in the revenue dashboard?

The download report has the billed to address of customers. In future, we plan to show “ship-to” address as well.

What does “Billed Month” refer to?

Billed Month refers to the order purchase month or the offer usage month for which the billing is done. For example, if a customer used a consumption or usage-based offer in the month of January, on the 4th of February you can download an accurate January-billed revenue report.

Why do I see a steep drop in estimated revenue trend for current month?

A blue dotted line in the revenue trend represents figures for the current month. The steep drop could be due to the open month for usage-based offers for which billed sales is not yet generated.

Can I sort the records in the customer leaderboard and the geographic spread widget?

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

How should I read growth percentage change for “Total” and “Others” estimated revenue?

The growth percentage change in the revenue dashboard is defined in a similar way to other reports. It's the percentage of change between the value at the end of the selected month range and the value at the beginning of the selected month range.

Why does the estimated revenue timeline not change for different month range selections?

This is expected because all figures for future months are shown for the unprocessed and upcoming revenues until date.

Where can I find my downloaded reports?

To find your downloaded reports, go to the CMP Analyze > Downloads section. The reports are available in .csv/.tsv format. To learn more about downloading reports, see Downloads dashboard in commercial marketplace analytics.

Can I apply filters to the report?

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

How can we reconcile this revenue report to the usage and transaction history report?

The primary purpose of the revenue dashboard is to enable partners to reconcile between billed sales, payouts, and analytics reports (such as orders, usage, and customers).

Use purchase record ID and line-item id in the revenue report as the unique identifier to match entities across transaction history, usage, and orders reports. See this information on the data dictionary.

What is the relationship between the timing of the revenue report and the usage report? If the revenue report is based on billing, would we compare the current month revenue report to the prior month usage or the current month usage?

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 4th of every month to verify accurate revenue figures for the customer's offer usage in the previous month.

What is the reporting logic for the revenue amount? Why are there are entries with revenue amounts but no transaction or earning amount?

The revenue dashboard contains information about billed sales. It may take some time for earnings to be realized due to the license agreement with the customer or the payment instrument used in the transaction.

The dashboard contains billed sales of all customer transactions, not necessarily those with entries on the transaction history report. The current transaction history report shows transactions for which earnings have been sent, are unprocessed. or are in upcoming status.

However, there can also be billed transactions with other statuses, such as uncollected, when a customer is yet to make a payment for their offer usage or purchase. See the Other statuses in the revenue dashboard.

How is the estimated payout month determined?

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

Next steps