// loading case studies
SaaSLaravelSEOAITailwind CSSPostgreSQLMySQL
KeywordMetrics SEO Operations Platform
2024
Overview
About the project
KeywordMetrics is a production-grade Laravel + Livewire platform that connects to Google Search Console, queues data ingestion jobs, and highlights profitable content updates. It orchestrates OAuth onboarding, Stripe billing plans, impersonation tools, OG asset generation, and AI-assisted content briefs so SEO teams can go from raw impressions to shipped updates in minutes.
Engineering
Challenges & solutions
Challenges
- 01Onboarding agencies securely to Google Search Console while persisting refresh tokens and enforcing scopes.
- 02Coordinating long-running keyword analytics, content analysis, and status updates without blocking the UI.
- 03Packaging enterprise billing tiers, impersonation workflows, and operations tooling into one cohesive UX.
Solutions
- 01Brokered Google OAuth flows with refresh-token rotation, permission audits, and scheduled Search Console ingestion pipelines.Orchestrated queue-backed analytics via Horizon, streaming progress to Livewire dashboards with optimistic UI states and Redis caching.",Integrated Stripe Cashier subscriptions, admin impersonation, OG asset generation, and automated content briefs to keep operations within KeywordMetrics.
Tech Stack
Laravel 10Livewire 3PHP 8.1MySQLRedisLaravel HorizonStripe CashierGoogle Search Console APIOpenAITailwind CSS
Project Info
- Completed
- 2024
- Category
- SaaS
- Tag
- Laravel
- Tag
- SEO
- Tag
- AI
- Tag
- Tailwind CSS
- Tag
- PostgreSQL
- Tag
- MySQL