SEODash: Automated GSC Monitoring & Alerting

Client Overview

Webify.io is a New York City–based SEO agency founded in 2021, specializing in international organic growth for high-traffic sites. It’s led by Igal Stolpner (former VP Growth at Investing.com) who scaled organic traffic from zero to over 250 million monthly sessions and Ron Kugler, ex-founder of Logic Leap Media.

Project Overview

SEODash is a web-based dashboard that turns raw Google Search Console data into actionable alerts. Once a user connects their Google account, SEODash continuously ingests clicks, impressions, CTR, and average position for every site, query, page, country, and device and then notifies them when performance shifts cross customizable thresholds.

The Challenge

Volume & Velocity: A single site can have thousands of query-level data points every day. Storing and paginating that volume in MySQL would be prohibitively slow and expensive.

User Experience: SEO professionals need GSC-style filters (by date, country, device) plus one-click alert setup, without waiting for heavy page reloads.

Thresholding Logic: Users want to track both “increases” and “decreases” in any metric, with flexible percentage thresholds and scheduling (one-off, daily, weekly, monthly).

Our Solution

Hybrid Data Architecture

• BigQuery handles all raw, high-cardinality GSC metrics. We schedule a daily batch job that pulls the previous day’s data via the GSC API and appends it into partitioned tables in BigQuery.
• MySQL stores lightweight user profiles, OAuth tokens (encrypted of course), and alert configurations, keeping transactional data separate from analytics.

Filament + Livewire Admin Panel

• We extended FilamentPHP’s Tables component to read directly from BigQuery via a custom connector.
• Livewire enables seamless filtering and pagination by date-range, query, page, country, or device, mirroring Google Search Console’s UX.

Configurable Alert Engine

• Users can target Queries, Pages, Countries, or Devices and select any of the four GSC metrics.
• They define a percentage threshold (e.g. “Notify me if CTR drops by more than 20%”) and choose notification cadence: one-time, daily, weekly, or monthly.
• A scheduled Laravel command runs hourly to evaluate each active alert against the latest BigQuery data and dispatches emails when conditions are met.

Key Features

• Google Single Sign-On: Users log in with Google; OAuth scope requests only GSC read-only, ensuring trust and ease of setup.
• Real-Time Filtering: Instantly filter and page through millions of rows on any dimension without page reloads.
• Multi-Dimension Alerts: Track anomalies at the query, page, country, or device level. No manual spreadsheet maintenance.
• Flexible Notifications: One-click alerts by email, with custom frequency, so you only get pinged when it matters.

Technical Highlights

BigQuery Connector for Filament

We built a generic “BigQueryTable” resource that implements Filament’s Table interface, supporting server-side sorting, filtering, and pagination over external data sources.

Optimized Data Ingestion

To avoid API rate-limits, we batch-fetch GSC rows in daily windows and write to BigQuery using Laravel’s queue system and Google’s PHP SDK.

Alert Evaluation

Efficient diff-percentage logic is pushed down to BigQuery SQL, so our Laravel scheduler only processes a small result set per alert, keeping CPU and memory usage minimal.

Conclusion

This internal tool, SEODash, transformed Webify.io’s SEO workflow from spreadsheet-driven to fully automated monitoring and alerting. Analysts now focus on strategy, not data chores. Next steps include expanding custom metric integrations and refining alert thresholds.

Client Feedback

“I was introduced to Rizwan from Titan Dev when searching for a new developer to complete our internal software. In just three months, Rizwan rebuilt the entire system from the ground up. His speed, responsiveness, and collaborative approach made the process smooth and easy. I’m excited to keep working with Titan Dev for maintenance and future updates. I highly recommend Rizwan and his team to anyone looking for great developers.”

Igal Stolpner
Founder @ Webify.io; Ex VP of Growth @ Investing.com