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


Recommended Resources

Starter Kit / Template
Starter Kit for Salesforce

These templates contain key analytics workflows and tutorial information to get you started using Alteryx for Salesforce.

  • Analytics Automation
  • Analyst
  • Sales and Service
Read Now
Starter Kit / Template
Starter Kit for Marketing Analytics for Adobe

Jumpstart your marketing analytics with everything you need to perform Customer Acquisition Analysis, Customer Segmentation, Customer Sentiment Analysis, Lifetime Value Analysis, and Offer Responsiveness with Alteryx Marketing Starter Kits.

Read Now
Starter Kit / Template
Starter Kit for Retail

As a retailer, understanding your customers is critical to success. Get everything you need to gain deeper customer insights with our Retail Starter Kit.

  • Analytics Automation
  • Analyst
  • Data Scientist
Read Now