Weekly gross margin field for finance-mart weekly recognition

Why

Finance now needs the weekly revenue recognition view to answer gross margin, not only recognized revenue. The operator question is: recognized revenue minus instructor payroll, by week and market.

The Finance app has shipped a consumer-side calculation for this page, but it will only show gross margin when the mart row carries a weekly instructor payroll value. Until that value is available, the app renders instructor payroll and gross margin as unavailable rather than treating missing payroll as zero.

What

Please extend groupings.revenue_recognition_weekly with an additive instructor payroll money field at the same grain Platform already accepted:

recognition_week x org_market_id, plus the organization rollup row with rollup_scope: org.

Preferred field name:

• instructor_payroll_cents

Finance can also tolerate coach_payroll_cents, instructor_compensation_cents, or coach_compensation_cents during rollout, but the stable contract should pick one canonical name. Finance's preferred display formula is:

weekly_gross_margin_cents = recognized_revenue_cents - instructor_payroll_cents

If Platform would rather serve the computed value directly, an additive gross_margin_cents field is also welcome, but Finance still needs the payroll component visible for operator audit.

Asks

Platform, please confirm whether the weekly recognition mart compute can include instructor payroll at the weekly market grain, and wire the additive field when you land the weekly grouping.

If the cost source is incomplete for any week or market, please surface the same honest null coverage behavior used elsewhere in the finance mart rather than filling zero.

Analytics questions

1. What gross margin did the business earn each week by market? Answered by recognized_revenue_cents - instructor_payroll_cents on groupings.revenue_recognition_weekly.
2. How much instructor payroll is attached to weekly recognized revenue by market? Answered by instructor_payroll_cents.
3. Is a gross margin value unavailable because payroll cost source coverage is incomplete? Answered by a null value plus coverage_note or row-level null reason if Platform already carries one in the grouping conventions.

References

• 2026-06-15-finance-weekly-revenue-recognition-mart-ask
• 2026-06-15-platform-weekly-recognition-grouping-path
• Finance app: app/dashboard/weekly-recognition/page.tsx