Comp-Plan-Modeler-Agent

Stop Modeling Comp Plans in Excel at 11 PM

When a new sales rep is hired, finance, sales ops, and the hiring manager all need a comp model: what quota, what ramp curve, what territory carve-out, what scenarios under different attainment assumptions. Today this is built by hand in Excel and signed off in email threads. The Comp Plan Modeler Agent automates the model and routes the sign-off, so the new rep's first conversation about comp is the offer letter, not a four-week back-and-forth.

Why This Lives in the Sales Marketplace

Like the Sales Hire Sourcing Agent, this is HR-adjacent work owned by the VP Sales / Sales Ops buyer, not Head of People. Sales ops already runs comp plans in tools sales operates. The agent uses CRM and territory data sales already maintains.

How It Works

When a new hire is moved to 'offer prepared' stage in Greenhouse or Lever, the agent fires. It pulls the role profile (SDR / AE / AM / Manager), the team's standard comp framework (base, OTE, accelerator structure), the territory book the hire will inherit, and the team's historical ramp curve. It builds three scenarios — conservative, plan, stretch — modeling first-year attainment and earnings, and writes the model to a Google Sheets template. Sign-off is routed through a Notion approval flow to Finance and the hiring manager.

Required Connections

• Greenhouse or Lever — ATS trigger
• Salesforce — territory book and historical attainment data
• Google Sheets — model destination
• Notion — approval flow
• Slack — sign-off notifications