Projects

Technical SEO projects focused on automation, data pipelines, and scalable solutions for complex site architecture challenges.

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

Interested in Working Together?

These projects represent just a sample of the technical SEO work I've delivered. If you're facing similar challenges or need custom solutions, let's discuss.