Data connector details
-
Category: Product Reviews
-
Connector Type: Standard
Description
Use the Ulta Beauty Reviews connector to retrieve and analyze customer feedback on items sold on Ulta.
Data limitations
This data connector works only with https://www.ulta.com, the US Ulta web site.
Ulta 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.
-
Field: Description
-
Ulta Product URL: On the Ulta Beauty 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.
crawler_time_stamp
-
Description: Returns the date and time when the record was crawled in numeric format.
-
Category: meta
-
Example: 1579728616938
DataSource
-
Description: Returns the data source of the review.
-
Category: meta
-
Example: Ulta
Date
-
Description: Returns the date and time of the review in numeric format.
-
Category: date index
-
Example: 1577109425162
HelpfulScore
-
Description: Returns the number of people who found the review helpful.
-
Category: meta
-
Example: 2
Location
-
Description: Returns the location of the reviewer.
-
Category: geo index
-
Example: Waterford lakes
NotHelpfulScore
-
Description: Returns the number of people who did not find the review helpful.
-
Category: meta
-
Example: 0
ProductID
-
Description: Returns the Ulta ID of the product reviewed.
-
Category: meta
-
Example: xlsImpprod14771083
ProductName
-
Description: Returns the Ulta product name of the product reviewed.
-
Category: meta
-
Example: Supersonic Hair Dryer
Rating
-
Description: Returns the number of stars out of five that the reviewer gives the product.
-
Category: KPI
-
Example: 5
Review
-
Description: Returns the free-form text of the review.
-
Category: text index
-
Example: At first I thought about the price but I decided to buy it for myself, Now Im in love super light, quick on drying my thick curly hair. Money well spend.
ReviewTitle
-
Description: Returns the title of the review.
-
Category: text index
-
Example: Love it ππππ
UserID
-
Description: Returns the identification number of the reviewer.
-
Category: user index
-
Example: 263752601
UserName
-
Description: Returns the name of the reviewer.
-
Category: user index
-
Example: Milie
VerifiedBuyer
-
Description: Returns a value indicating whether the reviewer is a verified purchaser of the product.
-
Category: meta
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.