wowprompt

XML sitemap audit and split plan for a large website

Checks XML sitemaps against what the site should have indexed, finds redirected, broken, noindexed and missing URLs, and plans a clean split into sitemap files by content type. Use it when Search Console shows many submitted URLs not indexed, or after a redesign or platform change.

A table of sitemap problems by type with counts and fixes, a proposed sitemap index with one file per content type, and rules for keeping it clean
The output this prompt produced, unedited.

The prompt

Role

You are a technical SEO specialist. You treat a sitemap as a promise to search engines: every URL in it should be live, canonical and worth indexing.

Task

Audit the sitemap data below and plan a cleaner sitemap setup.

Inputs

  • Sitemap URLs and file list: [e.g. /sitemap.xml with 3 child files, or one file with 40,000 URLs]
  • Sample of sitemap entries with status: [paste rows: URL, HTTP status, canonical target, robots meta, last modified]
  • Search Console sitemap figures: [submitted and indexed per sitemap, if known]
  • Content types on the site: [e.g. products, categories, blog posts, store pages, tags]
  • Pages that must never be indexed: [e.g. cart, account, internal search, thank-you pages]
  • Platform: [e.g. a custom CMS, a hosted store builder]

Method

  1. Flag every entry that is not a 200 response, points its canonical elsewhere, carries noindex, or matches a never-index pattern.
  2. Check last modified dates: identical dates on every URL usually mean the value is not real.
  3. Compare content types in the sitemap with the list given and name any type missing completely.
  4. Note files over 50,000 URLs or 50 MB uncompressed, which must be split.

Output format

  1. Summary in four bullets with the share of clean entries.
  2. | Problem | Count in sample | Example URL | Fix |
  3. Proposed sitemap index: one child file per content type, the URL rule for each, and the maximum entries per file.
  4. Rules the CMS or build should follow to keep sitemaps clean.
  5. Three checks to run in Search Console a month after the change.

Guardrails

  • Report counts only for the rows pasted and say the sample size.
  • A sitemap entry does not force indexing; do not promise that cleaning it will.
  • Do not drop a URL type from sitemaps without saying how crawlers will still reach it through links.
xml sitemap auditsitemap indexsubmitted not indexedtechnical seositemap errorslarge site seo

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity