Agreements and renewals dashboard - AWS Marketplace

Agreements and renewals dashboard

The agreements and renewals dashboard provides information about agreements and renewals within 24 hours of signing an agreement in AWS Marketplace. It helps to track expiring subscriptions to enable renewals. This dashboard can be accessed in the AWS Marketplace Management Portal Insights tab under Sales operations.

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.

Section 1: Controls

This section of the dashboard provides filters to refine your agreement and renewal dashboard data. You can select from the following filters.

Note

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

Control descriptions

Control name Description
Subscriber AWS account ID The ID of the account that subscribed to the product.
Subscriber company name The name of the account that subscribed to the product.
Offer ID The identifier for the offer that the buyer signed.
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.
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 software manufacturer (independent software vendor).

ISV AWS account ID

The account of the product or service owner.

ISV company name

The business name of the product or service owner.

Legacy product ID The legacy unique identifier for the software product.
Product title The title of the product.
Resale authorization ID

The ID of the resale authorization provided by the ISV to the channel partner.

Resale authorization name The name of the resale authorization provided by the ISV to the channel partner.
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.
Reseller company name The business name of the reseller account authorized to sell a software manufacturer's product.
Subscriber country The two-character country code associated with the account subscribed to the product.
Subscriber state or region The billing address state or region associated with the account subscribed to the product.
Subscriber city The billing address city associated with the account subscribed to the product.

Section 2: Select date category

This section of the dashboard provides filters to refine records based on the agreement end date, agreement ending period, or agreement start date for a specified date range. The filter selected within the select date category updates the data displayed in the metrics, trends, breakdowns, and granular data sections.

For information about recently signed agreements, you can filter by agreement start date. If you're interested in learning about agreement renewals, you can filter using the agreement end date.

Section 3: Metrics

This section of the dashboard displays a key performance indicator (KPI) to visualize a comparison of key agreement data. A KPI is displayed for the number of active agreements and number of ended agreements. You can update the date range by updating the date criteria in the Select date category field.

This section of the dashboard provides subscription 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 agreements. The agreement and renewal trends information is available at an aggregate level.

  • Subscription trends – Provides a snapshot of the number of active agreements and number of ended agreements based on the selected date aggregation filter and selected date category filter. To view subscription trends for agreement start dates, you can select Agreement start date in the Select date category filter. To view subscription trends for agreement end dates, select Agreement end date in the Select date category filter.

  • Renewal breakdowns – Provides a snapshot of renewals that have either ended or are about to end in a specific number of days. You can view renewal breakdowns for several time periods, such as agreements that ended one to 30 days ago, 31 to 60 days ago, or more than 60 days ago. You can also filter on agreements that are about to end in zero to 30 days, 31 to 60 days, and so on.

Section 5: Breakdowns

This section of the dashboard provides you with metrics for your business across company names for active subscribers, ISVs, and resellers. You can view the number of agreements IDs, ended agreement IDs, offer IDs, renewed agreement IDs, and subscribers.

Section 6: Granular data

This section of the dashboard shows granular data for agreements, offers, products, proposers of the agreement, subscribers, resale authorizations, resellers, and ISVs.

Note

For more information about how to export and download data from a QuickSight table, see Exporting data from visuals in the Amazon QuickSight User Guide.

Granular data descriptions

Column Description
Subscriber company name The name of the subscriber's company.
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 liu-jie@example.com, the entry is example.com.
Subscriber country The billing address country 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 city The billing address city 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.
Product title The title of the product.
Product ID The friendly unique identifier for the software product.
Legacy product ID The legacy unique identifier for the software product.
Offer name The seller-defined name of the offer.
Offer ID The identifier for the offer that the buyer signed.
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 start date The date that the customer's product subscription starts, formatted as MM-DD-YYYY. This date could be different than acceptance date if this is a future dated agreement.
Agreement acceptance date The date when the customer subscribed to the product, formatted as MM-DD-YYYY.
Agreement end date The date when the contract expires, formatted as MM-DD-YYYY. For metered/pay-as-you-go subscriptions, this date is set to JAN-1-9999.
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 opportunity.
Resale authorization name The unique name for a registered opportunity.
Resale authorization description The ISV-defined description for a registered opportunity.
CPPO flag Calculated field in Amazon QuickSight.
Agreement intent Populates if the current agreement was a renewal or upgrade of a previous agreement that’s provided in the previous agreement_id column. Possible values include:
  • Upgrade: For private offers, upgrade is a broad term for any modification (upgrade, downgrade, amend, expand, renew). For public offers, an upgrade is a specific agreement to change terms (use a different offer) resulting in a new agreement, and the specific agreement is archived.

  • Renew: For public offers only. When a renewal agreement has start date as the specific agreement's end date and the offer ID hasn't changed but the agreement ID changed. For example, agreement A has become agreement B.

  • Auto-renew: For public offers only. When a new agreement is created when current agreement ends. The buyer has auto-renew turned on.

  • New: The buyer has accepted the terms (using the offer) and subscribed to a new agreement.

Previous agreement ID Agreement reference if this agreement was renewed or upgraded.
Next agreement ID Agreement ID of the next agreement if the current agreement was renewed or upgraded.
Previous offer ID Offer ID associated with the previous agreements if current agreement was renewed or upgraded.
Next offer ID Offer ID associated with the next agreement if current agreement was renewed or upgraded.
Next agreement ID acceptance date(s) The date when the next agreement was accepted by the buyer.
Proposer AWS account ID The identifier of the product or service owner.
Proposer company name The business name of the product or service owner.
ISV AWS account ID The AWS identifier of the seller.
ISV company name The business name of the seller.
Agreement ends (in days) Calculated field in Quicksight. The number of days left for agreement to end from today.
Agreement ending period Calculated field in QuickSight. The time period within which the agreement will end.