Use Case

Sales Quota Planning


Align sales goals with company targets and eliminate reliance on spreadsheets by creating a centralized source for quota management.

Efficiency Gains

Automate quota structure updates to match current capabilities

Top-Line Growth

Ensure quotas are reachable and provide positive incentive to perform

Risk Reduction

Better measure expected performance of whole salesforce

Business Problem

Sales quotas are at the heart of sales function in almost every company, but what’s the most realistic way to set them?

Sales quota planning should consider factors like the hire date of the sales representative, the company’s targets, its territory mapping, and the go-to-market strategy for the product/service being sold. The first part of planning is to get agreement on those elements. But until you make sales quota management a consistent, repeatable process, free of human error, you run the risk of frustrating your sales representatives and confusing your new hires. How can you set attainable quotas that are aligned with company targets and apply them continually — without manual intervention?

Analytics Solution

Establishing a centralized source for sales quota management involves automating the process of aggregating data and applying business rules. Fairness in sales quota planning depends on including as many relevant variables as possible, and automation is the only practical way to make the process accurate, adjustable, and repeatable. Instead of depending on spreadsheets or manual calculations to determine sales quotas, analytics pulls information like hire date, sales team, territory, and product from multiple data sources. The resulting models keep quotas aligned with the company’s targets and the direction of the business.

Alteryx provides the ability to connect with Salesforce, group opportunities based on various metrics, and then automatically push assigned opportunities to sales reps. It can also automate the manual process of building out account lists for new hires.


1 – Data Preparation

Use one or many filters to narrow scope

2 – Blend Data Prep

Separate, apply filters, and recombine data all within the same workflow

3 – Modularize

Create modules and connect those modules to Workday or other workflows


Additional Resources

Starter Kit for Salesforce
Learn More
Starter Kit for Marketing Analytics for Adobe
Learn More
Starter Kit for Retail
Learn More
Sales Territory Optimization
Learn More

Recommended Resources

Customer Story
Jebsen Group: Bridging the Gap Towards Digital Transformation
The Jebsen Group uses Alteryx to automate and accelerate key data processing and analytics workflows that help the business manage a large portfolio of premium brands.
  • BI/Analytics/Data Science
  • Finance
  • IT
Learn More
Use Case
Sales Pipeline Consolidation and Reporting
Automatically pull data from multiple CRM platforms like Salesforce to power dashboards and reports for evaluating sales rep engagement and pipeline creation.
  • IT
  • Operations
  • Sales
Learn More
Customer Story
AmerisourceBergen: Building a smarter, data-driven sales engine
See how AmerisourceBergen increased the sales teams’ effectiveness by having more targeted customer conversations based on real-time data and insights.
  • Analytics Automation
  • Sales
  • English
Learn More