View a markdown version of this page

Marketplace Agreements and Renewals dataset - AWS Marketplace

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.

Marketplace Agreements and Renewals columns
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.