Data dictionaryThirteen columns,
and what each one holds.
Taken from the header row of real run exports, identical across every one of them and identical to the column list the platform ships. The note underneath covers the types, which are the part that catches people out.
- query
- The product URL you submitted, repeated verbatim on every row that came from it. It is echoed exactly as you typed it rather than normalised, so it always matches your input list.
- product_name
- Intended for the product name shown alongside the review. Identify the listing from
item_id rather than from this column - that is the field derived from the URL you submitted. - item_id
- Walmart’s numeric item ID for the listing, taken from the product URL. The same item submitted under two different URL slugs yields the same ID, which makes this the column to join on.
- reviewer
- Who wrote the review, as Walmart publishes it - a display name rather than a full identity. There is no profile link and no contact detail.
- rating
- The star rating the reviewer gave. It arrives as text rather than as a number - cast it before you average.
- title
- The review headline. Walmart lets a shopper leave a comment without one, so it is not on every review.
- text
- The review body, verbatim and unprocessed.
- date
- When the review was posted, as a US-style month/day/year date -
5/20/2026. - verified_purchase
- Carries the text
Yes where Walmart marks the review a verified purchase. It is a flag on the row, not a filter applied to the export. - helpful_positive
- How many shoppers marked the review helpful. Text, like the rating.
- helpful_negative
- The other direction - how many marked it unhelpful. Written where the review has them.
- review_url
- Intended for a direct link to the individual review.
- position
- Where the review fell in the order it was collected for that query, counting from one. It arrives as a real number while the counts beside it arrive as text.