Data connector details

  • Category: Product Reviews
  • Connector type: Standard

Description

Use the Walmart Reviews connector to retrieve and analyze customer feedback on items sold on Walmart.

Data flow

To get Walmart review data into the Stratifyd platform, it goes through a series of steps. As a Standard type data connector, you can find more information in the Standard section of the Data connector flow article.

Data Limitations

This data connector supports only the US Walmart web site.

Walmart does not impose limitations on the amount of data that you can pull, but for products with a lot of reviews, you may want to limit it yourself using the Comment Limit option or by narrowing the date range.

If you have issues with no data, try widening your date range on the second page of the wizard.

Input fields

When setting up the connector, provide the URL of the product or products for which you want to analyze customer reviews. 

  • Product URL (*required): On the Walmart web site, navigate to the product and from the address bar, copy the URL, then paste it into this field.
  • Add new search: To analyze multiple versions of the product or multiple products, click this as many times as needed to add more URLs.
  • Upload: Click to upload a file containing a list of product URLs. Takes a TXT file with one URL per line.
    (CSV is also acceptable, but it must have one URL per line.)
  • Comment Limit: To avoid going over Walmart's data restrictions, it is a good practice to set a limit on the number of comments returned.

You can change your date range on the second page of the wizard, or optionally Schedule data crawls to update your data stream periodically.

Data dictionary

This connector returns the following fields that you can use in analysis.

crawler_time_stamp

  • Description: Date and time on which the review was crawled.
  • Category: meta
  • Example: 1580251599779

DataSource

  • Description: Data source of the review.
  • Category: meta
  • Example: walmart

Date

  • Description: Date and time of the review.
  • Category: date index
  • Example: 1577750400000

DislikeCount

  • Description: Number of people who did not find the review helpful.
  • Category: meta
  • Example: 0

IsBuyer

  • Description: Value indicating whether the reviewer is a verified purchaser.
  • Category: meta

LikeCount

  • Description: Number of people who found the review helpful.
  • Category: meta
  • Example: 0

ProductID

  • Description: Walmart ID of the product reviewed. Note that this ID comes from the URL of the product rather than the Walmart # listed on the product page.
  • Category: meta
  • Example: 865355756

ProductName

  • Description: Name of the product reviewed.
  • Category: meta
  • Example: Bose SoundSport Free True Wireless Bluetooth Earbuds - Blue

ProductURL

Rating

  • Description: Reviewer's rating for the product.
  • Category: KPI
  • Example: 5

Reply

  • Description: Free-form text of any replies to the original review.
  • Category: text index

ReplyDate

  • Description: Date and time of any replies to the review in numeric format.
  • Category: date index

ReplyDepartment

  • Description: Name of the department providing a reply to the review.
  • Category: meta

Review

  • Description: Free-form text of the review.
  • Category: text index
  • Example: These are amazing! I can't say enough good things about them! From the sound quality to how well the fit into my ears and stay put. Every pair of headphones I've ever purchased usually just fall right out but these stay right in and when I'm running I don't have to adjust them or anything! I also love the changing case! It's not to big to I can take everywhere! I highly recommend!

ReviewRecommended

  • Description: Value indicating whether the reviewer recommends the product.
  • Category: KPI
  • Example: FALSE

ReviewSource

  • Description: Any external source of the comment, e.g. the product's web site.
  • Category: meta

ReviewTitle

  • Description: Title of the review.
  • Category: text index
  • Example: Amazing wireless headphones!

UserID

  • Description: Walmart's unique identifier for the reviewer.
  • Category: user index
  • Example: abf3f4360e08cd71caf3a93783ae6678

UserName

  • Description: Name of the reviewer.
  • Category: user index
  • Example: Samantha

Data

  • Description: Adds all output fields to a list visualization.

Did this answer your question?