Data connector details
Category: Product Reviews
Connector type: Standard
Description
Use the Costco Review connector to retrieve and analyze customer feedback on items sold at Costco.
Data Limitations
This data connector supports only the US Costco web site.
The URL must end with [product_id].html, e.g. https://www.costco.com/.product.100502813.html
If you have issues with no data, try widening your date range on the second page of the wizard.
Costco 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.
Input fields
When setting up the connector, provide the URL of the product or products for which you want to analyze customer reviews.
-
Costco Item URL: On the Costco 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 returns the following fields that you can use in analysis.
_id
-
Description: Any additional ID that may be provided.
-
Category: meta
comment_content_locale
-
Description: Two-letter language and two-letter country code for the reviewer's comment.
-
Category: meta
-
Example: en_US
comment_helpfulness
-
Description: Percentage of people who reacted to the review that found it helpful, where 1.0 is 100%.
-
Category: KPI
-
Example: 0
comment_is_recommended
-
Description: Value indicating whether the reviewer recommends the comment.
-
Category: KPI
comment_rating
-
Description: Reviewer's rating for the product.
-
Category: KPI
-
Example: 5
comment_rating_range
-
Description: Rating scale, for example, 5.
-
Category: meta
-
Example: 5
comment_source_client
-
Description: Source of the review.
-
Category: meta
-
Example: costco
comment_title
-
Description: Free-form text title of the review.
-
Category: text index
-
Example: A little pricey but met our needs
comment_total_feedback_count
-
Description: Total number of people who reacted to the review.
-
Category: meta
-
Example: 0
comment_total_positive_feedback_count
-
Description: Number of people who reacted positively to the review.
-
Category: meta
-
Example: 0
context
-
Description: Free-form text of the review.
-
Category: text index
-
Example: The unit has certainly met expectations for a $400 purchase. Has warmed up a back bathroom area that does not receive a good flow from the central air. The cost to fix the air flow problem was quoted at 1500-6000 - so the $400 fix has been fine. I look forward to using it when the weather turns warm and we need a cool breeze. I really like it because you can set it and forget it. It is quiet and really does not seem to pose any fire threat like some of the other heaters. It is not too big and is fairly inconspicuous.
crawler_time_stamp
-
Description: Date and time on which the review was crawled.
-
Category: meta
-
Example: 1580249639757
data_source
-
Description: Data source of the review.
-
Category: meta
-
Example: costco
product_average_overall_rating
-
Description: Average rating for the product from all reviewers.
-
Category: KPI
-
Example: 4.4574780058651
product_brand
-
Description: Brand name of the product reviewed.
-
Category: meta
-
Example: Dyson
product_category_id
-
Description: Identification number of the Costco category of the product reviewed.
-
Category: meta
-
Example: 30196
product_description
-
Description: Costco description of the product reviewed.
-
Category: meta
-
Example: Item may be available in your local warehouse without a shipping charge
product_helpful_vote_count
-
Description: Number of reviewers for the product that selected "Yes, I recommend this product."
-
Category: KPI
-
Example: 1345
product_id
-
Description: Costco ID of the product reviewed.
-
Category: meta
-
Example: 100502813
product_name
-
Description: Name of the product reviewed.
-
Category: meta
-
Example: Dyson Pure Hot+Cool Link, Air Purifier, Heater & Fan, HP02
product_not_helpful_vote_count
-
Description: Number of reviewers for the product that selected "No, I do not recommend this product."
-
Category: KPI
-
Example: 322
product_overall_rating_average
-
Description: Average rating for the product
-
Category: KPI
-
Example: 5
product_page_url
-
Description: Costco URL of the product reviewed.
-
Category: meta
-
Example: http://www.costco.com//.product.100502813.html
product_rating_value_five
-
Description: Number of 5-star ratings for the product.
-
Category: KPI
-
Example: 491
product_rating_value_four
-
Description: Number of 4-star ratings for the product.
-
Category: KPI
-
Example: 96
product_rating_value_one
-
Description: Number of 1-star ratings for the product.
-
Category: KPI
-
Example: 31
product_rating_value_three
-
Description: Number of 3-star ratings for the product.
-
Category: KPI
-
Example: 42
product_rating_value_two
-
Description: Number of 2-star ratings for the product.
-
Category: KPI
-
Example: 22
product_ratings_only_review_count
-
Description: Number of reviews for the product that included only star ratings.
-
Category: meta
-
Example: 477
product_total_review_count
-
Description: Total number of reviews for the product.
-
Category: meta
-
Example: 682
time_stamp
-
Description: Date and time of the review.
-
Category: date index
-
Example: 1579305600000
user_id
-
Description: Costco's unique identifier for the reviewer.
-
Category: user index
-
Example: cf4dddda-782a-41c6-9a29-9ec21e48e2d8
user_location
-
Description: Reviewer's location.
-
Category: geo index
-
Example: Texas
user_name
-
Description: Name of the reviewer.
-
Category: user index
-
Example: DC Reed
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.