Back to Tools

GSC Chart Visualiser

Use cases

Visualising GSC performance trends Filtering data by position ranges Comparing multiple metrics Quick GSC data exploration

OAuth 2.0 authentication via google_auth_oauthlib with token refresh.

Connects to webmasters API v3 and uses the searchconsole library for data queries.

Generates multi-metric layered Altair line charts with independent Y-axis scaling.

Supports position range filtering (1-3, 4-10, 11-20, 21-100) and date groupby aggregation.

Max 250,000 rows.

GSC Data

Platform

Python script (requires Python 3.x)

Input

OAuth credentials via Streamlit secrets (client ID, secret, redirect URIs)

GSC property access

Search type, date range, device, dimensions (page/query/country/device)

Output

Interactive charts and CSV export

View Source

Features

  • OAuth 2.0 with token refresh via google_auth_oauthlib
  • Webmasters API v3 via searchconsole library
  • Altair multi-metric layered line charts
  • Position range filtering (1-3, 4-10, 11-20, 21-100)
  • Date ranges: 7, 30, 90, 180, 365, 480 days
  • Search types: web, image, video, news, discover, googleNews
  • Max 250,000 rows per query

How to use

  1. 1 Configure OAuth credentials in Streamlit secrets
  2. 2 Sign in with Google and authorise
  3. 3 Select GSC property, search type, and date range
  4. 4 Choose device filter and dimensions
  5. 5 Fetch data – up to 250,000 rows
  6. 6 Explore Altair charts with independent Y-axis scaling
  7. 7 Download CSV (UTF-8 encoded)

Let's work together

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

Let's Talk