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. The dashbaord helps to track expiring subscriptions to enable renewals.

To open the dashboard, start the AWS Marketplace Management Portal, choose Sales operations, then choose the Insights tab.

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.

Section 4: Subscription trends

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 [e-mail], 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.
Status	The current status of the agreement. Supported statuses include: Active – Some or all of the terms of the agreement are in force. Terminated – The agreement ended before its pre-agreed end date due to an AWS-initiated termination event. Most commonly a payment failure. Canceled – The acceptor chooses to end the agreement prior to its end date. Expired – The agreement ended on its pre-agreed end date. Replaced – The agreement was replaced using a replacement offer. Renewed – The agreement was renewed into a new agreement using functionality such as auto-renewal. Archived – The agreement has ended; The exact reason for its ending, Terminated, Canceled, or Expired, is not specified. Rolled back – The agreement revision has been rolled back because of an error. An earlier revision is now active. Only applicable to inactive agreement revisions. Superceded – The agreement revision is no longer active and another agreement revision is now active. Only applicable to inactive agreement revisions. Rolled back – The agreement revision has been rolled back because of an error. An earlier revision is now active. Only applicable to inactive agreement revisions.
Estimated agreement value	The estimated cost of the agreement otherwise known as "Total contract value" OR "Purchase amount". This applies to the following Product types: SaaS, Professional Services, and Server, and Contract or Annual pricing types.
Currency code	The offer pricing currency associated with the estimated cost of the agreement.
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.