GSC Coverage Visualiser

Use cases

Spotting low-quality folder patterns in crawled-not-indexed URLs Identifying which site sections have indexing problems Creating visual reports for stakeholders Analysing URL structure patterns at scale

Generates three interactive visualisations from GSC coverage data using Plotly: a treemap showing hierarchical folder structure with URL counts, a sunburst chart for radial path depth analysis, and a word cloud of the top 25 keywords from URL paths.

Uses NLTK for stopword removal and regex-based tokenisation to extract meaningful terms from URLs.

Jupyter Notebook GSC Data

Platform

Jupyter Notebook (requires Python environment)

Input

GSC coverage Excel export

Output

Interactive treemap, sunburst chart, and word cloud

Features

Plotly treemap of folder hierarchy with URL counts
Sunburst chart showing path depth distribution
Word cloud of top 25 URL path keywords (NLTK stopwords filtered)
Adjustable folder_start depth for ccTLD handling
Automatic fallback if folder depth settings fail

How to use

1 Export GSC coverage report as Excel (drilldown to specific issue)
2 Upload the Excel file to the notebook
3 Set folder_start depth (default 1, increase for ccTLDs)
4 Run cells to generate treemap, sunburst, and word cloud

Want me to run this for you?

I offer this as a managed service. You get the insights without touching the tool.

GSC Data Exporter

Bulk download Search Console data beyond the 1,000 row limit with automatic batch processing.

GSC Question Finder

Extract question-based keywords from Search Console using regex pattern matching.

Striking Distance Finder

Find quick-win keywords ranking positions 4-20 that are missing from your on-page content.

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.