Blog · Territory, capacity and quota planning · Sales teams
Target market analysis combines external research with the segments that already buy from your company. Compare revenue, contribution, and retention in a fixed customer cohort, then identify what further evidence a market choice needs.
Target market analysis combines market research with evidence about the customer groups that already buy from your company. Compare revenue, contribution, and retention on consistent definitions, then investigate whether prospective buyers share the needs your business can serve. Customer performance supports the choice; it does not measure the whole market.
Start with a decision such as which industry should receive the next sales campaign or additional account coverage. Name the geography, product offer, buying organization, and period. A label as broad as manufacturing is a useful first grouping, but it may need narrowing before a campaign can run.
Use behavioral segmentation for the mechanics of grouping customers by observed behavior. Target selection adds a commercial judgment: which groups justify attention given their needs, economics, and reachable demand?
The SBA's market research guidance identifies demand, location, market saturation, and pricing as research questions. Keep those external questions beside the sales analysis. Strong historical margins are useful evidence, but they do not answer whether suitable prospects exist in the territory you plan to enter.
Export account ID, assigned industry, invoice date, net sales after credits, and the costs needed for your contribution measure. Add a customer roster that identifies accounts eligible for the retention calculation. Reconcile account IDs before joining summaries so that a renamed account does not become a new customer.
For the example below, the eligible cohort contains organizations with a net-positive purchase during calendar 2024. An organization is retained if it also has a net-positive purchase during calendar 2025. Assign industry consistently and include every eligible organization, including those with no 2025 sales.
The revenue and costs shown are the cohort's 2025 activity. New customers acquired during 2025 are excluded from this comparison and reviewed separately. That keeps each segment's economic results attached to a defined population instead of mixing a mature cohort with recently acquired accounts.
Contribution means revenue less the specified variable product, delivery, and service costs. It does not deduct all corporate expenses or represent net profit. Have finance approve the cost scope and use the same policy for every industry.
An illustrative US business supplier is choosing an industry for additional sales attention. Put the following headers in A1:F1 and the three segment records in rows 2:4. Place the totals separately so formulas do not include them twice.
| A: Industry | B: Revenue (USD) | C: Variable product and delivery cost (USD) | D: Variable service cost (USD) | E: Eligible customers | F: Retained customers |
|---|---|---|---|---|---|
| Manufacturing | 1,200,000 | 780,000 | 100,000 | 100 | 85 |
| Services | 900,000 | 450,000 | 90,000 | 80 | 72 |
| Wholesale | 1,500,000 | 1,125,000 | 150,000 | 120 | 78 |
| Total | 3,600,000 | 2,355,000 | 340,000 | 300 | 235 |
Add G1:I1: Contribution, Contribution margin, and Customer retention. Enter these Excel formulas in G2:I2, respectively, and fill down through row 4:
=B2-C2-D2
=IF(B2=0,"",G2/B2)
=IF(E2=0,"",F2/E2)
Format H:I as percentages. A blank means the denominator is zero and the ratio is undefined; it does not mean zero performance. Microsoft's percentage guidance documents calculating a share by dividing the part by the total and applying percentage formatting. Covirage is not affiliated with Microsoft.
Round displayed percentages to one decimal place and keep the underlying formulas unrounded.
| Industry | Contribution (USD) | Contribution margin | Customer retention |
|---|---|---|---|
| Manufacturing | 320,000 | 26.7% | 85.0% |
| Services | 360,000 | 40.0% | 90.0% |
| Wholesale | 225,000 | 15.0% | 65.0% |
| Total | 905,000 | 25.1% | 78.3% |
Services produce $360,000 of contribution from $900,000 of revenue and retain 72 of 80 eligible customers. Wholesale has the highest revenue at $1,500,000, but contributes $225,000 and retains 78 of 120. Revenue ranking alone would point the team toward a different segment than the combined evidence suggests.
The contribution identity must hold across the cohort:
=SUM(B2:B4)-SUM(C2:C4)-SUM(D2:D4)-SUM(G2:G4)
The result must be zero. Here, $3,600,000 less $2,355,000 and $340,000 equals the $905,000 contribution total.
Calculate the overall margin and retention from their respective totals:
=SUM(G2:G4)/SUM(B2:B4)
=SUM(F2:F4)/SUM(E2:E4)
These produce 25.1% and 78.3% after rounding. Averaging the segment percentages gives each industry equal weight even though their revenue and customer bases differ.
Tie revenue and costs to the selected export rows. Tie the 300 eligible customers to the opening cohort roster and the 235 retained customers to their qualifying purchases. Check that no industry's retained count exceeds its eligible count, and that each customer belongs to one industry in this view.
Services deserve closer investigation because they lead this cohort on contribution and retention. That is a provisional priority, not a market-size estimate or a promise that new service customers will perform identically.
Maintain a short research record alongside the workbook:
| Question | Evidence to obtain | What it would support |
|---|---|---|
| Do prospects have the same problem? | Documented buyer interviews or supplied research | A relevant offer and message |
| Can the team reach them? | Defined territory and permitted prospect coverage | A practical campaign scope |
| Can the business serve them? | Capacity and service requirements | A feasible delivery commitment |
| Are acquisition economics acceptable? | Observed acquisition spending and customer outcomes | A test budget under stated assumptions |
Keep the acquisition calculation in customer acquisition. Also review the booking-to-invoice cycle per customer when attractive contribution comes with delayed billing. Profitability and cash timing both matter to the decision.
Have sales own the proposed test, finance validate costs, and operations confirm capacity. Document the evidence still missing and the customer outcome that would justify expanding the effort. Reassess using completed results from the test rather than projecting the cohort's best performance onto every prospect.
Upload your account roster, sales and cost exports, and supplied market research; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See sales intelligence with Covirage for the supporting business context.
A customer segment is a defined group in your records, such as manufacturers in a territory. A target market is a group you choose to pursue. That choice also needs evidence about prospective buyers, demand, access, competition, and your ability to serve them profitably.
Revenue is one input. A large segment can require expensive delivery or support, retain fewer customers, or exceed your available capacity. Compare contribution and retention alongside revenue, then research whether the segment's prospective buyers have needs your company can meet.
Your customer records show the customers your company has reached and served. They do not contain all potential buyers or their budgets. Estimating total market size requires separate research with explicit coverage and assumptions, rather than scaling your customer count without evidence.