Marketplace Agreements and Renewals dataset
The Marketplace Agreements and Renewals dataset lists active, expired, renewed, and
cancelled agreements within 24 hours of signing, with offer details and subscriber,
reseller, and ISV relationships. AWS Marketplace delivers this dataset to the
marketplace_agreements_and_renewals folder in your bucket.
The following table lists the columns in the dataset.
Every row includes a row_type value of INSERT,
UPDATE, or DELETE, and a row_modified_date timestamp.
Apply rows to your copy of the data by key column, in order of
row_modified_date.
| Column name | Type | Description |
|---|---|---|
partner_aws_account_id (key column) |
string |
The AWS account ID of the partner (seller) account. |
product_title |
string |
The title of the product. |
product_id |
string |
The friendly unique identifier for the product. |
product_type |
string |
The type of the product. |
legacy_product_id |
string |
The legacy unique identifier for the product. |
offer_name |
string |
The seller-defined name of the offer. |
offer_id |
string |
The identifier for the offer that the buyer signed. |
offer_visibility |
string |
Whether the offer is a public, private, or an enterprise contract offer. |
agreement_id (key column) |
string |
A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product. |
agreement_start_date |
string |
The date timestamp in UTC when the customer's product subscription starts. This date can be different than the acceptance date if this is a future-dated agreement. |
agreement_end_date |
string |
The date in UTC when the contract expires. For metered or pay-as-you-go subscriptions, this date is set to January 1, 9999, 12:00 AM UTC. |
agreement_acceptance_date |
string |
The date timestamp in UTC when the customer subscribed to the product. |
agreement_type |
string |
The type of the agreement. |
agreement_intent |
string |
The intent of the agreement. |
previous_agreement_id |
string |
The identifier of the previous agreement, for a renewed or replaced agreement. |
next_agreement_id |
string |
The identifier of the next agreement, for a renewed or replaced agreement. |
previous_offer_id |
string |
The identifier of the previous offer, for a renewed or replaced agreement. |
next_offer_id |
string |
The identifier of the next offer, for a renewed or replaced agreement. |
next_agreement_id_acceptance_dates |
string |
The acceptance dates of the next agreement, for a renewed or replaced agreement. |
proposer_aws_account_id |
string |
The AWS account ID of the party that proposed the agreement. |
proposer_company_name |
string |
The company name of the party that proposed the agreement. |
subscriber_aws_account_id |
string |
The ID of the account that subscribed to the product. |
subscriber_company_name |
string |
The name of the account that subscribed to the product. |
subscriber_email_domain |
string |
The email domain associated with the account that subscribed to the product. For example, if the email address is abc@example.com, the entry is example.com. |
subscriber_city |
string |
The billing address city associated with the account that subscribed to the product. |
subscriber_state_or_region |
string |
The billing address state associated with the account that subscribed to the product. |
subscriber_country |
string |
The billing address country associated with the account that subscribed to the product. |
subscriber_postal_code |
string |
The billing address postal code associated with the account that subscribed to the product. |
resale_authorization_id |
string |
The unique identifier for a registered resale opportunity. |
resale_authorization_name |
string |
The unique name for a registered resale opportunity. |
resale_authorization_description |
string |
The description for a registered resale opportunity. |
resale_company_name |
string |
The name of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer. |
resale_aws_account_id |
string |
The ID of the account that purchased a product or service at wholesale cost from an ISV to resell to a customer. |
isv_company_name |
string |
The name of the product or service owner. |
isv_aws_account_id |
string |
The identifier of the product or service owner. |
estimated_agreement_value |
decimal(38,2) |
The estimated monetary value of the agreement. |
subscriber_encrypted_account_id |
string |
The encrypted identifier of the subscriber's account. |
currency_code |
string |
The currency of the transaction. For example, if the transaction is in U.S. dollars, the entry is USD. |
status |
string |
The current status of the agreement. |
accepted_term_types |
string |
The types of terms associated with and accepted by the acceptor during agreement creation. |
catalog |
string |
The catalog associated with the record. |
license_ids |
string |
The identifiers of the licenses associated with the agreement. |
offer_set_id |
string |
The identifier for the offer set associated with the offer. |
recipient_aws_account_id (key column) |
string |
The AWS account ID of the recipient of the data. |
row_type |
varchar(30) |
The change that this delivery records for the row. INSERT adds a new row, UPDATE replaces a changed row, and DELETE marks a row removed from the source. |
row_modified_date |
timestamp |
The UTC time of the last recorded change to the row. This is not the business date of the event. |