🏆 Top Pages by Traffic
last 6 months
| Page | Impressions | Clicks | CTR | Avg Pos | Trend |
|---|
⚠️ Pages with Ranking Drops
position worsened vs previous period
| Page | Pos Before | Pos Now | Change | Impressions | Clicks |
|---|
🔑 Top Keywords with Low CTR (opportunity)
high impressions, low clicks — potential CTR optimization
| Keyword | Impressions | Clicks | CTR | Position |
|---|
| Page URL | Impr (now) | Impr (prev) | Δ Impr | Clicks | CTR | Pos (now) | Pos (prev) | Δ Pos | Tasks |
|---|
| Keyword | Impr (now) | Impr (prev) | Δ Impr | Clicks | CTR | Pos (now) | Pos (prev) | Δ Pos |
|---|
Tasks
🔴 Priority 1 — Urgent
🟡 Priority 2 — Important
⚪ Priority 3 — Later
Import CSV from Google Search Console
Export Performance data from GSC → select "Compare" mode (last 6 months vs previous) → export Queries CSV and Pages CSV separately. The files should have columns: Top queries/Top pages, Last 6 months Impressions, Previous 6 months Impressions, Last 6 months Clicks, Previous 6 months Clicks, Last 6 months Position, Previous 6 months Position.
Queries CSV
✓ Queries loaded successfully
Pages CSV
✓ Pages loaded successfully
Data Status