Compare stores within transparent format, location and size groups. Build sales, gross margin and selling-area measures from exports, then reconcile segment totals before choosing a store-level action.
Store segmentation analysis compares retail locations within groups that share a format, size band and relevant trading conditions. Define those groups from the store master, then calculate sales and gross margin from the same period's export. Use the differences to choose what to investigate at each location.
Start with a decision such as reviewing margin at mature neighborhood stores. Record store ID, format, location type, selling square feet, opening date, trading status and assigned segment. The store ID must stay stable when a location changes its name or manager.
Choose attributes that explain operating conditions rather than the result you hope to improve. Grouping high-sales stores together and then observing higher sales is circular. A size band or store format can support a comparison without using the performance measure itself as the assignment rule.
Do not cross every available field. Combining format, location, selling area and maturity can leave groups with very few locations. Begin with the smallest set of business rules that changes the interpretation. Keep exceptional stores visible, and resist forcing them into an unsuitable peer group.
This analysis groups locations. Convenience store customer segmentation groups buyers and answers a different question. For the broader principle of choosing comparable entities, the ledger-based segmentation guide explains why descriptive attributes belong in benchmarking groups.
Total transaction lines to one row per store for the chosen month or quarter. Retain net sales, cost of goods sold, selling area and actual trading days. Join the store master only after checking that it has one applicable record per store for that period.
Use net sales after returns and allowances. The IRS's explanation of gross profit illustrates the sequence: reduce gross receipts by returns and allowances, then subtract cost of goods sold. Keep your company's cost classification consistent across stores; gross profit does not automatically include every operating expense.
The worked example uses merchandise gross profit. If rent, store labor or distribution expenses are excluded from cost of goods sold, do not label its gross margin as store operating profitability. The gross profit margin guide explains the underlying calculation and why cost definitions matter.
A US home-supplies retailer compares four mature neighborhood stores for September 2026. All were open throughout the month. Its supplied rules define Compact as selling area below 3,000 square feet and Standard as selling area from 3,000 through 10,000 square feet. A location outside these rules would remain unassigned until reviewed.
Place the following inputs in columns A through F, with headers in row 1:
| Store | Segment | Selling area (sq ft) | Net sales (USD) | COGS (USD) | Trading days |
|---|---|---|---|---|---|
| C01 | Compact | 2,000 | 300,000 | 195,000 | 30 |
| C02 | Compact | 2,500 | 330,000 | 224,400 | 30 |
| S01 | Standard | 6,000 | 600,000 | 390,000 | 30 |
| S02 | Standard | 8,000 | 720,000 | 504,000 | 30 |
In Google Sheets, calculate gross profit in G2, gross margin in H2, monthly sales per selling square foot in I2 and sales per trading day in J2:
=D2-E2
=IF(D2=0,"",G2/D2)
=IF(C2=0,"",D2/C2)
=IF(F2=0,"",D2/F2)
Fill down through row 5. Keep undefined rates blank and investigate a missing or zero denominator rather than replacing it with a favorable-looking result.
| Store | Gross profit (USD) | Gross margin | Monthly sales per sq ft (USD) | Sales per trading day (USD) |
|---|---|---|---|---|
| C01 | 105,000 | 35.0% | 150.00 | 10,000 |
| C02 | 105,600 | 32.0% | 132.00 | 11,000 |
| S01 | 210,000 | 35.0% | 100.00 | 20,000 |
| S02 | 216,000 | 30.0% | 90.00 | 24,000 |
For C02, gross profit is 330,000 − 224,400 = $105,600. Margin is 105,600 / 330,000 = 32.0%, and monthly sales per square foot is 330,000 / 2,500 = $132.00. These density figures cover the month; they are not annual measures.
Enter Compact in L2 and Standard in L3. In M2, N2 and O2, calculate segment sales, gross profit and selling area:
=SUMIFS($D$2:$D$5,$B$2:$B$5,L2)
=SUMIFS($G$2:$G$5,$B$2:$B$5,L2)
=SUMIFS($C$2:$C$5,$B$2:$B$5,L2)
Fill down. Google's SUMIFS documentation explains the conditional summation used here. Covirage is not affiliated with Google.
Calculate segment margin and sales density from the totals:
=IF(M2=0,"",N2/M2)
=IF(O2=0,"",M2/O2)
| Segment | Stores | Selling area (sq ft) | Net sales (USD) | Gross profit (USD) | Gross margin | Monthly sales per sq ft (USD) |
|---|---|---|---|---|---|---|
| Compact | 2 | 4,500 | 630,000 | 210,600 | 33.4% | 140.00 |
| Standard | 2 | 14,000 | 1,320,000 | 426,000 | 32.3% | 94.29 |
| Total | 4 | 18,500 | 1,950,000 | 636,600 | 32.6% | 105.41 |
Percentages are rounded to one decimal place and density to two decimals. Compact margin is 210,600 / 630,000 = 33.4%, and its density is 630,000 / 4,500 = $140.00. Segment margin weights stores by sales; segment sales density weights them by selling area.
Sales reconcile as 630,000 + 1,320,000 = $1,950,000. COGS from the input rows totals $1,313,400, so gross profit must be 1,950,000 − 1,313,400 = $636,600. That matches 210,600 + 426,000. Reconcile the included sales and COGS to the source export and document exclusions such as online orders.
The simple sales check is:
=SUM(M2:M3)-SUM(D2:D5)
It should return zero. Repeat the comparison for gross profit and selling area, then separately verify unique store IDs and complete segment assignments.
S02 produces more sales than S01 but a lower gross margin. If S02 had S01's 35.0% margin at unchanged sales, its gross profit would be 720,000 × 35.0% = $252,000, which is $36,000 above its actual $216,000. That is a comparison scenario, not a promised improvement. Product mix, discounts and cost classification could explain the difference.
Investigate assortment with a range-gap review per store, and inspect sell-out gaps where availability may affect sales. Those measures help explain individual locations; the segment itself does not establish the cause.
Bring your store master, supplied segment assignments and sales-and-cost export to Covirage. Covirage maps the columns; its tools compute and check store and segment comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See sales insights for the supporting commercial analysis.
Choose attributes that affect a fair operating comparison and are available in the store master. Format, selling area, location type and maturity can be useful. Keep the rules explicit, avoid creating groups too small to interpret, and review whether each split changes an operating decision.
No. Store segmentation assigns locations to groups, while customer segmentation assigns buyers or accounts. A store segment can contain many customer types. Keep the store ID as the analysis unit and bring in customer measures only when their definitions fit the store-level question.
Use both. Sales measures trading volume, while gross margin shows the share remaining after the recorded cost of goods sold. Add selling area or trading days where relevant to comparability. High sales alone do not establish a store's profitability after occupancy, labor and other expenses.
Give them explicit status fields and separate them when opening ramps or temporary closures affect the period. Document the eligibility rule before comparing results. A mature-store comparison and a full-network total can both be useful, provided each states which locations and trading days it includes.