search-console-indexing-audit
Use this skill to turn Google Search Console Coverage exports into a concrete indexing fix plan.
Workflow
- Read the export directory first:
Chart.csv for indexed/not-indexed trend and impressionsMetadata.csv for property context such as sitemap scopeCritical issues.csv and Non-critical issues.csv for issue buckets
- Run the summarizer when the standard CSV files are present:
python3 <skill-dir>/scripts/summarize_gsc_coverage.py <export-dir>
python3 <skill-dir>/scripts/summarize_gsc_coverage.py <export-dir> --json
- Inspect the target repo for SEO sources of truth:
- sitemap generation and whether listed URLs are canonical, indexable HTML pages
- robots rules, sitemap URL, and host hints
- canonical metadata,
metadataBase, Open Graph URL base, and per-route noindex
- redirects across apex/www, http/https, trailing slash, moved routes, and legacy paths
- Check live URLs when network access is available:
curl -sS -I https://example.com/sitemap.xml
curl -sS https://example.com/sitemap.xml
curl -sS https://example.com/robots.txt
curl -sS https://example.com/page | rg -o '<link rel="canonical"[^>]*>|<meta name="robots"[^>]*>'
curl -sS -I -L --max-redirs 5 https://example.com/page
- Map GSC buckets to fixes:
Page with redirect: remove redirected URLs from sitemap and canonicals; submit only final 200 URLs.Redirect error: inspect redirect chains, protocol/host loops, blocked destinations, and non-200 final responses.Alternate page with proper canonical tag: usually acceptable; verify sitemap does not include alternates.Discovered - currently not indexed: improve crawl signals first: clean sitemap, canonical consistency, internal links, content quality, stable 200 responses, and lastmod accuracy.Excluded by noindex: verify it is intentional and keep those URLs out of sitemap.
Output
Report:
- Export summary: date range, indexed/not-indexed trend, issue buckets, and limitations.
- Likely root cause, with evidence from files or live HTTP responses.
- Prioritized fixes, smallest reliable change first.
- Verification steps for local tests, build, live sitemap/robots/canonical checks, and Search Console validation.
Call out when the export is aggregate-only and does not contain affected URL examples. Do not infer exact URLs unless the CSVs or live sitemap provide them.
1---2name: search-console-indexing-audit3description: Analyze Google Search Console Coverage or indexing CSV exports and correlate them with repo and live-site SEO signals. Use for Chart.csv, Metadata.csv, Critical issues.csv, Non-critical issues.csv, sitemap/robots/canonical indexing problems, "Discovered - currently not indexed", redirect indexing buckets, or requests to fix Google indexing coverage.4license: MIT5---67# search-console-indexing-audit89Use this skill to turn Google Search Console Coverage exports into a concrete indexing fix plan.1011## Workflow12131. Read the export directory first:14 - `Chart.csv` for indexed/not-indexed trend and impressions15 - `Metadata.csv` for property context such as sitemap scope16 - `Critical issues.csv` and `Non-critical issues.csv` for issue buckets172. Run the summarizer when the standard CSV files are present:1819```bash20python3 <skill-dir>/scripts/summarize_gsc_coverage.py <export-dir>21python3 <skill-dir>/scripts/summarize_gsc_coverage.py <export-dir> --json22```23243. Inspect the target repo for SEO sources of truth:25 - sitemap generation and whether listed URLs are canonical, indexable HTML pages26 - robots rules, sitemap URL, and host hints27 - canonical metadata, `metadataBase`, Open Graph URL base, and per-route `noindex`28 - redirects across apex/www, http/https, trailing slash, moved routes, and legacy paths294. Check live URLs when network access is available:3031```bash32curl -sS -I https://example.com/sitemap.xml33curl -sS https://example.com/sitemap.xml34curl -sS https://example.com/robots.txt35curl -sS https://example.com/page | rg -o '<link rel="canonical"[^>]*>|<meta name="robots"[^>]*>'36curl -sS -I -L --max-redirs 5 https://example.com/page37```38395. Map GSC buckets to fixes:40 - `Page with redirect`: remove redirected URLs from sitemap and canonicals; submit only final 200 URLs.41 - `Redirect error`: inspect redirect chains, protocol/host loops, blocked destinations, and non-200 final responses.42 - `Alternate page with proper canonical tag`: usually acceptable; verify sitemap does not include alternates.43 - `Discovered - currently not indexed`: improve crawl signals first: clean sitemap, canonical consistency, internal links, content quality, stable 200 responses, and lastmod accuracy.44 - `Excluded by noindex`: verify it is intentional and keep those URLs out of sitemap.4546## Output4748Report:4950- Export summary: date range, indexed/not-indexed trend, issue buckets, and limitations.51- Likely root cause, with evidence from files or live HTTP responses.52- Prioritized fixes, smallest reliable change first.53- Verification steps for local tests, build, live sitemap/robots/canonical checks, and Search Console validation.5455Call out when the export is aggregate-only and does not contain affected URL examples. Do not infer exact URLs unless the CSVs or live sitemap provide them.
oleg-koval