Data connector details

  • Category: Product Reviews
  • Connector type: Standard

Description

Use the Target Reviews connector to retrieve and analyze customer feedback on items sold on https://www.target.com.

Data limitations

This data connector supports only the US Target web site.

Target 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. 

  • Target Product URL: On the Target 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 returning too much data, 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.

AuthorID

  • Description: Unique identifier for the reviewer at Target.
  • Category: user index
  • Example: 3a236d05-3866-54b4-9b1f-89a8c44ce054

ComfortRating

  • Description: Reviewer’s star rating of the comfort of the product.
  • Category: KPI

crawler_time_stamp

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

DataSource

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

Date

  • Description: Date and time on which the product was reviewed.
  • Category: date index
  • Example: 1564761284000

ProductDescription

  • Description: Full description of the product.
  • Category: meta
  • Example: In a world where babies run everything, little rockers Rebel against nap time and Teacher's pets become class presidents with "free pizza Fridays!" In this world, all work is play and nothing is dull Cuz it's all a Lil' Surprising and outrageous! <br /><br />L.O.L Surprise! House is the ultimate hangout for L.O.L Surprise! Dolls. It's moving day! Unbox 85+ surprises to move the included, exclusive family into the L.O.L Surprise! House. Made from wood, 3 stories, 6 rooms, and a working elevator! The outside patio includes a real pool for cold water, hot tub for warm water and a sandbox for L.O.L Surprise! Pets. The first floor includes a living room with a real working lamp and kitchen with table, chairs and refrigerator. The 2nd floor includes a bedroom and bathroom. Bedroom Includes bunk beds and a bassinet. Bathroom features a toilet that makes flushing sounds and a bathtub with purple rain. The 3rd floor's massive walk-in closet includes a fashion rack with hangers for all your dolls' outfits and a vanity with working drawers for storage! Dolls can take the spiral staircase to the rooftop, which has a helipad and patio that changes from day to night!

ProductID

  • Description: Target identification number of the product.
  • Category: meta
  • Example: 53318535

ProductTitle

  • Description: Target product name of the product reviewed.
  • Category: meta
  • Example: L.O.L. Surprise! Real Wood House with 85+ Surprises

QualityRating

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

Rating

  • Description: Reviewer’s overall rating for the product.
  • Category: KPI
  • Example: 3

RatingRange

  • Description: Range of the ratings, for example, 5 stars.
  • Category: meta
  • Example: 5

Review

  • Description: Free-form text of the review.
  • Category: text index
  • Example: While putting this together I ran into several problems with the quality. First, the stickers for the floor, walls and ceilings are not lined up with the screw holes. Throughout the process I noticed that some of the holes weren't in the right places either. This makes the walls not one up with the floors, etc. No corner is even, there are gaps and overlaps everywhere. I had to fill and redrill one hole because the piece wouldn't even fit in. The stairs aren't even a little bit secure and the elevator is very hard to move up and down. The furniture pieces don't fit and stay together and the dolly's heads keep coming off. The reason I gave this 3 stars is solely because my kids love it so much. They haven't stopped playing with it in 4 days. They don't care about the shoddy craftsmanship so I figure that's worth something. [This review was collected as part of a promotion.]

ReviewTitle

  • Description: Title of the review.
  • Category: text index
  • Example: Quality only so-so but the kids love it

SizingRating

  • Description: Reviewer’s star rating of the size of the product.
  • Category: KPI

StyleRating

  • Description: Reviewer’s star rating of the style of the product.
  • Category: KPI

UserLocation

  • Description: Location of the reviewer, if supplied.
  • Category: geo index

UserName

  • Description: Reviewer’s name.
  • Category: user index
  • Example: Usacntrygirl

ValueRating

  • Description: Number of stars out of five the reviewer gives the product for its value for the price.
  • Category: KPI

Data

  • Description: Adds all output fields to a list visualization.
Did this answer your question?