Data connector details

  • Category: Restaurant Reviews
  • Connector type: Standard

Description

Use the Yelp connector to retrieve and analyze customer feedback on businesses reviewed on Yelp.

Data limitations

Yelp does not impose limitations on the amount of data that you can pull, but for businesses 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 business or businesses for which you want to analyze customer reviews. 

  • Yelp Store URL: On the Yelp web site, navigate to the business and from the address bar, copy the URL, then paste it into this field.
  • Add new search: To analyze multiple locations of the business or multiple businesses, click this as many times as needed to add more URLs.
  • Upload: Click to upload a file containing a list of business 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.

CoolCount

  • Description: Number of people who marked the review as Cool.
  • Category: meta

crawler_time_stamp

  • Description: Date and time on which the review was crawled in numeric format.
  • Category: meta

CuisineServes

  • Description: Type of cuisine served.
  • Category: meta

DataSource

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

Date

  • Description: Date and time of the review in numeric format.
  • Category: date index

FeaturedFoodInfo

  • Description: Returns information on any featured menu items.
  • Category: meta

FunnyCount

  • Description: Number of people who marked the review as Funny.
  • Category: meta

OpeningYear

  • Description: Year the business first opened.
  • Category: meta

OwnerInfo

  • Description: Name and short biography of the business owner.
  • Category: meta

OwnerReply

  • Description: Free-form text of the owner's response to the review.
  • Category: text index

PriceRange

  • Description: Price range of the food or service.
  • Category: meta

Rating

  • Description: Reviewer's rating of the business.
  • Category: KPI

Reviews

  • Description: Free-form text of the review.
  • Category: text index

Services

  • Description: Returns any services offered by the business.
  • Category: meta

StoreCategory

  • Description: Yelp categories into which the business falls.
  • Category: meta

StoreHistory

  • Description: Business history as provided by the owner.
  • Category: meta

StoreName

  • Description: Name of the business.
  • Category: meta

StoreType

  • Description: Type of business.
  • Category: meta

UsefulCount

  • Description: Number of people who marked the review as Useful.
  • Category: meta

UserFriendCount

  • Description: Number of Yelp friends the reviewer has.
  • Category: meta

UserIcon

  • Description: URL to the reviewer's thumbnail image.
  • Category: meta

UserLocation

  • Description: Reviewer's city and state.
  • Category: geo index

UserName

  • Description: Name of the reviewer.
  • Category: user index

UserPhotoCount

  • Description: Total number of photos the reviewer has posted on Yelp.
  • Category: meta

UserReviewCount

  • Description: Total number of reviews the reviewer has posted on Yelp.
  • Category: meta

UserUrl

  • Description: Relative URL for the reviewer's details page on Yelp.
  • Category: meta

Data

  • Description: Adds all output fields to a list visualization.

Did this answer your question?