Data connector details
-
Category: Product Reviews
-
Connector type: Standard
Description
Use the Kohl’s Reviews connector to retrieve and analyze customer feedback on items sold on https://www.kohls.com.
Data flow
To get Kohl’s 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 Kohl’s web site.
Kohl’s 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.
-
Kohl’s Product URL: On the Kohl’s 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: Kohl’s unique identifier for the reviewer.
-
Category: user index
-
Example: 881877827994919
crawler_time_stamp
-
Description: Date and time on which the review was crawled.
-
Category: meta
-
Example: 1580309570329
DataSource
-
Description: Data source of the review.
-
Category: meta
-
Example: Kohls
Date
-
Description: Date and time on which the review was created.
-
Category: date index
-
Example: 1577748134000
DislikeCount
-
Description: Number of people who did not find the review helpful.
-
Category: meta
-
Example: 0
IsRecommended
-
Description: Value indicating whether the reviewer recommends the product.
-
Category: KPI
-
Example: TRUE
LikeCount
-
Description: Number of people who found the review helpful.
-
Category: meta
-
Example: 0
LogoImageURL
-
Description: URL of the logo image.
-
Category: meta
-
Example: https://photos-us.bazaarvoice.com/photo/2/cGhvdG86YXR0cmlidXRpb25sb2dvMg/0d70698e-fd30-4a02-85d8-8af072afe9f8
PageURL
-
Description: URL of the product reviewed.
-
Category: meta
-
Example: https://www.kohls.com/product/prd-3262665/nest-hello-video-doorbell.jsp?skuid=50087745
ProductName
-
Description: Kohl’s product name of the product reviewed.
-
Category: meta
-
Example: Google Nest Hello Video Doorbell
QualityRating
-
Description: Number of stars out of five the reviewer gives the product for its quality.
-
Category: KPI
Rating
-
Description: Reviewer’s overall rating for the product.
-
Category: KPI
-
Example: 5
Reply
-
Description: Free-form text of any response to the review from the client vendor.
-
Category: text index
Review
-
Description: Free-form text of the review.
-
Category: text index
-
Example: Took me 30-45 to install with my home and Google Home Hub. Easy and wonderful. I accidentally deleted my home on google (due to my kids having separate accounts for their own rooms) and it’s been a headache to get all my smart items synced up again. Otherwise the Nest Hello is amazing. I love the different ringtones like Christmas and New Years.
ReviewPhotosURL
-
Description: URL of any photos attached to the review.
-
Category: meta
ReviewTitle
-
Description: Title of the review.
-
Category: text index
-
Example: Nest Hello exceeds expectations
SourceClient
-
Description: Source of the product.
-
Category: meta
-
Example: nest
StyleRating
-
Description: Number of stars out of five the reviewer gives the product for its style.
-
Category: KPI
UserAge
-
Description: Age range of the reviewer, if supplied.
-
Category: meta
UserGender
-
Description: Gender of the reviewer, if supplied.
-
Category: meta
UserName
-
Description: Reviewer’s name.
-
Category: user index
-
Example: SupermanOfHope
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.
Further questions?
We're here to help! Don't hesitate to contact us for further assistance via chat or submit a ticket!
Comments
0 comments
Please sign in to leave a comment.