Audit redirect spreadsheets for chains and loops

Find redirect chains, circular loops, and soft 404 dumps in URL migration sheets before launching. Use it during pre-launch technical reviews.

You getCritical Errors, soft 404 Risks and cleaned Mapping

Prompt

Prompt
Act as a senior technical SEO auditor. Audit the pasted redirect mapping table for migration defects.

- Identify redirect chains (A -> B -> C) and rewrite them to direct one-to-one redirects (A -> C).
- Detect circular loops where a target URL eventually points back to the origin.
- Flag bad fallback redirects, such as mapping obsolete product pages directly to the homepage or top category.
- Highlight missing trailing slash inconsistencies and protocol mismatches.

Output format:
1. Critical Errors: bullet list of loops and chain issues with exact fixes.
2. Soft 404 Risks: table with columns Source URL, Current Target, Recommended Action.
3. Cleaned Mapping: table with columns Source URL, Final Destination URL, HTTP Status.

Here is the redirect mapping data:

Example output

Example for: an e-commerce catalog migration export

  1. Critical Errors:
  • Loop detected: /shoes/boots/ maps to /footwear/boots/, which points back to /shoes/boots/. Fix: break loop by pointing /shoes/boots/ directly to /footwear/boots/2024/.
  • 2-hop chain: /sale/clearance/ -> /deals/ -> /promotions/. Fix: update /sale/clearance/ to target /promotions/ directly.
  1. Soft 404 Risks:
Source URLCurrent TargetRecommended Action
/product/running-shoe-v1/Map to /category/running-shoes or return 410 Gone
/product/leather-belt-old/Map to /accessories/belts
  1. Cleaned Mapping:
Source URLFinal Destination URLHTTP Status
/sale/clearance//promotions/301
/shoes/boots//footwear/boots/2024/301
/category/old-running//category/running-shoes/301
Written by AI from this prompt. Your results will vary.

Copy rows directly from your migration CSV or spreadsheet into ChatGPT, Claude, or Gemini. Ask a follow-up to format the final cleaned mapping into an upload-ready .htaccess or CSV table.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in SEO
SEO

Build a site migration SEO QA checklist

Create a comprehensive quality assurance checklist to protect organic rankings during site migrations. Use this before staging sites push to production.