GSC Winners & Losers Analysis

A powerful Google Apps Script that automatically analyzes your Google Search Console data to identify winning and losing keywords, pages, and categories. Perfect for SEO reporting and strategy optimization.

⬇️ Jump to Code Copy

📊 Auto-Generate Reports

Creates pivot tables and charts automatically from your GSC data with just one click.

🎯 Winners & Losers

Identifies top performing keywords and pages that are gaining visibility, plus those losing traction.

💡 Action Plan

Generates actionable insights for quick wins and CTR optimization opportunities.

📈 Comparison Analysis

Compares current vs previous periods to track performance changes automatically.

How to Use

Step-by-Step Setup:

Export GSC Data: Go to Google Search Console → Select your property → Download your data (Pages & Queries tabs) as CSV files. Import them into a Google Sheet.
Copy the Script: Click the "Copy Script" button below to copy the entire Apps Script code.
Open Google Sheets: Open your Google Sheet with the GSC data.
Access Apps Script: Go to Extensions → Apps Script (or Scripts in older Sheets).
Paste the Code: Delete the default code and paste the copied script.
Save and Authorize: Click Save, then refresh your Sheet. You'll see a new "SEO Tools" menu appear.
Run the Report: Click "SEO Tools" → "Run Full SEO Report & Action Plan" to generate your analysis.

What This Script Does:

✅ Cleans up excess GSC tabs automatically
✅ Creates Category Performance pivot table with winners and losers
✅ Creates Query Performance pivot table with keyword gainers/losers
✅ Generates visual bar charts for easy analysis
✅ Calculates % change and raw difference metrics
✅ Creates an Action Plan tab with quick wins and CTR optimization opportunities
✅ Applies conditional formatting (green for gains, red for losses)
✅ Formats all tables with professional styling

Copy the Script

Click the button below to copy the entire Apps Script code, then paste it into your Google Sheet's Apps Script editor:

💡 Pro Tips:

Make sure your GSC export has "Pages" and "Queries" sheet names exactly as shown.
The script works best with at least 2 comparison periods (current vs previous).
Check that your clicks, impressions, and position columns are properly labeled.
The script will create new pivot tables, so don't worry if your original data is modified.