It's not possible to do SEO at scale if you're still doing everything manually. You need automation, monitoring, and alerting, and at this level, your data doesn't fit in a spreadsheet.
I design and build scalable technical SEO systems that automate crawling, monitoring, and data integration across enterprise-level sites. My focus is on automation, cloud infrastructure, and actionable data pipelines that power smarter SEO decisions.
Here are some of my projects:
AI Overview Monitoring
Monitoring solution using DataForSEO API to track AI Overview appearances, changes, and performance across target keywords, providing insights into Google's generative search features.
- Real-time AI Overview tracking
- Keyword-level monitoring via DataForSEO API
- Change detection and alerts
- Performance analysis and reporting
DataForSEO API
AI Overview
Keyword Tracking
Screaming Frog Cloud Automation
Automated Screaming Frog crawls running on cloud infrastructure with cron-controlled scheduling, pushing crawl data directly into Snowflake for SQL-based analysis and reporting.
- Scheduled crawls without manual intervention
- Data warehouse integration for advanced querying
- Centralized monitoring and alerting
Screaming Frog
Snowflake
Cron
DMCA Takedown Monitoring
Automated system for monitoring and tracking DMCA takedown requests, ensuring content protection compliance and maintaining up-to-date status across multiple platforms.
- Automated detection and logging
- Multi-platform monitoring
- Status tracking and reporting
Compliance
DMCA
Website Vectorisation
Vector-based content analysis for identifying content gaps, optimizing internal linking structures, and systematically identifying URLs ready for retirement.
- Gap analysis through semantic similarity
- Automated interlinking recommendations
- Content consolidation planning
Vector Embeddings
Python
Content Analysis
Hreflang Matching
Large-scale hreflang implementation and validation system for international sites, ensuring correct language and region targeting across multiple domains and subdirectories.
- Cross-domain hreflang validation
- Bidirectional link verification
- Automated error detection and reporting
Hreflang
International SEO
Python
Google Search Console Pipeline
Data pipeline setup connecting Google Search Console to Snowflake, using multiple property queries to bypass the 50k row export limitation and enable unlimited historical data analysis.
- Multiple GSC property aggregation
- Automated data pipeline to Snowflake
- Bypasses 50k row export limits
- Unlimited historical data retention
Google Search Console API
Snowflake
ETL
Indexation Monitoring
Automated system for monitoring and tracking site indexation status, identifying indexation issues, and providing real-time alerts for indexing problems across large-scale websites.
- Real-time indexation tracking
- Automated issue detection with 90, 120, and 150-day no-crawl alerts
- Multi-site monitoring
- Alerting and reporting
Google Search Console API
Python
Indexation
XML Sitemap Monitoring
Hourly XML sitemap monitoring solution built in Python on Azure, tracking sitemap changes, validating URLs, and alerting on sitemap availability issues or structural changes.
- Hourly sitemap monitoring
- URL validation and change detection
- Availability and uptime tracking
- Automated alerting on issues
Python
Azure
Sitemap
Website Migration
Comprehensive framework or domain migration project involving detailed planning, QA processes, redirect mapping, and post-launch monitoring to minimize organic visibility impact.
- Pre-migration audit and inventory
- Redirect strategy and implementation
- Structured data preservation
- Post-launch monitoring and optimization
Site Migration
Technical SEO
Strategy
Scalable Crawling
Self-service crawling infrastructure - an on-demand, scalable solution providing purpose-built crawling servers and managed services for large-scale website audits.
- DIY crawling servers with Screaming Frog integration
- Managed crawling services for enterprise sites
- Cloud storage and BigQuery data warehousing
- Multi-site concurrent crawling capabilities
Screaming Frog
BigQuery
Looker