Yelp Reviews fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Yelp Reviews data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

2 metrics37 dimensions

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REVIEWS

reviews__id
Field label ID
Description ID of the review
Field type dimension
Data type string.text.value
reviews__rating
Field label Rating
Description Rating of the review
Field type dimension
Data type int.number.value
reviews__reviewer
Field label Reviewer
Description Name of the reviewer
Field type dimension
Data type string.text.value
reviews__avatar
Field label Avatar
Description Avatar
Field type dimension
Data type string.text.url
reviews__text
Field label Text
Description Text written for the review
Field type dimension
Data type string.text.value
reviews__language
Field label Review language
Description Language of the review
Field type dimension
Data type string.geo.country.twolettercode
reviews__review_datetime
Field label Created at datetime
Description Date and time when review was written
Field type dimension
Data type string.time.datetime
reviews__review_date
Field label Created at date
Description Date when review was written
Field type dimension
Data type string.time.date
reviews__url
Field label Link to review
Description A link to the review
Field type dimension
Data type string.text.url
reviews__reply
Field label Reply
Description The replied text
Field type dimension
Data type string.text.value
reviews__reply_datetime
Field label Reply time
Description Date and time when reply was written
Field type dimension
Data type string.text.value
reviews__number_of_reviews
Field label Number of reviews
Description Number of reviews
Field type metric
Data type int.number.value
reviews__avg_rating
Field label Average rating
Description Average rating of the reviews
Field type metric
Data type float.number.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
reviews__year
Field label Year
Field type dimension
Data type string.time.year
reviews__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
reviews__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
reviews__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
reviews__month
Field label Month
Field type dimension
Data type string.time.month
reviews__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
reviews__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
reviews__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
reviews__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
reviews__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
reviews__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
reviews__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
reviews__date
Field label Date
Field type dimension
Data type string.time.date
reviews__atom
Field label Datetime
Field type dimension
Data type string.time.datetime