Revenue dashboard in commercial marketplace analytics

This article provides information on the Revenue dashboard for commercial marketplace in Partner Center. The dashboard shows the insights around revenue, payout status, top offers, and top customers.

Use this report to understand your revenue information across customers, billing models, offer plans, and so on. It provides a unified view across entities and helps answer queries, such as:

• How much revenue was generated and what’s the payout status?
• Who are the top customers?
• What are the top revenue generating offers?
• What are the billing models and sales channels used?

This article explains how to access the revenue report, understand the purpose of the various widgets on the page, and how to download the exported revenue reports. To learn about your earnings and payouts, see Getting paid in Partner Center.

Revenue Dashboard

The Revenue dashboard displays the revenue for all your order purchases and offer consumption. The dashboard contains widgets for these themes:

• Gross revenue
• Revenue timeline
• Revenue breakup
• Revenue by offers
• Revenue by customers
• Geographical spread
• Details

Revenue dashboard filters

The page has different dashboard-level filters you can use to filter the Revenue data:

• Offer type
• Offer listing
• Billing model
• Payout status
• Offer name
• Payment instrument family
• Sales channel
• Multiparty

To select the filters, in the top-right of the page, select Filters.

Each filter is expandable with multiple options that you can select. Filter options are dynamic and based on the selected date range.

Gross revenue

This widget shows the gross billed revenue for the selected period and page filters. Distribution of gross revenue by payout status is shown in the cards: Sent, Upcoming, Unprocessed, and Collection in progress. It also shows the manual adjustment amount in selected period.

Use this widget to track the gross revenue and breakup based on payout status.

Click on Details link to view the customer and transaction information.

Note

“Collection in progress” card only shows the revenue generated by customers who don’t have Enterprise agreement with Microsoft. This amount becomes eligible for payout after the customer has cleared the invoice.

Revenue Timeline

This widget shows the timeline view of revenue eligible for payout so you can have an estimate of future payouts. It shows the revenue amount eligible for last payout and estimated eligible revenue in future payouts.

Click on View contributing transactions to get more details around the transactions considered in each payout.

Note

The page filters have no impact on the data shown in the Revenue timeline widget.

Revenue by payout status

This widget shows the monthly trend chart of revenue breakup by payout status. It helps you track the revenue trend and payout status of revenue generated in past months.

Revenue by billing model

This widget shows the monthly trend chart of revenue breakup by billing model. It helps you identify the monthly trend of revenue generated by subscription vs usage-based transactions.

Collection in progress: days overdue

This widget shows the breakup of collection in progress revenue amount by overdue days. It helps you track if your customers are clearing their invoice on time or they are at risk of getting defaulted.

Click on View contributing transactions to get more details around the overdue transactions.

Transactions

Order transactions and Usage transaction widgets show the insights for revenue generated by subscription and usage-based transactions respectively. It shows the breakup of total transactions by payout status. You can also view the respective revenue amount for each payout status.

Revenue by Offers

This widget shows the insights around revenue generated by your published offers. Default selection is All and the chart show the monthly trend of top three offers. Click on any offer to view further breakup of revenue by plans.

Revenue by customers

This widget shows the breakup of revenue by customers. It shows the distribution between Enterprise agreement customers and non-enterprise agreement customers. It also provides the monthly trend of revenue generated by these two types of customers. You can view the top revenue generating customers by selecting either Enterprise Agreement(EA) or Non-Enterprise Agreement (Non-EA) tabs.

Geographical spread

This widget shows the revenue breakup by country/region. You can use this widget to identify and track the top revenue generating regions.

Details

Important

To download the data in CSV, please use the Download data option, available at the top of the page.

The Details table displays a numbered list of the 1,000 top orders sorted by transaction month.

• Each column in the grid is sortable.
• To view revenue split across different statuses for a given PurchaseOrderID and LineItemID, expand the record.

Note

• The revenue is an estimate since it factors the exchange currency rates. It's displayed in transaction currency, US dollar, or partner preferred currency. Values are displayed as per the selected date range and page filters.

Revenue data dictionary

Column Name	Definition
MonthStartDate	The month for which the billing was done and PurchaseRecordID and LineItemId were generated
PurchaseRecordId	Identifier of a purchase item and relates to the customer invoice. Same as orderID in the Earning report.
LineItemId	Identifier of individual line item in customer's invoice. Same as LineItemID in the Earning report.
BillingId	The Billing ID of the enterprise customer
EarningId	Unique identifier of each earning in earning report. Same as EarningID in the earning report.
OfferType	Type of offer, such as SaaS, VM, and so on.
OfferId	Marketplace offer ID associated with the transaction.
OfferName	Display name of the offer
SKU	Plan associated with the offer.
PlanId	Identifier of plan associated with the offer. It was originally a number.
Revenue	Billed sales for any transaction done through commercial marketplace in transaction currency.
EstimatedRevenuePC	Estimated revenue reported in partner preferred currency.
EstimatedRevenueUSD	Estimated revenue reported in US dollars.
ExchangeRateDate	This date is used to calculate exchange rates for currency conversions.
ExchangeRatePC	Exchange rate used to convert revenue amount to partner preferred payout currency
ExchangeRateUSD	This exchange rate is used to convert transaction amount in USD
IncentiveRate	Incentive rate applied for transaction.
PayoutStatus	Payout status against the transaction. Possible values are Unprocessed, Upcoming, Uncollected, Sent.
PaymentSentDate	Date when payout is sent to the partner.
PaymentInstrumentType	Represents the instrument through which payment was sent to the partner.
PayoutCurrency	The partner preferred currency to receive payout. It's same as the lastpaymentcurrency column in the transaction history report.
SalesChannel	Represents the sales channel for the customer. It's the same as Azure License Type. - Enterprise agreement - Pay as You Go - Microsoft cloud agreement (GTM) - Cloud solution provider
BillingModel	Subscription or consumption-based billing model used for calculation of estimated revenue. It can have one of these two values. - UsageBased - SubscriptionBased
AssetId	An identifier for the software assets. Same as the AssetId in the orders report.
Quantity	Indicates billed quantity for transactions. This field represents the seats and site purchase count for subscription-based offers, and usage units for consumption-based offers.
Units	Indicates the unit for transaction. Possible values are: - Seats - Sites - Hours - NA
TrialDeployment	Denotes whether the offer was in trial deployment at the time of billing
ListPriceUSD	Publicly listed price of the offer plan in U.S Dollars
DiscountedPriceUSD	Discounted price of the offer plan in U.S Dollars.
TransactionAmountCC	Transaction amount in the original transaction currency. Refers to the transaction amount column in the transaction history report
TransactionAmountPC	Transaction amount in Partner preferred payout currency.
TransactionAmountUSD	Transaction amount in US dollars. Refers to the transaction currency USD column in the transaction history report
TransactionCurrency	Indicates the currency used in transaction by customer.
EarningAmountCC	Earnings amount in the original transaction currency
EarningAmountPC	Earnings amount in partner preferred payout currency
EarningAmountUSD	Earnings amount in USD
EarningCurrencyCode	Transaction currency code for earning.
EarningExchangeRatePC	Exchange rate used to convert earning amount to partner preferred payout currency
EstimatedPayoutMonth	Estimated month in which partner can receive the payout for this transaction.
TermStartDate	Start date of the order subscription term
TermEndDate	End date of the order subscription term
IsPrivatePlan	Flag to identify if it's a private plan. - 0 value indicates false. - 1 indicates true.
IsPrivateOffer	Flag to identify if it's a private offer. - 0 value indicates false. - 1 value indicates true.
PrivateOfferId	Private offer ID associated with the transaction.
PrivateOfferName	Private offer name associated with the transaction.
CustomerAdjustmentUSD	The price offered by the Channel partner to the billed customer in U.S Dollars. This value is empty for ISV partners, as only Channel partners can see the final adjusted price for the customer
IsInvoiced	Flag to identify if invoice is generated for the transaction. - 0 value indicates false. - 1 value indicates true.
InvoiceId	Indicates the unique identifier of invoice sent to customer
InvoiceDate	Indicates the date when invoice was generated
InvoiceDueDate	Indicates the payment due date mentioned in customer invoice
DaysUncollected	Indicates the overdue days if the payoutStatus is uncollected.
AdjustmentType	Indicates if this row is related to adjustment.
AdjustmentReasonCode	Indicates the reason for adjustment
BillingAccountId	Identifier of the account on which billing is generated. Map BillingAccountID to CustomerID to connect your Earnings Report with the Customer, Order, and Usage Reports.
CustomerId	The unique identifier assigned to a customer. A customer can have zero or more Azure Marketplace subscriptions. Same as CustomerID in the customers report.
CustomerName	Name of the customer
CustomerCompanyName	Name of the customer's company
CustomerEmail	The e-mail address provided by the end customer. This address could be different than the e-mail address in customer's Azure subscription.
CustomerCity	The city name provided by the customer
CustomerState	The state name provided by the customer
CustomerCountry	The country/region name provided by the customer. The country/region could be different than the country/region in a customer's Azure subscription.
CustomerPostalCode	The postal code provided by the bill-to customer
ResellerId	Indicates the unique identifier assigned to a reseller.
ResellerCompany	Name of the reseller's company
ResellerEmail	The e-mail address provided by the reseller.
ResellerCity	The city name provided by the reseller
ResellerState	The state name provided by the reseller
ResellerCountry	The country/region name provided by the reseller
ResellerPostalCode	The postal code provided by the reseller
MultiParty	Flag indicating whether a private offer transaction involved multi-parties. - 1 indicates that multi parties like ISV and channel partner were involved. - 0 indicates only ISV partner was involved
PartnerInfo	Represents SellerID and name of the partners involved in a Multiparty private offer transaction.
SalesNotes	Sales note added by an ISV or a Channel partner during private offer creation. An ISV can't view Channel Partner's Sales notes and vice versa.

Next steps

• For common questions about the revenue dashboard or commercial marketplace analytics, and for a comprehensive dictionary of data terms, see Commercial marketplace analytics Frequently Asked Questions.
• For information on payout statements, see Payout statements.
• For information on Payout schedules, see Payout schedules and processes.
• For Virtual Machine (VM) offers usage and metered billing metrics, see Usage dashboard in commercial marketplace analytics.
• For information about your orders in a graphical and downloadable format, see Orders dashboard in commercial marketplace analytics.
• For a list of your download requests over the last 30 days, see Downloads dashboard in commercial marketplace analytics.
• For an overview of analytics reports available in the commercial marketplace, see Access analytic reports for the commercial marketplace in Partner Center.