SEO automation that keeps running
If someone on your team spends hours pulling data together every week, there's probably a better way. I build scripts, reports and small applications that handle the repetitive work.
#the-work
Every SEO team has a task that eats a day a week. Someone exports three reports, stitches them together in a spreadsheet, and produces the same deliverable as last month.
I build the tool that fits: Python scripts, scheduled reports and small apps shaped around your data sources, naming and sign-off process. I work inside your warehouse, with SQL pipelines in Snowflake and BigQuery and Streamlit apps, including Streamlit in Snowflake where the data can’t leave. You own the code.
I also measure what changed: before-and-after analysis of releases, and benefit models that put a likely value on each backlog item, so tests and fixes are ordered by impact.
The free tools on this site started the same way: a real client problem, solved, then generalised.
#data
Most problems on large sites only show up when the data is joined. I bring your sources together in your data warehouse, then build what your team uses on top of it.
Your data
- Search Console
- Analytics
- Crawl data
- Product, location or property data
Joined in
Your data warehouseBigQuery, Snowflake or similar
Used by your team
- Reports
- Checks and alerts
- Apps
#examples
The kind of output this work produces. The data shown is illustrative.
- e.g. Weekly Slack alerts for Monday morning
- e.g. Dashboards your team keeps
- e.g. Search Console data pipelines
- e.g. Impact analysis of site releases
- e.g. Benefit models to prioritise tickets
#includes
Includes
- Automated reports delivered to Slack
- Search Console data pipelines
- Apps that work with your data warehouse
- Dashboards your wider team can actually use
- Before-and-after impact analysis for site changes
- Benefit models to order your SEO backlog
Free tools to start with
Free for one-off exports. The service adds pipelines, schedules and interpretation.
#how-it-works
- 01
Tell me what's getting in the way
Send me a message or email me. You don't need a polished brief or a list of requirements. Just tell me what's holding your team back, what you need help with or what you'd like to improve.
- 02
Agree on the work
I'll set out what needs doing, what you'll get, how long it'll take and what it'll cost. We'll agree on the scope before I start, so you know what to expect.
- 03
I get on with it
I work directly with your team to investigate problems, build solutions and get the work shipped. I'll keep you updated as I go, and if something unexpected comes up, we'll work out the next step together.
- 04
Built to keep working
You keep the code, scripts, documentation and data. If I've built a tool, dashboard or automated process for your team, I'll make sure you have what you need to run and maintain it.
/services
- Technical SEO I investigate the problems that stop search engines crawling, indexing and understanding your site. That includes the awkward issues that tend to come with large, complex websites.
- Ecommerce SEO I help ecommerce teams find and fix problems across large product catalogues, from category page coverage to product data and shopping feeds.
- AI search visibility AI assistants are becoming another way people find information about businesses. I help you understand where your brand appears, what those systems say about you, and whether your own website gives them accurate information to work from.