How to analyze sales performance by region and product
Analyze regional and product sales by first confirming the what one row represents and comparable periods, then decomposing the revenue change into volume, price, mix, and coverage effects. Compare actuals with both target and prior period, use rates alongside totals, and investigate the few segments that materially explain the variance instead of ranking regions on revenue alone.
From the field · Regional sales director
Compare retail regions after returns and currencies are made comparable
Stores report gross sales in local currencies while one region records returns in a separate file. Ranking raw totals would reward large currencies and ignore the product mix that explains margin differences.
Columns used in the example
order_id · date · region · product · units · gross_sales · returns · currency · rate_date
Follow it with your own file
- Define net sales and attach returns to the correct region, product, and period.
- Preserve local-currency results and create a reporting-currency view using a documented rate date.
- Compare units, price, mix, net sales, and margin rather than one total.
- Show contribution to change so large regions do not dominate every conclusion.
Check: Regional and product subtotals must reconcile to net sales, currency conversion must be reproducible, and every excluded return or unmapped product must appear in an exception list.
What needs resolving first
A regional leaderboard can reward the largest market while hiding falling conversion, unfavorable mix, missing targets, or a one-time deal. Product totals can also be distorted by launches, discontinued lines, currency movements, and uneven selling days.
What changes the answer
- Compare like-for-like periods and currencies before ranking regions.
- Separate growth caused by volume, price, mix, and new coverage.
- Use contribution and attainment together so large regions do not dominate the story.
- Trace every conclusion to a segment-level calculation.
Build the result step by step
- Confirm grain and comparability: Identify whether a row is an order, line item, account-period, or snapshot. Align dates, currencies, returns, taxes, and target definitions.
- Build a metric tree: Connect revenue to units, price, customers, opportunities, conversion, and mix so movement has an explainable driver.
- Decompose the variance: Calculate actual versus target and prior period by region and product, then rank segments by contribution to the total gap.
- Validate the business story: Inspect underlying records, material one-offs, missing targets, and denominator sizes before recommending an action.
Start with a driver tree, not a leaderboard
Revenue is an outcome. A useful analysis connects it to units, effective price, active customers, conversion, and product mix. That tree prevents a large total from being mistaken for healthy performance.
Use absolute contribution to answer what moved the company result and rates to answer how efficiently each segment performed.
Make every comparison fair
A region with 22 selling days should not be compared casually with one having 18. Currency, returns, launch timing, and target coverage can create the same problem. State exclusions and make consistent only when the adjustment has a defensible rule.
Show the base size beside every percentage. A 100% increase from one order is not equivalent to 10% growth on a major product.
Sales measures answer different questions
| Measure | Answers | Watch for |
|---|---|---|
| Revenue contribution | Which segment moved the total? | Large-market bias |
| Target attainment | Did the segment deliver its plan? | Unmatched or stale targets |
| Growth rate | How fast did it change? | Small bases and new products |
| Conversion or units | What operational driver changed? | Different funnel definitions |
Warning signs in the file
- Revenue rises while units or conversion fall.
- One large region explains most absolute growth but misses its target.
- A product grows only because it entered more markets.
- Currency or calendar differences make periods incomparable.
Doing these steps in Prepyr
Upload a CSV working copy in Prepyr. Describe the result you need: Analyze sales performance by region and product using consistent currency, returns, and product definitions. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Natural Language analysis · Segment comparisons · Charts · Evidence Based reports
Make the output easy to check
- what one row represents confirmed
- Periods and currencies aligned
- Returns handled consistently
- Targets matched to the same level
- Small denominators flagged
- Largest drivers reconciled to total
A decision-ready explanation of where sales changed, how much each segment contributed, and whether the movement reflects sustainable performance or a temporary mix effect.
Questions readers usually ask next
Should regions be ranked by revenue or growth?
Use both, plus target attainment and contribution to the total gap. No single ranking explains performance.
How do I handle currencies?
Choose reported or constant-currency analysis explicitly, retain source currencies, and disclose the rate and period used.
What makes a sales insight actionable?
It names the segment, quantified gap, likely driver, supporting evidence, uncertainty, owner, and next check.