
Explore the basics of sales commissions, why they matter, and how to motivate a sales team, then study commission plans, on target earnings, accelerators, and calculations in google sheets.
Learn who should learn and set sales commissions, including business owners, analysts, and sales leaders. Understand how bonuses motivate teams, design and test commission plans, and optimize targets.
Motivate the sales team with a commission system and plans to boost performance and productivity, as sales and growth teams generate revenue, profitability, and stock value for investors and stakeholders.
Explore sales team structure across the funnel from awareness to loyalty, with marketing driving awareness, SDRs handling discovery and evaluation, account executives closing deals, and growth teams driving upsell.
Learn how to motivate sales teams with a structured commission plan that blends fixed salaries with on target earnings, quotas, and varying payout schedules.
Explore how sales bonuses and commissions are calculated, covering lti on-target incentive, quota, ramping periods, capped versus uncapped pay, and acceptable pipeline versus monthly recurring revenue.
Explain quarterly and annual accelerators in sales compensation, showing how exceeding 100% multiplies bonuses and boosts motivation and retention.
Use customer relationship management systems to measure sales team performance and calculate commissions by tracking leads, potential sales, and acquired customers, using Salesforce, Microsoft Dynamics, Pipedrive, and Zoho Matrix.
Learn how CRM systems measure sales success and track leads and opportunities. Decide between Excel for simple commissions and specialized software like Spiff for larger teams, with transparent data.
Explore the components and dependencies of commissions by examining different quota types that drive revenue, pipeline, conversions, and retention, and explain how these quotas shape bonus calculations.
Explore how quotas align with sales roles, linking accepted pipeline and opportunities to conversion rates for account executives, while growth teams stress retention, churn, and expansion metrics.
Explain ramps and ramping percentages to set monthly quotas for new joiners, returning from leave, or promoted employees, and how phased targets build a base for steady performance.
Explore how on target earnings (ote) combine base salary and planned on target incentives (oci) to compute commissions, where 100% target yields €3,000 and 8% yields €800.
Understand commission plans for external hires and freelancers with zero salary. See a 10% commission on €20,000 revenue, yielding €200, and learn about two types of funnels that generate revenue.
Understand how accelerator multipliers amplify commissions in plans for overachievement, using a concrete example where 110% achievement with a twofold multiplier turns €100 of overachievement into €200.
Explain why companies cap sales bonuses to prevent overpayment and miscalculated quotas, and illustrate cap methods such as two times achievements or fixed per-rep amounts, including pros and cons.
Explore CRM data to calculate commissions, build summary table of accepted pipeline and revenue by account executives, and apply scenarios like kept or not kept, ramping phases, and achievement boundaries.
Create November 2023 crm data summary table to show stars and account executives' achievements, using unique and sumifs to compute accepted pipeline, revenue, and new clients, with a commissions example.
An example scenario demonstrates how to calculate monthly sales commissions for an SDR with LTI of €2,000, no cap, using accepted pipeline, quota €7,000, and accelerator multipliers.
Explore how to compute capped and uncapped bonuses for account executives using revenue-based quotas, accelerator multipliers, and achievement calculations to limit top earners.
Learn how to calculate commissions for employees in ramping phase using months since hire to set ramp percentages that adjust quota and achievement, as shown in the scenarios.
Explore how external hires earn commissions as a fixed percentage of revenue, with no quota or cap, typically 10%, calculated from revenue and tied to a pre-set contract.
Demonstrates scenario five for sales commissions, detailing an sdr with oci 2000, a not capped 7000 quota, monthly payments, and tiered 0%, 10%, and 25% commissions by performance.
Explore the basics of conventions and terminology, learn about quartiles, and calculate commissions in Google Sheets and Excel, then design CRM-driven summary tables for achievements.
In this course you are going to learn about sales commissions, how it is calculated and why it is important. At the end of the course you will be able to calculate commissions with CRM data, for various commission systems.
First we will start with the basics of sales commissions, which will include the terminology that will be really useful to understand the concept and to understand the following sections.
Then we will focus on the components and dependencies of commission calculations such as quotas, on target incentives, on targets earnings, ramps, capped amounts etc.
Finally we will make commission calculations with a CRM data. First we will be familiar with the CRM data and create summary tables for achievement measurements of sales teams. Then we will have 5 different scenarios that will show various commission plans, and we will be working on the calculations of these scenarios. These scenarios will contain calculations for sales development representatives, account executives, with scenarios where the bonus is capped, or some employees will be in ramping phase, or even an odd commission calculation where there are achievement grades that will change the percentage of the commission calculation.
At the end of the course you will be able to calculate any given commission plans, by using the given examples and by being creative and adding up on these examples.