Search Console Visualization Tool

I created this Search Console Visualization Tool to save the hassle of manually figuring out why URLs or keywords are dropping or improving. It pulls data directly from the Search Console API and gives clear insights with automated comments, all in one place.

Here’s what this tool does and how it works.

The tool’s homepage for selecting a website and date ranges.

Key Features

URL and Keyword Analysis

I made the tool to work with both URL-level and keyword-level data. We can check clicks, impressions, CTR, and average position for pages or search queries. It’s great for finding pages that are losing traffic or keywords that are performing well.

Compare Time Periods

We can compare two date ranges to see changes in performance. The tool shows differences in clicks, impressions, and positions, with a button to toggle comparison data on or off.

Comparing URL performance between two periods with toggleable comparison data.

Smart Comments

I added comments that automatically explain performance changes. For example, if a URL’s clicks drop because its position fell from 5 to 10, the tool will tell you. These are based on logic I wrote to check clicks, impressions, and position.

Automated comments explaining why a URL’s performance changed.

Powerful Filtering

• URL Filters: Match exact URLs, URLs with a string, or use regex (like ^/blog/.* for blog posts).
• Keyword Filters: Include or exclude keywords, or use regex (like ^(what|how|why)\s for question queries).
• Handles invalid regex with error messages so it doesn’t break.

Advanced filtering options for URLs and keywords, including regex support.

Interactive Tables

Data shows up in sortable tables with a “Load More” button. Keyword tables have expandable rows to list all URLs ranking for a query, which I added for cases where multiple pages rank for one term. Sticky headers and text wrapping keep it readable.

Interactive keyword-level table with expandable URL details and pagination.

Runs Locally

I built it to run locally with Flask, keeping your data private. It uses a client_secrets.json file for Google API authentication and picks a free port to avoid issues.

How It Works

Here’s how to use the tool:

• Log In: Open the tool locally and sign in with your Google account to see your Search Console sites.
• Pick a Site and Dates: Choose a website and set a date range, plus an optional comparison period.
• Filter Data: Use URL or keyword filters, including regex, to narrow down the data.
• View Insights: Check tables for metrics, comparisons, and comments. Sort, expand rows, or load more data.
• Optimize: Use the insights to fix issues, like updating titles for low-CTR keywords or pages with dropping ranks.

Upcoming Features

I’m adding new features to make the tool more useful:

• Track Custom Keywords: Upload a CSV file with keywords to track their positions over time.
• Country-Level Data View: See performance data for specific countries.