Tabellab

Market Demand, Demand Share and Capture Rate: Sizing the International SEO Opportunity

Lesson 1 of 20Lab

All lessons
  1. Market Demand, Demand Share and Capture Rate: Sizing the International SEO OpportunityLabFree
  2. Market Prioritisation Scorecard: Weights, SUMPRODUCT Scores, RANK.EQ and Launch WavesLab Locked
  3. Language vs Country Targeting: SUMIFS Language Totals, Demand Shares and Version RulesLab Locked
  4. Language and Country Coverage: a Localised-Page Matrix, Coverage Rates and the Weakest Page GroupLab Locked
  5. Translation Cost Estimate: Words, Rates per Language with XLOOKUP, Fees and Cost per PageLab Locked
  6. Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and OrdersLab Locked
  7. Cost vs Traffic: Monthly Gross Profit, Payback Months, Go/Hold Rule and RankLab Locked
  8. Local Keyword Demand: Literal Translation vs Local Term, Ratios, Best Term and Missed DemandLab Locked
  9. Keyword Cluster Grid: Cluster and Market Totals, Mixed-Reference Shares and the Strongest MarketLab Locked
  10. Market Visibility Index: Expected Clicks, CTR Lookup with IFERROR, Weighted Position and Page-One ShareLab Locked
  11. Market-Level Conversion: Conversion Rate, Revenue per Session, an Index vs the Site and AssessmentsLab Locked
  12. The Cost of the Wrong Language: Local vs Fallback Conversion, Orders Lost and Revenue LostLab Locked
  13. hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass RateLab Locked
  14. Rollout Plan within a Budget: ROI, Cumulative Cost, Funding Rule and Funded ProfitLab Locked
  15. Ramp-Up Forecast: Slope, Intercept, FORECAST.LINEAR and the Month a Target Is ReachedLab Locked
  16. What-If Grid: Net Profit by CTR and Conversion with Mixed References and Break-Even ConversionLab Locked
  17. Testing Human Edit vs Machine Translation: Pooled Rate, z-Test and p-ValueLab Locked
  18. Translation Quality Sampling: Weighted Error Points, Pass Rule, AVERAGEIFS by Language and Rework CostLab Locked
  19. Net Revenue in Euros: Removing VAT, Currency Rates with XLOOKUP and Market SharesLab Locked
  20. Final Project: International SEO Scorecard with Conversion, Profit after Cost, ROI, Rank, Chart and FlagsLab Locked

You are not signed in — the lab works, but your progress is not saved. Sign up

Lesson 1 of 20 is free. Unlock all 20 hands-on labs, the final exam and your certificate.

Buy course — $9.90
Loading the spreadsheet…

Why international SEO starts with demand, not with translation

Most teams that expand a website into new countries begin with the wrong question. They ask which language to translate into, or which market a colleague happens to like. The better first question is much simpler: how many people in each market search for what we sell, and how many of them reach us today? Everything else in international SEO, from the choice of languages to the budget for translators, depends on that answer.

International SEO is the work of making a website visible in organic search results in more than one country or language. It combines market research, content, technical signals and measurement. It is also expensive to do badly: a translated site that nobody finds earns nothing, and a market with huge demand that you ignore is a missed opportunity that no dashboard will remind you of.

This free lesson shows the first step of the process in a spreadsheet: sizing the search demand of ten markets, comparing it with the organic visits you already get, and turning the difference into a visit gap. It uses a fictional company, Lindenmoor Home, and all companies, names and numbers are invented for learning. The search volumes are illustrative, not data from any real keyword tool.

What international SEO covers

It helps to separate five jobs that are often mixed up. Each of them is a topic later in the course, and each can be measured in a spreadsheet:

  • Market choice: which countries are worth the effort, based on demand, competition, margin and practical fit.
  • Targeting: which language and which country each page is meant for, and how search engines are told (for example with hreflang annotations).
  • Content and keywords: what people in each market really search for, which is often not the literal translation of your English terms.
  • Cost and return: what each market costs to launch and maintain, and how long it takes to earn that back.
  • Measurement: visibility, conversion and revenue by market, reported in one currency and without VAT.
Language and country are different choices. A German-language page can serve Germany, Austria and Switzerland, but prices, delivery and legal text are national. Lesson 3 of the course looks at when one language version is enough and when a country needs its own.

The example: Lindenmoor Home and ten candidate markets

Lindenmoor Home is a fictional online shop for home textiles and lighting. Its website is in English and serves the United Kingdom well. Customers in other countries find it only by accident. The team has estimated the monthly searches for its category terms in ten markets and has taken the organic visits of the last month from its analytics. The table shows the data of the lab above, plus the three measures you are going to calculate.

MarketLanguageMonthly searchesOrganic visitsDemand shareCapture rateVisit gap
United KingdomEnglish412,00036,50023.4%8.9%0
IrelandEnglish38,0002,1002.2%5.5%940
GermanyGerman366,0009,80020.8%2.7%19,480
AustriaGerman41,0006402.3%1.6%2,640
FranceFrench274,0005,20015.6%1.9%16,720
NetherlandsDutch96,0002,3005.5%2.4%5,380
SpainSpanish188,0001,70010.7%0.9%13,340
ItalyItalian152,0001,1008.6%0.7%11,060
PolandPolish119,0005206.8%0.4%9,000
SwedenSwedish74,0003804.2%0.5%5,540
Total1,760,00060,240100%3.4%84,100

Two things stand out immediately. The United Kingdom has the most searches and the site already captures a good part of them. Germany has nearly as many searches as the United Kingdom, but fewer than a third of the visits per search that the UK enjoys. That difference is what the rest of this lesson makes precise.

Step 1: demand share, how the opportunity is spread

The demand share of a market is its monthly searches divided by the searches of all markets together. In the sheet the total sits in cell C15, and the formula in E5 is =C5/$C$15. The dollar signs lock the total, so when you copy the formula down to E14 every market is divided by the same number.

Monthly category searches by market (share of total demand)United Kingdom412,000 (23.4%)Germany366,000 (20.8%)France274,000 (15.6%)Spain188,000 (10.7%)Italy152,000 (8.6%)Poland119,000 (6.8%)Netherlands96,000 (5.5%)Sweden74,000 (4.2%)Austria41,000 (2.3%)Ireland38,000 (2.2%)Total: 1,760,000 searches per month (illustrative)
Figure 1. Search demand is concentrated: the United Kingdom and Germany together hold 44.2 % of the demand of the ten markets.

The two largest markets, the United Kingdom (23.4 %) and Germany (20.8 %), hold together 44.2 % of the demand. France adds 15.6 % and Spain 10.7 %. The five smallest markets together are only about 21 % of the demand. A demand share tells you where a translation can matter most, but it says nothing yet about how well you are doing.

A common slip is to write =C5/SUM(C5:C14). It looks right in the first row, but when you copy it down the range moves with the row and the denominators shrink. Lock the total with $C$15 or lock the whole range with $C$5:$C$14.

Step 2: capture rate, how much of the demand reaches you

The capture rate is organic visits divided by monthly searches: =D5/C5. It answers a question the share cannot: of all the searches in this market, what fraction arrives on our site from organic results? Not every search can lead to a visit, because people click on several results or none, so a capture rate of 100 % is neither possible nor a goal. Used carefully, it is a fair way to compare markets of very different size.

Capture rate = organic visits / monthly searchesUnited Kingdom8.9%Ireland5.5%Germany2.7%Netherlands2.4%France1.9%Austria1.6%Spain0.9%Italy0.7%Sweden0.5%Poland0.4%Target 8%Green = at or above target, red = below target
Figure 2. Only one market reaches the assumed 8 % target capture rate; Germany stands at 2.7 % and Poland at 0.4 %.

Across all ten markets the site captures 3.4 % of the searches (60,240 visits from 1,760,000 searches). The United Kingdom is at 8.9 %, Ireland at 5.5 %, but Germany is at only 2.7 % and Poland at 0.4 %. Ireland is interesting: it shares the language of the UK site and the English pages already work there, so it is not a translation problem at all.

Step 3: the visit gap to a target

To turn a comparison into a size, you need a target. The sheet assumes an 8 % target capture rate in cell C2. This is an assumption chosen for the exercise, roughly the level the home market has reached; in real work you would derive it from your best market or from competitor visibility. The visit gap is then the extra monthly visits needed to reach the target: =MAX(0,C5*$C$2-D5).

The MAX(0, …) part matters. The United Kingdom is above the target, so searches × 8 % minus current visits is negative (-3,540). A negative gap is not a useful number: you do not subtract visits from the markets that are doing well. MAX(0, …) shows such a market as a gap of zero. Without it, a total of the gaps would be too small because the UK's surplus would cancel part of the other markets' shortfall.

From searches to the visit gap, GermanyMonthly searches: 366,000× 8 % target capture rate9,800Gap: 19,480Current organic visitsTarget visits: 29,280Visit gap = MAX(0, searches × target − current visits)A gap is a pointer to where visibility is missing, not yet a decision to invest.
Figure 3. For Germany the target is 29,280 organic visits per month; the site earns 9,800, so the visit gap is 19,480.

The gap of all markets together is 84,100 visits per month. Germany contributes 19,480, France 16,720 and Spain 13,340: these three markets alone make up 59 % of the total gap.

How to read the result

Read the three measures together, never one alone:

  • High demand share, low capture rate, big gap: the classic expansion candidate. Germany and France are examples.
  • High capture rate in a small market: you are already doing well, and more translation will not bring much (Ireland, to some extent).
  • Small demand share and a small gap: a market for later, or for a shared language version of a neighbouring country.
  • A gap that looks big only because the target is generous: test a lower target (for example 5 %) and check whether the ranking of markets changes. If it does not, the conclusion is robust.
Change C2 in the lab and watch what happens. If a market only enters the top three when the target is 12 %, it is a weaker case than one that stays in the top three at any target between 4 % and 12 %.

A worked check: Germany, step by step

Whenever you copy a formula down a column, verify one row by hand. Germany is a good test row because its numbers are not trivial:

  • Demand share (E7): 366,000 ÷ 1,760,000 = 20.8 %.
  • Capture rate (F7): 9,800 ÷ 366,000 = 2.68 %.
  • Target visits: 366,000 × 8 % = 29,280.
  • Visit gap (G7): MAX(0, 29,280 − 9,800) = 19,480.
Where do the inputs come from? Searches usually come from a keyword research tool that estimates volumes per country and language, and organic visits come from your web analytics, filtered to organic search and to the country of the visitor. Both are estimates with their own errors, so use the same source and the same month for all markets.
Keep the assumptions in labelled cells (here the 8 % in C2) and the data in one block. A reviewer can then change one input and see the whole sheet respond, which is much easier to discuss than a formula with a number typed inside.

Common mistakes when sizing markets

  • Using search volume as if it were visits. Volume is the demand; only a fraction of it can become organic visits, depending on rank and the result page layout.
  • Mixing time periods. Searches are monthly. Visits must be monthly too, and a seasonal peak (lighting before winter, for example) can distort a single month.
  • Comparing volumes across languages without checking the terms. The same product has different names in different countries. A keyword list translated word for word can understate the real demand badly (lesson 8).
  • Forgetting that countries share languages. Austria's demand is small, but a German-language site already serves it. The gap there is a ranking and targeting task, not a translation task.
  • Treating the gap as a business case. It ignores cost, margin and conversion. A large gap in a market with poor margins is not an opportunity.
All search volumes in this lesson are illustrative round numbers and are not taken from any real keyword database. Estimates from keyword tools differ between providers and are best treated as an order of magnitude, not as exact counts.

What the numbers do not tell you

A sizing sheet is a good start and a poor finish. It does not know how hard it is to rank: a market with a large gap and strong local competitors may need years, while a smaller gap in a less crowded market may close in a few months. It does not know what the visits are worth, because conversion rates and order values differ between countries. It does not know the cost, which depends on how many pages you need, how many words they contain and what each language costs per word.

That is why the course continues with exactly those questions. You will build a weighted scorecard for market choice, then compare languages with countries, audit your coverage and hreflang annotations, estimate translation cost, convert keyword volume into potential visits, and combine cost and traffic into a payback period.

What the 20 labs of the course cover

Each lesson uses a different fictional data set from Lindenmoor Home and ends with checked tasks. Here is the route:

  1. Market demand, demand share and capture rate (this lesson): the opportunity and the visit gap.
  2. Market scorecard: weights, SUMPRODUCT scores, ranks and launch waves.
  3. Language vs country targeting: SUMIFS by language and a rule for own or shared versions.
  4. Coverage matrix: localised pages per market and the weakest page group.
  5. Translation cost: words, rates per language and fees.
  6. Traffic potential: CTR by position, potential visits and orders.
  7. Payback: monthly gross profit, payback months and a Go or Hold rule.
  8. Local keyword demand: literal translations against the terms people use.
  9. Keyword cluster grid: mixed references and the strongest market per cluster.
  10. Market visibility index: expected clicks and weighted position.
  11. Market-level conversion: revenue per session and an index against the site.
  12. The wrong-language landing: conversion lost on fallback pages.
  13. hreflang audit: failed checks, status and pass rate.
  14. Rollout within a budget: ROI, cumulative cost and funded profit.
  15. Ramp-up forecast: slope, intercept and FORECAST.LINEAR.
  16. What-if grid: CTR and conversion scenarios and break-even.
  17. Human edit vs machine translation: a z-test with a p-value.
  18. Translation QA sampling: error points and rework cost.
  19. Net revenue in euros: VAT, exchange rates and market shares.
  20. Final project: a scorecard with ROI, rank, chart and flags.

Quick reference: functions in this lesson

Function / ideaWhat it does hereExample
SUMTotal searches and visits=SUM(C5:C14)
Absolute reference $C$15Keeps the total in place when copying down=C5/$C$15
DivisionCapture rate: visits per search=D5/C5
MAXStops a gap from going below zero=MAX(0,C5*$C$2-D5)
F4 / Cmd + TCycles through absolute and mixed references$C$15
Alt + =Inserts a SUM for the selected cellsTotals in row 15
Column chartCompares the size of the marketsLab task 5

Summary

International SEO starts with demand. For Lindenmoor Home the ten markets together offer 1,760,000 searches per month; the site collects 60,240 visits, a capture rate of 3.4 %. Demand share is =C5/$C$15, capture rate is =D5/C5 and the visit gap to an 8 % target is =MAX(0,C5*$C$2-D5). The United Kingdom is already above target, while Germany (19,480), France (16,720) and Spain (13,340) carry the biggest gaps.

Now scroll up to the lab and build the sheet yourself. It takes about eighteen minutes, the Coach checks each step, and you end up with a sizing method you can apply to your own market list. The next lesson adds the other criteria that make a market worth entering.

Frequently asked questions

What is international SEO?

International SEO is the work of making a website visible in organic search results in several countries or languages. It covers market choice, language and country targeting, local keyword research, technical signals such as hreflang annotations, and measurement of visibility and revenue by market.

How do I size the search demand of a new market?

Estimate the monthly searches for your category terms in each market with a keyword tool, add them up and divide each market's volume by the total to get its demand share. Compare the volume with the organic visits you already get to see how much of the demand reaches you.

What is a capture rate in SEO?

The capture rate is organic visits divided by monthly searches for the same market and period. It shows what fraction of the demand arrives on your site from organic results. It is useful for comparing markets of different size, but a value of 100 % is neither possible nor a goal.

Why use MAX(0, ...) in the visit gap formula?

A market that is already above the target would give a negative gap. MAX(0, target visits minus current visits) shows such a market as zero, so that a total of the gaps adds up only the shortfalls and the surplus of one market does not hide the shortfall of another.

Should I translate my site into the language with the most searches?

Not on search volume alone. Check how well you already capture that demand, how hard the competition is, the margin and conversion in the market, and the cost of translation. The course builds these steps one by one: scorecard, cost, traffic potential and payback.

Are the numbers in this lesson real?

No. Lindenmoor Home is a fictional company, and all search volumes, visits and rates are invented for teaching. Benchmarks such as the 8 % target capture rate are assumptions to practise with, not statistics about real markets or official platform data.

Keep going: International SEO & Localisation: Market Prioritisation, Language & Country Coverage, Translation Cost vs Traffic, Local Keyword Demand & Market-Level Conversion

This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.

  1. Market Prioritisation Scorecard: Weights, SUMPRODUCT Scores, RANK.EQ and Launch Waves
  2. Language vs Country Targeting: SUMIFS Language Totals, Demand Shares and Version Rules
  3. Language and Country Coverage: a Localised-Page Matrix, Coverage Rates and the Weakest Page Group
  4. Translation Cost Estimate: Words, Rates per Language with XLOOKUP, Fees and Cost per Page
  5. Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and Orders
  6. Cost vs Traffic: Monthly Gross Profit, Payback Months, Go/Hold Rule and Rank
  7. Local Keyword Demand: Literal Translation vs Local Term, Ratios, Best Term and Missed Demand
  8. Keyword Cluster Grid: Cluster and Market Totals, Mixed-Reference Shares and the Strongest Market
  9. Market Visibility Index: Expected Clicks, CTR Lookup with IFERROR, Weighted Position and Page-One Share
  10. Market-Level Conversion: Conversion Rate, Revenue per Session, an Index vs the Site and Assessments
  11. The Cost of the Wrong Language: Local vs Fallback Conversion, Orders Lost and Revenue Lost
  12. hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass Rate
  13. Rollout Plan within a Budget: ROI, Cumulative Cost, Funding Rule and Funded Profit
  14. Ramp-Up Forecast: Slope, Intercept, FORECAST.LINEAR and the Month a Target Is Reached
  15. What-If Grid: Net Profit by CTR and Conversion with Mixed References and Break-Even Conversion
  16. Testing Human Edit vs Machine Translation: Pooled Rate, z-Test and p-Value
  17. Translation Quality Sampling: Weighted Error Points, Pass Rule, AVERAGEIFS by Language and Rework Cost
  18. Net Revenue in Euros: Removing VAT, Currency Rates with XLOOKUP and Market Shares
  19. Final Project: International SEO Scorecard with Conversion, Profit after Cost, ROI, Rank, Chart and Flags

Buy course — $9.90 See the full course