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.
| 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. |