Compensation analytics in Dashboards and Reports

Compensation analytics live in "Analytics > Dashboards" and "Analytics > Reports". With these analytics, you can:

• Use the ready-made Compensation dashboard
• Build your own compensation widgets and combine them with other HR data, such as headcount, tenure or diversity
• Add compensation cycle data to reports and exports

Please note: Budget, budget spent and budget left are not part of the analytics. Budget analytics live inside each compensation cycle.

Table of Contents

Accessing compensation analytics
The Compensation dashboard
Choosing cycles
How the numbers are calculated
Widgets on the dashboard
Building your own compensation widgets
Compensation data in Reports
Sharing dashboards and reports that contain compensation data

Accessing compensation analytics

To view compensation data, you need:

• The Compensation module enabled
• The View compensation analytics permission in the Feature Access Matrix
• Access to the relevant dashboard or report through its visibility group

Super-admins have the permission automatically. Users who already have full compensation access receive it as well. An admin can grant it to other access roles.

The permission controls access to compensation data; it does not, by itself, grant access to every dashboard or report. Compensation admins can access the default Compensation dashboard through a visibility group for their access role.

Please note: Managers, cycle owners, and cycle creators who previously viewed analytics scoped to their own cycles and participants will no longer have that scoped view on the standalone page. They need the appropriate access described above to view compensation analytics in Dashboards & Reports.

The Compensation dashboard

A default Compensation dashboard is created automatically for every account with the Compensation module. You'll find it under "Analytics > Dashboards".

The widgets on the default dashboard can't be edited, which keeps it consistent with other default dashboards. To change it, duplicate the dashboard and edit your copy.

Choosing cycles

Use the Compensation cycle filter at the top of the dashboard to choose which cycles the widgets show.

• By default, the dashboard shows all active cycles. If there are no active cycles, it shows the cycles closed in the last 6 months. Drafts and templates are never included.
• You can choose any specific cycles, including closed ones.
• Trend widgets also show cycles closed in the last 3 years, so you can see more than one or two data points.

Please note: Compensation widgets ignore the dashboard's Timeframe and Status filters. Everyone with a proposal in the selected cycles is counted, including people who have since left the company. Without this, totals for closed cycles would shrink every time someone leaves.

How the numbers are calculated

• Each person is counted once, even if they have proposals in several of the selected cycles.
  • A person counts as active if any of their proposals isn't signed off yet. They count as signed off only when all of their proposals are signed off.
  • A person counts as overdue if any of their proposals is overdue, and as signed off late if any of their proposals was signed off after its deadline.
• Averages and medians use one value per person: their latest signed-off proposal in the selected cycles.
  • Averages and medians use full-time equivalent pay, so a part-time employee's pay is converted to what they'd earn full time. Totals use actual pay.
• Pay means total pay (salary + bonus), shown as a yearly amount. Monthly pay is multiplied by 12, and hourly pay by weekly hours × 52. Bonuses count as yearly.
  • A salary with no pay period set is treated as yearly.
  • An hourly employee with no weekly hours is left out, not counted as 0.
• All amounts are in the company currency, converted with each cycle's exchange rates.
• People who belong to several teams are counted in each of their teams.

Widgets on the dashboard

All pay widgets show total pay (salary + bonus) as a yearly amount in your company currency.

Overall summary

• Employees with active proposals: people with at least one proposal that isn't signed off yet
• Employees with signed off proposals: people whose proposals are all signed off
• Employees with overdue proposals: people with a proposal that isn't signed off and is past the cycle's sign-off deadline
• Employees signed off late: people with a proposal that was signed off after the cycle's sign-off deadline

Pay overview (signed-off proposals only)

• Total raise amount: the sum of all raises
• Final pay after the cycle: the sum of everyone's pay after the cycle

Pay charts (signed-off proposals only)

• Pay by team: average pay after the cycle for each team
• Average pay after the cycle by team and gender (cycle participants only): average pay after the cycle for each team, split by gender. This chart only includes people in the selected cycles, so it doesn't show your company-wide gender pay gap. For that, use the "Pay Gaps" dashboard.
• Average pay by level and Median pay by level: each person is shown under their level after the cycle. For example, someone promoted from Level 2 to Level 3 appears under Level 3 with their new pay.

Averages and medians use full-time equivalent pay, so part-time employees can be compared fairly.

Promotions (signed-off proposals only)

• Who got promoted, by team, by gender and by location: how the people who got promoted are spread across teams, genders and locations
• Promoted with and without a pay bump: promoted people whose salary or bonus went up, compared with promoted people whose pay didn't change
• Promotion rate by gender: for each gender, the share of people with a signed-off proposal in a promotion cycle who got promoted

Building your own compensation widgets

If you have the View compensation analytics permission and can edit a dashboard, you can add compensation widgets to it, either on a copy of the Compensation dashboard or on any other dashboard.

1. Open the dashboard and add a widget.
2. Select the Compensation cycle data source.
3. Choose a Measure: Employee count, Raise amount, Pay at kickoff, Proposed pay, Pay after the cycle or Promotion rate.
4. For pay measures, choose a Pay component: Salary, Bonus or Total pay.
5. Choose how to group and display the data, then save.

When you add a compensation widget, a few things change on the dashboard automatically:

• The Compensation cycle filter is added to the dashboard.
• The dashboard gets a Compensation tag.
• A message reminds you that only viewers with compensation access will see the widget.

Compensation data in Reports

If you have the View compensation analytics permission, you can add the Compensation cycle column in the report builder.

• One row per proposal: an employee who took part in two cycles appears in two rows. Cycle name is selected by default so you can tell the rows apart.
• Who is included: the report's Conditions decide which employees appear.
• Filters: you can filter by compensation cycle and by proposal status.
• Grouping: you can group by compensation cycle or by proposal status.

Available properties:

• Cycle details: Cycle name, Kickoff date, Sign-off deadline, Close date
• Proposal details: Proposal status (Active / Signed off), Overdue now, Signed off late, Sign-off date
• Pay: salary, bonus and total pay at kickoff, as proposed, and after the cycle
• Raises: Salary raise, Bonus raise and Total raise, as an amount and as a percentage
• Promotions and levels: Promoted, Pay bump, Level before the cycle, Level after the cycle

Every money property is available in the employee's own currency and in the company currency.

Sharing dashboards and reports that contain compensation data

Dashboards and reports with compensation data show a Compensation tag. When you share one, or add the Compensation cycle column to a report that's already shared, Leapsome reminds you that people without compensation access will see it without the compensation data.