Keepa: Most-used fields#
The table below gives information about most-used fields that you can import from Keepa. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
CategoryID |
CategoryID |
The unique identifier for an Amazon product category. Used for looking up categories, filtering deals, and requesting best seller lists. |
metric |
Domain locale |
Domain locale |
The Amazon domain (e.g., US, UK, JP) where the product data is collected from. This is a common parameter across most API requests. |
dimension |
asin |
asin |
The Amazon Standard Identification Number, a 10-character alphanumeric identifier for products on Amazon. It is a primary key for product queries. |
dimension |
asinList |
asinList |
A list of ASINs, often associated with a seller’s storefront or a best-sellers list within a category. |
dimension |
author |
author |
The author of a book or similar product. This field can be used to filter products in a product search. |
dimension |
availabilityAmazon |
availabilityAmazon |
Indicates the availability status of a product directly from Amazon. This field can be used as a filter in product searches. |
metric |
binding |
binding |
The binding type of a book or publication (e.g., ‘Paperback’, ‘Hardcover’). This field can be used to filter products in a product search. |
dimension |
brand |
brand |
The brand name of the product. This field can be used to filter products in a product search. |
dimension |
buyBoxSellerIdHistory |
buyBoxSellerIdHistory |
A historical record of the seller IDs that have won the Buy Box for the product, available when requesting buy box data. |
dimension |
categories |
categories |
A collection of categories a product belongs to, used for general classification and navigation. |
dimension |
categoryId |
categoryId |
The unique identifier for an Amazon product category. Used for looking up categories, filtering deals, and requesting best seller lists. |
metric |
categoryTree |
categoryTree |
A hierarchical representation of the product’s categories on Amazon, typically showing the path from a root category to the specific product category. This can be constructed from category information provided by the API. |
dimension |
color |
color |
The color of the product. This field can be used to filter products in a product search. |
dimension |
deals |
deals |
Information about product deals, including products that recently changed prices and match specific search criteria. This is retrieved via the ‘deals’ API method. |
dimension |
domain locale |
domain locale |
The Amazon domain (e.g., US, UK, JP) where the product data is collected from. This is a common parameter across most API requests. |
dimension |
domainId |
domainId |
A numerical identifier for the Amazon domain (e.g., 1 for US). Used in deal parameters. |
metric |
eanList |
eanList |
A list of European Article Numbers (EANs) associated with the product. EANs can be used to identify products in queries. |
dimension |
edition |
edition |
The edition of a book or other published media. This field can be used to filter products in a product search. |
dimension |
fbaFees |
fbaFees |
dimension |
|
fbaFees.lastUpdate |
fbaFees.lastUpdate |
metric |
|
fbaFees.pickAndPackFee |
fbaFees.pickAndPackFee |
metric |
|
fbaFees.pickAndPackFeeTax |
fbaFees.pickAndPackFeeTax |
metric |
|
fbaFees.referralFeePercent |
fbaFees.referralFeePercent |
The percentage of the product’s selling price that Amazon charges as a referral fee for FBA products. |
metric |
fbaFees.storageFee |
fbaFees.storageFee |
metric |
|
fbaFees.storageFeeTax |
fbaFees.storageFeeTax |
metric |
|
format |
format |
The format of the product, e.g., ‘DVD’, ‘Blu-ray’, ‘Digital’. This field can be used to filter products in a product search. |
dimension |
gtinList |
gtinList |
A list of Global Trade Item Numbers (GTINs) associated with the product, which can include UPCs, EANs, and ISBNs. GTINs can be used to identify products in queries. |
dimension |
hasReviews |
hasReviews |
A boolean indicating whether the product has customer reviews. Can be used as a filter for deals and product searches. |
dimension |
hazardousMaterials |
hazardousMaterials |
A flag indicating if the product is classified as hazardous material. This corresponds to the ‘isHazMat’ field. |
dimension |
isAdultProduct |
isAdultProduct |
A boolean indicating whether the product is considered an adult-oriented product. This field can be used to filter products in a product search. |
dimension |
isEligibleForSuperSaverShipping |
isEligibleForSuperSaverShipping |
A boolean indicating whether the product is eligible for Super Saver Shipping. This field can be used to filter products in a product search. |
dimension |
isEligibleForTradeIn |
isEligibleForTradeIn |
A boolean indicating whether the product is eligible for Amazon’s Trade-In program. This field can be used to filter products in a product search. |
dimension |
isSNS |
isSNS |
A boolean indicating whether the product is eligible for Amazon’s Subscribe & Save program. This field can be used to filter products in a product search. |
dimension |
itemHeight |
itemHeight |
The height of the physical item, as provided by Amazon product data. Can be used as a filter in product searches. |
metric |
itemLength |
itemLength |
The length of the physical item, as provided by Amazon product data. Can be used as a filter in product searches. |
metric |
itemWeight |
itemWeight |
The weight of the physical item, as provided by Amazon product data. Can be used as a filter in product searches. |
metric |
itemWidth |
itemWidth |
The width of the physical item, as provided by Amazon product data. Can be used as a filter in product searches. |
metric |
languages |
languages |
The languages associated with the product, such as for books or media. This field can be used to filter products in a product search. |
dimension |
lastPriceChange |
lastPriceChange |
The timestamp of the most recent price change for the product. Available for various price types (e.g., Amazon, New, Used). This field can be used to filter products in a product search. |
metric |
lastRatingUpdate |
lastRatingUpdate |
The timestamp of the last update to the product’s customer rating. This field can be used to filter products in a product search. |
metric |
lastSoldUpdate |
lastSoldUpdate |
The timestamp of the last update to the product’s sales data, reflecting recent sales activity. While not a direct field, ‘SALES’ history is provided. |
metric |
lastUpdate |
lastUpdate |
The timestamp of the last time the product’s data was updated in the Keepa database. This field can be used to filter products in a product search. |
metric |
listedSince |
listedSince |
The date when the product was first listed on Amazon. This field can be used to filter products in a product search. |
metric |
liveOffersOrder |
liveOffersOrder |
An ordered list of indices pointing to the currently active offers for a product. |
dimension |
manufacturer |
manufacturer |
The manufacturer of the product. This field can be used to filter products in a product search. |
dimension |
model |
model |
The model number of the product. This field can be used to filter products in a product search. |
dimension |
newPriceIsMAP |
newPriceIsMAP |
A boolean indicating if the new price of the product is at the Minimum Advertised Price (MAP). This field can be used to filter products in a product search. |
dimension |
numberOfItems |
numberOfItems |
The total number of items included in a product package. This field can be used to filter products in a product search. |
metric |
numberOfPages |
numberOfPages |
The number of pages for books or similar publications. This field can be used to filter products in a product search. |
metric |
offers |
offers |
Detailed information about all available offers for a product, including price history for each offer. This data is retrieved by enabling the ‘offers’ parameter in product queries. |
dimension |
packageHeight |
packageHeight |
The height of the product’s package. This field can be used to filter products in a product search. |
metric |
packageLength |
packageLength |
The length of the product’s package. This field can be used to filter products in a product search. |
metric |
packageQuantity |
packageQuantity |
The quantity of units in the product’s package. This field can be used to filter products in a product search. |
metric |
packageWeight |
packageWeight |
The weight of the product’s package. This field can be used to filter products in a product search. |
metric |
packageWidth |
packageWidth |
The width of the product’s package. This field can be used to filter products in a product search. |
metric |
parentAsin |
parentAsin |
The ASIN of the parent product if the item is a variation (e.g., different size, color) of a main product listing. This corresponds to the ‘historicalParentASIN’ field in ProductParams. |
dimension |
parentAsinHistory |
parentAsinHistory |
A historical record of the parent ASINs associated with a product, useful for tracking product variations or bundles over time. The ‘historicalParentASIN’ field is available for filtering. |
dimension |
parentTitle |
parentTitle |
dimension |
|
partNumber |
partNumber |
The manufacturer’s part number for the product. This field can be used to filter products in a product search. |
dimension |
productGroup |
productGroup |
The general group the product belongs to, often a broader classification than category. This field can be used to filter products in a product search. |
dimension |
productType |
productType |
The specific type of product (e.g., ‘BOOK’, ‘VIDEO_GAME’). This field can be used to filter products in a product search. |
metric |
promotions |
promotions |
Information regarding ongoing promotions or deals for the product. This relates to the ‘deals’ API method. |
dimension |
publicationDate |
publicationDate |
The date when a book or similar publication was published. This field can be used to filter products in a product search. |
metric |
referralFeePercent |
referralFeePercent |
The percentage of the product’s selling price that Amazon charges as a referral fee. |
metric |
referralFeePercentage |
referralFeePercentage |
The percentage of the product’s selling price that Amazon charges as a referral fee. |
metric |
releaseDate |
releaseDate |
The official release date of the product. This field can be used to filter products in a product search. |
metric |
rootCategory |
rootCategory |
The highest-level category a product belongs to. This field can be used to filter products in a product search. |
metric |
salesRankReference |
salesRankReference |
The reference category for the product’s sales rank, indicating which category’s best-seller list the rank applies to. This field can be used to filter products in a product search. |
metric |
salesrank |
salesrank |
The product’s sales rank within its primary category, indicating its popularity. Historical sales rank data is available through product queries. |
metric |
salesrank_date |
salesrank_date |
The timestamp when the sales rank data was recorded. This is associated with the sales rank history. |
dimension |
size |
size |
The size of the product, such as clothing size or dimension. This field can be used to filter products in a product search. |
dimension |
stats |
stats |
Aggregated statistical data for the product, including current prices, min/max prices, and weighted mean values over a specified period. This is enabled via the ‘stats’ parameter in product queries. |
dimension |
timestamp |
timestamp |
A generic timestamp indicating when a particular data point was recorded. |
dimension |
title |
title |
The title of the product, as displayed on Amazon. This field can be used to filter products in a product search. |
dimension |
trackingSince |
trackingSince |
The date since Keepa started tracking the product’s data. This field can be used to filter products in a product search. |
metric |
type |
type |
The general type of the product, such as ‘BOOK’, ‘ELECTRONICS’, etc. This corresponds to the ‘productType’ field. |
dimension |
upcList |
upcList |
A list of Universal Product Codes (UPCs) associated with the product. UPCs can be used to identify products in queries. |
dimension |
variations |
variations |
Information about product variations (e.g., different sizes, colors) available for a single product listing. Can be restricted in best seller queries. |
dimension |