
ปัญหา
A full-service marketing agency needs a UTM builder, an attribution engine, a GTM generator, a schema.org generator, a redirect manager, and SERP tracking on day one. Buying each from a SaaS vendor is ~$400 per month per agency and lands the data in six different silos. We wanted one self-hosted stack with the agency's data in one database.
เราสร้างมันอย่างไร
- 01FastAPI backend with 77 endpoints and a PostgreSQL data model tuned for agency multi-tenancy.
- 02Next.js frontend with shadcn/ui for the agency-operator UX — UTM builder, attribution dashboard, schema generator, redirect manager, internal linker.
- 03DataForSEO integration for real SERP intelligence when needed; MOCK_MODE for development without burning credits.
- 04Docker Compose stack with Caddy terminating HTTPS, a single docker-compose up from a fresh box.
ผลลัพธ์
MVP through seven phases. Replaces ~$3,500/month of commercial SaaS on paper; unavoidable cost shrinks to ~$80–170/month (LLM + voice + DataForSEO + VPS). Runs in mock mode today with zero external keys.
สแต็ก
Python 3.12 · FastAPI · Celery + Redis · PostgreSQL · Next.js 15 · shadcn/ui · Recharts · next-intl · Caddy.
ขั้นต่อไป
Docker Desktop install + DataForSEO $50 deposit → first real agency deployment.
เคสสตัดดีเพิ่มเติม
- Mobile AppsMieter App
German tenant-rights companion. 8-city Mietspiegel, Mietpreischeck, Nebenkostenprüfung, PDF export.
- Mobile AppsVerein App
Offline-first DSGVO-konformer Vereinsmanager: members, fees, events, docs, announcements. Free under 25 active members.
- Mobile AppsTGA-Assistent
Guided four-Gewerk Auslegungs- und Orientierungstool für SHK-Profis. Heizung, Lüftung, Kälte, Sanitär. 258 Tests, PDF-Export, offline.