Usage dashboard

The Usage dashboard provides visualizations and fine-grained data for customers using SaaS and server usage-based products. AWS Marketplace sellers can use this dashboard to track customer consumption across usage-based products to make decisions on product support, pricing, conversion from public to private offers, and product discontinuation. This dashboard can be accessed in AWS Marketplace Management Portal on the Insights tab under Sales operations. It provides data from the last 6 months, which is a rolling window.

You can export and download data (as .csv or Microsoft Excel files) from any chart, graph, and table on the Amazon QuickSight dashboard. For more information, see Exporting data from visuals in the Amazon QuickSight User Guide.

Note

This dashboard displays usage for all the dimension keys specified at the time of the offer creation. For example, for Amazon Machine Image (AMI) products, dimension keys are instance types, and all instance types specified in the offer will be shown in this dashboard, even if they're priced at $0. To see product usage for a dimension that wasn't specified at the time of offer creation, consider republishing the product to include the dimension you need.

Refresh frequency of the usage dashboard

Dashboards are updated daily at 4 PM PST (midnight UTC). Note that the usage data is received from upstream data sources and may encounter delays, you can refer to the usage date and the usage reported date for clarity on when the usage occurred compared to when it was reported on the dashboard.

You can export and download data (as .csv or Microsoft Excel files) from any chart, graph, and table on the Amazon QuickSight dashboard. For more information, see Exporting data from visuals in the Amazon QuickSight User Guide.

For operational and financial processes, review the following topics.

Section 1: Controls

This section of the dashboard provides filters to refine your usage data. For example, you can select from the following filters.

Note

For more information about filtering, see Filtering data in Amazon QuickSight in the Amazon QuickSight User Guide.

Control descriptions

Control name	Description
End user company name	The name of the account that used the product.
End user AWS account ID	The ID of the account that used the product.
End user country	The two-character country code associated with the account that used the product.
Product title	The title of the product.
Product code	The existing entitlement product code used to meter the product. This value is also used to join data with a report, or to reference what's provided in the AWS Marketplace Metering Service.
Offer ID	The identifier for the offer that the buyer signed.
Offer visibility	Whether the offer is a public, private, or enterprise contract offer.
Agreement ID	A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product.
Dimension key	The resource type associated with the product usage. Dimension keys apply to SaaS and server usage-based products.
Subscriber company name	The name of the account that subscribed to the product.
Subscriber AWS account ID	The ID of the account that subscribed to the product.
Subscriber country	The two-character country code associated with the account subscribed to the product.
Reseller company name	The name of the reseller account authorized to sell a product manufacturer's product.
Reseller AWS account ID	The ID of the account that purchased a product or service at wholesale from an ISV to resell to a customer.
Resale authorization ID	The ID of the account that purchased a product or service at wholesale from an ISV to resell to a customer.
CPPO flag	A yes/no flag indicating whether an agreement was made using a channel partner private offer. If yes, the seller of record is the channel partner. If no, the seller of record is the product manufacturer (independent software vendor).

Section 2: Filters

This section of the dashboard provides filters to refine records based on the usage date. The values selected in these filters update the data displayed in the metrics, trends, breakdowns, and granular data sections. The default selection is to pull data for last 6 months usage.

Section 3: Metrics

This section of the dashboard displays a key performance indicator (KPI) to visualize metrics related to consumption: estimated usage units, customers with usage, and products with usage. You can update the date range by updating the usage date criteria in the filters section. Note that the key metrics display data for all unit types.

Section 4: Trends

This section of the dashboard provides usage trends for a specified date range. You can view the trends by a specified date aggregation, such as daily, month-over-month, quarter-over-quarter, or year-over-year to gain insight into usage. You can also select a usage unit type to view its usage trends graphically.

Section 5: Breakdowns

This section of the dashboard provides you with estimated usage metrics for your business across company names, product titles, dimension key and offer IDs for the unit type selected. You may also select the number of entries to view.

Section 6: Granular data

This section of the dashboard shows granular data for usage, offers, product, subscriber, payer, end user, resale authorizations, resellers, and independent software vendors (ISVs). Note that the granular data table displays data for all unit types.

Revenue should be considered estimated until billing is finalized at the end of the month. Usage-based invoices are presented to buyers on the second or third day of the following month for the previous month's usage (for example, customers metered for usage between 11/1 and 11/30 will be presented an invoice for the usage on 12/2 or 12/3). Metered usage may arrive to this dashboard several days after the actual usage date, so the usage date and usage reported dates may be different. This means you may need to visit the dashboard daily throughout the month for up-to-date tracking in the current month. For authoritative customer billing information, see the Billed revenue dashboard in the Financial operations tab.

Note

For more information about filtering, see Exporting data from visuals in the Amazon QuickSight User Guide.

Granular data descriptions

Column	Description
Usage date	The date of the customer's product consumption.
Usage reported date	The date the customer's product consumption is surfaced in the insights dashboard.
End user company name	The name of the account that used the product.
End user AWS account ID	The ID of the account that used the product.
End user email domain	The email domain associated with the account that used the product. For example, if the email address is [e-mail], the entry is example.com.
End user city	The city associated with the account that used the product.
End user state or region	The state or region associated with the account that used the product.
End user country	The two-character country code associated with the account that used the product.
End user postal code	The billing address postal code associated with the account that used the product.
Product title	The title of the product.
Legacy product ID	The legacy unique identifier for the product.
Product ID	The friendly unique identifier for the product.
Product code	The existing entitlement product code used to meter the product. This value is also used to join data with a report, or to reference what's provided in AWS Marketplace Metering Service.
Offer ID	The identifier for the offer that the buyer signed.
Offer name	The seller-defined name of the offer.
Offer visibility	Whether the offer is a public, private, or an enterprise contract offer.
Agreement ID	A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product.
Agreement acceptance date	The date time stamp in UTC when the customer subscribed to the product.
Agreement start date	The date timestamps in UTC when the customer's product subscription starts. This date could be different than acceptance date if this is a future dated agreement.
Agreement end date	The date in UTC when the contract expires. For metered/pay-as-you-go subscriptions, this date is set to Jan 1, 9999 12:00 AM.
Dimension key	The resource type associated with the product usage. Dimension keys apply for SaaS and server usage-based products.
Region	The region where the buyer deployed Amazon EC2 instances.
Estimated usage	The quantity of the usage recorded for the product.
Usage unit types	The unit type for which the usage is recorded.
Estimated revenue	The revenue from the product usage. Revenue should be considered estimated until billing is finalized at the end of the month. Usage-based invoices are presented to buyers on the second or third of the following month for the previous month's usage.
Currency	The currency of the transaction. For example, if the transaction is in U.S. dollars, the entry is USD.
Subscriber company name	The name of the account that subscribed to the product.
Subscriber AWS account ID	The ID of the account that subscribed to the product.
Subscriber email domain	The email domain associated with the account that subscribed to the product. For example, if the email address is [e-mail], the entry is example.com.
Subscriber city	The billing address city associated with the account that subscribed to the product.
Subscriber state or region	The billing address state associated with the account subscribed to the product.
Subscriber country	The billing address country associated with the account that subscribed to the product.
Subscriber postal code	The billing address postal code associated with the account that subscribed to the product.
Payer company name	The name of the account that paid for the product.
Payer AWS account ID	The ID of the account that paid for the product.
Payer email domain	The email domain associated with the account that paid for the product. For example, if the email address is [e-mail], the entry is example.com.
Payer city	The billing address city associated with the account that paid for the product.
Payer state or region	The billing address state associated with the account that paid for the product.
Payer country	The billing address country associated with the account that paid for the product.
Payer postal code	The billing address postal code associated with the account that paid for the product.
Reseller company name	The name of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer.
Reseller AWS account ID	The ID of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer.
Resale authorization ID	The unique identifier for a registered resale opportunity.
Resale authorization name	The unique name for a registered resale opportunity.
Resale authorization description	The description for a registered resale opportunity.
CPPO flag	A yes/no flag indicating whether an agreement was made using a channel partner private offer. If yes, the seller of record is the channel partner. If no, the seller of record is the product manufacturer (ISV).
ISV company name	The name of the product or service owner.
ISV AWS account ID	The identifier of the product or service owner.