Data connector details

  • Category: Voice of Employee
  • Connector type: Cached

Description

Use the Glassdoor Review connector to retrieve and analyze employee reviews of employers.

Data limitations

This data connector supports https://www.glassdoor.com.

Glassdoor does not impose limitations on the amount of data that you can pull, but for very large companies 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, you can filter your results by date.

  • Company Name: Type the name of the company you want to analyze, and then select it when it appears in the list of suggestions.
  • Comment Limit: Specify a limit on the number of reviews to return. You can also control this with data range and recurrence settings.
  • Data Source: Enter a descriptive name for the data stream so that you and other team members know exactly which data it contains.

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. 

cache_id

  • Description: Globally unique identifier of the cached record.
  • Category: meta
  • Example: 35d89816153c0486c2e2e83bdea2eb2a

ceo_approval

  • Description: Reviewer's selected value for approval of the CEO.
  • Category: KPI
  • Example: No Opinion (or Approve or Disapprove)

ceo_rating

  • Description: Reviewer's rating value for the CEO on a scale of 1 to 5. (Returns 0 if no value was provided.)
  • Category: KPI
  • Example: 0

comment_advice

  • Description: Free-form text of the reviewer's advice for the company's management.
  • Category: text index
  • Example: You've taken away every incentive for long term people to stay, losing the service based 401k was the last straw!

comment_business_outlook

  • Description: Reviewer's selected value for the business outlook.
  • Category: KPI
  • Example: Getting Worse

comment_career_opportunities_rating

  • Description: Reviewer's rating value for career opportunities at the company on a scale of 1 to 5.
  • Category: KPI
  • Example: 4

comment_compensation_and_benefits_rating

  • Description: Reviewer's rating value for compensation and benefits at the company on a scale of 1 to 5.
  • Category: KPI
  • Example: 4

comment_cons

  • Description: Free-form text of the reviewer's cons about the company.
  • Category: text index
  • Example: Cost cutting, not sure they're going to get through a major downturn caused by 6 losing projects. There's a salary freeze in effect. Also froze pension in 2015 and now they took away service based 401K.

comment_culture_and_values_rating

  • Description: Reviewer's rating value for culture and values at the company on a scale of 1 to 5.
  • Category: KPI
  • Example: 3

comment_current_job

  • Description: Value indicating whether this is the reviewer's current job.
  • Category: meta
  • Example: TRUE

comment_employment_status

  • Description: Reviewer's selected value for their employment status at the company.
  • Category: meta
  • Example: full-time

comment_headline

  • Description: Title of the review.
  • Category: text index
  • Example: Will we stay in business or be sold?

comment_helpful_count

  • Description: Number of people who found this review helpful.
  • Category: meta
  • Example: 7

comment_is_featured_review

  • Description: Value indicating whether this is a featured review.
  • Category: meta
  • Example: FALSE

comment_job_information

  • Description: Reviewer's selected value for their job information at the company.
  • Category: meta
  • Example: I have been working at The Babcock & Wilcox Company full-time (more than 10 years)

comment_job_title

  • Description: Reviewer's job title at the company.
  • Category: meta
  • Example: Rather Not Say

comment_length_of_employment

  • Description: Reviewer's selected value for the length of employment at the company.
  • Category: meta
  • Example: for more than 10 years

comment_location

  • Description: Company location being reviewed.
  • Category: primary geo index
  • Example: Barberton, OH

comment_not_helpful_count

  • Description: Number of people who found this review unhelpful.
  • Category: meta
  • Example: 0

comment_overall

  • Description: Reviewer's selected value for their overall rating of the company.
  • Category: KPI
  • Example: Neutral ("OK")

comment_overall_numeric

  • Description: Reviewer's rating value for the company overall on a scale of 1 to 5.
  • Category: KPI
  • Example: 3

comment_pros

  • Description: Free-form text of the reviewer's pros about the company.
  • Category: text index
  • Example: Every other Friday off! Free Coffee and can wear jeans.

comment_recommend_to_friend

  • Description: Value indicating whether the reviewer would recommend the company to a friend.
  • Category: KPI
  • Example: FALSE

comment_senior_leadership_rating

  • Description: Reviewer's rating value for senior leadership at the company on a scale of 1 to 5.
  • Category: KPI
  • Example: 2

comment_url

comment_work_life_balance_rating

  • Description: Reviewer's rating value for work/life balance at the company on a scale of 1 to 5.
  • Category: KPI
  • Example: 5

crawler_time_stamp

  • Description: Date and time when the data was crawled in numeric format.
  • Category: meta
  • Example: 1559724457000

data_source

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

employer_addr

  • Description: Address of the company.
  • Category: geo index
  • Example: Barberton, OH

employer_icon

employer_id

  • Description: Numeric identification of the company on Glassdoor.
  • Category: meta
  • Example: 17786

employer_industry_id

  • Description: Numeric identification of the company's industry on Glassdoor.
  • Category: meta
  • Example: 200090

employer_industry_name

  • Description: Name of the industry to which the company belongs.
  • Category: meta
  • Example: Energy

employer_is_employer_rep

  • Description: Value indicating whether the reviewer is a representative of the company.
  • Category: meta
  • Example: FALSE

employer_is_open_company

  • Description: Value indicating whether the company is a member of Glassdoor's OpenCompany program for workplace transparency.
  • Category: meta
  • Example: FALSE

employer_name

  • Description: Name of the company.
  • Category: meta
  • Example: The Babcock & Wilcox Company

employer_rating

  • Description: Average of all of the reviewer's rating values for the company as an employer on a scale of 1 to 5.
  • Category: primary KPI
  • Example: 2.8

employer_rating_description

  • Description: Reviewer's selected value describing their rating of the company as an employer.
  • Category: KPI
  • Example: OK

employer_sector_id

  • Description: Numeric identification of the sector to which the company belongs.
  • Category: meta
  • Example: 10019

employer_sector_name

  • Description: Name of the sector to which the company belongs.
  • Category: meta
  • Example: Oil, Gas, Energy & Utilities

employer_website

  • Description: URL of the company's web site.
  • Category: meta
  • Example: www.babcock.com

save_time_stamp

  • Description: Date and time when the review was saved in numeric format.
  • Category: date index
  • Example: 1564568792000

time_stamp

  • Description: Date and time when the review was written in numeric format.
  • Category: primary date index
  • Example: 1548355095999

Data

  • Description: Returns all of the data collected by the connector.
Did this answer your question?