GSC Folder Analyser

Use cases

Understanding which site sections perform best Identifying underperforming folders Content strategy by site section Quick site performance overview

Maps various GSC column names to standard labels, converts metrics to appropriate data types, removes domain prefix/query parameters/anchors, and splits URLs into folder hierarchy levels.

Aggregates by folder path summing traffic and counting keywords.

Extracts highest-traffic query per page using forward-fill technique.

Adjustable folder depth slider (1-10).

Streamlit App GSC Data

Platform

Browser-based (no installation required)

Input

GSC export CSV

Supports various column naming conventions

Output

CSV: Traffic (summed clicks), Keywords (query count), Pages (count per path), Path, Top Keyword, Volume (impressions), Top Position.

Launch App View Source

Features

Auto column name mapping (Top queries, Query, Queries, etc.)
URL cleaning: removes domain, query params, anchors
Path segmentation into folder hierarchy
Folder depth slider (1-10 levels)
Traffic summing and keyword counting per path
Top keyword extraction via forward-fill

How to use

1 Export data from Google Search Console
2 Upload CSV to the tool
3 Enter your domain with protocol and trailing slash (e.g., https://example.com/)
4 Set maximum folder depth (1-10)
5 Review aggregated metrics in interactive table
6 Download CSV with folder analysis