Service
SEO data analysis with Python and SQL
Search Console only shows you part of the picture. I pull your search, analytics and crawl data together with Python, SQL and BigQuery to find where traffic is won or lost, and which fixes will actually move the numbers.
- For
- Sites with a lot of pages, queries or markets
- Deliverable
- Analyses, forecasts and recommendations
- Languages
- French and English
Why it matters
On large sites, intuition doesn't scale. Traffic drops hide in page groups, markets or query types, and the interface of the tools can't show them. Data analysis turns thousands of rows into a few clear decisions.
It also answers the questions that matter to the business: what an update really cost, which sections deserve investment, and what traffic to expect next quarter.
What's included
Search Console at scale
Full exports through the API, beyond the 1,000-row limit of the interface, by page, query, country and device.
Drops and anomalies
What changed, where and when: updates, migrations, cannibalization, seasonality or tracking issues.
Segmentation
Traffic by template, section, topic cluster, market or intent, to see what really drives results.
Semantic proximity
Embeddings to measure how well each page matches the queries it should rank for, compared with competitors.
Traffic forecasting
Forecasts of clicks, impressions and positions with Google's TimesFM and Meta's Prophet.
Automation
Recurring analyses automated in Python and SQL, so you get the same answers every month without the manual work.
How it works
- 1
30-minute call
We look at your site together: your goals, what's blocking you, and the scope of the work.
- 2
Access and data
Read access to Search Console, Analytics and, when useful, Bing Webmaster Tools. I crawl the site and gather the data.
- 3
Analysis
I audit, measure and compare you with the competitors that matter, then turn findings into priorities.
- 4
Roadmap and walkthrough
You get a prioritized action plan, presented live so your team knows exactly what to do and why.
- 5
Follow-up
I can support implementation with your developers and writers, and track the results over time.
What you get
- Clear answers to your business questions
- Segmented analyses of your search data
- Traffic forecasts with their assumptions
- Reusable Python notebooks or SQL queries
- Recommendations ordered by impact
Tools I use
- Python (pandas)
- SQL (BigQuery)
- Search Console API
- Ahrefs API
- sentence-transformers
- TimesFM
- Prophet
Results and feedback
La passion de Aslane Samai pour l'analyse des données et son dévouement inébranlable pour maximiser le retour sur investissement de nos campagnes sont vraiment louables. Son expertise en SEO, SEM et réseaux sociaux est remarquable, et il est évident qu'il a une compréhension approfondie de la manière de générer du trafic qualifié vers le site web d'InterFast.
SEO & GEO Case Study: aioseo.fr, a GEO Blog Built from Scratch
How aioseo.fr went from 1,000 to 36,000 monthly Google impressions and earned 14,765 impressions in AI Overviews and AI Mode: niche, news…
Read the case study
SEO Case Study: RADCO, Construction Company in Algiers
How RADCO, a construction company in Algiers, went from a blank slate to strong online visibility: technical fixes, indexing, content and…
Read the case studyQuestions about this service
What data do you need?
Read access to Search Console, and ideally to Google Analytics 4 or BigQuery exports. I can also work from CSV exports.
Why not just use the Search Console interface?
The interface samples and limits the data. The API and BigQuery give access to much more detail, which you can segment and combine with other sources.
Can you forecast our organic traffic?
Yes, with models such as TimesFM and Prophet, based on your history. Forecasts come with their assumptions and limits.
SEO and GEO audit
What's blocking your visibility on Google and in AI answers, and what to fix first. It starts with a 30-minute call.