The People Group pulls metrics reports each month, quarter, and year, as well as routinely for the People Team Group Conversation.
The monthly metrics reports can be found in the Google Drive and is only accessible to those who contribute to and review the reports, as they contain confidential information about team members and candidates. The reports contain several tabs: "Summary", "Recruiting", "SAT", "Diversity", "Low Location Factor", and "Turnover". The team is responsible for the the Low Location Factor and Turnover tabs, as well as summarizing their findings on the Summary tab. The reports are done in the month following the month that we are analyzing so that we are able to have the full picture (e.g. January's metrics report is done in February).
Average Location Factor
The average location factor of all team members per department or division. The location factor directly correlates to geographical area in the Compensation Calculator. The company wide average location factor target is < 0.65. Each division and department also has their own average location factor target.
Low Location Factor Reporting
Create the "Low Location Factor Factor Data" tab.
In columns A through E add the following information from the "Comp Data Analysis & Modeling" Google spreadsheet.
In Range? (Metrics)
In columns H and on export and past the "Low Location Factor" Report from BambooHR. Remove anyone who was hired after the last day of the reporting month and ensure any terminated team members that were active as of the last day of the month are accounted for.
Run an audit to match Employee IDs and Cities from the comp calc to BambooHR and correct any misaligned information
Copy any new hires for the reporting month into the rows above as we will report on just that month's metrics separately.
Next, update the rolling three month's tab by adding this month's new hires and removing the new hires from what would be four months ago.
Generate pivot tables on a new tab totaling the average location factor for each department and division for the reporting month, rolling last three months, and company wide average location factors.
Update and audit the figures on the "Location Factor Graphs/Summary" tab which will automatically update the graph.
Copy and paste the graph to the summary page outlining anything of importance based on the analytics.
Update the slide deck with this information as needed.
Percent Over Compensation Band
During the Location Factor reporting, People Operations Analysts will also analyze against how many team members in a division or department are compensated above the bands specific by our Global Compensation policy. To determine this, use the "In Range? (Metrics)" column from the Low Location Factor Reporting and generate a pivot table using a count of "FALSE" per department and division. Add this information to the "Location Factor Graphs/Summary" tab to generate a percentage based on total headcount per department and division as well as the raw number. The number can help explain the percentage if a department or division is small, for example.
The percent over compensation band cap is <= 1%.
TODO: Weight the percentage based on how far out of range a team member is. The Compensation and Benefits Manager will synch with the Finance Business Partner to present to the CFO.
Note: The percentages may fluctuate based on the results of our Compensation Review through Radford. If we change the compensation bands, we are also adjusting whether someone falls in or out of range.
Tracking the days it takes to complete onboarding task completion from the day the onboarding task is open to the day all People Group tasks are complete on the onboarding task. The target is still to be determined.
Ship X% of work scope within agreed timeframe
Ensuring the timeframe that is set for each specific work scope is met.
There are two parts to the turnover reporting: Turnover and Tenure.
Open the "Turnover Rates Workbook" google sheet.
Update the 2019 Term Data tab by running the "Additions and Terminations" Report in BambooHR for the reporting month. Populate the following columns, Time in Job, MOS Category, Type, Tenure in days. Carry down the average tenure and rolling 12 months tenure.
Update the Rolling Turnover tab.
Delete what would be the 13th month and add a new item in for the reporting month under rolling tenure and rolling turnover by month.
Pull the Turnover Report from BambooHR for the last rolling twelve months and update the information in the spreadsheet.
Update the 2019 Average Tenure Data Report
Pull the Average Tenure Data report from BambooHR for all active team members. Ensure anyone hired after the reporting month is removed and any terminated team members that were active at the end of the reporting month are included.
Add in the end date, and carry down the formula for tenure in days and the transfer to tenure in months/years.
Populate the summary box and transfer that data to the Rolling Turnover tab.
Copy and paste the table from the Rolling Turnover tab to the Turnover tab on the Metrics Reporting spreadsheet and the GitLab Turnover Rates workbook (viewable to the company)
Update the information on the Turnover tab: Voluntary/Involuntary term information (tag the HRBPs to update reasons), Tenure, and term percentages which update the graphs.
Add this information and a copy of the graphs to the summary tab and the slide deck as needed.
For calculating KPIs we define Team Members on the date measured as the number of full time equivalent employees or contractors who are providing services to GitLab and are listed on our Team page.
Excluded from this category are board members, board observers, core team members, and advisors.
The canonical source of truth of the number of team members comes from BambooHR.
Team Member Voluntary Turnover
Voluntary turnover is any instance in which a team member actively chooses to leave GitLab. GitLab measures voluntary turnover over a rolling 12 month period, as well as over a calendar month. (The default period is over a rolling 12 month period.) The rolling 12 month voluntary team member turnover cap is < 10%. In order to achieve the rolling 12 month voluntary team member turnover cap, the monthly voluntary team member turnover cap is < 0.83% (10/12). The data is housed in BambooHR.
Rolling Voluntary Team Member Turnover = (Number of Team Members actively choosing to leave GitLab/Average Total Team Members Count) x 100
Industry Standard Turnover is 22% overall: 15% voluntary and 7% involuntary for software companies.
Team Member Retention
Team Member Retention = (1-(Number of Team Members leaving GitLab/Average of the 12 month Total Team Member Headcount)) x 100
GitLab measures team member retention over a rolling 12 month period, as well as over a calendar month. (The default period is over a rolling 12 month period.) The 12 month team member retention target is > 84%. In order to achieve the rolling 12 month team member retention target, the monthly team member total turnover target is < 1.3% (16/12). The data is housed in BambooHR.
Spend Per Team Member
The spend per team member metric is intended to track variances across the company in compensation, discretionary bonuses, promotions, and involuntary attrition. This metric does not have an associated goal as the purpose is not to reduce costs, but instead understand the early indicators of something going wrong or what may be going well. Consistency should be the key evaluator of the KPI.
Outline any large deltas and note any takeaways for review at the next monthly metric meeting for People Ops.
Run the Promotions/Transfers report from BambooHR. Change the Showing from Active to All.
Set the conditional formatting on the Compensation Change Reason to highlight "Promotion"
Separate out all data in the month of the review to add to the rolling 12 month totals
Add columns for the Amount of USD change per year, and the percent increase by determining the values using the record in BambooHR.
Determine the Promotions Spend Summary by including Rolling 12 Month Payroll Spend (base salary and bonuses), and Average Percent Increase
Filter this information by Division, Gender, and Ethnicity by creating pivot tables.
For the Divisional breakdown, Rolling 12 Month Payroll Spend (salary and bonuses), and Average Percent Increase.
For Gender and Ethnicity, the pivot table should calculate the count of those promoted. In a column to the right of the pivot table, use the Identity Data to determine what percent of the population was promoted.
TODO as a next iteration: Work with Finance to build out a per division budget for promotions to benchmark against.
TODO: evaluate promotion stock grants per month outstanding to be able to look forward on how many options will be needed per quarter for promotions.
Run the Point in Time Report from BambooHR with the following columns: "Employee Name" "Employee #" "Division" "Department" "Job Title" as of the start of the month
Run the same report with the end of the month.
Remove the data from the month no longer part of the rolling 12 month period.
Add Columns in for Division Match, Department Match, Job Title Match and Filter by which line items are false based on the two reports
Add all Transfers to the "Transfer Analysis Tab" and add the Effective Date by looking it up in the job information table in BambooHR.
Exclude any data related to organizational moves that the person had no control over. For example, the recruiting department being separated out of People Ops is not a transfer for internal mobility into new roles.
Create a pivot table to outline the number of transfers into the division in the last rolling 12 months. Add a line for the headcount as of the last day of the rolling 12 month period. Add one more line to take the percentage of transfers into the department.
TODO Next iterations: Outline divisions those are transferring out of, generate a way to analyze compensation implications of transfers (Difficult to report since not all transfers come with a comp change).
Run the Employment Status History Report from BambooHR.
Sort by Employment Status and filter to "PIP"
Use the count function to determine the "Total Number of PIPs at GitLab"
Add the following information to the table: PIPs in last rolling 12 months, Number of PIPs Successfully completed, Number of PIPs resulting in a termination
Comment on any takeaways based on the data.
We should strive for a PIP success rate of 50% or more.
This indicates that we identity underperformance early when it is easier to remediate than later.
It also indicates to our team members a PIP means we still believe in them and want to make them successful, it isn't a one way street to job termination.
Generate a chart for the compa ratio distribution by Division.
Using the "Comp Data Analysis & Modeling" Google spreadsheet, copy over the employee ID, first name, last name, and Comp Compa Ratio columns.
Using a vlookup, add the division to the report for filtering.
Create a pivot table to take the average compa ratio based on Division.
TODO: Filter this analysis by Location, Gender, Ethnicity
TODO: Determine a way to measure roles without an compa ratio (OTE, Director, Exec)
Determine the Total Target Compensation (inclusive of OTE) as of the end of the month
Using the BambooHR report, take the max of the USD OTE and Annual USD column.
Create a pivot table to sum the values by division.
TODO: Create an average spend per headcount.