| Available for | Roles | Super Admin |
| Permissions | • Access Visual Insights Report Builder (Data Explorer) | |
| Packages | LeverTRM for Enterprise, Advanced Analytics add-on LeverTRM for Enterprise or Advanced HR add-on for requisitions |
|
|
This article depicts and describes Lever's Opportunities Dataset Expansion, which will roll out in the Spring 2025 release. More information in our Spring release notes here: Spring release 2025 notes. |
Data fields are used to compose your dashboard charts in Visual Insights. The Data Explorer allows you to pull fields from a dataset into a chart that you can then filter and/or pivot to visualize the insights you wish to see. This article lists all data fields available in the Opportunities data set.
Read on to learn about the differences between the types and groups of data fields listed below. Given the large number of available data fields, we recommend using a keyword search on this webpage (Mac: ⌘ + F || Windows: Ctrl + F ) to locate fields in the data fields table.
For instructions on using the data fields in the 'Opportunities' data set to build custom charts, refer to our help article on how to use the Data Explorer to build custom charts.
Understanding data fields
Data fields are organized by type and group in the picker. There are also functional considerations to keep in mind when including specific data fields in a custom chart. This section provides an overview of data field types, groups, and functional considerations.
Types of data fields
There are three data field types you can select from when building a custom chart:
Dimensions
Dimensions are fields for non-aggregate data. Dimensions consist of a single data point.
Measures
Measures are fields for aggregate data, such as counts, sums, and averages.
Filter-only fields
Nearly all dimensions can also be used as filters. However, some fields can only be used as filters. These fields typically have logic related to advanced features.
Data field groups
In the 'Opportunities' data set, data fields are organized into the following groups:
- Requisition financials
- Common attributes
- Conditions
- Dates and durations
- People
- Other attributes
- Dynamic date formats
- Static date formats
- Filters
- Ids
- UTC stat date formats
- Offer fields by name
Functional considerations
Some data fields exhibit unique behaviour when added to a custom chart. Look for the following signifiers when adding data fields to understand how they will display in your chart:
Fan outs
If a data field has '(1:n)' appended to the end of its name, it means that field may result in a fan out when the report is run. A 'fan out' occurs when multiple results are returned for a single field. For example, suppose a 'Pipeline history (1:n)' data field is added to a chart visualized as a table. In that case, that field may yield multiple rows for a single opportunity (one for each stage it reached in the pipeline). To prevent the fanning out of multiple fields in a chart, try using 'Summary list' fields (see below).
Summary lists
If a data field has '(list)' appended to the end of its name, it means that if the field returns multiple results when the report is run, those results will be contained in a single cell as a comma-separated list. For example, if an 'Opportunity sources (list)' data field is added to a chart visualized as a table, opportunities with multiple sources will be listed in a single cell, with each source separated by a comma.
Hyperlinks
If a data field has '(hyperlink)' appended to the end of its name, it means that the results in this field will be clickable. Clicking the result will bring you to the corresponding item in your Lever environment. For example, if a 'Posting title (hyperlink)' field is added to a chart, clicking a posting title in the resulting chart will open that posting in Lever (in a new browser tab). User access permissions will be enforced when an item is clicked (i.e., if a user clicks the hyperlink for an item they do not have access to, Lever will prevent them from seeing it).
Data fields in the Opportunities data set
|
|
Fields from the Postings, Requisitions, and EEO fields can also be added as of the Spring 2025 release. Available fields TBA. |
| Opportunity | |
| DIMENSIONS | |
| Opportunity attributes | |
| Opportunity preferred location | The location preferred by the opportunity |
| Archive reason | The reason an opportunity is archived. |
| Opportunity archived by email | The email of who archived the opportunity |
| Opportunity archived by name | The name of who archived the opportunity |
| Opportunity owner email | The email of the recruiter/opportunity owner. |
| Opportunity owner name | The name of the recruiter/opportunity owner |
| Opportunity sourced by email | The email of who sourced the opportunity |
| Opportunity sourced by name | The name of who sourced the opportunity |
| Origin | The origin of an opportunity (agency, applied, internal, referred, sourced, university) |
| Opportunity conditions | |
| Is archived (yes/no) | An archived opportunity including if hired. True if archived date is not null. |
| Is archived non-hire (yes/no) | The opportunity is archived and is not hired |
| Is confidential (yes/no) | The posting associated with the opportunity is confidential |
| Is deleted (yes/no) | Is the opportunity deleted. This should be removed. |
| Is employee referral (yes/no) | Is this opportunity referred by an employee |
| Is hired (yes/no) | The opportunity has been archived as hired |
| Is in pipeline (yes/no) | The opportunity is not archived |
| Is manual referral (yes/no) | Indicates whether the opportunity is a manual referral. |
| Is opportunity active (Use Standard filter) | The opportunity is not archived or if archived, the archive/hire date (UTC) is greater than the start date of the date range. |
| Is referred (yes/no) | Indicates whether the opportunity is a referral. |
| Is snoozing (yes/No) | The opportunity is in a snooze state |
| Is social referral (yes/no) | Indicates whether the opportunity is a social referral. |
| Is sourced (yes/no) | The opportunity has an origin = sourced |
| Is stuck (yes/no) | The opportunity is stuck in the stage for longer than anticipated. |
| Opportunity has start date | Active opportunity that is in a stage that has an interview. Has a start date been determined. |
| Contact | |
| Applied at (UTC) | The create date of an application |
| Contact country | The residing country of the contact. |
| Contact country (map) | The residing country of the contact. In order to map it must be a valid ISO two or three letter country code or the full country name. |
| Contact is anonymized (yes/no) | Has this contact been anonymized. The contact name is NULL, blank or does not exist. |
| Contact location | The location of the contact associated with the opportunity |
| Contact name | The name of the opportunity. |
| Contact name anonymized | The contact name. If it has been anonymized (the contact name is NULL, blank or does not exist), 'Anonymized' is used as the name |
| Contact location | |
| Contact city | The location of the contact associated with the opportunity |
| Contact country | The location of the contact associated with the opportunity |
| Contact postal code | The postal code of the contact location |
| Contact region | The region of the contact location |
| Latitude | The location's latitude. |
| Location geometry | The geometry of the location. Useful for specialized exports. Currently format is for a point. May be simpler to use the latitude and longitude directly |
| Location geometry type | The type of geometry in location geometry. Currently always point. |
| Location is structured (yes/no) | Is the location geographically structured? Are latitude and longitude available? |
| Location source | The source of the contact information |
| Location updated by ID | The user id that updated the location |
| Location updated by email | The email of who updated the location. |
| Location updated by name | Who updated the location. |
| Longitude | The location's latitude. |
| Map UK postcode area | Place this field on a map visualization to produce a map based on UK postcode areas. Includes only locations where GB is the country. |
| Map US state | Place this field on a map visualization to produce a map based us states. Includes only locations where US is the country. |
| Map US zip | Place this field on a map visualization to produce a map based us zip codes. Includes only locations where US is the country. |
| Map country | Place this field on a map visualization to produce a map based on country code. |
| Map latitude-longitude | Place this field on a map visualization. |
| Pipeline current state | |
| Stage name | The current stage name sorted by rank of a non-archived opportunity in the pipeline. If the opportunity is archived, there is no value. |
| Archive stage has interview (yes/no) | The stage at which an opportunity is archived has interviews |
| Archived milestone | The milestone of the stage at which an opportunity is archived. |
| Archived pipeline | The pipeline of the stage at which an opportunity is archived. |
| Archived stage | The stage at which an opportunity is archived. |
| Current account stage ID | The account stage ID when the opportunity is not archived. If the opportunity is archived, there is no value. |
| Current pipeline name | The pipeline of the current stage. Sorted by rank. If the opportunity is archived, there is no value. |
| Current stage has interview (yes/no) | The current stage of a non-archived opportunity has interviews. If the opportunity is archived, there is no value. |
| Current stage milestone | The milestone of the current stage of a non-archived opportunity. If the opportunity is archived, there is no value. |
| Current stage name | The current stage name of a non-archived opportunity in the pipeline. If the opportunity is archived, there is no value. |
| Current stage pipeline | The pipeline of the current stage of a non-archived opportunity. If the opportunity is archived, there is no value. |
| Current stage rank | The rank of the current stage of a non-archived opportunity. If the opportunity is archived, there is no value. |
| Opportunity account stage ID | The account stage ID on the opportunity |
| Stage | The last stage of the opportunity. The opportunity may be archived or active in the pipeline. |
| Stage stuck days | The amount of time that an opportunity is expected to spend in a stage. If it exceeds this time, the opportunity is stuck. |
| Agency sources | |
| Agency name | The name of the agency. |
| Agency source name | The agency source name. |
| Source contact email | The email of the contact at the agency. |
| Source contact name | The name of the contact at the agency |
| Requisition used for hire | |
| Hired requisition active offers | The number of active offers of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition code | The requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition compensation band | The compensation band interval of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition compensation currency | The compensation currency of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition compensation max | The compensation band maximum of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition compensation min | The compensation band minimum of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition employment status | The employment status of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition headcount hired | The total hired of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition headcount total | The total number of headcount of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition internal notes | The first 500 characters of the description of the requisition that was used to hire the opportunity. The field is also known as internal notes. Until the opportunity is hired, this field is not populated. |
| Hired requisition name | The requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition status | The status of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition is backfill (yes/no) | The backfill of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition is confidential (yes/no) | The confidentiality of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition is infinite (yes/no) | The infinite headcount of the requisition that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Summary List | |
| Application sources (list) | The sources associated with an application |
| Candidate organizations (list) | A list of organizations of the contact associated with the opportunity. There are no null values. Use filter option 'is not blank' to see only those that are populated. When filtering, use filter option 'contains' to find specific list items. |
| Interviewers who provided feedback (list) | A list of interviewers who provided feedback |
| Opportunity completed stages (list) | The path the opportunity followed through the pipeline. When filtering, use filter option 'contains' to find specific list items. |
| Opportunity education (list) | The list of educational institutions associated with the opportunity. |
| Opportunity emails (list) | The list of emails associated with the opportunity. |
| Opportunity files (list) | The list of files associated with the opportunity. |
| Opportunity phones (list) | All phones numbers for the opportunity in a comma separated list |
| Opportunity sources (list) | All sources for the opportunity in a comma separated list |
| Opportunity tags (list) | All tags for the opportunity in a comma separated list |
| Opportunity web links (list) | The list of web links associated with the opportunity. |
| Referrer emails (list) | The emails(s) of the opportunity referrals. When filtering, use filter option 'contains' to find specific list items. |
| Referrer names (list) | The name(s) of the opportunity referrals. When filtering, use filter option 'contains' to find specific list items. |
| Duration | |
| Candidate time in current stage | The time from when opportunity entering the current stage until now when the opportunity is not archived. |
| Days in completed snooze | The number of days from when the completed snooze started until end. If there is an active snooze, zero is returned. |
| Days in current snooze | The number of days from the start of the active snooze until today. |
| Days in pipeline | The number of days from when the opportunity is created until archived. |
| Days in stage (Use Standard filter) | The number of days from when the opportunity is created until the lesser of archived/filter end. Opportunities must be active within the filter timeframe. If archived, the archive/hire date (UTC) is greater than the start date of the date range. |
| Days stuck | The number of days the opportunity is in the stage longer than anticipated time to exit. Only stages with a non-zero expected transit time are included. |
| Duration time to hire | |
| Contact create to hire | The duration from the contact create date to when the opportunity is archived as HIRED. |
| Contact create to offer signed | The duration from the contact create date to the first offer signed date. |
| Offer create to signing duration | The duration from the offer create date to the first offer signed date. |
| Opportunity create to hire | The number of days from when the opportunity is created until mark archived as hire. |
| Opportunity creation to offer signing | The time from the opportunity create date to the first offer signing date. |
| Posting applied to hired | The time from when the posting is applied to the opportunity to the hire date. |
| Posting applied to offer signed | The time from when a posting is applied to an opportunity until the first offer signed. |
| Posting creation to hired | The time from the posting creation to the hire date. |
| Archive or filter end (Use Standard filter) | |
| Archive or filter end date (UTC) | The lesser of the Stage filter end or archived date. |
| Archive or filter end seconds (UTC) | The lesser of the Stage filter end or archived date. |
| Contact created dates | |
| Contact create date | The create date of the contact associated with the opportunity. |
| Contact create hhmm | The create date of the contact associated with the opportunity. |
| Contact create millisecond | The create date of the contact associated with the opportunity. |
| Contact create week | The create date of the contact associated with the opportunity. |
| Contact create month | The create date of the contact associated with the opportunity. |
| Contact create quarter | The create date of the contact associated with the opportunity. |
| Contact create year | The create date of the contact associated with the opportunity. |
| Contact create date (UTC) | The create date of the contact associated with the opportunity. |
| Contact create hhmm (UTC) | The create date of the contact associated with the opportunity. |
| Contact create millisecond (UTC) | The create date of the contact associated with the opportunity. |
| Opportunity archived dates | |
| Opportunity archive date | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive hhmm | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive millisecond | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive second | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive week | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive month | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive quarter | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive year | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive date (UTC) | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive hhmm (UTC) | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive millisecond (UTC) | The opportunity archive date. All archives including archived as HIRED |
| Opportunity archive second (UTC) | The opportunity archive date. All archives including archived as HIRED |
| Opportunity created dates | |
| Opportunity create date | The create date of the opportunity. |
| Opportunity create hhmm | The create date of the opportunity. |
| Opportunity create millisecond | The create date of the opportunity. |
| Opportunity create second | The create date of the opportunity. |
| Opportunity create week | The create date of the opportunity. |
| Opportunity create month | The create date of the opportunity. |
| Opportunity create quarter | The create date of the opportunity. |
| Opportunity create year | The create date of the opportunity. |
| Opportunity create date (UTC) | The create date of the opportunity. |
| Opportunity create hhmm (UTC) | The create date of the opportunity. |
| Opportunity create millisecond (UTC) | Opportunity create |
| Opportunity create second (UTC) | The create date of the opportunity. |
| Opportunity entered current stage dates | |
| Opportunity enter current stage date | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. |
| Entered current stage millisecond | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. |
| Entered current stage second | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. |
| Entered current stage date (UTC) | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. |
| Entered current stage millisecond (UTC) | The time the last stage was entered. The opportunity can still be in the pipeline or archived. Primarily used for exports. |
| Entered current stage second (UTC) | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. Primarily used for exports. |
| Opportunity entered last stage dates | |
| Entered last stage date (UTC) | The time the last stage was entered. The opportunity can still be in the pipeline or archived. Primarily used for exports. |
| Entered last stage second (UTC) | The time the last stage was entered. The opportunity can still be in the pipeline or archived. Primarily used for exports. |
| Opportunity hired dates | |
| Opportunity hire date | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire hhmm | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire millisecond | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire second | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire week | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire month | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire quarter | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire year | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire date (UTC) | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire hhmm (UTC) | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire millisecond (UTC) | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity hire second (UTC) | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) |
| Opportunity last activity dates | |
| Last activity date | The opportunity last interaction date |
| Last activity hhmm | The opportunity last interaction date |
| Last activity millisecond | The opportunity last interaction date |
| Last activity week | The opportunity last interaction date |
| Last activity month | The opportunity last interaction date |
| Last activity quarter | The opportunity last interaction date |
| Last activity year | The opportunity last interaction date |
| Last activity date (UTC) | The opportunity last interaction date |
| Last activity hhmm (UTC) | The opportunity last interaction date |
| Last activity millisecond (UTC) | The opportunity last interaction date |
| Opportunity last advance dates | |
| Last advanced date | The opportunity last advance date |
| Last advanced hhmm | The opportunity last advance date |
| Last advanced millisecond | The opportunity last advance date |
| Last advanced second | The opportunity last advance date |
| Last advanced week | The opportunity last advance date |
| Last advanced month | The opportunity last advance date |
| Last advanced quarter | The opportunity last advance date |
| Last advanced year | The opportunity last advance date |
| Last advanced date (UTC) | The opportunity last advance date |
| Last advanced hhmm (UTC) | The opportunity last advance date |
| Last advanced millisecond (UTC) | The opportunity last advance date |
| Last advanced second (UTC) | The opportunity last advance date |
| Opportunity snooze completed dates | |
| Snooze completed date | The most recent time a snooze was completed. |
| Snooze completed hhmm | The most recent time a snooze was completed. |
| Snooze completed millisecond | The most recent time a snooze was completed. |
| Snooze completed second | The most recent time a snooze was completed. |
| Snooze completed week | The most recent time a snooze was completed. |
| Snooze completed month | The most recent time a snooze was completed. |
| Snooze completed quarter | The most recent time a snooze was completed. |
| Snooze completed year | The most recent time a snooze was completed. |
| Snooze completed date (UTC) | The most recent time a snooze was completed. |
| Snooze completed hhmm (UTC) | The most recent time a snooze was completed. |
| Snooze completed millisecond (UTC) | The most recent time a snooze was completed. |
| Snooze completed second (UTC) | The most recent time a snooze was completed. |
| Opportunity sourced dates | |
| Opportunity sourced date | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced hhmm | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced millisecond | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced second | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced week | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced month | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced quarter | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced year | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced date (UTC) | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced hhmm (UTC) | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced second (UTC) | The create date of the opportunity if the opportunity origin is sourced. |
| Opportunity sourced millisecond (UTC) | The create date of the opportunity if the opportunity origin is sourced |
| Snooze end dates | |
| Snooze end date | The end date of the snooze. |
| Snooze end hhmm | The end date of the snooze. |
| Snooze end millisecond | The end date of the snooze. |
| Snooze end week | The end date of the snooze. |
| Snooze end month | The end date of the snooze. |
| Snooze end quarter | The end date of the snooze. |
| Snooze end year | The end date of the snooze. |
| Snooze end date (UTC) | The end date of the snooze. |
| Snooze end hhmm (UTC) | The end date of the snooze. |
| Snooze end millisecond (UTC) | The end date of the snooze. |
| Snooze start dates | |
| Snooze start date | The start date of the snooze. |
| Snooze start hhmm | The start date of the snooze. |
| Snooze start millisecond | The start date of the snooze. |
| Snooze start week | The start date of the snooze. |
| Snooze start month | The start date of the snooze. |
| Snooze start quarter | The start date of the snooze. |
| Snooze start year | The start date of the snooze. |
| Snooze start date (UTC) | The start date of the snooze. |
| Snooze start hhmm (UTC) | The start date of the snooze. |
| Snooze start millisecond (UTC) | The start date of the snooze. |
| Hyperlinks | |
| Contact name (hyperlink) | A hyperlink to the opportunity in the Lever hire application. |
| Hired requisition ID (hyperlink) | The requisition id that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Hired requisition name (hyperlink) | The requisition id that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Offer requisition ID (hyperlink) | The requisition id of the offer to the opportunity. |
| Offer requisition name (hyperlink) | The requisition text of the requisition that is associated with the opportunity offer |
| Opportunity ID (hyperlink) | The opportunity id hyperlink. When clicked upon will take you to the opportunity in the Lever application. |
| Ids | |
| Agency source ID | The agency source ID. |
| Contact ID | The identifier of the contact associated with the opportunity. |
| Contact ID (Anonymized) | The anonymized identifier of the contact associated with the opportunity. |
| Current stage key | The current stage key of a non-archived opportunity in the pipeline. If the opportunity is archived, there is no value. |
| Hired requisition ID | The requisition id that was used to hire the opportunity. Until the opportunity is hired, this field is not populated. |
| Offer requisition ID | The requisition id of the offer to the opportunity. |
| Opportunity ID | The opportunity identifier |
| Opportunity ID (anonymized) | The anonymized opportunity identifier |
| Opportunity archived by ID | The ID archived the opportunity |
| Opportunity owner ID | The owner/recruiter for the opportunity |
| Opportunity sourced by ID | The ID of who sourced the opportunity |
| MEASURES | |
| Counts | |
| Archived all | A distinct count of all archived opportunities including hires. True if archived date is not null. |
| Contacts | A distinct count of contacts |
| Hires | A distinct count of hired opportunities. True if archived date is not null and the is hired flag is true. |
| In pipeline | Distinct count of opportunities in the pipeline that are not archived. |
| Non-hires | A distinct count of archived opportunities excluding hires. True if archived date is not null and the is hired flag is false. |
| Opportunities | A distinct count of opportunities |
| Sourced opportunities | Distinct count of opportunities that are sourced. |
| Stuck in stage | The distinct number of opportunities that are stuck |
| Interview scheduled | |
| Interviews not scheduled | Count of active opportunities in a stage that have an interview but have no start date set for an interview. |
| Interviews scheduled | Count of active opportunities in a stage that has an interview and a start date set for an interview. |
| Opportunity has interview | Count of active opportunities in a stage that has an interview. |
| Percent interview scheduled | Percent of active opportunities in a stage that has an interview stage that have an interview start date set/active opportunities in a stage that has an interview. |
| Ratio | |
| Opportunities per hire | The number of opportunities needed to make a hire. (not hired / hired) |
| Duration | |
| Average days in pipeline (Use Standard filter) | The average number of days from when the opportunity is created until the lesser of the Standard filter end/archived date. Opportunities must be active within the filter timeframe. If archived, the archive/hire date (UTC) is greater than the start date of the date range. |
| Avg. candidate time in current stage | Avg. candidate time in current stage. Archived candidates are excluded. |
| Avg. days in pipeline | The average number of days from when the opportunity create until archive. |
| Median days in pipeline | The median number of days from when the opportunity is created until archived. |
| Median time in current stage | The duration from when the opportunity entered a current stage in the pipeline until now. Archived candidates are excluded. |
| Duration time to hire | |
| Avg. contact create to hired | The average duration from the contact create date to when the opportunity is archived as HIRED. |
| Avg. contact create to offer signed | The average duration from the contact create date to the first offer signed date. |
| Avg. opportunity create to hire | The average time from an opportunity create to archive as HIRED |
| Avg. opportunity creation to offer signing | Average days from the time an opportunity was created to signing an offer. |
| Avg. posting applied to hire | The average time from the posting applied to the opportunity to the hire date. |
| Avg. posting applied to offer signed | The time from when a posting is applied to an opportunity until the first offer signed. |
| Avg. posting created to hire | The average time from the posting creation to the opportunity hire date. |
| Median contact create to offer signed | The mean duration from the contact create date to the first offer signed date. |
| Median contact created to hire | The median duration from the contact create date to when the opportunity is archived as HIRED. |
| Median days from opportunity creation to offer signing | Median number of days from the opportunity creation to first offer signing. |
| Median days from posting applied to offer signed | Median days from the posting applied to the opportunity to first offer signed |
| Median opportunity create to hired | The median time from when an opportunity is created to hired archive. If this is used with items that cause SQL fanning (such as progress steps and , the results will be inaccurate) |
| Median posting applied to offer hire. | The median time from the posting applied to the opportunity to the hire date. |
| Median posting created to offer hire. | The median time from the posting creation to the opportunity hire date. |
| Dates to pivot | |
| Opportunity enter last stage date (Pivot) | The time the last stage was entered. The opportunity may be archived or active in the pipeline. Used for pivots in exports. |
| Opportunity enter last stage second (UTC) (Pivot) | The time the last stage was entered. The opportunity may be archived or active in the pipeline. Used for pivots in exports. |
| Opportunity enter current stage date (pivot) | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. Used for pivots in exports. |
| Opportunity enter current stage second (UTC) (pivot) | The time the current non archived stage was entered. If the opportunity is archived, no date is returned. Used for pivots in exports. |
| Posting | |
| DIMENSIONS | |
| Posting attributes | |
| Posting count | 0 if opportunity has a GENERAL_OPPORTUNITY posting, 1 if the opportunity has a specific posting |
| Posting country (map) | The country of the posting for the opportunity. Use this field to create map visualizations |
| Posting country code | The country code of the posting for the opportunity. |
| Posting department | The department of the posting for the opportunity. |
| Posting distribution list | A list of the posting distribution channels. When filtering, use filter option 'contains' to find specific list items. |
| Posting has multiple location (yes/no) | True if the posting has more than one location. |
| Posting hiring manager email | The email of the posting hiring manager for the opportunity. |
| Posting hiring manager name | The name of the posting hiring manager for the opportunity. |
| Posting job level | The job level on the posting. |
| Posting location | The location of the posting for the opportunity. |
| Posting location count | The number of locations on the posting |
| Posting location list | A list of all locations on the posting. When filtering, use filter option 'contains' to find specific list items. |
| Posting location type | The location type associated with the posting. |
| Posting owner email | The email of the posting owner for the opportunity. |
| Posting owner name | The name of the posting owner for the opportunity. |
| Posting salary currency | The currency for the posting salary. |
| Posting salary description | The description of the posting salary range. |
| Posting salary interval | The interval of the posting salary. |
| Posting salary maximum | The maximum of the posting salary. |
| Posting salary minimum | The minimum of the posting salary. |
| Posting status | The posting status for the opportunity |
| Posting team | The team of the posting for the opportunity. |
| Posting title | The posting title for the opportunity |
| Posting work type | The work type of the posting for the opportunity. |
| Requisitions for posting (1:n) | |
| Posting requisition active offers | The number of active offers of the requisition that is associated with the opportunity posting.. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition code (1:n) | The requisition code that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition compensation band (1:n) | The compensation band interval of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition compensation currency (1:n) | The compensation currency of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition compensation max (1:n) | The compensation band maximum of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition compensation min (1:n) | The compensation band minimum of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition employment status (1:n) | The employment status of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition headcount hired (1:n) | The total hired of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition headcount total (1:n) | The total number of headcount of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition internal notes | The first 500 characters of the posting requisition description. The field is also known as internal notes. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition is backfill (yes/no) (1:n) | The backfill of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition is confidential (yes/no) (1:n) | The confidentiality of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition is infinite (yes/no) (1:n) | The infinite headcount of the requisition that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition name (1:n) | The requisition text that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting requisition status (1:n) | The status of the requisition of the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed. |
| Posting applied dates | |
| Posting applied date | The date the posting is applied to the opportunity |
| Posting applied hhmm | The date the posting is applied to the opportunity |
| Posting applied millisecond | The date the posting is applied to the opportunity |
| Posting applied week | The date the posting is applied to the opportunity |
| Posting applied month | The date the posting is applied to the opportunity |
| Posting applied quarter | The date the posting is applied to the opportunity |
| Posting applied year | The date the posting is applied to the opportunity |
| Posting applied date (UTC) | The date the posting is applied to the opportunity |
| Posting applied hhmm (UTC) | The date the posting is applied to the opportunity |
| Posting applied millisecond (UTC) | The date the posting is applied to the opportunity |
| Posting created dates | |
| Posting create date | The date the posting is created |
| Posting create hhmm | The date the posting is created |
| Posting create millisecond | The date the posting is created |
| Posting create week | The date the posting is created |
| Posting create month | The date the posting is created |
| Posting create quarter | The date the posting is created |
| Posting create year | The date the posting is created |
| Posting create date (UTC) | The date the posting is created |
| Posting create hhmm (UTC) | The date the posting is created |
| Posting create millisecond (UTC) | The date the posting is created |
| Posting first published | |
| Posting first published date | The first date the posting was published |
| Posting first published hhmm | The first date the posting was published |
| Posting first published millisecond | The first date the posting was published |
| Posting first published week | The first date the posting was published |
| Posting first published month | The first date the posting was published |
| Posting first published quarter | The first date the posting was published |
| Posting first published year | The first date the posting was published |
| Posting first published date (UTC) | The first date the posting was published |
| Posting first published hhmm (UTC) | The first date the posting was published |
| Posting first published millisecond (UTC) | The first date the posting was published |
| Posting last closed dates | |
| Posting last closed date | The most recent date the posting was closed. |
| Posting last closed hhmm | The most recent date the posting was closed. |
| Posting last closed millisecond | The most recent date the posting was closed. |
| Posting last closed week | The most recent date the posting was closed. |
| Posting last closed month | The most recent date the posting was closed. |
| Posting last closed quarter | The most recent date the posting was closed. |
| Posting last closed year | The most recent date the posting was closed. |
| Posting last closed date (UTC) | The most recent date the posting was closed. |
| Posting last closed hhmm (UTC) | The most recent date the posting was closed. |
| Posting last closed millisecond (UTC) | The most recent date the posting was closed. |
| Posting last published dates | |
| Posting last published date | The most recent date the posting was published |
| Posting last published hhmm | The most recent date the posting was published |
| Posting last published millisecond | The most recent date the posting was published |
| Posting last published week | The most recent date the posting was published |
| Posting last published month | The most recent date the posting was published |
| Posting last published quarter | The most recent date the posting was published |
| Posting last published year | The most recent date the posting was published |
| Posting last published date (UTC) | The most recent date the posting was published |
| Posting last published hhmm (UTC) | The most recent date the posting was published |
| Posting last published millisecond (UTC) | The most recent date the posting was published |
| Posting last update dates | |
| Posting updated date | The most recent data there was a posting event. |
| Posting updated hhmm | The most recent data there was a posting event. |
| Posting updated millisecond | The most recent data there was a posting event. |
| Posting updated week | The most recent data there was a posting event. |
| Posting updated month | The most recent data there was a posting event. |
| Posting updated quarter | The most recent data there was a posting event. |
| Posting updated year | The most recent data there was a posting event. |
| Posting updated date (UTC) | The most recent data there was a posting event. |
| Posting updated hhmm (UTC) | The most recent data there was a posting event. |
| Posting updated millisecond (UTC) | The most recent data there was a posting event. |
| Hyperlinks | |
| Posting ID (hyperlink) | Provides a html link to the posting in the Lever application. |
| Posting requisition ID (hyperlink) | The requisition id that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed.. |
| Posting requisition name (hyperlink) | The requisition text that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed.. |
| Posting title (hyperlink) | The posting title for the opportunity. Clicking will take you to the posting in the Lever hire application. |
| Ids | |
| Posting ID | The posting identifier associated with the opportunity |
| Posting Requisition ID (1:n) | The requisition id that is associated with the opportunity posting. If the posting is not associated to a requisition this field is not populated. If the posting is associated to more than 1 requisition (not recommended), then multiple rows for the posting will be displayed.. |
| Posting hiring manager ID | The identifier of the posting hiring manager for the opportunity |
| Posting owner ID | The identifier of the posting owner for the opportunity |
| Posting locations (1:n) | |
| DIMENSIONS | |
| Posting location is primary (yes/no)(1:n) | Is this the primary location. |
| Posting location name (1:n) | The name of a posting location. |
| Posting location rank (1:n) | The rank of a posting location. |
| Offers | |
| DIMENSIONS | |
| Offer attributes | |
| Is offer sent (yes/no) | The offer is sent. True if there is an offer first sent date. |
| Is offer signed (yes/no) | The offer is signed. True if there is an offer first signed date. |
| Is saved internally | The offer revision is saved internally. |
| Offer ID | The identifier of the offer for the opportunity |
| Offer active revision ID | The offer revision ID of the active revision |
| Offer active revision approval status | The approval status of the active offer revision |
| Offer active revision key | The key indicating the active revision |
| Offer active revision number | The revision number of the active revision. The characters of an offer revision ID after the final dash. |
| Offer annualize compensation | Calculates the annualized compensation by multiplying the salary and the salary interval. |
| Offer first signed date | The first date the offer is signed |
| Offer is original revision version (yes/no) (dynamic) | Indicates whether the current offer revision is the original offer. |
| Offer posting ID | The posting ID for the offer for the opportunity |
| Offer posting country (map) | The country of the offer posting. Use this field to create map visualizations |
| Offer posting country code | The country code of the offer. |
| Offer posting department | The department of the offer posting. |
| Offer posting job level | The job level of the offer posting. |
| Offer posting location | The job location of the offer. |
| Offer posting team | The team of the offer posting. |
| Offer posting work type | The commitment (work type) of the offer posting. |
| Offer requisition ID | The requisition ID of the offer for the opportunity |
| Offer requisition is backfill (yes/no) | The backfill of the requisition that is associated with the opportunity offer |
| Offer requisition is confidential (yes/no) | The confidentiality of the requisition that is associated with the opportunity offer |
| Offer requisition is infinite (yes/no) | The infinite headcount of the requisition that is associated with the opportunity offer |
| Offer salary | Active offer salary |
| Offer salary max difference | The difference between the salary and the offer requisition band max. |
| Offer salary mid point difference | The difference between the salary and the midpoint of the offer requisition salary band. |
| Offer salary outside band | The salary amount outside the offer requisition band. Negative numbers indicate the salary was below the minimum. Positive numbers indicate salary was above the maximum |
| Offer salary within range | Active offer salary is within the offer requisition bands. |
| Offer status | The offer status of the offer for the opportunity |
| Offer requisition | |
| Offer requisition code | The requisition code of the requisition that is associated with the opportunity offer |
| Offer requisition compensation band | The compensation band interval of the requisition that is associated with the opportunity offer |
| Offer requisition compensation currency | The compensation currency of the requisition that is associated with the opportunity offer |
| Offer requisition compensation max | The compensation band maximum of the requisition that is associated with the opportunity offer |
| Offer requisition compensation min | The compensation band minimum of the requisition that is associated with the opportunity offer |
| Offer requisition employment status | The employment status of the requisition that is associated with the opportunity offer |
| Offer requisition headcount hired | The total hired of the requisition that is associated with the opportunity offer |
| Offer requisition headcount total | The total number of headcount of the requisition that is associated with the opportunity offer |
| Offer requisition internal notes | The first 500 characters of the offer requisition description. The field is also known as internal notes. of the requisition that is associated with the opportunity offer |
| Offer requisition name | The requisition of offer to the opportunity. |
| Offer requisition offers | The number of active offers of the requisition that is associated with the opportunity offer |
| Offer requisition status | The status of the requisition that is associated with the opportunity offer |
| Offer salary band midpoint | The midpoint between the offer requisition compensation band minimum and maximum. |
| Offer last signed dates | |
| Offer revision last signed date | The last signed date of the active offer revision |
| Offer revision last signed hhmm | The last signed date of the active offer revision |
| Offer revision last signed millisecond | The last signed date of the active offer revision |
| Offer revision last signed week | The last signed date of the active offer revision |
| Offer revision last signed month | The last signed date of the active offer revision |
| Offer revision last signed quarter | The last signed date of the active offer revision |
| Offer revision last signed year | The last signed date of the active offer revision |
| Offer revision last signed date (UTC) | The last signed date of the active offer revision |
| Offer revision last signed hhmm (UTC) | The last signed date of the active offer revision |
| Offer revision last signed second (UTC) | The last signed date of the active offer revision second (UTC) |
| Offer revision last signed millisecond (UTC) | The last signed date of the active offer revision millisecond (UTC) |
| Offer create dates | |
| Offer create date | Offer created at time. |
| Offer create hhmm | Offer created at time. |
| Offer create millisecond | Offer created at time. |
| Offer create week | Offer created at time. |
| Offer create month | Offer created at time. |
| Offer create quarter | Offer created at time. |
| Offer create year | Offer created at time. |
| Offer create date (UTC) | Offer created at time. |
| Offer create hhmm (UTC) | Offer created at time. |
| Offer create millisecond (UTC) | Offer created at time millisecond (UTC) |
| Offer create second (UTC) | Offer created at time. second (UTC) |
| Offer first sent dates | |
| Offer first sent date | The first date the offer is sent |
| Offer first sent hhmm | The first date the offer is sent |
| Offer first sent millisecond | The first date the offer is sent |
| Offer first sent week | The first date the offer is sent |
| Offer first sent month | The first date the offer is sent |
| Offer first sent quarter | The first date the offer is sent |
| Offer first sent year | The first date the offer is sent |
| Offer first sent date (UTC) | The first date the offer is sent |
| Offer first sent hhmm (UTC) | The first date the offer is sent |
| Offer first sent millisecond (UTC) | The first date the offer is sent |
| Offer first signed dates | |
| Offer first signed hhmm | The first date the offer is signed |
| Offer first signed millisecond | The first date the offer is signed |
| Offer first signed week | The first date the offer is signed |
| Offer first signed month | The first date the offer is signed |
| Offer first signed quarter | The first date the offer is signed |
| Offer first signed year | The first date the offer is signed |
| Offer first signed date (UTC) | The first date the offer is signed |
| Offer first signed hhmm (UTC) | The first date the offer is signed |
| Offer first signed millisecond (UTC) | The first date the offer is signed |
| Offer last approved dates | |
| Offer revision last approved date | The last approved date of the active offer revision |
| Offer revision last approved hhmm | The last approved date of the active offer revision |
| Offer revision last approved millisecond | The last approved date of the active offer revision |
| Offer revision last approved week | The last approved date of the active offer revision |
| Offer revision last approved month | The last approved date of the active offer revision |
| Offer revision last approved quarter | The last approved date of the active offer revision |
| Offer revision last approved year | The last approved date of the active offer revision |
| Offer revision last approved date (UTC) | The last approved date of the active offer revision |
| Offer revision last approved hhmm (UTC) | The last approved date of the active offer revision |
| Offer revision last approved second (UTC) | The last approved date of the active offer revision second (UTC) |
| Offer revision last approved millisecond (UTC) | The last approved date of the active offer revision millisecond (UTC) |
| Offer last declined dates | |
| Offer revision last declined date | The last declined date of the active offer revision |
| Offer revision last declined hhmm | The last declined date of the active offer revision |
| Offer revision last declined millisecond | The last declined date of the active offer revision |
| Offer revision last declined week | The last declined date of the active offer revision |
| Offer revision last declined month | The last declined date of the active offer revision |
| Offer revision last declined quarter | The last declined date of the active offer revision |
| Offer revision last declined year | The last declined date of the active offer revision |
| Offer revision last declined date (UTC) | The last declined date of the active offer revision |
| Offer revision last declined hhmm (UTC) | The last declined date of the active offer revision |
| Offer revision last declined second (UTC) | The last declined date of the active offer revision second (UTC) |
| Offer revision last declined millisecond (UTC) | The last declined date of the active offer revision millisecond (UTC) |
| Offer last sent dates | |
| Offer revision last sent date | The last sent date of the active offer revision |
| Offer revision last sent hhmm | The last sent date of the active offer revision |
| Offer revision last sent millisecond | The last sent date of the active offer revision |
| Offer revision last sent week | The last sent date of the active offer revision |
| Offer revision last sent month | The last sent date of the active offer revision |
| Offer revision last sent quarter | The last sent date of the active offer revision |
| Offer revision last sent year | The last sent date of the active offer revision |
| Offer revision last sent date (UTC) | The last sent date of the active offer revision |
| Offer revision last sent hhmm (UTC) | The last sent date of the active offer revision |
| Offer revision last sent second (UTC) | The last sent date of the active offer revision second (UTC) |
| Offer revision last sent millisecond (UTC) | The last sent date of the active offer revision millisecond (UTC) |
| MEASURES | |
| Salary | |
| Average salary over band max. | The average of the difference between the salary and the offer requisition band max. |
| Offer salary max difference total | The total of the difference between the salary and the offer requisition band max. |
| Offer acceptance | |
| DIMENSIONS | |
| Offer acceptance attributes | |
| Has outcome | The offer is signed or declined. |
| Outcome offer ID | The outcome offer id. |
| Offer outcome dates | |
| Last offer declined date | The latest offer declined event. |
| Last offer sent date | The latest offer sent event. |
| Last offer signed date | The latest offer signed event. |
| Last offer declined date (UTC) | The latest offer declined event. |
| Last offer sent date (UTC) | The latest offer sent event before the outcome. |
| Last offer signed date (UTC) | The latest offer signed event. |
| MEASURES | |
| Calculations | |
| Acceptance rate (hover) | The percent of offers accepted. (Total signed / (total signed + total declined) ). Provides a hover to use in visualizations |
| Outcome acceptance rate | The percentage of distinct offers signed / (total signed + total declined) |
| Counts | |
| Declined status count | A distinct count of offers with a current status of declined. |
| Pending count | A distinct count of offers sent that are neither signed or declined. |
| Sent outcome count | A distinct count of offers sent and that are either signed or declined. |
| Sent status count | A distinct count of offers with a current status of sent. |
| Signed count | A distinct count of sent offers that are signed. |
| Signed status count | A distinct count of offers with a current status of signed. |
| Offer form fields | |
| FILTER_ONLY FIELDS | |
| Choose offer custom fields** | |
| Set offer field 01 | Dynamically set which custom offer field should populate dynamic 'field_01' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 02 | Dynamically set which custom offer field should populate dynamic 'field_02' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 03 | Dynamically set which custom offer field should populate dynamic 'field_03' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 04 | Dynamically set which custom offer field should populate dynamic 'field_04' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 05 | Dynamically set which custom offer field should populate dynamic 'field_05' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 06 | Dynamically set which custom offer field should populate dynamic 'field_06' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 07 | Dynamically set which custom offer field should populate dynamic 'field_07' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 08 | Dynamically set which custom offer field should populate dynamic 'field_08. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 09 | Dynamically set which custom offer field should populate dynamic 'field_09' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| Set offer field 10 | Dynamically set which custom offer field should populate dynamic 'field_10' dimensions. For the filter to work properly, the 'is equal to' option must be used. |
| DIMENSIONS | |
| Offer custom fields value | |
| Offer field 01 value (dynamic) | Display offer field 01 as text. |
| Offer field 02 value (dynamic) | Display offer field 02 as text |
| Offer field 03 value (dynamic) | Display field 03 as text. |
| Offer field 04 value (dynamic) | Display field 04 as a date. |
| Offer field 05 value (dynamic) | Display field 05 as text. |
| Offer field 06 value (dynamic) | Field 06 value. |
| Offer field 07 value (dynamic) | Field 07 value. |
| Offer field 08 value (dynamic) | Field 08 value. |
| Offer field 09 value (dynamic) | Field 09 value. |
| Offer field 10 value (dynamic) | Field 10 value. |
| Offer custom fields previous | |
| Offer field 01 is same as previous (yes/no) (dynamic) | Indicates whether offer field 01 is the same as previous field 01(Yes/No) Set the 'Offer field 01 dynamic name' filter to pick which offer field will populate the 01 fields. |
| Offer field 02 is same as previous (yes/no) (dynamic) | Indicates whether field 02 is the same as previous field 02(Yes/No)(Yes/No) Set the 'Offer field 02 dynamic name' filter to pick which offer field will populate the 02 fields. |
| Offer field 03 is same as previous (yes/no) (dynamic) | Indicates whether field 03 is the same as previous field 03(Yes/No)(Yes/No) Set the 'Offer field 03 dynamic name' filter to pick which offer field will populate the 03 fields. |
| Offer field 04 is same as previous (yes/no) (dynamic) | Indicates whether field 04 is the same as previous field 04(Yes/No) Set the 'Offer field 04 dynamic name' filter to pick which offer field will populate the 04 fields. |
| Offer field 05 is same as previous (yes/no) (dynamic) | Is field 05 same as previous field 05(Yes/No) Set the 'Offer field 05 dynamic name' filter to pick which offer field will populate the 05 fields. |
| Offer field 06 is same as previous (yes/no) (dynamic) | Indicates whether field 06 is the same as previous field 06(Yes/No) Set the 'Offer field 06 dynamic name' filter to pick which offer field will populate the 06 fields. |
| Offer field 07 is same as previous (yes/no) (dynamic) | Indicates whether field 07 is the same as previous field 07(Yes/No) Set the 'Offer field 07 dynamic name' filter to pick which offer field will populate the 07 fields. |
| Offer field 08 is same as previous (yes/no) (dynamic) | Indicates whether field 08 is the same as previous field 08(Yes/No) Set the 'Offer field 08 dynamic name' filter to pick which offer field will populate the 08 fields. |
| Offer field 09 is same as previous (yes/no) (dynamic) | Indicates whether field 09 is the same as previous field 09(Yes/No) Set the 'Offer field 09 dynamic name' filter to pick which offer field will populate the 09 fields. |
| Offer field 10 is same as previous (yes/no) (dynamic) | Indicates whether field 10 is the same as previous field 10(Yes/No) Set the 'Offer field 10 dynamic name' filter to pick which offer field will populate the 10 fields. |
| Offer previous field 01 value (dynamic) | Display the previous value of offer field 01 as text. |
| Offer previous field 02 value (dynamic) | Display the previous value of offer field 02 Set the 'Offer field 02 dynamic name' filter to pick which offer field will populate the 02 fields. |
| Offer previous field 03 value (dynamic) | Display field 03 as text. Set the 'Offer field 03 dynamic name' filter to pick which offer field will populate the 03 fields. |
| Offer previous field 04 value (dynamic) | Display field 04 as text. Set the 'Offer field 04 dynamic name' filter to pick which offer field will populate the 04 fields. |
| Offer previous field 05 value (dynamic) | Set the 'Offer field 05 dynamic name' filter to pick which offer field will populate the 05 fields. |
| Offer previous field 06 value (dynamic) | Set the 'Offer field 06 dynamic name' filter to pick which offer field will populate the 06 fields. |
| Offer previous field 07 value (dynamic) | Set the 'Offer field 07 dynamic name' filter to pick which offer field will populate the 07 fields. |
| Offer previous field 08 value (dynamic) | Set the 'Offer field 08 dynamic name' filter to pick which offer field will populate the 08 fields. |
| Offer previous field 09 value (dynamic) | Set the 'Offer field 09 dynamic name' filter to pick which offer field will populate the 09 fields. |
| Offer previous field 10 value (dynamic) | Set the 'Offer field 10 dynamic name' filter to pick which offer field will populate the 10 fields. |
| Offer previous field 01 date (dynamic) | Display previous offer field 01 as a date. Set the 'Offer field 01 dynamic name' filter to pick which offer field will populate the 01 fields. |
| Offer previous field 01 number (dynamic) | Display previous offer field 01 as number. Set the 'Offer field 01 dynamic name' filter to pick which offer field will populate the 01 fields. |
| Offer previous field 02 number (dynamic) | Display the previous value of offer field 02 as a number. Set the 'Offer field 02 dynamic name' filter to pick which offer field will populate the 02 fields. |
| Offer previous field 03 number (dynamic) | Display the previous value of field 03 as a date. Set the 'Offer field 03 dynamic name' filter to pick which offer field will populate the 03 fields. |
| Offer previous field 04 number (dynamic) | Display the previous value of field 04 as a number. Set the 'Offer field 04 dynamic name' filter to pick which offer field will populate the 04 fields. |
| Offer previous field 05 number (dynamic) | Number previous value 05. Set the 'Offer field 05 dynamic name' filter to pick which offer field will populate the 05 fields. |
| Offer previous field 06 number (dynamic) | Number previous value 06. Set the 'Offer field 06 dynamic name' filter to pick which offer field will populate the 06 fields. |
| Offer previous field 07 number (dynamic) | Number previous value 07. Set the 'Offer field 07 dynamic name' filter to pick which offer field will populate the 07 fields. |
| Offer previous field 08 number (dynamic) | Number previous value 08. Set the 'Offer field 08 dynamic name' filter to pick which offer field will populate the 08 fields. |
| Offer previous field 09 number (dynamic) | Number previous value 09. Set the 'Offer field 09 dynamic name' filter to pick which offer field will populate the 09 fields. |
| Offer previous field 10 number (dynamic) | Number previous value 10. Set the 'Offer field 10 dynamic name' filter to pick which offer field will populate the 10 fields. |
| Offer previous field 02 date (dynamic) | Display the previous value of offer field 02 as a date. Set the 'Offer field 02 dynamic name' filter to pick which offer field will populate the 02 fields. |
| Offer previous field 03 date (dynamic) | Display the previous value of field 03 as a date. Set the 'Offer field 03 dynamic name' filter to pick which offer field will populate the 03 fields. |
| Offer previous field 04 date (dynamic) | Display the previous value of field 04 as a date. Set the 'Offer field 04 dynamic name' filter to pick which offer field will populate the 04 fields. |
| Offer previous field 05 date (dynamic) | Date previous value 05. Set the 'Offer field 05 dynamic name' filter to pick which offer field will populate the 05 fields. |
| Offer previous field 06 date (dynamic) | Date previous value 06. Set the 'Offer field 06 dynamic name' filter to pick which offer field will populate the 06 fields. |
| Offer previous field 07 date (dynamic) | Date previous value 07. Set the 'Offer field 07 dynamic name' filter to pick which offer field will populate the 07 fields. |
| Offer previous field 08 date (dynamic) | Date previous value 08. Set the 'Offer field 08 dynamic name' filter to pick which offer field will populate the 08 fields. |
| Offer previous field 09 date (dynamic) | Date previous value 09. Set the 'Offer field 09 dynamic name' filter to pick which offer field will populate the 09 fields. |
| Offer previous field 10 date (dynamic) | Date previous value 10. Set the 'Offer field 10 dynamic name' filter to pick which offer field will populate the 10 fields. |
| Offer custom fields typed | |
| Offer field 01 number (dynamic) | Display offer field 01 as a number. |
| Offer field 02 number (dynamic) | Display offer field 02 as a number. |
| Offer field 03 number (dynamic) | Display field 03 as a number. |
| Offer field 04 number (dynamic) | Display field 04 as a number. |
| Offer field 05 number (dynamic) | Display field 05 as a number |
| Offer field 06 number (dynamic) | Display field 06 as a number |
| Offer field 07 number (dynamic) | Used to set which field will be use for field 07 |
| Offer field 08 number (dynamic) | Used to set which field will be use for field 08 |
| Offer field 09 number (dynamic) | Used to set which field will be use for field 09 |
| Offer field 10 number (dynamic) | Used to set which field will be use for field 10 |
| Offer field 01 date (dynamic) | Display offer field 01 as a date. |
| Offer field 02 date (dynamic) | Display offer field 02 as a date. |
| Offer field 03 date (dynamic) | Display field 03 as a date. |
| Offer field 04 date (dynamic) | Display field 04 as a date. |
| Offer field 05 date (dynamic) | Display field 05 as a date. |
| Offer field 06 date (dynamic) | Display field 06 as a date. |
| Offer field 07 date (dynamic) | Display field 07 as a date. |
| Offer field 08 date (dynamic) | Display field 08 as a date. |
| Offer field 09 date (dynamic) | Display field 09 as a date. |
| Offer field 10 date (dynamic) | Display field 10 as a date. |
| Offer field 01 type (dynamic) | The type of data in offer field 01. |
| Offer field 02 type (dynamic) | The type of data in field 02. |
| Offer field 03 type (dynamic) | The type of data in field 03. |
| Offer field 04 type (dynamic) | The type of data in field 04. |
| Offer field 05 type (dynamic) | The type of data in field 05. |
| Offer field 06 type (dynamic) | The type of data in field 06. |
| Offer field 07 type (dynamic) | The type of data in field 07. |
| Offer field 08 type (dynamic) | The type of data in field 08. |
| Offer field 09 type (dynamic) | The type of data in field 09. |
| Offer field 10 type (dynamic) | The type of data in field 10. |
| Predefined offer fields | |
| Offer additional details | Active offer additional authorization details |
| Offer annual bonus | Active offer annual bonus |
| Offer annualize value | This value is used to multiply the compensation to calculate the annual compensation. |
| Offer anticipated start | Active offer anticipated start |
| Offer anticipated start second | Active offer anticipated start in seconds. |
| Offer bonus | Active offer bonus |
| Offer candidate address line 1 | Active offer candidate address line 1 |
| Offer candidate address line 2 | Active offer candidate address line 2 |
| Offer candidate name | Active offer candidate name |
| Offer candidate signature | Active offer candidate signature |
| Offer company job posting | Active offer company job posting |
| Offer company previous signature 1 email | Active offer company previous signature 1 email |
| Offer company previous signature 2 email | Active offer company previous signature 2 email |
| Offer company previous signature 3 email | Active offer company previous signature 3 email |
| Offer company signature 1 | Active offer company signature 1 |
| Offer company signature 1 date UTC | Active offer company signature 1 creation date |
| Offer company signature 1 date UTC (seconds) | Active offer company signature 1 creation date |
| Offer company signature 1 email | Active offer company signature 1 email |
| Offer company signature 2 | Active offer company signature 2 |
| Offer company signature 2 date UTC | Active offer company signature 2 creation date |
| Offer company signature 2 date UTC (seconds) | Active offer company signature 2 creation date |
| Offer company signature 2 email | Active offer company signature 2 email |
| Offer company signature 3 | Active offer company signature 3 |
| Offer company signature 3 date UTC | Active offer company signature 3 creation date |
| Offer company signature 3 date UTC (seconds) | Active offer company signature 3 creation date |
| Offer company signature 3 email | Active offer company signature 3 email |
| Offer compensation currency | Active offer compensation currency |
| Offer competing offer details | Active offer competing offer details |
| Offer country | Active offer country |
| Offer date field | Active offer date field |
| Offer department | Active offer department |
| Offer direct manager name | Active offer direct manager name |
| Offer direct manager | Active offer direct manage |
| Offer direct manager email | Active offer direct manager email |
| Offer employment status | Active offer employment status |
| Offer equity | Active offer equity |
| Offer equity type | Active offer equity type |
| Offer exemption status | Active offer exemption status |
| Offer hours per week | Active offer hours per week |
| Offer job description | Active offer job description |
| Offer job title | Active offer job title |
| Offer level | Active offer level |
| Offer office location | Active offer office location |
| Offer relocation bonus | Active offer relocation bonus |
| Offer requires USA visa | Active offer Requires USA visa |
| Offer requires international visa | Active offer Requires international visa |
| Offer requisition | Active offer requisition |
| Offer salary interval | Active offer salary interval |
| Offer signing bonus | Active offer signing bonus |
| Offer team | Active offer team |
| Offer today | Active offer today |
| Offer verbal status | Active offer verbal status |
| Offer vesting cliff | Active offer vesting cliff |
| Offer work authorization | Active offer work authorization |
| Offer work authorize status | Active offer work authorize status |
| Previous direct manager email | Active offer previous direct manager email |
| Previous direct manager name | Active offer previous direct manager name |
| Offer previous compensation currency | Active offer previous compensation currency |
| Predefined offer fields previous values | |
| Offer 'today date' is same as previous (yes/no) | Indicates whether the previous today date is the same as the current today date.(Yes/No) |
| Offer address 1 is same as previous (yes/no) | Indicates whether the previous candidate address line 1 is the same as the current candidate address line 1.(Yes/No) |
| Offer address 2 is same as previous (yes/no) | Indicates whether the previous candidate address line 2 is the same as the current candidate address line 2.(Yes/No) |
| Offer annual bonus is same as previous (yes/no) | Indicates whether the previous offer annual bonus is the same as the current offered annual bonus..(Yes/No) |
| Offer anticipated start date is same as previous (yes/no) | Indicates whether the previous anticipated start date is the same as the current anticipated start date.(Yes/No) |
| Offer anticipated start is same as previous (yes/no) | Indicates whether the previous anticipated start date is the same as the current anticipated start date.(Yes/No) |
| Offer authorization details is same as previous (yes/no) | Indicates whether the previous additional authorization details is the same as the current additional authorization details.(Yes/No) |
| Offer authorization details is same as previous (yes/no) | Indicates whether the previous competing offers detail is the same as the current competing offers detail.(Yes/No) |
| Offer bonus is same as previous (yes/no) | Indicates whether the previous offered bonus is the same as the current offered bonus.(Yes/No) |
| Offer candidate name is same as previous (yes/no) | Indicates whether the previous candidate name is the same as the current candidate name.(Yes/No) |
| Offer candidate name is same as previous (yes/no) | Indicates whether the previous candidate name is the same as the current candidate name.(Yes/No) |
| Offer candidate signature' is same as previous (yes/no) | Indicates whether the previous candidate signature is the same as the current candidate signature.(Yes/No) |
| Offer company signature 1 is same as previous (yes/no) | Indicates whether the previous company signature 1 is the same as the current company signature 1.(Yes/No) |
| Offer company signature 2 is same as previous (yes/no) | Indicates whether the previous company signature 2 is the same as the current company signature 2.(Yes/No) |
| Offer company signature 3 is same as previous (yes/no) | Indicates whether the previous company signature 3 is the same as the current company signature 3.(Yes/No) |
| Offer compensation currency is same as previous (yes/no) | Indicates whether the previous compensation currency is the same as the current compensation currency.(Yes/No) |
| Offer compensation currency is same as previous (yes/no) | Indicates whether the previous compensation currency is the same as the current compensation currency.(Yes/No) |
| Offer country is same as previous (yes/no) | Indicates whether the previous country is the same as the current country.(Yes/No) |
| Offer date field is same as previous (yes/no) | Indicates whether the previous date field is the same as the current date field.(Yes/No) |
| Offer direct manager is same as previous (yes/no) | Indicates whether the previous direct manager is the same as the current direct manager.(Yes/No) |
| Offer employment status is same as previous (yes/no) | Indicates whether the previous employment status is the same as the current employment status.(Yes/No) |
| Offer equity is same as previous (yes/no) | Indicates whether the equity is the same as the current equity.(Yes/No) |
| Offer equity is same as previous (yes/no) | Indicates whether the previous equity is the same as the current equity.(Yes/No) |
| Offer equity type is same as previous (yes/no) | Indicates whether the previous equity type is the same as the current equity type.(Yes/No) |
| Offer equity type is same as previous (yes/no) | Indicates whether the previous equity type is the same as the current equity type.(Yes/No) |
| Offer exemption status is same as previous (yes/no) | Indicates whether the previous exemption status is the same as the current exemption status.(Yes/No) |
| Offer hours per week is same as previous (yes/no) | Indicates whether the previous hours per week is the same as the current hours per week.(Yes/No) |
| Offer job description is same as previous (yes/no) | Indicates whether the previous job description is the same as the current job description.(Yes/No) |
| Offer job posting is same as previous (yes/no) | Indicates whether the previous job posting is the same as the current job posting.(Yes/No) |
| Offer job title is same as previous (yes/no) | Indicates whether the previous job title is the same as the current job title.(Yes/No) |
| Offer level is same as previous (yes/no) | Indicates whether the previous level is the same as the current level.(Yes/No) |
| Offer office location is same as previous (yes/no) | Indicates whether the previous office location is the same as the current office location.(Yes/No) |
| Offer office location is same as previous (yes/no) | Indicates whether the previous office location is the same as the current office location.(Yes/No) |
| Offer previous additional details | Active offer previous additional authorization details |
| Offer previous annual bonus | Active offer previous annual bonus |
| Offer previous anticipated start | Active offer previous anticipated start |
| Offer previous bonus | Active offer previous bonus |
| Offer previous candidate address line 1 | Active offer previous candidate address line 1 |
| Offer previous candidate address line 2 | Active offer previous candidate address line 2 |
| Offer previous candidate name | Active offer previous candidate name |
| Offer previous company job posting | Active offer previous company job posting |
| Offer previous company signature 1 | Active offer previous company signature 1 |
| Offer previous company signature 2 | Active offer previous company signature 2 |
| Offer previous company signature 3 | Active offer previous company signature 3 |
| Offer previous competing offer details | Active offer previous competing offer details |
| Offer previous country | Active offer previous country |
| Offer previous date field | Active offer previous date field |
| Offer previous department | Active offer previous department |
| Offer previous direct manager | Active offer previous direct manage |
| Offer previous employment status | Active offer previous employment status |
| Offer previous equity | Active offer previous equity |
| Offer previous equity type | Active offer previous equity type |
| Offer previous exemption status | Active offer previous exemption status |
| Offer previous hours per week | Active offer previous hours per week |
| Offer previous job description | Active offer previous job description |
| Offer previous job title | Active offer previous job title |
| Offer previous level | Active offer previous level |
| Offer previous office location | Active offer previous office location |
| Offer previous relocation bonus | Active offer previous relocation bonus |
| Offer previous requires USA visa | Active offer previous Requires USA visa |
| Offer previous requires international visa | Active offer previous Requires international visa |
| Offer previous requisition | Active offer previous requisition |
| Offer previous salary | Active offer previous salary |
| Offer previous salary interval | Active offer previous salary interval |
| Offer previous signing bonus | Active offer previous signing bonus |
| Offer previous team | Active offer previous team |
| Offer previous today | Active offer previous today |
| Offer previous verbal status | Active offer previous verbal status |
| Offer previous vesting cliff | Active offer previous vesting cliff |
| Offer previous work authorization | Active offer previous work authorization |
| Offer previous work authorize status | Active offer previous work authorize status |
| Offer relocation bonus is same as previous (yes/no) | Indicates whether the previous relocation bonus is the same as the current relocation bonus.(Yes/No) |
| Offer required US visa is same as previous (yes/no) | Indicates whether the previous visa USA is the same as the current visa USA.(Yes/No) |
| Offer required international visa is same as previous (yes/no) | Indicates whether the previous visa international is the same as the current visa international.(Yes/No) |
| Offer requisition is same as previous (yes/no) | Indicates whether the previous requisition is the same as the current requisition.(Yes/No) |
| Offer salary interval is same as previous (yes/no) | Indicates whether the previous salary interval is the same as the current salary interval.(Yes/No) |
| Offer salary interval is same as previous (yes/no) | Indicates whether the previous salary interval is the same as the current salary interval.(Yes/No) |
| Offer salary is same as previous (yes/no) | Indicates whether the salary is the same as the current salary.(Yes/No) |
| Offer salary is same as previous (yes/no) | Indicates whether the previous salary is the same as the current salary.(Yes/No) |
| Offer signing bonus is same as previous (yes/no) | Indicates whether the previous signing bonus is the same as the current signing bonus.(Yes/No) |
| Offer verbal status is same as previous (yes/no) | Indicates whether the previous verbal offer status is the same as the current verbal offer status.(Yes/No) |
| Offer vesting cliff is same as previous (yes/no) | Indicates whether the previous vesting cliff is the same as the current vesting cliff.(Yes/No) |
| Offer work authorization is same as previous (yes/no) | Indicates whether the previous work authorization is the same as the current work authorization.(Yes/No) |
| Offer form fields pivot | |
| DIMENSIONS | |
| Filter fields | |
| Offer field previous value | Offer field previous value. |
| Offer field value | Offer field value. |
| Offer ID** | The identifier of the offer for the opportunity |
| Pivot fields | |
| Offer field label (pivot)** | Offer field label. This is the preferred pivot on this field. |
| Offer field identifier | Offer field identifier. The identifier may be used as a pivot. |
| MEASURES | |
| Offer values pivoted** | Pivot by requisition field label or identifier. This is useful primarily for downloads. |
| Offer previous value pivoted | Pivot by requisition field label or identifier. This is useful primarily for downloads. |
| Nurture campaigns (1:n) | |
| DIMENSIONS | |
| Nurture status (1:n) | The nurture status of an opportunity. |
| Nurture template (1:n) | A nurture campaign start date. |
| Is campaign active (yes/no) (1:n) | Opportunity is part of a active nurture campaign. |
| Is opportunity part of campaign (yes/no) (1:n) | The opportunity is part of a current/past nurture campaign. |
| Nurture start date (UTC) (1:n) | A nurture campaign start date. |
| Nurture complete date (UTC) (1:n) | A nurture campaign complete date. |
| Sources (1:n) | |
| DIMENSIONS | |
| Opportunity primary source | The primary source on the opportunity. |
| Opportunity source (1:n) | A source on the opportunity |
| Source application rank (1:n) | The order in which sources that came from the applications process were applied to the opportunity. |
| Source opportunity rank (1:n) | The order in which sources that came from the opportunities process were applied to the opportunity. Tip: To see the first source only, filter this field, Source opportunity rank (1:n) = 0 |
| Source rank (1:n) | The ranking of the source. There are two origins of sources, applications and opportunities. The lower the ranking, the source was applied first. |
| Source type (1:n) | The origin of the source. There are two origins of sources, applications and opportunities. A source can come from one or both. |
| Opportunity source id (1:n) | The ID of a opportunity-source combination |
| Tags (1:n) | |
| DIMENSIONS | |
| Tag (1:n) | The tag. |
| Tag rank (1:n) | The rank of the tag on the opportunity. |
| Tag ID (1:n) | The ID of the tag. A tag ID can be attached to many opportunities, |
| Opportunity tag ID (1:n) | The id of the opportunity and tag relationship. |
| Forms (1:n) | |
| DIMENSIONS | |
| Form attributes | |
| Answer user name | Answer provider name. |
| Feedback user email | Feedback provider email. |
| Form name | Form name |
| Form type | Form type. A 'not null' filter will exclude comments and scores that are only tied to the opportunity and not to a form. |
| Form type capitalized | Form type id that is capitalized. |
| Question | The text of the question. |
| Interview forms | |
| Interview stage | The stage when the panel is created. |
| Interview time zone | The time zone of the interview. |
| Interview start second (UTC) | The start of the interview (UTC). |
| Panel completed second (UTC) | The completion of the interview panel (UTC). |
| Forms created dates | |
| Form created date | The date the form was created. date |
| Form created hhmm | The date the form was created. hhmm |
| Form created millisecond | The date the form was created. millisecond |
| Form created week | The date the form was created. week |
| Form created month | The date the form was created. month |
| Form created quarter | The date the form was created. quarter |
| Form created year | The date the form was created. year |
| Form created date (UTC) | The date the form was created. date (UTC) |
| Form created hhmm (UTC) | The date the form was created. hhmm (UTC) |
| Form created second (UTC) | The date the form was created. second (UTC) |
| Form created millisecond (UTC) | The date the form was created. millisecond (UTC) |
| Form created month (UTC) | The date the form was created. month (UTC) |
| Form created quarter (UTC) | The date the form was created. quarter (UTC) |
| Form created year (UTC) | The date the form was created. year (UTC) |
| Form created calculation date (UTC) | Field is meant for Custom Fields date calculations such (diff_days etc.). The date the form was created. calculation date |
| Ids | |
| Form interview ID | Feedback form interview id. |
| Form template ID | Form template id |
| Form user id | Form user id. |
| Opportunity form id | Feedback form id. |
| Form answers (1:n) | |
| DIMENSIONS | |
| Answers | |
| Answer | A consolidation of answers into a single format for display |
| Answer detail key | Include this key in the result set to guarantee detail. Hint: Hide the Detail key. Do not include if aggregating. |
| Currency code | The currency code associated with a form field value. |
| Feedback type | The field type of the feedback |
| Interviewers average feedback | The average of interviewers feedback for an opportunity. |
| Note opportunity | An opportunity note. The note is connected to the opportunity, not to a form. |
| Note score | The notes that often accompanies a form score |
| Opportunity note (yes/no) | Is this an opportunity note where the note is connected to the opportunity, not to a form. |
| Score comment | Opportunity scores or scores from feedback forms. |
| Scores | Opportunity scores and scores from feedback forms. |
| Files | |
| Uploaded file extension | The file extension of the file that was uploaded. |
| Uploaded file minute | The time the file was uploaded |
| Uploaded file name | The name given to the uploaded file. |
| Uploaded file url | The location of the file that was uploaded |
| MEASURES | |
| Answers | |
| Answer (pivot) | The answer to the question. Use with a pivoted question. |
| Surveys | |
| DIMENSIONS | |
| Survey attributes | |
| Form template ID | The ID of the form template used in the survey |
| Is enabled for applications | The survey is enabled for use with applications |
| Survey ID | The ID of the survey |
| Survey delivered (yes/no) | Has the survey been delivered. Yes if there is a delivery date. |
| Survey enabled for email | The survey is enabled for use with email |
| Survey is enabled | The survey is enabled. |
| Survey responded (yes/no) | Is there a survey response. Yes if there is a response date |
| Survey template name | The name of the survey form template used in the survey |
| Survey type | The type of the survey |
| Responses | |
| Survey collection method | The collection method of the survey. |
| Survey collection status | The collection status of the survey. |
| Survey response ID | The ID grouping the responses to a survey. Used to organize survey responses at the opportunity level |
| Survey created dates | |
| Survey created date | The date the survey was created. millisecond |
| Survey created hhmm | The date the survey was created. hhmm |
| Survey created millisecond | The date the survey was created. millisecond |
| Survey created week | The date the survey was created. week |
| Survey created month | The date the survey was created. month |
| Survey created quarter | The date the survey was created. quarter |
| Survey created year | The date the survey was created. year |
| Survey created date (UTC) | The date the survey was created. date (UTC) |
| Survey created hhmm (UTC) | The date the survey was created. hhmm (UTC) |
| Survey created millisecond (UTC) | The date the survey was created. millisecond (UTC) |
| Survey delivered dates | |
| Survey delivered date | The date the survey was delivered. millisecond |
| Survey delivered hhmm | The date the survey was delivered. hhmm |
| Survey delivered millisecond | The date the survey was delivered. millisecond |
| Survey delivered week | The date the survey was delivered. week |
| Survey delivered month | The date the survey was delivered. month |
| Survey delivered quarter | The date the survey was delivered. quarter |
| Survey delivered year | The date the survey was delivered. year |
| Survey delivered date (UTC) | The date the survey was delivered. date (UTC) |
| Survey delivered hhmm (UTC) | The date the survey was delivered. hhmm (UTC) |
| Survey delivered millisecond (UTC) | The date the survey was delivered. millisecond (UTC) |
| Survey responded dates | |
| Survey responded date | The date the survey was responded. millisecond |
| Survey responded hhmm | The date the survey was responded. hhmm |
| Survey responded millisecond | The date the survey was responded. millisecond |
| Survey responded week | The date the survey was responded. week |
| Survey responded month | The date the survey was responded. month |
| Survey responded quarter | The date the survey was responded. quarter |
| Survey responded year | The date the survey was responded. year |
| Survey responded date (UTC) | The date the survey was responded. date (UTC) |
| Survey responded hhmm (UTC) | The date the survey was responded. hhmm (UTC) |
| Survey responded second (UTC) | The date the survey was responded. second (UTC) |
| Survey responded millisecond (UTC) | The date the survey was responded. millisecond (UTC) |
| MEASURES | |
| Aggregates | |
| Surveys delivered count | The count of distinct surveys delivered. |
| Surveys response count | The count of distinct survey responses. |
| Surveys response rate | The count of distinct survey responses. |
| Survey answers (1:n) | |
| DIMENSIONS | |
| Answers (1:n) | |
| Survey response answer | The answer. |
| Score | The score of satisfaction questions where the question type = rating-scale-satisfaction. |
| Survey question text | The question |
| Is satisfaction question (yes/no) | The type of question is rating-scale-satisfaction |
| Survey question type | The type of question |
| Survey answer index | The answer index. Used to organize the sort order of survey answers. |
| Survey question index | The question index. Used to order the questions. |
| Survey question ID | The question ID. |
| Survey response answer ID | The answer ID for answer |
| MEASURES | |
| Aggregates | |
| Average score | The average score of satisfaction questions where the question type = rating-scale-satisfaction. |
| Answers | |
| Survey response answer | The survey response answer. This field is intended for the special use case of pivoting the answer. |
| Survey tracking (1:n) | |
| DIMENSIONS | |
| Survey response tracking key (1:n) | The tracking key for the responses to a survey. Each survey can have multiple tracking keys for associating the survey to something. The tracking key should be used mainly for filtering and grouping. |
| Survey tracking index (1:n) | The tracking index for the responses to a survey |
| Tracking value (1:n) | The value for the tracking key. |
| Survey response tracking ID (1:n) | The tracking ID for responses. It represent a tracking key on a survey response. |
| Survey triggers (1:n) | |
| DIMENSIONS | |
| Trigger attributes | |
| Email template name (1:n) | The name of the email template for a survey trigger |
| Email template subject (1:n) | The subject of the email template for a survey trigger |
| Survey trigger type (1:n) | The type of event that triggers the survey to be delivered |
| Ids | |
| Email setting ID (1:n) | The ID of the email setting for the survey trigger. |
| Email template ID (1:n) | The ID of the email template for a survey trigger. |
| Survey trigger ID (1:n) | The ID of the survey trigger. |
| Trigger archive reason ID (1:n) | The archive reason ID that triggers a survey delivery |
| Trigger stage ID (1:n) | The stage ID that triggers a survey delivery |
| Date intervals | |
| FILTER_ONLY FIELDS | |
| Controls the granularity of the date being displayed. This only works on dates that have (interval) in their title. | |
| DIMENSIONS | |
| Opportunity dates | |
| Contact created interval | Contact create date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Hired interval | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Last activity interval | Opportunity last activity date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Last advanced interval | Opportunity last advanced date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Opportunity archived interval | Opportunity archive date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Opportunity created interval | Opportunity create date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Contact created interval (UTC) | Contact create date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Hired interval (UTC) | The opportunity hire date. (The date the opportunity is archived with the reason of HIRED.) The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Last activity interval (UTC) | Opportunity last activity date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Last advanced interval (UTC) | Opportunity last advanced date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Opportunity archived interval (UTC) | Opportunity archive date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Opportunity created interval (UTC) | Opportunity create date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Posting dates | |
| Postings created interval | The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Postings created interval (UTC) | The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer dates | |
| Offer first signed interval | Offer first signed date The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer sent interval | Offer first sent date The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer first signed interval (UTC) | Offer first signed date The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer sent interval (UTC) | Offer first sent date The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer acceptance dates | |
| Offer outcome last sent interval | The last sent date before the outcome of an offer The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Offer outcome last sent interval (UTC) | The last sent date before the outcome of an offer The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey dates | |
| Survey create interval | Survey created at The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey delivered interval | Survey delivered at. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey responded interval (UTC) | Survey responded at. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey created interval (UTC) | Survey create date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey delivered interval (UTC) | Survey deliver date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Survey responded interval (UTC) | Survey response date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Historical stage dates (1:n) | |
| Stage enter interval (1:n) | Pipeline event stage enter date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Stage exit interval (1:n) | Pipeline event stage exit date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Stage enter interval (UTC) (1:n) | Pipeline event stage enter date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Stage exit interval (UTC) (1:n) | Pipeline event stage exit date. The date interval (Year, quarter, month, week) as controlled by the dynamic interval filter. If the dynamic interval filter is not set, the interval defaults to month. |
| Stage conversions (1:n) | |
| DIMENSIONS | |
| Conversion attributes | |
| Event Type | The event type associated with each conversion |
| Event key | The unique key associated with each conversion |
| Conversion from | |
| From stage | The stage that is the source of the movement. |
| From milestone | The milestone that is the source of the movement. |
| From milestone (sort) | Provides a sorted version of the from milestone (Ascending lead, applicant, interview) |
| From pipeline | The pipeline that is the source of the movement. |
| From pipeline (sort) | Provides a sorted version of the from pipeline (Ascending lead, applicant, interview) |
| From rank | Rank. Use as a hidden (Hide from visualization) sort. |
| From stage ID | The stage ID that is the source of the movement. |
| Conversion to | |
| To stage location | Converted to location |
| To milestone (sort) | To milestone. Sorted by lead, applicant, screen, onsite, offer. |
| To milestone location | The milestone that is the destination of the conversion. |
| To pipeline | The pipeline that is the destination of the conversion. |
| To pipeline (sort) | To pipeline. Sorted by lead, applicant, interview. |
| To stage | Converted to stage |
| To stage ID | Converted to stage ID |
| To stage rank | Converted to stage rank |
| Conversion movements | |
| Advanced conversion | Conversion - advanced. 1 if the next stage has a higher rank, otherwise 0. |
| Archive conversion | Conversion - archived. 1 if the next stage was an archive, otherwise 0. |
| Hired conversion | Hired conversion. 1 if the next stage was a hire, otherwise 0. |
| Moved back conversion | Move back conversion. 1 if the next stage was an archive, otherwise 0. |
| Advanced milestone | Conversion - milestone advanced. 1 if the next milestone was a advance, otherwise 0. |
| Archived milestone | Conversion - milestone archive. 1 if a archive, otherwise 0. |
| Hired milestone | Conversion - milestone hire. 1 if a hire, otherwise 0. |
| Moved back milestone | Conversion - milestone moved back. 1 if the next milestone moved back, otherwise 0. |
| Conversion durations | |
| Days in stage | The time in days in this stage. |
| Days to advance | The number of days spent in a stage before advancing |
| Days to archive | The number of days spent in the stage before archiving |
| Days to hire | The number of days spent in final stage before hiring |
| Days to move back | The number of days spent in a stage before moving back |
| Conversion dates | |
| Stage enter date | The stage entry date. |
| Stage exit date | The stage exit date. |
| Stage enter date (UTC) | The stage entry date. |
| Stage exit date (UTC) | The stage exit date. |
| MEASURES | |
| Conversion average duration | |
| Days in stage | The time in days in this stage. |
| Avg. days to advance | The average number of days in the stage before advancing. |
| Avg. days to archive | The average number of days in the final stage before archive conversion. |
| Avg. days to hire | The average number of days in the final stage before hire conversion |
| Avg. days to move back | The average number of days in the stage before moving back. |
| Conversion counts | |
| Conversion count | The total number of conversions including advanced, moved back, archived and hired. |
| Advanced count | The total number of advanced conversions. |
| Archived count | The total of archived conversions. |
| Hired count | The total of hired conversions. |
| Moved back count | The total of conversions that moved back. |
| Milestone conversions | The total number of milestone conversions. |
| Archived milestone count | The number of archived conversions that occurred from the milestone. |
| Hired milestone count | The total number of hired conversions that occurred from the milestone |
| Moved back milestone count | The total number of conversions that moved back a milestone. |
| Advanced milestone total | The total number of milestone advances. |
| Conversion percents | |
| Advanced percent | The percentage of advanced conversions to total conversions. |
| Archived percent | The percentage of archived conversions to total conversions. |
| Hired percent | The percentage of hired conversions to total conversions. |
| Moved back percent | The percentage of conversions that moved back to total conversions. |
| Advanced Ratio | The percentage of advanced conversions to total conversions. |
| Archived ratio | The percentage of archived conversions to total conversions. |
| Hired ratio | The ratio of hired conversions to total conversions. |
| Moved back ratio | The percentage of conversions that moved back to total conversions. |
| Advanced milestone percent | The percentage of advanced milestone conversions to total conversions. |
| Archived milestone percent | The percentage of archived milestone conversions to total conversions. |
| Hired milestone percent | The milestone percentage of hired conversions to milestone movements. |
| Moved back milestone percent | The percentage of conversions that moved back to total conversions. |
| Pipeline stage events (1:n) | |
| FILTER_ONLY FIELDS | |
| Pipeline date filter ** | On dashboards, associate the filter to date fields to control. The default start date is 1970-01-01. The default end date is tomorrow. Some stage calculations use the filter. The picker label will indicate 'Use Stage filter' |
| Pipeline event type filter (1:n) | This filters the events table. 'Stage events' are events that affect stages. This is the default value if the filter is no used. 'Stage and snooze events' are the stage events and snooze events. 'All' includes all events. |
| DIMENSIONS | |
| Pipeline attributes(1:n) | |
| Duration days spent in stage (1:n) | Days spent in completed stage, Only stages that have been exited are included. |
| Stage milestone (1:n) | The milestone of the stage for a pipeline stage change event. |
| Stage milestone (sort) (1:n) | The milestone of the stage for a pipeline stage change event. Sorted by rank. |
| Stage milestone name (1:n) | The milestone of the stage for a pipeline stage change event. Use for filtering. |
| Stage name (1:n) | The stage name for a pipeline stage change event. |
| Stage name (sorted) (1:n) | The stage name for a pipeline stage change event. Sorted by rank. |
| Stage pipeline name (1:n) | The pipeline of the stage for a pipeline stage change event. Sorted by rank. |
| Stage pipeline name (1:n) | The pipeline of the stage for a pipeline stage change event. |
| Stage pipeline name (1:n) | The pipeline of the stage for a pipeline stage change event. |
| Stage rank (1:n) | The rank of the stage for a pipeline stage change event. |
| Previous stage enter date (1:n) | For a stage, when was the previous stage entered. |
| Previous stage id (1:n) | The previous stage id for a pipeline stage change event. |
| Previous stage milestone (1:n) | Previous stage milestone name for a pipeline stage change event |
| Previous stage name (1:n) | The previous stage name for a pipeline stage change event. |
| Previous stage pipeline (1:n) | Previous pipeline name for a pipeline stage change event |
| Previous stage rank (1:n) | Previous stage rank for a pipeline stage change event |
| Stage archive reason (1:n) | The archive reason of the stage for a pipeline stage change event. |
| Stage event key (1:n) | The key representing the row of a stage movement. Use this key when doing calculations |
| Stage event name (short) | The stage event that put the opportunity in this stage. |
| Pipeline conditions (1:n) | |
| Is stage complete (yes/no) (1:n) | Has the opportunity moved from this stage. |
| Stage has interview (yes/no) (1:n) | Does this stage has an interview associated with it. |
| Stage date conditions (1:n) | |
| Is stage enter in timeframe (UTC) (use Stage date filter) (1:n) | Is the stage enter time (UTC) within the date range of the Stages date filter . |
| Is stage enter in timeframe (use Stage date filter) (1:n) | Is the stage enter time within the date range of the Stages date filter . |
| Is stage exit in timeframe (UTC) (use Stage date filter) (1:n) | Is the stage exit time (UTC) within the date range of the Stages date filter . |
| Is stage exit in timeframe (use Stage date filter) (1:n) | Is the stage exit time within the date range of the Stages date filter. |
| Is stage in snapshot (UTC) (use Stage date filter)(1:n) | Is the stage a snapshot event? For non archive events, the stage enter date (UTC) is less than the end date of the date range of the Stages date filter and the stage exit date (UTC) is greater than the end of the date range of the Stages date filter. For archive events, the stage enter date (UTC) must also be greater than the start of the date range of the Stages date filter. |
| Is stage in snapshot (use Stage date filter)(1:n) | Is the stage a snapshot event? For non archive events, the stage enter date is less than the end date of the date range of the 'Stages date filter' and the stage exit date is greater than the end of the date range of the 'Stages date filter'. For archive events, the stage enter date must also be greater than the start of the date range. |
| Duration (1:n) | |
| Opportunity create to stage enter (1:n) | The duration from the opportunity created date to entering the stage for a pipeline stage change event |
| Opportunity create to stage exit (1:n) | The duration from the opportunity created date to exiting the stage for a pipeline stage change event |
| Pipeline history (1:n) | |
| Active seconds (1:n) | Seconds spent active in a completed stage |
| Days active in stage (1:n) | Days spent in completed stage, Only stages that have been exited are included. |
| Duration days spent in stage (1:n) | Days spent snoozing a in completed stage, Only stages that have been exited are included. |
| Snoozing day in stage (1:n) | Days spent snoozing in a stage, All stages are included. If the snooze was started and ended during the current stage this field is updated. |
| Snoozing seconds (1:n) | Seconds spent snoozing in a completed stage |
| History stage enter dates (1:n) | |
| Stage enter date (1:n) | The stage entry date. |
| Stage enter hhmm (1:n) | The stage entry date. |
| Stage enter millisecond (1:n) | The stage entry date. millisecond |
| Stage enter week (1:n) | The stage entry date. |
| Stage enter month (1:n) | The stage entry date. |
| Stage enter quarter (1:n) | The stage entry date. |
| Stage enter year (1:n) | The stage entry date. |
| Stage enter date (UTC) (1:n) | The stage entry date. |
| Stage enter hhmm (UTC) (1:n) | The stage entry date. |
| Stage enter millisecond (UTC) (1:n) | The stage entry date. |
| Stage enter second (UTC) (1:n) | The stage entry date. |
| History stage exit dates (1:n) | |
| Stage exit date (1:n) | The stage exit date. |
| Stage exit hhmm (1:n) | The stage exit date. |
| Stage exit millisecond (1:n) | The stage exit date. |
| Stage exit millisecond (UTC) (1:n) | The stage exit date. |
| Stage exit week (1:n) | The stage exit date. |
| Stage exit month (1:n) | The stage exit date. |
| Stage exit quarter (1:n) | The stage exit date. |
| Stage exit year (1:n) | The stage exit date. |
| Stage exit date (UTC) (1:n) | The stage exit date. |
| Stage exit hhmm (UTC) (1:n) | The stage exit date. |
| History previous stage enter (1:n) | |
| Previous stage enter hhmm (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter millisecond (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter week (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter month (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter quarter (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter year (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter date (UTC) (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter hhmm (UTC) (1:n) | For a stage, when was the previous stage entered. |
| Previous stage enter millisecond (UTC) (1:n) | For a stage, when was the previous stage entered. |
| MEASURES | |
| Duration (1:n) | |
| Avg. candidate time in completed stage (1:n) | The average time spent in a stage. Only stages that have been exited are included. |
| Median candidate time in completed stage (1:n) | The median time spent in a stage. Only stages that have been exited are included. |
| History stage enter dates (1:n) | |
| Stage enter date (UTC) (list) (1:n) | The stage entry date.. Use for when this date is a measure in a pivot. Otherwise use the dimension. |
| Stage enter date (UTC) (max) (1:n) | The stage entry date.. The most recent time to enter a stage. |
| Stage enter second (UTC) (1:n) | The stage entry date.. Use for when this date is a measure in a pivot. Otherwise use the dimension. |
| Stage enter second (UTC) (max) (1:n) | The stage entry date.. The most recent time to enter a stage. |
| Email events (1:n) | |
| DIMENSIONS | |
| Email events summary | |
| Email sent (Yes/No) | Was an email sent? |
| Emails sent | The number of emails sent. Each email is sent only once. |
| Open events | The number of times emails have been opened. Some emails are opened more than once. Each open event is counted. |
| Opened emails | The number of opened emails. An email is counted as open only once, even if has many open events. |
| First sent at date | The first email sent event for the opportunity. |
| Last event at date | The last email open event by the opportunity. |
| Last opened at date | The last email open event by the opportunity. |
| Last sent at date | The most recent email sent event for the opportunity. |
| First sent at date (UTC) | The first email sent event for the opportunity. |
| Last event at date (UTC) | The last email event. |
| Last opened at date (UTC) | The last email open event by the opportunity. |
| Last sent at date (UTC) | The most recent email sent event for the opportunity. |
| Email event attributes (1:n) | |
| Email subject (1:n) | The id of the email event. Can be used to force email event granularity, |
| Event type (1:n) | The type of the email event. |
| Event id (1:n) | The id of the email event. Can be used to force email event granularity, |
| Event email id (1:n) | The id of the email. A email can have multiple events associated with it. It will be sent only once. |
| Email event dates (1:n) | |
| Email created date (1:n) | The time the email event occurred. |
| Event at date (1:n) | The time the email event occurred. |
| Email created date (UTC) (1:n) | The time the email event occurred. |
| Event at date (UTC) (1:n) | The time the email event occurred. |
| General | |
| FILTER_ONLY FIELDS | |
| Standard Date filter | Very handy generic filter for dashboards. On dashboards, associate the filter to date fields to control. The default start date is 1970-01-01. The default end date is tomorrow. Some calculations (such as average time in pipeline) use the filter. The picker label will indicate 'Use Standard filter'. |
| DIMENSIONS | |
| Now | |
| Now date | Now in your local time zone |
| Now hhmm | Now in your local time zone |
| Now millisecond | Now in your local time zone |
| Now date (UTC) | Now in UTC time. (Universal Time Coordinated) |
| Now hhmm (UTC) | Now in UTC time. (Universal Time Coordinated) |
| Now millisecond (UTC) | Now in UTC time. (Universal Time Coordinated) |
| Standard date filter start | The value the filter used as the end date. If no start date is supplied, 1970-01-01 is used. Typically used only for understanding what values the filter is using. |
| Local time zone {{ _user_attributes['lever_hire_user_timezone'] }} | The local time in the Lever hire application. |
| Standard date filter end | The value the filter used as the end date. If no end date is supplied, tomorrow is used. Typically used only for understanding what values the filter is using. |
| MEASURES | |
| Tally (generic count) | A generic count equal to the number of records returned by a query. |