Gem data export format/schema

Audience

External

Displayed Description

Page Type

Article

Data is provided in CSV format with the following schema:

event_log.csv
  Timestamp                  integer  * epoch seconds
  User Name                  text
  User Email                 text
  Candidate ID               integer
  Candidate ATS ID           text     * renamed from Candidate Greenhouse ID
  Candidate First Name       text
  Candidate Last Name        text
  Candidate Email            text
  Event Type                 text
  Event Subtype              text
  Event Metadata             text
  Event ID                   text     * new — Base64-encoded global ID

projects.csv
  Added Timestamp            integer  * epoch seconds
  Project ID                 integer
  Project Name               text
  Project Owner Name         text
  Project Owner Email        text
  Candidate ID               integer
  Candidate Greenhouse ID    text
  Candidate First Name       text
  Candidate Last Name        text
  Candidate Email            text
  Adding User Name           text
  Adding User Email          text

custom_field_data.csv
  Candidate ID               integer
  Candidate Greenhouse ID    text
  Candidate First Name       text
  Candidate Last Name        text
  Candidate Email            text
  (one column per custom field)  text

notes.csv
  Timestamp                  integer  * epoch seconds
  User Name                  text
  User Email                 text
  Candidate ID               integer
  Candidate Greenhouse ID    text
  Candidate First Name       text
  Candidate Last Name        text
  Candidate Email            text
  Note Content               text

candidate_info.csv
  Candidate ID               integer
  Candidate Greenhouse ID    text
  Candidate First Name       text
  Candidate Last Name        text
  Candidate Email (Primary)  text     * renamed from Candidate Email
  All Candidate Emails       text     * JSON array
  Candidate Phone Number     text
  Candidate Location         text
  Candidate Linkedin URL     text
  Candidate Company          text
  Candidate Title            text
  Candidate School           text
  Candidate Source           text
  Candidate ATS ID           text
  Sourced Timestamp          integer  * epoch seconds
  Sourced By User ID         text     * new

candidate_dei_data.csv
  Candidate ID               integer
  Candidate Greenhouse ID    text
  Sourced Timestamp          integer  * epoch seconds
  Candidate Predicted Gender           text
  Candidate Predicted Race/Ethnicity   text
  Candidate Manual Race/Ethnicity      text  * new

Possible values for the Event Type column of the event_log file:

First Outreach
Follow-up
Reply

Possible values for the Event Subtype column of the event_log file:

Email
Inmail
Phone Call
Text Message
Meeting

Possible values for the Event Metadata column of the event_log file:

Interested
Not Interested
Later

ℹ️

Any new columns added later will be added after existing columns.

Current limitations

One potential issue to be aware of when using CSVs is that they can have issues with handling the special characters that sometimes appear as part of the candidate dataset. If you experience errors when opening your exported CSV in Excel, please follow these steps:

Open a blank Excel workbook.
Go to the Data tab.
Select Get Data, then hover over From File and select From Text/CSV.
Select your exported file and set File Origin to 65001: Unicode (UTF-8).

Have any issues or questions on this topic? Please feel free to contact your dedicated Gem Customer Success Manager directly or our Support team at support@gem.com.