Data connector details

  • Category: Product Reviews
  • Connector type: Standard

Description

Use the Home Depot connector to retrieve and analyze customer feedback on items sold at The Home Depot.

Data limitations

This data connector supports only the US Home Depot web site.

Home Depot does not impose limitations on the amount of data that you can pull, but for products with a very large number 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. 

  • Home Depot Product URL: On the Home Depot 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: 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 Following fields that you can use in analysis.

Cons

  • Description: Free-from text of any negative features of the product.
  • Category: text index

crawler_time_stamp

  • Description: Date and time on which the review was crawled in numeric format.
  • Category: meta
  • Example: 1580236780934

Date

  • Description: Date and time of the review in numeric format.
  • Category: date index
  • Example: 1577806869000

DislikeVotes

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

LikeVotes

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

ProductID

  • Description: Home Depot ID number of the product reviewed.
  • Category: meta
  • Example: 308604656

ProductName

  • Description: Home Depot product name of the product reviewed.
  • Category: meta
  • Example: 13 in. 20-Volt Max Lithium-Ion Cordless String Trimmer w/ (1) 4 Ah Battery and Charger

ProductURL

Pros

  • Description: Free-form text of any positive features of the product.
  • Category: text index

Quality

  • Description: Reviewer's quality rating of the product.
  • Category: KPI

Rating

  • Description: Reviewer's star rating of the product.
  • Category: KPI
  • Example: 4

Review

  • Description: Free-form text of the review.
  • Category: text index
  • Example: would have given 5 stars if not for line bump feed doesn't work so well.

ReviewTitle

  • Description: Title of the review.
  • Category: text index
  • Example: would have given 5 stars if not for line bump...

UserName

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

Value

  • Description: Reviewer's value rating of the product.
  • Category: KPI

Data

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

Did this answer your question?