Technical Sitemap Builder — URL-Mapped Keywords

Same output as the standard Technical Sitemap Builder, but Target Keywords are mapped directly per URL from Ahrefs and/or AccuRanker exports, and Clicks/Impressions come straight from the Screaming Frog crawl (if it was run with the GSC API connected) — no separate GSC upload needed.

🐸
Screaming Frog Crawl
Required

In Screaming Frog: crawl your site → Internal tab → Export CSV. The tool filters to HTML pages automatically. If the crawl was connected to the Search Console API, its Clicks and Impressions columns are used directly.

📈
Ahrefs URL + Keyword + Volume CSV
At least one of Ahrefs / AccuRanker required

CSV with URL, Keyword and Volume columns — e.g. Ahrefs Site Explorer → Organic Keywords, exported with the URL/Page field included.

🎯
AccuRanker URL + Keyword + Volume CSV
At least one of Ahrefs / AccuRanker required

CSV with URL, Keyword and Search Volume columns from an AccuRanker export. Combined with Ahrefs (if both are uploaded) and matched per URL.

🔑
GSC Query Data — Search Analytics for Sheets
Optional

CSV with Query, Page, Impressions, Position columns. Used only for the Striking Distance insight (positions 4–15) — not needed for Clicks/Impressions or Target Keywords.

How to Use — URL-Mapped Keywords Version

This version of the Technical Sitemap Builder maps keywords to URLs directly from Ahrefs and/or AccuRanker exports, and pulls Clicks/Impressions straight from the Screaming Frog crawl rather than a separate GSC upload.

Step 1 — Screaming Frog: Crawl your site, then go to File → Export → CSV (from the Internal tab). If you connected the Search Console API before crawling, Screaming Frog adds Clicks/Impressions columns that this tool uses directly — no GSC export needed.

Step 2 — Ahrefs and/or AccuRanker: Export Ahrefs Site Explorer → Organic Keywords, and/or an AccuRanker ranking export, each with URL, Keyword and Volume/Search Volume columns. Upload one or both — rows from every source you upload are matched to the crawled URL and merged. Every matched keyword for a URL (up to 10, sorted by volume) is comma-separated into Target Keywords, e.g. King size beds (5,500), Super king bed (2,400), Super king size mattress (1,900).

Step 3 — GSC Query CSV (optional): Only used for the Striking Distance insight (positions 4–15 with meaningful impressions) — not required for Clicks/Impressions or Target Keywords, both of which are already covered by the crawl and the keyword CSVs.

Step 4 — Download & Import: Download the CSV and import it into Google Sheets. Output columns match the standard technical sitemap template, so the same Google Sheets formatting script from the standard builder works here too.