Pricing Analytics: Data You Need Before Changing a Price

Pricing analytics is the discipline of measuring the prices you actually realize, how they vary across customers, channels and products, and what drives the differences, so that pricing decisions rest on data and not on list prices and anecdotes. Most companies know their list prices well and their realized prices poorly: discounts, rebates, allowances, freight absorption and payment terms push the price a customer really pays far below the price on the list. This guide describes the data you need, builds a price waterfall from list to pocket price with checked arithmetic, shows how to measure price dispersion and size the opportunity, works a price-volume-mix bridge, and sets out a short dashboard. It belongs to unit economics and budgeting and forecasting, builds on bundle pricing and promotion ROI, and leads to how to run a price test and pricing strategy.

The data you need

Start with what you have. Even the invoice-line data of one year from the ERP will answer important questions.

The price waterfall

The waterfall starts at list price and subtracts each item between the list price and the cash you keep.

Check: 100 - 8 - 3 - 4 - 1 - 2 - 1 = 81; 81 - 55 = 26; 26 / 81 = 32.1% of the pocket price. On list price, the margin looks like 45 percent (100 - 55 = 45). Price realization is 81 / 100 = 81%: nineteen cents of every list dollar leaks away. Many of the steps (rebates, allowances, chargebacks) are not on the invoice and do not appear in a report based on invoiced price. Build the waterfall by product, customer and channel. The differences between them are where the opportunity lies.

Price dispersion

Dispersion is the variation in net price paid by different customers for the same product. Some of it is justified, by volume, service or contract terms, and some is not.

Example: a product with 100,000 units sold in a year, by net price band.

The lowest quartile of volume (25,000 units) sells below $85, while a third of the volume sells at $90 or more. Suppose analysis shows that customers in the lowest band are not larger or more strategic than those in the next band, and the gap is due to historic deals and discretionary discounts. Moving those 25,000 units up by $3 would add 25,000 × 3 = $75,000 if volume held. It is a better target than a broad price rise, since it affects only customers with prices out of line. Test the effect on a sample of accounts and treat the figure as an upper limit, since some volume will be lost.

Analysis steps: sort customers by realized price, adjust for volume and terms, find outliers and ask why. Use regression or simple peer groups to identify customers paying much less than similar customers.

Price-volume-mix analysis

When profit changes, a price-volume-mix (PVM) bridge shows how much came from price, volume, mix and cost.

Example (single product, to show the mechanics). Last year: 100,000 units at an average net price of $82 and a cost of $55, so margin per unit $27 and total margin $2,700,000. This year: 105,000 units at an average net price of $80.50, cost unchanged at $55, margin per unit $25.50, total margin $2,677,500.

• Price effect = (80.50 - 82.00) × 105,000 = -$157,500
• Volume effect = (105,000 - 100,000) × (82 - 55) = 5,000 × 27 = +$135,000
• Total change = -157,500 + 135,000 = -$22,500, which equals 2,677,500 - 2,700,000.

Volume grew 5 percent, and margin fell, because realized price fell by $1.50 per unit, or 1.8 percent. Without the bridge, the company would celebrate volume growth and miss the price leakage. With several products, add a mix effect (the effect of selling more of the lower- or higher-margin items) and a cost effect. See product mix analysis.

KPIs to track

The last one is worth explaining. If a 5 percent list increase leads to a 3 percent rise in net price, price realization on the increase is 60 percent; the other 40 percent leaked to discounts and exceptions. Tracking it shows whether the sales organization is passing increases through.

A short dashboard

A pricing dashboard for management should fit on one page. Show: price realization trend (monthly), the waterfall for the top five products, the bottom 10 percent of customers by pocket price compared with the average, the PVM bridge for the quarter, the share of volume sold below the floor and the realized outcome of the last price change. Each chart should have an owner who can act on it. See budgeting and forecasting.

Data quality checklist

1. Do the totals tie to the general ledger?
2. Are rebates and allowances linked to the right customers and products?
3. Are returns and credits netted against the original sale?
4. Are currencies and units of measure consistent?
5. Is the product hierarchy stable?
6. Are costs current, with landed cost where relevant?
7. Are promotional prices flagged separately from regular prices?
8. Are bundles broken out to components?

Tools

You can do all of this in a spreadsheet for small data sets, and with a database or a business intelligence tool (Power BI, Tableau) for larger ones. The tool matters less than the discipline of reconciling to the ledger, defining metrics once and keeping a history. Pricing software can help once the basics are in place.

Link to demand planning

Price is an input to the demand forecast. Planned promotions, price changes and competitor moves should be visible to the planning team, and realized volumes should feed back into elasticity estimates. Companies that connect pricing analytics and demand planning make fewer inventory mistakes after a price change. See demand planning and inventory optimization.

Common mistakes

• Analyzing list or invoice price instead of pocket price.
• Treating all price dispersion as a problem or as justified.
• Not reconciling to the ledger.
• Ignoring mix when explaining margin changes.
• Building the system before defining the questions.
• No owner for the metrics.
• Using elasticity estimates from periods with stockouts.

Sizing the opportunity from the waterfall

Once the waterfall exists, it can be used to size opportunities in dollars. Take a company with $50 million of sales at list price and a price realization of 81 percent. Each point of realization is worth 1 percent of $50 million, or $500,000, and because it requires no extra cost to produce or ship, it falls directly into profit. Moving realization from 81 to 83 percent would add $1,000,000. That is a more credible target than a broad price rise because it depends on discipline already within the company's control: tighter approval of invoice discounts, a review of rebate tiers, fewer unplanned allowances and faster resolution of deductions. Break the two points down by waterfall step so that each owner has a specific target.

From analysis to action in 90 days

In the first month, build the waterfall for the top ten products and top twenty customers and reconcile the totals to the ledger. In the second month, rank customers by pocket price, flag the outliers and discuss them with the account owners to separate justified differences from legacy deals. In the third month, set floor prices and approval rules, run a test of a price change in one segment, and publish the first one-page dashboard. At the end of the 90 days, you should have a baseline, a list of actions with owners, and a regular review. Most of the value in the first year comes from making the data visible, because it changes how discounts are discussed.

Who owns pricing

Pricing analytics fails when nobody owns the numbers. A pricing lead, whether a dedicated analyst or a finance partner, should be accountable for the data, the definitions and the monthly review. Sales owns customer-level actions. Marketing owns promotions. Finance owns the reconciliation and the margin reporting. Supply planning needs to see planned price and promotion changes in time to plan inventory. A monthly pricing meeting with these functions, using the same one-page dashboard, is usually enough to start.

FAQs

What is pricing analytics?

The measurement and analysis of realized prices, discounts, rebates and margins across customers, products and channels, used to guide pricing decisions.

What is a price waterfall?

A step-by-step view from list price to pocket price, showing each discount, rebate, allowance and cost that reduces the price.

What is price realization?

Pocket price divided by list price. It shows how much of the list price the company actually keeps.

What data do I need to start?

Transaction lines with price, quantity, customer, product and date, plus discounts, rebates and product costs. Start with the ERP and add other sources over time.

How is price-volume-mix analysis used?

It breaks the change in profit between periods into the effects of price, volume, mix and cost, so you can see what really drove the result.