An Enterprise Grade SEO Audit Web Application

AtSpisek d.o.o.
Year2022
RoleCo-Founder and Sole Developer

Tools

PythonFlaskJinjaHTMLCSSJavascriptMySQLShell ScriptVirtualizationCloud

Overview

An enterprise-grade SEO crawler and audit platform built to scan millions of pages per project and check against 300+ technical SEO issues. Originally developed as an internal tool for Spisek d.o.o., it evolved into a standalone SaaS product that Spisek relied on for over years, now available to external users.

Key Features

High-Scale Crawling & Scheduling

  1. Crawl millions of URLs in a single run
  2. Customizable schedules (daily/weekly/monthly) and crawl archiving for trend analysis

300+ SEO Checks

  1. Predefined audit reports covering everything from indexability and metadata to performance and security issues

Advanced Link Explorer

  1. 40+ metrics per URL (response codes, link depth, anchor text distribution, load times, etc.)
  2. Conditional filtering and toggleable metrics for bespoke reporting

Intuitive Dashboard and Reporting

  1. 15 “out-of-the-box” SEO reports designed for rapid insights
  2. Export to Excel or CSV with one click
  3. Automated email notifications highlighting new issues and delta vs. previous crawl

Rapid Onboarding

  1. Spin up a new project in minutes and immediately begin large-scale audits

Technical Architecture

Backend & API

Python 3 + Flask

Frontend

HTML, CSS, JavaScript (vanilla + Jinja components)

Data Storage

MySQL on a dedicated database server

Infrastructure

  1. Three interconnected Droplets on DigitalOcean, separate VM for frontend, backend and database, behind Nginx reverse-proxies
  2. Shell scripts for deployment automation and VM orchestration
  3. Virtualization ensures zero-downtime upgrades and near-local network performance

Role and Impact

Co-Founder & Sole Developer

  1. Led end-to-end design, development, deployment and maintenance
  2. Rolled out new features (e.g., link explorer filters, email diff reports) based on our own agency’s needs
  3. Reduced audit turnaround from days to minutes, enabling faster client reporting and iteration

Client Success

  1. Enabled Spisek d.o.o. to automate and scale SEO crawls, freeing up 20+ hours/month in manual QA