Weekly GSC SEO Pulse: Top Movers Across Keyword Segments

This workflow automates SEO monitoring by pulling Google Search Console (GSC) data weekly to compare performance metrics like clicks, impressions, CTR, and position against the prior week. It segments queries by brand, non-brand, and content types (e.g., recipes, blog), calculating deltas and percentage changes to identify significant movements exceeding thresholds (±200 clicks, ±30%).

Instead of generic reports, it focuses on actionable insights: Slack notifications for big wins/losses/anomalies, and a detailed HTML email with Top 25 increases/decreases per segment, including linked URLs for quick investigation. This helps SEO teams catch opportunities early without manual data dives.

Benefits include time savings (15-25 min setup, automated weekly runs), reduced alert fatigue (threshold-based only), and customizable segments for site-specific needs. Ideal for marketing/SEO pros managing organic traffic, spotting content successes, or diagnosing drops. Supports GSC integration, Slack/email outputs, and easy filter tweaks.