List of all the funnel stages a consideration entered and exited.
| Field Type | Field Name | Data Type | Definition |
| Dimension | applicationId | Text | Unique id of the application the record belongs to |
| Dimension | archivedDate | Datetime | Date when a consideration's pipeline stage was changed to Archive |
| Dimension | candidateName | Text | Name of the consideration applying for the posting |
| Dimension | candidateSignedDate | Datetime | Date candidated signed an offer |
| Dimension | considerationArchiveReason | Text | Reason why this consideration was archived |
| Dimension | considerationCreatedDate | Datetime | Date when this consideration was created |
| Dimension | Conversion Date | Datetime | If there is no stageEndedDate, use the Stage Started Date. (Helper dimension for more complex calculations) |
| Dimension | currentFunnelStage | Text | Pipeline segment of the stage which this consideration is currently set to |
| Dimension | currentStageName | Text | Name of the current stage of the consideration |
| Dimension | currentFunnelStageExclArchived | Text | Higher-level funnel stage name of the stage which this consideration is currently set to. If the consideration has been archived, will be set to Archived (compared to currentFunnelStage, which will be set to the last stage before Archived if the candidate was Archived). |
| Dimension | firstSource | Text | First of the sources entered for consideration source |
| Dimension | funnelStage | Text | A higher-level funnel stage name the candidate was in, at some point during this timespan |
| Dimension | stageName | Text | Name of a stage which this consideration was in, at some point during this timespan |
| Dimension | Hires & Pipeline Date Set | Boolean | If Hires & Pipeline Dates is between Start and End date selected on the dashboard, then True. Else, False. (Helper dimension for more complex calculations) |
| Dimension | Hires & Pipeline Dates | Datetime | If candidate was hired, use the candidateSignedDate (manualOfferUploadDate, if the candidate has not signed yet). If candidate was not hired, use stageEndedDate (Stage Started Date, if the candidate has not exited the stage yet. Helper dimension for more complex calculations) |
| Dimension | Historical Candidates in Stage | Text | Unique profile ids of candidates that were in a funnel stage at a previous point in time. Works in conjunction with Start and End date filters on dashboards. |
| Dimension | isHired | Boolean | True if the candidate was hired for this consideration, else False |
| Dimension | manualOfferUploadDate | Datetime | Date when a manual offer was uploaded to the consideration, null if an offer was sent through a partner intergration |
| Dimension | postingDepartment | Text | Department of the posting associated with this consideration |
| Dimension | postingHiringManager | Text | Hiring manager of the posting associated with this consideration |
| Dimension | postingId | Text | Unique id of the posting associated with this consideration |
| Dimension | postingLastClosed Date | Datetime | Date the posting was most recently closed, if a posting has been closed at least once |
| Dimension | postingLocation | Text | Location of the posting associated with this consideration |
| Dimension | postingOwnerName | Text | Owner of the posting associated with this consideration |
| Dimension | postingStatus | Text | Status of the posting associated with this consideration |
| Dimension | postingTeam | Text | Team of the posting associated with this consideration |
| Dimension | postingTitle | Text | Job title of the posting associated with this considertaion |
| Dimension | prevFunnelStage | Text | The name of the higher-level funnel stage the candidate was in before this stage |
| Dimension | profileCreatedDate | Datetime | Date when this profile was created |
| Dimension | profileId | Text | Unique id of the profile for the candidate this record belongs to |
| Dimension | profileLinks | Text | Comma-separated list of links associated with this candidate |
| Dimension | profileOwnerName | Text | Name of the owner of this candidate's profile |
| Dimension | reqId | Text | Unique id of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Code | Text | Requisition code for the job posting that this consideration applied to |
| Dimension | Requisition Department | Text | Department of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Hiring Manager | Text | Hiring manager of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Location | Text | Location of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Name | Text | Name of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Owner Name | Text | Owner of the requisition associated with the posting that this consideration applied to |
| Dimension | Requisition Team | Text | Team of the requisition associated with the posting that this consideration applied to |
| Dimension | State Started Date | Datetime | The date the consideration entered stageName (note: stageName may not be the same stage as currentStageName, because this table captures every stage a candidate was in during the recruitment process) |
| Dimension | stageEndedDate | Datetime | The date the consideration left stageName (note: stageName may not be the same stage as currentStageName, because this table captures every stage a candidate was in during the recruitment process) |
| Dimension | stageIndex | Numeric | Order of all the stages the candidate passed through during the recruitment process |
| Dimension | stageIsCurrent | Boolean | If the candidate is still in this stageName, then True. Else, False. |
| Dimension | wasOnsite | Boolean | True if the consideration reached the Onsite pipeline segment or further |
| Dimension | wasScreen | Boolean | True if the consideration reached the Screen pipeline segment or further |
| Measure | active candidates in progress | Numeric | Count of unique candidates in Onsite, Screen, or Offer stage relative to the selected time period (i.e relative to the start and end date selected on dashboard) |
| Measure | active candidates/ managers | Numeric | Average number of candidates in an "active" stage (screen, onsite or offer) per hiring manager during the time period selected. |
| Measure | active candidates/owner | Numeric | Average number of candidates in an "active" stage (screen, onsite or offer) per profile owner during the time period selected. |
| Measure | daysInStage | Numeric | Amount of time consideration was in this stage, defined as "stage ended date" - "stage started date". Only applies to considerations who left a stage. |
| Measure | Is hired/Total | Numeric | Count of profileIds where candidate was hired, divided by total count of profileIds |
| Measure | Screen to Onsite | Numeric | Count of candidates who were in Screen and made it to Onsite during the selected time period, divided by all candidates who made it to Screen during the selected time period. |
| Measure | stageSortRank | Numeric | Ranking of stageName by their order in Lever. Used to sort pipeline / funnel charts in order of occurence, instead of alphabetically. |
| Measure | Swap Measure | Numeric | Helper measure to toggle between candidates and days in stage on Pipeline dashboards. DO NOT USE. |
| Measure | TotalAppIdCount | Numeric | Count of unique profileIds |
| Measure | Total Leads | Numeric | Unique count of opportunities who were / or currently are in the lead pipeline during the time period selected |
| Measure | Total Onsites | Numeric | Unique count of opportunities who were / or currently are in an "onsite" stage during the time period selected |
| Measure | Total Screens | Numeric | Unique count of opportunities who were / or currently are in a "screening" stage during the time period selected |