Blog · Territory, capacity and quota planning · Sales teams
Market trend analysis compares company sales with an external indicator covering the same market and periods. Build a spreadsheet comparison, check the inputs, and identify which changes need a commercial explanation.
Market trend analysis compares your sales with an external measure of the market over the same periods. Match the market definition first, then calculate growth and examine the gaps. A rise in one company's revenue is a company result; it does not measure demand across every supplier.
Write down the decision before selecting a series. A regional distributor deciding where to add sales capacity needs evidence about its customer industries and territories. A national measure may be too broad to support that choice.
Define geography, product scope, customer segment, period, and measurement unit. Keep the external series name, source, release date, and any revisions beside the figures. Treat the selection as a business judgment that the sales and finance owners can review.
Use trend analysis for the wider method of studying a series over time. The additional requirement here is a defensible connection between internal results and an independently measured market.
Check whether the indicator measures dollars, physical output, orders, employment, or sentiment. Each answers a different question. An employment measure can provide context for a customer industry, but it is not a direct substitute for that industry's purchases from your company.
Export sales by transaction date, segment, product category, net revenue, and currency. Apply returns and credits consistently, then summarize the relevant rows by month. Keep a reconciliation to the sales register so the summary can be traced back.
Bring the external series into a separate worksheet with one value for each matching month. Leave missing observations blank and investigate them. Do not fill a missing market reading with zero or repeat the previous observation without labeling that assumption.
Use complete months. Record whether each series is seasonally adjusted. The Census Bureau explains seasonal adjustment as removing seasonal and certain calendar effects to make consecutive periods easier to compare. Comparing adjusted external values with an unadjusted seasonal sales series can create a misleading gap.
For a first comparison, use the same seasonal treatment where practical. If that is unavailable, show the limitation and compare equivalent periods from a longer history before making a capacity decision.
This illustrative US distributor has supplied a monthly category sales-value index and its own matching category revenue. The indicator is an example input, not a reported public market reading. Both series cover the same territory and completed months of 2026, with no seasonal adjustment.
Put these headers in A1:C1 and the observations in rows 2:5:
| A: Month | B: Company net sales (USD) | C: Supplied market index |
|---|---|---|
| January 2026 | 200,000 | 100 |
| February 2026 | 210,000 | 102 |
| March 2026 | 220,000 | 104 |
| April 2026 | 230,000 | 106 |
Add D1:H1: Company index, Market rebased index, Company monthly growth, Market monthly growth, and Index gap. Rebase both series to January equal to 100. In D2 and E2 enter:
=B2/$B$2*100
=C2/$C$2*100
Fill both down through row 5. In F3 and G3 enter the month-over-month changes, leaving F2:G2 blank because no preceding month is supplied:
=(B3-B2)/B2
=(C3-C2)/C2
Fill those formulas through row 5. In H2 enter the difference between the indexed levels and fill down:
=D2-E2
Format F:G as percentages. Microsoft's percentage guidance documents dividing the change by the original value and applying percentage formatting. Covirage is not affiliated with Microsoft.
The calculated results below round indices and percentages to one decimal place. Keep unrounded values in the workbook.
| Month | Company index | Market rebased index | Company monthly growth | Market monthly growth | Gap (index points) |
|---|---|---|---|---|---|
| January | 100.0 | 100.0 | — | — | 0.0 |
| February | 105.0 | 102.0 | 5.0% | 2.0% | 3.0 |
| March | 110.0 | 104.0 | 4.8% | 2.0% | 6.0 |
| April | 115.0 | 106.0 | 4.5% | 1.9% | 9.0 |
Company sales rose from $200,000 to $230,000, or 15.0%. The supplied market index rose from 100 to 106, or 6.0%. The growth difference is 9.0 percentage points, and April's rebased levels differ by 9.0 index points. These labels describe different calculations even though their values coincide here.
The result supports investigating why company sales grew faster. Price changes, product mix, new accounts, territory changes, and timing could all contribute. Use product mix analysis to examine the assortment behind the revenue movement.
The comparison alone cannot prove market-share gains or establish causation. An indexed external series does not provide the market sales denominator. Sales managers should identify the affected segments, and finance should check whether pricing or credits explain the apparent advantage before increasing targets.
First, January's two rebased values must equal 100. Second, the monthly company revenue must sum to the selected export total:
=SUM(B2:B5)
That total is $860,000. Match it to the selected transaction rows, then reconcile excluded categories separately.
Third, the April endpoints must reproduce the growth calculation:
=B5/B2-1
=C5/C2-1
These return 15.0% and 6.0%. An index is a level relative to a base; summing its monthly readings does not give total market sales. Preserve these checks when adding another month or segment. Use market analysis and sales forecasting when turning the reviewed evidence into planning assumptions.
Upload your sales workbook and the supplied market series; Covirage maps the columns, and its tools compute and check the comparisons. 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.
See Covirage for sales teams for the supporting business context.
Use dated net sales by segment and an external indicator with documented coverage, units, seasonal treatment, and publication date. Keep the original series definition alongside the workbook. A broad national series may provide context without measuring demand in your particular territory.
Faster growth than an indicator is evidence to investigate, but an index alone does not establish market share. Share needs your comparable sales divided by total market sales, using matching products, geography, periods, and accounting definitions.
Match the review to the indicator's release schedule and your decision cycle. Use completed, comparable periods and record revisions. A monthly review can flag changes for investigation, while a longer history helps distinguish recurring seasonality from a sustained change.