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

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.

Did this answer your question?