Measuring topics instead of pages
A custom Search Console report that shows performance by topic, so a team can see which part of the site is growing and which is dragging.
- 210
- Likes on X
- 23.8K
- Views on X
- First-party GSC
- Data source
- Data
- Google Search Console
- Stack
- Python + SQL
- Used for
- Prioritising content work
The problem
Page-level reports hide the real story.
Standard dashboards show thousands of pages and queries. Nobody can make a decision from that. More charts do not fix it.
What I built
Divide the site before you analyse it.
I group URLs and queries into topics, then report clicks, impressions and keyword counts per topic over time. The brand versus non-brand gap shows whether SEO is doing anything at all.
Result
Decisions per topic, not per page.
Teams can see which topic to expand, which to consolidate and which to leave alone. The thread showing the report was my most-liked post on X.
Sources