Advanced Analytics Data Dictionary

The Advanced Analytics Data Dictionary provides an overview of the data available in each table within Recruit CRM. Use these tables to understand the fields available when creating reports, dashboards, and charts in Advanced Analytics.

This table contains detailed information about all Candidates created within Recruit CRM.

This table contains detailed information about all Contacts created within Recruit CRM.

This table contains detailed information about all Companies created within Recruit CRM.

This table contains detailed information about all Jobs created within Recruit CRM.

This table contains detailed information about all Deals created within Recruit CRM.

When multiple collaborators are involved, the deal value is split according to each collaborator's assigned percentage, with a separate row created for each collaborator. To count the unique number of deals accurately, use the DISTINCT() function instead of simply counting rows.

This table tracks candidates as they progress through the hiring stages for the jobs they are assigned to.

Since a candidate can move through multiple stages within a job, multiple rows may exist for the same candidate. Each row represents the candidate's specific hiring stage for a particular job.

This table contains information about all calls made within Recruit CRM.

This table contains information about all meetings created within Recruit CRM.

This table contains information about all notes created within Recruit CRM.

This table contains information about all tasks created within Recruit CRM.

This table contains detailed information about all Candidates pitched to Contacts and Companies within Recruit CRM.

This table contains information about team members, their roles, associated teams, and active status within Recruit CRM.

The Advanced Analytics Data Dictionary helps you understand the data available across Candidates, Contacts, Companies, Jobs, Deals, and other Recruit CRM tables. Use the relevant table to identify the fields you need when building reports, dashboards, and charts in Advanced Analytics.