Yelp Reviews report building guide

Prev Next

Use the Yelp Reviews connector to check how many reviews and what kind of ratings a business on Yelp has received, and analyze reviews and ratings over time. Compare reviews and ratings across different businesses for competitive benchmarking.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Query types

To fetch this data, use the following settings in your reporting or visualization tool:

  • Reviews: Returns data for up to 100 of the most recent reviews for a business.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Browse ratings and review content

See the date, rating, full text, and link for each review. This data is useful for qualitative analysis of customer feedback and identifying recurring themes in what reviewers are saying.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Reviews

Dimensions

Date, Rating, Text, Link to review

Suggested visualization

Table

Understanding the data

  • Date: The date the review was published on Yelp.

  • Rating: The star rating given by the reviewer.

  • Text: The written content of the review.

  • Link to review: A direct URL to the review on Yelp.

Monitor average rating and review volume

See your overall average rating alongside the total number of reviews — a quick snapshot of your current reputation and the volume of feedback it's based on.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Reviews

Metrics

Average rating, Number of reviews

Suggested visualization

Table

Understanding the data

  • Average rating: The mean star rating across all reviews.

  • Number of reviews: The total number of reviews received.

Track average rating trends by month

See how your average rating and review volume have evolved month by month — useful for spotting whether sentiment is improving or declining and assessing the impact of business or service changes over time.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Query type

Reviews

Metrics

Average rating, Number of reviews

Dimensions

Year & Month

Suggested visualization

Time series chart

Understanding the data

  • Average rating: The mean star rating across reviews within the reporting period.

  • Number of reviews: The number of reviews received within the reporting period.

  • Year & Month: Splits results by month so you can track rating and volume trends over time.

More resources

You might also be interested in: