Don't miss Inspire 2024, taking place May 13 - 16, 2024 at the Venetian, Las Vegas. Register Now.

Use Case

Renewal Discounting Impact Analysis


Changing the discounts you offer can dramatically affect new sales, customer churn and the likelihood of subscription renewals. With an automated process that compares the changes you plan against the impact of current discounts, you can estimate the costs and benefits to your business.

Bottom-Line Returns

Analyze and minimize the impact that changes to discounts will have on customer churn

Top-Line Growth

Optimize discounting to encourage longer-term deals and additional purchases

Customer Experience

Make the right change the first time and avoid confusion or churn caused by altering discount plans


Business Problem

Price discounts are common with subscription services. They encourage customers to subscribe for longer terms, increase the likelihood that they will renew and reward them for buying products together. However, the overuse of discounts can lock the company into unprofitable, long-term deals, while underuse can result in customer churn and lost business.

Analytics Solution

Evaluate the impact of your organization’s discounting model on customer metrics like the total Annual Contract Value (ACV) of current contracts. Then, analyze how those metrics will change with increases and decreases in discounts. That requires connecting to sources of customer metrics, performing ACV calculations at the opportunity level and comparing that data with proposed discounts. Automating the process with data connections and analytics lets you optimize discounts before you offer them to customers.

With Alteryx, you can:

  • Import current customer metrics like contract term, annual list price and current discount from CRM platforms like Salesforce
  • Automate the Annual Contract Value (ACV) calculation at the customer level to arrive at exact ACV across subscriptions
  • Compare existing customer contract value with expected value after new discounts to fully understand impact on metrics like Likelihood to Renew

Discount Impact on Renewals Analysis Designer Workflow

1 – Automated Calculations

Calculate discounts at opportunity level to ensure numbers are accurate at the customer level

2 – Data Prep

Assign opportunities to the proper tier for the new discount matrix

3 – Advanced Analytics

Show impact by directly comparing current total ACV with ACV expected after new discounts


Additional Resources

Starter Kit for Intelligence Suite
Learn More
Starter Kit for Office of Finance
Learn More
Starter Kit for Salesforce

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