View a markdown version of this page

Marketplace Usage dataset - AWS Marketplace

Marketplace Usage dataset

The Marketplace Usage dataset provides usage records for SaaS and server usage-based products, by dimension key, Region, and product. Revenue is estimated until billing is finalized at the end of the month. AWS Marketplace delivers this dataset to the marketplace_daily_usage_report 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 Usage columns
Column name Type Description
internal_usage_line_item_id (key column) string The unique identifier of the usage line item.
partner_aws_account_id string The AWS account ID of the partner (seller) account.
end_user_aws_account_id string The ID of the account that used the product.
end_user_address_id string The address reference for the end user.
end_user_company_name string The name of the account that used the product.
end_user_email_domain string The email domain associated with the account that used the product. For example, if the email address is abc@example.com, the entry is example.com.
end_user_city string The city associated with the account that used the product.
end_user_state_or_region string The state or region associated with the account that used the product.
end_user_country string The two-character country code associated with the account that used the product.
end_user_postal_code string The billing address postal code associated with the account that used the product.
payer_aws_account_id string The ID of the account that paid for the product.
payer_address_id string The address reference for the payer.
payer_company_name string The name of the account that paid for the product.
payer_email_domain string The email domain associated with the account that paid for the product. For example, if the email address is abc@example.com, the entry is example.com.
payer_city string The billing address city associated with the account that paid for the product.
payer_state_or_region string The billing address state associated with the account that paid for the product.
payer_country string The billing address country associated with the account that paid for the product.
payer_postal_code string The billing address postal code associated with the account that paid for the product.
subscriber_aws_account_id string The ID of the account that subscribed to the product.
subscriber_address_id string The address reference for the subscriber.
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 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.
usage_date string The date of the customer's product consumption.
dimension_key string The resource type associated with the product usage. Dimension keys apply to SaaS and server usage-based products.
region string The Region where the buyer deployed Amazon Elastic Compute Cloud (Amazon EC2) instances.
usage_unit_types string The unit type for which the usage is recorded. For Agentic Commerce products, the quantity for the agentic_commerce_default dimension is in dollars: one unit equals USD 1.00 of quoted charges.
currency string The currency of the transaction. For example, if the transaction is in U.S. dollars, the entry is USD.
estimated_usage_units decimal(38,2) The quantity of the usage recorded for the product.
estimated_revenue decimal(38,2) The revenue from the product usage. Revenue should be considered estimated until billing is finalized at the end of the month.
product_id string The friendly unique identifier for the product.
legacy_product_id string The legacy unique identifier for the product.
product_title string The title of the product.
product_code string 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.
agreement_id string A unique agreement data feed reference for the agreement signed between a proposer and an accepter to start using a product.
agreement_revision string The revision number of the agreement.
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.
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.
offer_name string The seller-defined name of the offer.
cppo_flag string 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).
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_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.
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.
isv_aws_account_id string The identifier of the product or service owner.
isv_company_name string The name of the product or service owner.
usage_reported_date string The date the customer's product consumption is reported.
end_user_encrypted_account_id string The encrypted identifier of the end user's account.
payer_encrypted_account_id string The encrypted identifier of the payer's account.
subscriber_encrypted_account_id string The encrypted identifier of the subscriber's account.
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.
offer_set_id string The identifier for the offer set associated with the offer.
usage_rate_per_unit decimal(38,6) The usage rate per unit.
charge_item_description string The description of the charge.
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.