Yelp Reviews: Query setup guide

Supermetrics Support Site Team

Modified on: Wed, 28 Aug, 2024 at 12:53 PM

Once you’ve connected Supermetrics to Yelp Reviews, you’re ready to create your first query.

This guide will walk you through Yelp Reviews query setup for Google Sheets, Looker Studio (formerly Data Studio), and Excel.

Available fields

Connect Supermetrics to Yelp Reviews in Google Sheets.
Enter the Yelp Business ID in the Yelp Business ID field.
Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
Select Metrics.
Select Split by Dimensions.
You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
Click Get Data to Table to create your query and pull your data.

You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Google Sheets.

Connect Yelp Reviews to Supermetrics in Looker Studio.
Enter the Yelp Business ID in the Yelp Business ID field.
Under Dimension, select Dimensions.
Under Metric, select Metrics.
Select how to sort the data.
Select the Date range from the auto or custom options. If you choose a custom date range, click the arrow on the top-right hand side. Under a specific period, select a Start Date and End Date.

You can filter your data by selecting the field, condition, and value to filter by. Learn more about using filters.

Connect Supermetrics to Yelp Reviews in Excel.
Enter the Yelp Business ID in the Yelp Business ID field.
Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
Select Metrics.
Select Split by Dimensions.

You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
Click Get data to create your query and pull your data.

You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Excel.

If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
If you see errors relating to quotas, or “daily query quotas”, read this guide.