Keepa: Most-used fields

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