Do you connect to my Google account?

No. This tool only parses text you paste. No API keys and no Search Console authentication.

Why is average position weighted?

Weighted average uses impressions so a rare deep page does not skew the mean the same way a simple average would.

Can I use semicolon-separated files?

The parser expects comma-separated columns as shown in the sample. Re-export or convert delimiters first.

What if a column is missing?

Parsing looks up columns by header name. Missing columns produce empty keys and may drop rows. Fix the header row and try again.

SERP & Rankings

Live

Search Console Analyzer

Slice GSC performance data with custom segments and pivots.

X / Twitter LinkedIn Facebook

GSC export CSV

Header: query,page,country,device,impressions,clicks,position

38,500

Impressions

3,990

Clicks

10.36%

CTR

4.7

Avg position

Pivot

query	Imp	Clicks	CTR	Avg pos
hiking boots	22,700	2,200	9.7%	4.0
trail running shoes	8,000	1,020	12.8%	5.3
hiking boots beginners	3,200	420	13.1%	3.5
backpack fit	2,700	210	7.8%	8.1
sock guide	1,900	140	7.4%	7.5

Start here · What is this analyzer for?

Search Console stores performance rows: query, page, country, device, impressions, clicks, and average position. Teams export CSVs when they want spreadsheets not tied to the UI.

This tool accepts a CSV-shaped block with a fixed header row. It aggregates your chosen dimension and recomputes totals, CTR, and weighted average position.

It is privacy-friendly: processing stays in your browser. Paste exports from Search Console or practice files that follow the same columns.

When to use this tool

Find your winning queries
Pivot by query and sort by clicks to see which phrases already earn traffic.
Spot weak pages
Pivot by page and compare CTR versus position to notice titles that underperform expectations.
Device or country splits
Pivot by device or country when you suspect mobile titles or international templates behave differently.
Teach GSC basics
Use the bundled sample CSV to explain how aggregation changes when dimensions roll up.

Examples

Walk through these with the form above — they are practice scenarios, not live data.

Paste your export

Try this

Copy a GSC table export with header query,page,country,device,impressions,clicks,position and paste it into the text area.

What to look for

Check the headline totals, switch pivot to query, and confirm the highest click rows match what you see in Search Console.

Page-level diagnostic

Try this

Filter mentally to one URL by keeping rows for a single /blog/example path in the paste (or edit the CSV first).

What to look for

Pivot by query to list terms that single page ranks for and how CTR looks before you rewrite the title.

Short tutorial

Follow in order the first time you use the tool; later you can skip to the step you need.

Step 1 — Export from Search Console
Use the Performance report, choose dimensions that match the header, and export as CSV or paste equivalent rows.
Step 2 — Keep the header exact
The first line must be query,page,country,device,impressions,clicks,position in any case the tool normalizes to lowercase.
Step 3 — Paste and validate totals
Confirm impressions and clicks match your source file within rounding. CTR should be clicks divided by impressions.
Step 4 — Pick a pivot dimension
Toggle query, page, country, or device depending on the story you need.
Step 5 — Take insights back to briefs
Pair high-impression, low-CTR rows with title rewrites. Pair high-position, low-click pages with snippet experiments.

More detail

New here? Skim Start here first, then run one Examples scenario in the form above.

Search Console Analyzer does one job: slice GSC performance data with custom segments and pivots. It lives under SERP & Rankings on SEOToolkits, where the beginner idea is simple: SERP SEO studies the search results page itself: rankings, snippets, features, and what Google is rewarding.

FAQ

Do you connect to my Google account?: No. This tool only parses text you paste. No API keys and no Search Console authentication.
Why is average position weighted?: Weighted average uses impressions so a rare deep page does not skew the mean the same way a simple average would.
Can I use semicolon-separated files?: The parser expects comma-separated columns as shown in the sample. Re-export or convert delimiters first.
What if a column is missing?: Parsing looks up columns by header name. Missing columns produce empty keys and may drop rows. Fix the header row and try again.