Blog · Territory, capacity and quota planning · Sales teams
Build a territory SWOT from account revenue, concentration, coverage and capacity figures. This worked US example connects each observation to an action and changes one capacity assumption to test the conclusion.
A SWOT analysis for a sales territory should connect each strength, weakness, opportunity and threat to evidence and a next action. Account exports establish growth, concentration and coverage; buyer conversations and competitive records establish the outside conditions. The useful result is a short set of decisions that a territory manager can defend.
This illustrative example follows a US industrial-parts distributor's Ohio territory at September 30, 2026. Its manager combines account revenue for two comparable trailing twelve-month periods, current ownership, qualifying activity dates, estimated annual buying potential and weekly service requirements. Each account appears once.
Potential is management's estimate of addressable annual purchases for the product range, including current purchases. It is neither total customer spending nor committed future revenue. Estimated service hours include preparation, customer contact and travel, using the same method for every account.
The manager also keeps dated buyer notes and competitive evidence. The SBA's market research guidance asks businesses to examine demand, market size, location, pricing and competitive conditions, and describes direct customer research. An internal revenue spreadsheet cannot, by itself, prove an external market opportunity.
For the broader planning pack, use the sales territory plan template. Comparing alternative assignments is the separate job covered in sales territory planning.
The prior period ends September 30, 2025; the current period ends September 30, 2026. Coverage here means a qualifying customer conversation within the last 30 days, measured at the current snapshot. An automated message does not qualify under this company's rule.
| Account | Prior revenue (USD) | Current revenue (USD) | Annual potential (USD) | Days since qualifying touch | Required hours/week |
|---|---|---|---|---|---|
| A | 300,000 | 330,000 | 500,000 | 12 | 12 |
| B | 240,000 | 270,000 | 400,000 | 18 | 10 |
| C | 180,000 | 180,000 | 300,000 | 25 | 8 |
| D | 120,000 | 120,000 | 350,000 | 38 | 10 |
| E | 100,000 | 90,000 | 250,000 | 50 | 8 |
| F | 60,000 | 60,000 | 200,000 | 65 | 6 |
| Total | 1,000,000 | 1,050,000 | 2,000,000 | 54 |
Put the table in A1:F8. In G2, calculate current revenue less prior revenue; in H2, flag coverage; in I2, calculate the potential gap. Fill these formulas down through row 7:
=C2-B2
=IF(E2="","Review",IF(E2<=30,1,0))
=D2-C2
Keep missing activity dates in review rather than treating them as recent contact. For the fully populated example, the covered-account count is:
=COUNTIFS(H2:H7,1)
Microsoft's COUNTIFS documentation confirms that the function counts rows meeting stated criteria. The flag makes the coverage rule explicit and leaves incomplete records visible.
| Measure | Calculation from the account rows | Result |
|---|---|---|
| Revenue growth | (1,050,000 - 1,000,000) / 1,000,000 | 5.00% |
| Largest two accounts' revenue share | (330,000 + 270,000) / 1,050,000 | 57.14% |
| Account coverage | 3 / 6 | 50.00% |
| Revenue represented by covered accounts | (330,000 + 270,000 + 180,000) / 1,050,000 | 74.29% |
| Total potential gap (USD) | 2,000,000 - 1,050,000 | 950,000 |
| Uncovered accounts' potential (USD) | 350,000 + 250,000 + 200,000 | 800,000 |
| Uncovered accounts' potential gap (USD) | 800,000 - (120,000 + 90,000 + 60,000) | 530,000 |
Percentages are rounded to two decimal places after calculation. Revenue rose by $50,000: A added $30,000, B added $30,000 and E lost $10,000; the other accounts were unchanged. The territory's growth therefore depends on a narrow part of the book.
Two additional inputs complete the example. The two assigned reps each have 30 hours a week available for these accounts after other duties, giving 60 available hours. Buyer notes at D, E and F describe interest in product categories used in the potential estimates; A has documented that a competing supplier is participating in its next renewal review.
| Quadrant | Evidence | Amount (USD) | Action and owner |
|---|---|---|---|
| Strength | Covered relationships at A, B and C: current revenue | 780,000 | Territory manager preserves the current contact cadence while testing expansion needs |
| Weakness | Three accounts lack current coverage; A and B represent 57.14% of revenue | Sales operations prepares an account action list; the manager reviews concentration exposure | |
| Opportunity | Buyer discussions at D, E and F: estimated potential gap to investigate | 530,000 | Account owners verify requirements, access and timing before adding qualified opportunities |
| Threat | A's documented competitive review: current account revenue exposed | 330,000 | Account owner prepares a renewal plan with the manager and records the next buyer conversation |
The threat figure describes exposure, not a predicted loss. Likewise, the potential gap is an investigation boundary, not a sales target automatically added to the forecast. Track qualification separately through sales funnel analysis.
The capacity check is 60 available hours minus 54 required hours = 6 hours of weekly headroom. This supports a limited expansion investigation while maintaining service. It does not establish that every travel route or appointment can fit; the manager still checks the proposed calendar. The sales capacity planning method develops that budget connection.
Now change only available hours per rep from 30 to 24. Keep the same accounts, potential, service requirements and coverage snapshot. The revised total is 2 × 24 = 48 hours a week.
| Capacity measure | Original case | Revised case |
|---|---|---|
| Available hours/week | 60 | 48 |
| Required hours/week | 54 | 54 |
| Headroom: available less required | 6 | -6 |
The opportunity remains, but the action changes. The manager must first free or reassign 6 hours of weekly work, or explicitly revise the service standard. Adding an expansion campaign without addressing that shortage would promise time the team does not have. Coverage remains 50.00% in this variation because it is an observed snapshot, not a figure recalculated from staffing.
Before approving actions, reconcile account revenue to the source total and review account ownership. Keep the original potential assumptions available for challenge. Covirage is not affiliated with Microsoft.
Bring a sample of your own account revenue, activity, ownership and capacity files with the assumptions behind potential. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the evidence with every figure traced to its rows. Create a free Covirage account and set up your business; creating the account takes about a minute.
See territory planning with Covirage for the supporting context.
Include internal strengths and weaknesses, such as established relationships, specialist knowledge, workload and coverage gaps. Opportunities and threats describe external conditions, including unmet customer needs and competitive activity. Support each point with a dated source, an account-level figure where available, and a decision it should change.
Potential is an estimate of what accounts could buy under stated assumptions. A forecast estimates what the company expects to sell within a period. A territory can have substantial potential without enough access, qualified demand or rep capacity to convert it into forecast revenue.
Choose a review cycle that matches the territory's decisions, then refresh it when an important assumption changes. A departing rep, a major renewal or a verified competitor move can justify an earlier review. Keep the previous snapshot so changed inputs remain visible.