Blog · Territory, capacity and quota planning
Product segmentation groups a portfolio by shared commercial attributes. Work through product-level sales, margin, and growth, then see how a change in sales mix affects the total.
Segmentation of product portfolios means grouping goods or services by shared commercial attributes so a business can compare sales, margin, and growth at a useful level. Start with what makes the products meaningfully different, then measure their performance from sales and cost records. Keep the grouping rules stable enough that a period comparison reflects business changes rather than relabeling.
A useful segment connects a product attribute to a decision. A category view may support assortment planning. A price-position view can support a review of discounts and margin. A lifecycle view can distinguish established ranges from launches or products being retired.
The Census Bureau's explanation of product classification describes NAPCS as a market- or demand-based system for goods and services. It also explains that the same product can be sold across different industries. That is a useful distinction for internal reporting: the product's identity and the customer's industry answer different questions.
Your commercial grouping does not have to reproduce a government classification. It needs an explicit rule, an owner, and a way to classify every included product. The more detailed product taxonomy guide covers how to keep the underlying product structure consistent.
| Grouping dimension | Example labels | Decision it supports |
|---|---|---|
| Intended use | Cleaning, storage, maintenance | Where the range serves different needs |
| Category | Detergents, containers, replacement parts | How assortment and category economics compare |
| Price position | Value, core, premium | Whether portfolio mix supports the margin objective |
| Lifecycle status | Launch, established, retiring | Where growth and inventory review need context |
Choose one primary dimension for the first report. Keep other attributes in separate columns so they remain available without creating overlapping totals.
The product master needs a stable SKU or service code and one approved primary segment per code. The sales export needs the same code, transaction date, net sales, and the cost of the items sold. Prior-period sales need a comparable date range and the same currency.
Sum the transaction rows to product level before presenting the comparison. Retain credit amounts with the products they reverse under the reporting policy. Products with missing mappings should appear in an Unassigned group until resolved; dropping them makes the report look reconciled only because part of the business disappeared.
For gross profit, the IRS explanation subtracts returns and allowances from receipts before deducting cost of goods sold. Use the finance team's approved cost definition consistently. The resulting gross profit does not include every operating cost and should not be presented as net profit.
This is different from customer segmentation from the ledger. Here the grouping key is the product code. The customer remains a separate attribute, even when one account buys most of a particular range.
A fictional US office-supply business groups its products as Core, Premium, and Value using approved price-position labels. It compares July through September 2026 with the same quarter in 2025. The following product summary is the complete included portfolio for this example.
| SKU | Product group | Prior sales (USD) | Current sales (USD) | Current COGS (USD) | Current gross profit (USD) |
|---|---|---|---|---|---|
| S-01 | Core | 180,000 | 220,000 | 154,000 | 66,000 |
| S-02 | Core | 120,000 | 140,000 | 98,000 | 42,000 |
| S-03 | Premium | 80,000 | 120,000 | 60,000 | 60,000 |
| S-04 | Premium | 70,000 | 80,000 | 40,000 | 40,000 |
| S-05 | Value | 100,000 | 90,000 | 72,000 | 18,000 |
| S-06 | Value | 50,000 | 50,000 | 40,000 | 10,000 |
| Total | 600,000 | 700,000 | 464,000 | 236,000 |
Product-group gross profit = Group net sales - Group cost of goods sold
Product-group gross margin = Group gross profit / Group net sales
Product-group sales growth = (Current group sales - Prior group sales) / Prior group sales
Apply those formulas after summing the products in each group:
| Group | Prior sales (USD) | Current sales (USD) | Gross profit (USD) | Gross margin | Sales growth | Current sales share |
|---|---|---|---|---|---|---|
| Core | 300,000 | 360,000 | 108,000 | 30.0% | 20.0% | 51.4% |
| Premium | 150,000 | 200,000 | 100,000 | 50.0% | 33.3% | 28.6% |
| Value | 150,000 | 140,000 | 28,000 | 20.0% | -6.7% | 20.0% |
| Total | 600,000 | 700,000 | 236,000 | 33.7% | 16.7% | 100.0% |
Percentages are rounded to one decimal place after calculation. Premium growth is (200,000 - 150,000) / 150,000 = 33.3%. Total growth is (700,000 - 600,000) / 600,000 = 16.7%. Use the totals for the company rate, rather than averaging the three growth percentages.
Core has the largest sales base and the largest gross profit in dollars. Premium has the highest margin and growth rate. Those are different findings, and neither alone establishes which group should receive more investment.
The current sales check is 360,000 + 200,000 + 140,000 = $700,000. The gross profit check is 108,000 + 100,000 + 28,000 = $236,000. Both must match the product rows above, and the product rows must match the included sales and cost exports.
The cost identity gives another check: 700,000 - 464,000 = $236,000. Total gross margin is therefore 236,000 / 700,000 = 33.7%. The gross profit margin guide explains why an unweighted average of product margins will not preserve that identity.
Review unmatched product codes, duplicated mappings, and products that changed codes between periods. A replacement code should not appear as a launch merely because its earlier sales use a different identifier.
Hold the group margins fixed and shift $40,000 of sales from Core to Premium. This is a sensitivity calculation with unchanged total sales, rather than a forecast of achievable demand.
| Group | Revised sales (USD) | Assumed gross margin | Revised gross profit (USD) |
|---|---|---|---|
| Core | 320,000 | 30.0% | 96,000 |
| Premium | 240,000 | 50.0% | 120,000 |
| Value | 140,000 | 20.0% | 28,000 |
| Total | 700,000 | 34.9% | 244,000 |
Gross profit rises from $236,000 to $244,000, a gain of $8,000. No group margin changed; a greater share of sales moved into the higher-margin group. A full price, volume, and mix analysis separates that effect from changes in realized prices and quantities.
The commercial team can use this result to frame an assortment or selling-priority discussion. It still needs evidence about demand, capacity, customer preferences, and the cost of changing the mix. Finance should own the margin calculation, while the product or category owner maintains the segment mapping.
Bring a sample of your own product master and sales workbook with approved group labels, net sales, and cost fields. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own file.
See revenue driver analysis in Covirage for the supporting business context.
It makes a large portfolio easier to compare and manage. Grouped sales and margin can show which parts support growth, require pricing review, or absorb resources. The groups should reflect a business decision and use consistent product attributes, rather than change whenever a product has a strong month.
Product segmentation groups what the company sells. Customer segmentation groups the buyers. A premium product can be sold to several customer groups, and one customer can buy from several product groups. Keep those dimensions separate, then compare them together when a specific commercial question requires it.
It can carry several descriptive attributes, such as category, price position, and launch status. For a report whose segment totals must add to company sales, choose one exclusive grouping dimension. Otherwise, the same transaction can appear in several groups and inflate the combined total.
Revenue or margin bands can help prioritize a review, but distinguish those changing performance bands from stable commercial groups. A category or use-based group supports period comparisons. A margin band shows current economics and may change when price, cost, or discounting changes.