Keyword URL Mapping Audit

Import your mapping file and run. Results appear below; export them as a formatted Excel sheet.

1 Import
2 Run
3 Export Excel

Drop your Keyword URL Mapping file here or browse your computer · .xlsx, .xls or .csv

Target location (optional)

Used for local-SEO checks and to filter uploaded Search Console data by country. Leave empty to skip.

Rank data (optional)

Upload Search Console CSV(s) Queries / Pages / Filters, or a Query + Page export Upload rank tracker CSV Columns: Keyword, URL, Position, Location, Date

Fetch live SERP rank via SerpAPI (needs your Worker + SERPAPI_KEY secret; uses 1 search per keyword)

Results

—

Total URLs

—

Keywords analyzed

—

Average score

—

Critical issues

—

Passed checks

No results yet

Import your Keyword URL Mapping file above, then hit Run Analysis. Results, charts and the keyword matrix appear here.

Master-Sheet style export (page fields merged once per URL group)

Shaded rows = URL with multiple keywords (same colors in the Excel export)

Rows

Relevance of each URL for each keyword (0–100) from title, H1, description, URL slug, first 100 words and frequency. marks the best-fit URL for each keyword. If two URLs score close for the same keyword, they may be competing (cannibalization).

Keyword URL Mapping Audit

Results

No results yet

SEO score per URL

Issue distribution

Details