Data analytics case study · SEO market analytics

SEO market opportunity for bus travel

I compared search demand, query intent and sampled competitors to recommend a launch sequence for a new bus travel vertical in Spain, France and the United Kingdom.

Three-market comparison Supplied dataset
Total and non-brand demand

Bars compare monthly keyword search volume on one scale. Mint shows the non-brand portion; percentages show its share within each market.

ES
53.2%
FR
69.7%
UK
40.4%
Comparison of total and non-brand monthly search demand across Spain, France and the United Kingdom. France has the highest non-brand share and is recommended as the first launch market.
Recommended first marketFrance

A focused starting point for testing route-led acquisition.

Total demand analysed2.15M

Estimated monthly searches in the supplied keyword set.

Non-brand demand1.11M

Search volume for queries without a named brand or operator.

France non-brand share69.7%

The strongest non-brand ratio in the comparison.

Business context

A launch across three markets

A professional assessment for a European online travel company asked which market should lead a new organic bus travel offering. I used supplied keyword and ranking data to compare the options and identify a practical launch focus.

My contribution

I normalised the data, classified brand queries, search intent and competitor types, built a keyword-to-ranking crosswalk and checked the summary totals. I translated those findings into market priorities and a route-led site architecture.

Working approach Excel analysis · Data quality checks · SQL examples for reproducibility

Market evidence

Search demand by market

The UK leads on total volume in the supplied keyword set. Switch metrics to compare absolute non-brand volume with its share of each market.

Compare market opportunity

Select a metric, then a market. Volumes are sums of keyword estimates, not unique users or the whole national travel market; non-brand queries do not guarantee ranking ease or traffic.

View the comparison as a table
Estimated monthly keyword search volume by market · 211 included records
MarketTotal searchesNon-brand searchesNon-brand share
Spain653,900348,10053.2%
France534,500372,30069.7%
United Kingdom958,700387,00040.4%

Analysis lenses

Intent, query types and competitors

Transactional queries lead in every market. Compare their share, the non-brand query mix and the types of competitors in the ranking sample.

France search intent

Transactional queries account for 68.3% of France’s total keyword volume, compared with 51.6% in Spain and 55.3% in the UK.

Volume and share of the selected market total. Source: Summary_Tables in the analytical workbook.

FranceVolume · share
01Transactional365,10068.3%
02Navigational147,50027.6%
03Informational21,9004.1%

Method and data quality

Preparing market data

I made the supplied tables comparable before interpreting demand. Duplicate flags protected the totals, brand classification clarified the query mix and match status kept uncertain ranking assignments visible.

01

Normalise

Standardise CPC values, numeric fields, spelling variants and accents.

02

Protect the denominator

Exclude both duplicate-flagged records from market totals and retain them for inspection.

03

Classify demand

Separate brand and operator queries from non-brand demand.

04

Classify competitors

Group sampled ranking records into operators, aggregators and online travel agencies (OTAs), or marketplaces.

05

Join and test

Link normalised queries to ranking records, retain uncertain matches and validate summaries.

Keyword table213 input records
Competitor table125 ranking records
Cross-market scope3 markets
Project evidenceDownload the cleaned workbook ↓

Market totals use 211 keyword records; two duplicate-flagged rows are excluded. The ranking crosswalk retains 117 matched, four ambiguous and four unmatched records. Ranking samples cover 50 of the 211 included keyword records.

SQL exampleInspect a reproducible market summary
SELECT
  market,
  SUM(avg_monthly_searches) AS non_brand_search_volume,
  COUNT(DISTINCT keyword_norm) AS non_brand_keywords
FROM keyword_clean
WHERE brand_flag = FALSE
  AND dup_keyword_market_flag = FALSE
GROUP BY market
ORDER BY non_brand_search_volume DESC;

Decision logic

From market evidence to launch priorities

The recommendation changes when headline volume is read together with brand dependence, scalable query types and the visible competitor mix.

UK
Signal

Volume and dependence

Implication

The UK has the largest total volume (958,700) and non-brand volume (387,000). However, 59.6% of its keyword volume is brand-related, and operators account for 32 of 54 ranking records (59.3%), suggesting a more selective entry test.

FR
Signal

A different query mix

Implication

France has a slightly smaller non-brand base than the UK (372,300), but the highest non-brand share (69.7%) and transactional share (68.3%). Operators account for 12 of 38 ranking records (31.6%), supporting a focused initial test.

SEO
Signal

A repeatable route structure

Implication

City-to-city route queries sum to 688,300 estimated monthly searches, distributed almost evenly across the three markets. That supports a common route-page structure with local prices, schedules and transfer information.

01

France

Test the route-led architecture in a market with a strongly transactional query mix. Use the launch to validate rankings, qualified traffic and conversion.

02

Spain

Adapt the tested structure to Spanish routes, schedules and booking queries, using local demand and performance to guide expansion.

03

United Kingdom

Pilot selected city-to-city routes and airport-transfer clusters before committing to wider coverage in the most operator-heavy sample.

Organic architectureRoute pages at the centre
FoundationCountry and city hubs
Core assetCity-to-city route pages
Demand supportPrice, schedule and transfer modules

Project evidence

Explore the project evidence

Review the underlying data and QA checks, or download the summary of the business question, findings and recommendation.

Continue exploring

Explore more data work

Compare this market analysis with operational reporting and loan portfolio analysis, or explore my wider data experience.

Contact

Need a clearer answer from complex data?

I turn complex datasets into clear comparisons, practical recommendations and reports people can use.