What a promotion pays

Six workers moved up a grade in May. Their combined base went from 720,000.00 to 790,560.00, an average increase of 9.8 percent, and every one landed inside its new band. The report shows each move against its destination range.

RulePrice a promotion against the destination range: the new base must land inside the new grade’s band, and the report proves it row by row.

Neverreport promotion increases as an average alone. Six moves averaging 9.8 percent can hide one at four and one at sixteen.

◆ The May movessix promotions, each priced against its new band.

Grade move and department	Old base	New base	Increase %
G2 to G3, Support	98,000.00	107,800.00	10.0
G3 to G4, Technology Delivery	112,000.00	122,304.00	9.2
G3 to G4, Sales	126,000.00	139,104.00	10.4
G4 to G5, Technology Delivery	130,000.00	141,700.00	9.0
G3 to G4, Sales	124,000.00	137,020.00	10.5
G4 to G5, Sales	130,000.00	142,632.00	9.7
Six moves	720,000.00	790,560.00	9.8

Every new base lands inside its destination band on the grade structure: the two G5 moves sit low in a 125,000.00 to 175,000.00 range, which is where a fresh promotion should sit. These six are the same six the change ledger counts for May. Sample values are illustrative, never client data.

◆ Why the destination range decidesthe increase is the output, not the input.

Pricing a promotion as a flat percentage produces new pay that ignores where the worker lands in the new band. Price against the destination range instead: low in band for a stretch move, nearer midpoint for a proven one. The percentage then falls out, and the spread above, nine to ten and a half, is the evidence of case-by-case pricing.

◆ The owned answerpromotions from the event fact, bands from the grade dimension.

A promotion is a pay change event with a grade move; the report joins each event to the destination range and computes position in band at landing.

-- May promotions priced against their destination bands
SELECT e.worker_id, e.old_base, e.new_base,
       g.range_min, g.range_max,
       ROUND((e.new_base - g.range_min) * 100.0
             / (g.range_max - g.range_min), 0) AS landing_penetration_pct
FROM fct_comp_event e
JOIN dim_comp_grade g ON g.grade_key = e.new_grade_key
WHERE e.reason = 'Promotion'
  AND e.effective_date BETWEEN '2026-05-01' AND '2026-05-31'

Use case

Problem

Promotion increases are set by habit percentages, reported as one average, and occasionally land outside the new grade’s range entirely.

What we build

Promotion events joined to destination ranges: each move shown with old base, new base, the increase, and where it lands in the new band.

What you get

Promotions you can calibrate: six rows instead of one average, every landing inside its band, and the stretch-versus-proven pricing visible.

Do your promotions land inside their new bands?

We build the report that prices every move against its destination range.

Talk to us

Terms on this page

promotion: A grade move with a pay change, one event in the ledger.
destination range: The new grade’s minimum to maximum; the pricing frame.
landing position: Where the new base sits in the destination band.
stretch move: An early promotion, priced low in the new band on purpose.
habit percentage: A flat increase applied without looking at the band; the anti-pattern.