Glassdoor Reviews data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: REVIEW

dataSourceName
Display name 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
reviews__advice
Display name Advice
Description Advice written for the management by the reviewer
Field type dimension
Data type string.text.value
reviews__avg_rating
Display name Average rating
Description Average overall rating of the reviews
Field type metric
Data type float.number.value
reviews__business_outlook
Display name Business outlook
Description Business outlook
Field type dimension
Data type string.text.value
reviews__career_opportunities_rating
Display name Average career opportunities rating
Description Average career opportunities rating
Field type metric
Data type float.number.value
reviews__ceo_approval
Display name CEO approval
Description CEO approval
Field type dimension
Data type string.text.value
reviews__compensation_and_benefits_rating
Display name Average compensation and benefits rating
Description Average compensation and benefits rating
Field type metric
Data type float.number.value
reviews__cons
Display name Cons
Description Cons of the reviewed company
Field type dimension
Data type string.text.value
reviews__culture_and_values_rating
Display name Average culture and values rating
Description Average culture and values rating
Field type metric
Data type float.number.value
reviews__diversity_and_inclusion_rating
Display name Average diversity and inclusion rating
Description Average diversity and inclusion rating
Field type metric
Data type float.number.value
reviews__is_current_job
Display name Current job
Description Whether it is the reviewers current job or not
Field type dimension
Data type bool
reviews__language
Display name Language
Description Language of the review
Field type dimension
Data type string.language.twolettercode
reviews__pros
Display name Pros
Description Pros of the reviewed company
Field type dimension
Data type string.text.value
reviews__recommend_to_a_friend
Display name Recommend to a friend
Description Recommend to a friend
Field type dimension
Data type string.text.value
reviews__review_date
Display name Review date
Description Date of the review
Field type dimension
Data type string.time.date
reviews__review_datetime
Display name Review date & time
Description Date & time of the review
Field type dimension
Data type string.time.datetime
reviews__review_id
Display name ID
Description ID of the review
Field type dimension
Data type string.text.value
reviews__review_location
Display name Location
Description Location of the review
Field type dimension
Data type string.geo.country
reviews__reviewer
Display name Reviewer occupation
Description Occupation of the reviewer
Field type dimension
Data type string.text.value
reviews__senior_management_rating
Display name Average senior management rating
Description Average senior management rating
Field type metric
Data type float.number.value
reviews__title
Display name Title
Description Title of the review
Field type dimension
Data type string.text.value
reviews__url
Display name Review link
Description A link to the review
Field type dimension
Data type string.text.url
reviews__work_life_balance_rating
Display name Average work life balance rating
Description Average Work life balance rating
Field type metric
Data type float.number.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date