Greenhouse Analytics data support
Support for the Greenhouse Analytics data product is provided by the Greenhouse team, and consists of:
- Self-service materials including FAQs, here on ZenDesk
- Email support via email@example.com
Documentation on data and reports:
- Greenhouse Analytics Redshift schema - please see posts tagged with "GH Analytics" in the Product Blog for the latest schema. Note: Schema files are best opened up with a text editor like Sublime (free) after you change the file extension from .txt to .sql.
- Guide to Greenhouse Analytics tables (last updated 2/2/17) – a guide to each Greenhouse Analytics data table
- Greenhouse Analytics data model – a simple visual illustration of how certain Greenhouse Analytics data tables relate to each other
- Greenhouse data guide (last updated 4/21/17) – a comparison of 1) data that exists in Greenhouse, 2) data that exists in Greenhouse Analytics, and 3) data that is accessible via the Harvest API
Thought leadership and best practices
- 5 Recruiting KPIs whitepaper – our recommendation on 5 KPIs to track at the highest level
- Greenhouse configuration best practices – a collection of best practices in using Greenhouse so that the data that is generated can be used more effectively to derive insights
Greenhouse Recruiting support
For any questions about Greenhouse Recruiting that DON'T relate to Greenhouse Analytics data, including support for the Harvest API please contact:
- Your Account Manager (if applicable) for strategic questions about Greenhouse and product requests for Greenhouse Recruiting
- Customer Support via in-app chat or firstname.lastname@example.org for usability questions, including for Greenhouse Recruiting reports
Amazon Redshift support
The Greenhouse Analytics data is stored in an Amazon Redshift cluster that is managed by the Greenhouse team. For a guide to connecting to Redshift, please refer to the Redshift documentation. The main methods are via a compatible business intelligence / analytics tool (see shortlist of official Redshift Business Intelligence Partners), a SQL query tool, psql, or programmatically via Java or .NET.
See technical requirements here.
If you have any questions about the analytics tool you are using—including error messages—they are best answered by the provider of your analytics tool.