- query
- The ASIN or product URL you submitted, echoed on every row.
- position
- Where the product sat in the result set for that query.
- name
- The product title as published.
- asin
- Amazon's product identifier.
- price
- Price as displayed, with the currency symbol - e.g.
$788.49. - price_parsed
- The same price as a bare number, ready to compute with.
- currency
- Three-letter currency code, e.g.
USD or INR. - old_price
- The pre-discount price as displayed. Present on 27% of rows - only discounted listings carry it.
- old_price_parsed
- That pre-discount price as a bare number.
- strike_price
- The struck-through price shown on the listing. Tracks
old_price, at 27%. - rating
- Average star rating for the product. Present on 95% of rows.
- reviews
- How many reviews the product has. Present on 93% of rows.
- prime
- Whether the listing is Prime-eligible.
- bage
- The badge on the listing, e.g. a best-seller flag. Spelled this way in the export. Present on 25% of rows.
- image_1
- The main product image. Further image columns exist but fill on under 10% of rows.
- url
- The full product URL.
- short_url
- A shortened product URL.
- ref_url
- The referral-tagged URL for the listing.