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.
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.
| Market | Language | Monthly searches | Organic visits | Demand share | Capture rate | Visit gap |
|---|---|---|---|---|---|---|
| United Kingdom | English | 412,000 | 36,500 | 23.4% | 8.9% | 0 |
| Ireland | English | 38,000 | 2,100 | 2.2% | 5.5% | 940 |
| Germany | German | 366,000 | 9,800 | 20.8% | 2.7% | 19,480 |
| Austria | German | 41,000 | 640 | 2.3% | 1.6% | 2,640 |
| France | French | 274,000 | 5,200 | 15.6% | 1.9% | 16,720 |
| Netherlands | Dutch | 96,000 | 2,300 | 5.5% | 2.4% | 5,380 |
| Spain | Spanish | 188,000 | 1,700 | 10.7% | 0.9% | 13,340 |
| Italy | Italian | 152,000 | 1,100 | 8.6% | 0.7% | 11,060 |
| Poland | Polish | 119,000 | 520 | 6.8% | 0.4% | 9,000 |
| Sweden | Swedish | 74,000 | 380 | 4.2% | 0.5% | 5,540 |
| Total | 1,760,000 | 60,240 | 100% | 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.
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.
=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.
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.
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.
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.
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.
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:
- Market demand, demand share and capture rate (this lesson): the opportunity and the visit gap.
- Market scorecard: weights, SUMPRODUCT scores, ranks and launch waves.
- Language vs country targeting: SUMIFS by language and a rule for own or shared versions.
- Coverage matrix: localised pages per market and the weakest page group.
- Translation cost: words, rates per language and fees.
- Traffic potential: CTR by position, potential visits and orders.
- Payback: monthly gross profit, payback months and a Go or Hold rule.
- Local keyword demand: literal translations against the terms people use.
- Keyword cluster grid: mixed references and the strongest market per cluster.
- Market visibility index: expected clicks and weighted position.
- Market-level conversion: revenue per session and an index against the site.
- The wrong-language landing: conversion lost on fallback pages.
- hreflang audit: failed checks, status and pass rate.
- Rollout within a budget: ROI, cumulative cost and funded profit.
- Ramp-up forecast: slope, intercept and FORECAST.LINEAR.
- What-if grid: CTR and conversion scenarios and break-even.
- Human edit vs machine translation: a z-test with a p-value.
- Translation QA sampling: error points and rework cost.
- Net revenue in euros: VAT, exchange rates and market shares.
- Final project: a scorecard with ROI, rank, chart and flags.
Quick reference: functions in this lesson
| Function / idea | What it does here | Example |
|---|---|---|
SUM | Total searches and visits | =SUM(C5:C14) |
Absolute reference $C$15 | Keeps the total in place when copying down | =C5/$C$15 |
| Division | Capture rate: visits per search | =D5/C5 |
MAX | Stops a gap from going below zero | =MAX(0,C5*$C$2-D5) |
| F4 / Cmd + T | Cycles through absolute and mixed references | $C$15 |
| Alt + = | Inserts a SUM for the selected cells | Totals in row 15 |
| Column chart | Compares the size of the markets | Lab 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.
- Market Prioritisation Scorecard: Weights, SUMPRODUCT Scores, RANK.EQ and Launch Waves
- Language vs Country Targeting: SUMIFS Language Totals, Demand Shares and Version Rules
- Language and Country Coverage: a Localised-Page Matrix, Coverage Rates and the Weakest Page Group
- Translation Cost Estimate: Words, Rates per Language with XLOOKUP, Fees and Cost per Page
- Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and Orders
- Cost vs Traffic: Monthly Gross Profit, Payback Months, Go/Hold Rule and Rank
- Local Keyword Demand: Literal Translation vs Local Term, Ratios, Best Term and Missed Demand
- Keyword Cluster Grid: Cluster and Market Totals, Mixed-Reference Shares and the Strongest Market
- Market Visibility Index: Expected Clicks, CTR Lookup with IFERROR, Weighted Position and Page-One Share
- Market-Level Conversion: Conversion Rate, Revenue per Session, an Index vs the Site and Assessments
- The Cost of the Wrong Language: Local vs Fallback Conversion, Orders Lost and Revenue Lost
- hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass Rate
- Rollout Plan within a Budget: ROI, Cumulative Cost, Funding Rule and Funded Profit
- Ramp-Up Forecast: Slope, Intercept, FORECAST.LINEAR and the Month a Target Is Reached
- What-If Grid: Net Profit by CTR and Conversion with Mixed References and Break-Even Conversion
- Testing Human Edit vs Machine Translation: Pooled Rate, z-Test and p-Value
- Translation Quality Sampling: Weighted Error Points, Pass Rule, AVERAGEIFS by Language and Rework Cost
- Net Revenue in Euros: Removing VAT, Currency Rates with XLOOKUP and Market Shares
- Final Project: International SEO Scorecard with Conversion, Profit after Cost, ROI, Rank, Chart and Flags