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

buyBoxEligibleOfferCounts

buyBoxEligibleOfferCounts

The number of offers eligible to win the Buy Box for a product, categorized by offer type (e.g., New FBA, Used FBM).

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

Represents the hierarchical structure of Amazon product categories to which a product belongs. This includes category IDs and their relationships.

dimension

color

color

The color of the product. This field can be used to filter products in a product search.

dimension

coupon

coupon

Information regarding coupons available for the product, including one-time absolute or percentage-based discounts and Subscribe & Save percentage discounts.

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

Container for various fees associated with Fulfillment by Amazon (FBA) services for the product.

dimension

fbaFees.lastUpdate

fbaFees.lastUpdate

The timestamp of the last update for the Fulfillment by Amazon (FBA) fee information.

metric

fbaFees.pickAndPackFee

fbaFees.pickAndPackFee

The fee charged by Amazon for picking and packing the product when fulfilled through FBA.

metric

fbaFees.pickAndPackFeeTax

fbaFees.pickAndPackFeeTax

This field represents the tax portion of the Fulfillment by Amazon (FBA) pick and pack fee for the product.

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

The fee charged by Amazon for storing the product in their fulfillment centers as part of FBA.

metric

fbaFees.storageFeeTax

fbaFees.storageFeeTax

This field represents the tax portion of the Fulfillment by Amazon (FBA) storage fee for the product.

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

images

images

A collection of images associated with the product.

dimension

ingredients

ingredients

Details about the active and special ingredients present in the product.

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

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

monthlySold

monthlySold

This field represents the estimated number of units of a product sold monthly on Amazon.

metric

monthlySoldHistory

monthlySoldHistory

This field provides a historical record of the estimated monthly sales for a product on Amazon.

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

The title of the parent product for items that are part of a variation family.

dimension

partNumber

partNumber

The manufacturer’s part number for the product. This field can be used to filter products in a product search.

dimension

primeDealEndTime

primeDealEndTime

The end time of a Prime-exclusive deal or Lightning Deal for the product.

metric

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 active promotions, discounts, or coupon offers available for the product.

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

salesRankDisplayGroup

salesRankDisplayGroup

This field provides the historical sales rank data for a product within its respective Amazon category.

dimension

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

salesRankReferenceHistory

salesRankReferenceHistory

Historical data of the product’s sales rank within its primary reference category on Amazon.

dimension

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