How can we help you?

Greenhouse Analytics Schema Update - June 14th, 2019

We are making the following changes to the Greenhouse Analytics schema on June 28th, 2019! See below for a description. We will update this post with the newest schema when it is available.

This update allows customers with the Business Intelligence Connector to view data regarding different aspects of their job posts, including:

  • Whether EEOC questions are enabled for the job post.
  • Whether or not the job has been indexed to one of the free job boards offered in Greenhouse
  • A list of all job post questions for the job post

If you have any questions or comments, please direct them to analytics@greenhouse.io.

---

New column in the job_posts table:
      job_posts.eeoc_enabled (boolean)

New columns in the job_posts table:
     job_posts.indeed_feed (boolean)
     job_posts.linkedin_feed (boolean)
     job_posts.glassdoor_feed (boolean)

New table for job post questions:
CREATE TABLE job_post_questions (
     job_post_id (bigint)
     question (text)

 
 
schema_062819.txt (30 KB)