Search Console Data Analyzer
Analyze Google Search Console CSV exports (URL, Query, Clicks, Impressions, CTR, Position). Aggregate by URL and query, identify top pages/queries, find high-impression low-CTR opportunities, striking-distance keywords (positions 5-15), low-position high-impression pages, high-position low-impression pages, generate optimization recommendations, summary stats, filters, copy + download .txt + download CSV, history (localStorage), shareable URL. 100% client-side.
About Search Console Data Analyzer
Analyze Google Search Console CSV exports (URL, Query, Clicks, Impressions, CTR, Position). Aggregate by URL and query, identify top pages/queries, find high-impression low-CTR opportunities, striking-distance keywords (positions 5-15), low-position high-impression pages, high-position low-impression pages, generate optimization recommendations, summary stats, filters, copy + download .txt + download CSV, history (localStorage), shareable URL. 100% client-side. Everything runs locally in your browser — your data never leaves your device.
How to use
- Enter your input in the tool above.
- Adjust any options to your preference.
- Use the Copy or Download buttons to save the result.
- Everything happens locally — your data never leaves your browser.
FAQ
How does the Search Console Data Analyzer work?
Paste your Google Search Console CSV export (columns: URL, Query, Clicks, Impressions, CTR, Position). The tool parses each row, aggregates by URL and by query, then identifies opportunities: high-impression low-CTR queries (CTR < 2% with > 1000 impressions — improve titles/meta), striking-distance keywords (positions 5-15 — close to page 1), low-position high-impression pages (page 2+ opportunities), and high-position low-impression pages (page 1 with low volume to expand).
What columns does the CSV need?
Header row with case-insensitive column names: URL, Query, Clicks, Impressions, CTR (percentage, e.g. 3.0), Position (average SERP position, e.g. 8.5). If the CTR column is missing, the tool calculates CTR = clicks / impressions × 100 automatically.
What recommendations does it generate?
Four rule-based recommendations: (1) high-impression low-CTR → improve title tag and meta description; (2) low-position high-impression → improve content depth; (3) striking-distance keywords → add internal links + optimize; (4) high-position low-impression → expand content with related keywords.
What extra features does this tool have compared to others?
(1) CSV parser with case-insensitive header detection. (2) Record validator (numeric checks, position > 0). (3) URL aggregator (per-page totals + averages). (4) Query aggregator (per-query totals + averages). (5) Top pages list (by clicks). (6) Top queries list (by clicks). (7) High-impression low-CTR finder. (8) Striking-distance keyword finder (positions 5-15). (9) Low-position high-impression finder. (10) High-position low-impression finder. (11) Recommendation generator. (12) Text report. (13) CSV export. (14) Copy + Download .txt + Download CSV. (15) History (localStorage, last 20). (16) Shareable URL. (17) Filter by opportunity type. (18) Summary stats. (19) CTR calculator (when CTR column missing).
Is my data sent anywhere?
No. All parsing, aggregation, and recommendation logic runs locally in your browser. History is stored in localStorage on this device only.
Related tools
Affiliate Commission Calculator
Calculate affiliate commissions across four program types — flat percent, tiered percent (progressive brackets), recurring (monthly × N months), and hybrid (initial + recurring). Apply refund-rate and tax-withholding adjustments, compute effective commission rate, compare two program types side-by-side, and project break-even sales to hit a target income. History (localStorage) + shareable URL. 100% client-side.
Affiliate Link Cloaker & Redirect Generator
Cloak affiliate links into pretty URLs and generate redirect scripts (PHP, JavaScript, HTML meta refresh), plus .htaccess, nginx, and robots.txt rules. CSV import of slug/affiliate_url pairs, slug auto-generator from hostname, click-tracking parameter builder, URL-shortener compatibility check, history (localStorage), shareable URL. 100% client-side.
Anchor Text Distribution Analyzer
Analyze anchor text distribution from backlink data. Categorize anchors as exact/partial match, branded, generic, naked URL, or image. Compute distribution %, warn on over-optimization, and export. 100% client-side.