How to get the CSV
- Open
Google Search Console→ choose your property - Go to
Performance→Search results - Set your date range (last 3 months is a good default)
- Click the
Pagestab - Click
Export(top right) →CSV - Upload the file above
What you'll get back
A four-tab XLSX workbook:
- Summary — site-wide stats, category breakdown, key insights
- Best Performing — pages with 30+ clicks. Your traffic moat.
- Low-Hanging Fruit — page-2 climbers + page-1 CTR opportunities
- Not Performing — high-impression underperformers + dead weight
Categorization logic
| Winner | Clicks ≥ 30 |
| Low-Hanging Fruit | Position 11–20 AND Impressions ≥ 500 |
| CTR Opportunity | Position 4–10 AND CTR < 1.5% AND Impressions ≥ 300 |
| Underperforming | Impressions ≥ 1,000 AND Clicks ≤ 5 |
| Dead Weight | Clicks = 0 AND Impressions < 500 AND Position > 20 |