Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Templates

Market Sizing Worksheet Template

A market sizing worksheet template: market definition, top-down and bottom-up estimates, assumptions and sources, triangulation, ranges and the answer.
Templateadvanced9 min readUpdated

What this template is for

Use the worksheet whenever a market size will inform a decision: whether to enter a new country, launch a product line, raise a budget, hire a sales team or set a growth target. It suits a quick estimate for an internal choice as well as a careful one for a board paper; the quick version simply has wider ranges and more assumptions marked low confidence. What matters is that every figure in the answer can be traced back through the worksheet to a definition, a source or an assumption someone can challenge.

The worksheet sits between other documents on this site. Before it, the segmentation guide defines the customers the business serves, which is the raw material of the market definition. After it, the size feeds the go-to-market plan, where the obtainable share becomes customer targets and capacity, and, for a business comparing countries, the market entry and prioritisation guide, where each market's size is one signal among demand, competition, regulation and cost to serve. The market sizing guide explains the methods, the proxies and the triangulation; the worksheet holds the working.

The worksheet is also the defence against motive. Sizes are often produced to justify a decision already taken, by someone who would like a large answer. Writing each step down makes the reasoning visible, and a reviewer can ask the useful question: what would the figure be if the analyst wanted it small, and would the method have stopped them?

The template

Build the worksheet in a spreadsheet, with one tab for the summary below and one tab per estimate showing each line of arithmetic. Keep the assumptions in a single table that both estimates refer to.

FieldWhat to write
Decision and definitionThe decision the size informs, and the market defined by customer, the job the product does, geography, unit and period
Top-down estimateEach line from a category total down to the serviceable market, with the filter applied at each step
Bottom-up estimateThe count of buyers who meet the definition, multiplied by purchase rate, frequency and value, line by line
ProxiesSearch demand, category data, trade sources or competitor disclosures used as checks, and why each moves with the market
Assumptions and sourcesEvery assumption with its low and high value, the source and a confidence rating
Triangulation and rangeWhere the estimates agree or differ, the reason for any gap, and the range carried forward
Obtainable shareThe share reachable within the plan period, built from sales and marketing capacity, conversion evidence and competition
Answer and caveatsThe serviceable and obtainable markets as ranges, the assumption that drives the spread, the date and the refresh trigger

How to fill each section

Decision and definition

Start with the decision, because it sets how precise the size needs to be: a choice between two countries needs a comparison more than an absolute figure, and a budget request needs an obtainable figure more than a total. Then define the market by the job buyers are trying to get done, not by the product category, so substitutes are counted. Use the customer definition from the segmentation guide, and state the geography, the unit — buyers, purchases or spend — and the period. Write the boundary conditions, such as the price band or the minimum size of buyer, because that is where disagreements about the figure live.

Top-down estimate

Start from a broad published figure — category spend, a count of households or businesses, a population — and narrow it one filter at a time: region, segment, the share with the problem, the share who pay to solve it. Write each filter as its own line with its own assumption reference. The market sizing guide explains why the method's weakness is that filters compound, so a chain of plausible percentages can produce almost any answer; showing every line is what lets a reviewer find the weak link. Check that the source's category definition matches yours before using its total.

Bottom-up estimate

Count the buyers who meet your definition from registers, directories, customer lists or panel data, then estimate how many buy, how often and at what value, using your own sales data, competitor disclosures or primary research. Multiply, line by line. The bottom-up route uses your own definitions and evidence, which is its strength; its weakness is assuming that the buyers you already know are typical of those you do not. Do it independently of the top-down estimate, ideally by a different person, so the two do not share assumptions.

Proxies

Add the checks that measure something related to demand. Query Search Volume for the problem, the category and its substitutes shows expressed demand and how it splits by region and season; it is strongest as a relative signal and weakest as an absolute count, because it counts searches rather than buyers. Category statistics, trade sources and competitors' published customer counts or segment revenues set floors and ceilings. For each proxy, write in one line why it should move with the market, because a proxy without that reason is decoration.

Assumptions and sources

List every assumption once, with a low and a high value, its source and a confidence rating: high for a documented count, medium for a credible estimate, low for a judgement. Both estimates refer to this table, so changing an assumption updates the whole worksheet. Where an input comes from the business's own Unit Economics — average order value, purchase frequency, retention — say which period and which customers it was measured on. An assumption taken from a conversation with a distributor, installer or consultant goes in as that person's view, coded rather than named, as the guide to interviewing industry experts describes.

Triangulation and range

Compare the estimates and explain the gap. A top-down figure well above the bottom-up one usually means the published category is drawn wider than your definition, or that the bottom-up count missed a segment; either finding improves the size. Then build the range: identify the few assumptions the answer is most sensitive to, run the estimate at their low and high values, and carry forward the range rather than a midpoint. The guide is clear that the point is not to average the routes but to learn why they differ.

Obtainable share

The obtainable layer is the one that matters for planning and the one most often invented. Build it from capacity and evidence: how many prospects marketing can reach, how many conversations or sign-ups the funnel can handle, how often they convert, and how strong the incumbents are. For a business weighing a new country, the market entry guide explains how a pilot market tests these assumptions before full investment. If the obtainable figure implies more customers than the business can serve, it is not obtainable.

Answer and caveats

State the serviceable and obtainable markets as ranges, keep the layers visibly separate, name the assumption that drives most of the spread and what it would take to narrow it, and date the estimate with the event that should trigger a refresh. Lead with the definition rather than the number, so a reader who reuses the figure for another decision can see whether it still applies.

Filled example

Below, the worksheet is completed in summary for an invented business. The figures, sources and names are illustrative, chosen to show the working rather than to describe a real market.

Illustrative example — not a real result

Barkhallow Dog Training: sizing the UK market for an online puppy course

FieldBarkhallow's worksheet
Decision and definitionDecision: whether to invest in a German version next year or spend the same budget growing at home. Market: UK households with a puppy under 12 months who pay for training of any kind (classes, one-to-one or online), valued at annual spend on puppy training. Period: one year. Boundary: excludes working-dog and assistance-dog training
Top-down estimatePet industry survey: about 13 million dog-owning UK households (A1). Households acquiring a puppy in a year: 6% to 9% (A2), giving 780,000 to 1,170,000. Share paying for any training: 35% to 50% (A3), giving 273,000 to 585,000. Average spend on puppy training: £90 to £140 (A4). Serviceable market: £25m to £82m
Bottom-up estimatePuppies registered or microchipped in a year, from a national breed registry plus a microchip database sample: 700,000 to 900,000 (A5). Share whose owners pay for training, from Barkhallow's own survey of 1,200 owners: 38% to 46% (A3b), giving 266,000 to 414,000. Average spend from the same survey: £95 to £120 (A4b). Serviceable market: £25m to £50m
ProxiesMonthly UK searches for "puppy training" and close variants: about 90,000, peaking in January and after summer, in line with puppy acquisition seasons (relative check). Two listed pet-service competitors report 41,000 and 18,000 paying puppy-course customers a year: a floor of about 59,000 buyers. Search interest for online puppy courses grew year on year, while class-based terms were flat
Assumptions and sourcesA1 households: survey, medium confidence. A2 acquisition rate: survey, low confidence (wide spread between years). A3 paying share: survey, medium; A3b own survey, medium (sample skews to engaged owners). A4 spend: trade estimate, low; A4b own survey, medium. A5 registrations: registry and database, high for the registry, medium for the microchip sample
Triangulation and rangeBoth routes agree at the low end (£25m). The top-down high end (£82m) depends on A2 at 9% and A4 at £140, neither supported by Barkhallow's own data. Carried forward: serviceable market £25m to £50m, with the bottom-up route preferred because its inputs are closer to the definition
Obtainable shareOnline courses are about a fifth of paid puppy training in Barkhallow's survey (£5m to £10m). With current ad budget and conversion rates, Barkhallow can reach 9,000 to 14,000 buyers a year at £89 a course within two years: £0.8m to £1.25m, or between 8% and 25% of the online segment depending on its true size
Answer and caveatsUK serviceable market: £25m to £50m a year; obtainable within two years: £0.8m to £1.25m. Driving assumption: the paying share (A3/A3b); a larger, less engaged survey sample would narrow it. Dated 15 September; refresh when next year's registration figures are published. Recommendation: current sales of about £0.4m are well under the home obtainable range, so grow at home first and run the same worksheet for Germany before deciding

Common mistakes

  • A borrowed definition. A published total describes the category as its publisher drew it. Define the market yourself and check whether the source matches before using its figure.
  • One method only. A top-down estimate never tested against a bottom-up count passes any error in its source straight into the plan. Build two estimates independently.
  • Hidden filters. A total reduced by a single round percentage cannot be challenged. Show every filter as its own line with its own assumption.
  • A proxy treated as the market. Search volume counts searches, not buyers, and the category's query volume is the size of the shop window, not of the market. Use proxies as checks.
  • A point where the evidence supports a range. False precision invites readers to treat an assumption as a measurement. Carry the range and name the assumption that drives it.
  • Total presented as obtainable. Plans built on the total addressable market as if it could be won fail on contact with sales capacity. Keep the layers separate and build the obtainable share from capacity.
  • No date. An undated estimate is reused for a later decision without anyone checking it. Date it and set the refresh trigger.

The go-to-market and planning documents that use a market size are in the templates library.

Terms used on this page

Where this page is used

Also related

Related