Как посчитать Revenue per Employee в SQL

Зачем Revenue per Employee

Productivity metric. SaaS gigantы (Adobe, Salesforce) — $400-600K revenue per employee. Стартап-startup — $100-200K. Если растёт revenue, но employee count растёт быстрее → producvity падает.

Формула

Revenue per Employee = Annual Revenue / Total Employees

Базовый расчёт

Данные: financials(quarter, revenue), headcount(snapshot_date, count).

WITH q_revenue AS (
    SELECT
        quarter,
        revenue * 4 AS annualized_revenue  -- quarterly × 4
    FROM financials
),
q_headcount AS (
    SELECT
        DATE_TRUNC('quarter', snapshot_date) AS quarter,
        AVG(count) AS avg_headcount
    FROM headcount
    GROUP BY 1
)
SELECT
    r.quarter,
    r.annualized_revenue,
    h.avg_headcount,
    r.annualized_revenue / NULLIF(h.avg_headcount, 0) AS revenue_per_employee
FROM q_revenue r
JOIN q_headcount h ON h.quarter = r.quarter
ORDER BY r.quarter;

Benchmarks

Тренды

SELECT
    quarter,
    revenue_per_employee,
    LAG(revenue_per_employee) OVER (ORDER BY quarter) AS prev_q,
    (revenue_per_employee / NULLIF(LAG(revenue_per_employee) OVER (ORDER BY quarter), 0) - 1) * 100 AS qoq_pct
FROM (
    -- previous query
) x
ORDER BY quarter;

Растёт = efficiency improvement. Падает = или revenue stagnant, или headcount растёт быстрее.

Частые ошибки

Ошибка 1. Total vs FTE (Full-Time Equivalent). Part-time, contractors — counts как 0.5 FTE? Decision-based.

Ошибка 2. Включать contractors / outsource. Stripe headcount excludes contractors. Иногда — нет. Document.

Ошибка 3. Annual vs quarterly. Use annualized revenue for benchmarks. Quarterly metric variance.

Ошибка 4. Newly acquired companies. M&A inflates headcount immediately, revenue takes time to integrate.

Ошибка 5. Compare cross-industry. SaaS vs Manufacturing — apples to oranges. Industry-specific benchmarks.

Связанные темы

• Как посчитать revenue в SQL
• Как посчитать ARR в SQL
• Как посчитать burn rate в SQL
• Как посчитать gross margin в SQL

FAQ

Какой Revenue per Employee considered ok?

SaaS: $300K+ — good. $500K+ — excellent. $700K+ — top-tier (Adobe, Salesforce).

Revenue per Employee падает — плохо?

Зависит. Если стартап hires aggressively pre-revenue — temporary dip OK. Если зрелый SaaS падает — concerning.

Inflate с contractors?

Если используете many contractors (counted as headcount), Revenue per Employee deflated.

Public companies benchmark?

10-K filings показывают headcount. Compare to peers.

Best Revenue per Employee growth-stage?

При раннем growth — focus on Net New ARR per employee, не total Revenue per Employee.