gsc_seasonal
Year over year monthly comparison. Spot seasonal patterns with YoY percentage changes.
How to use it
gsc_seasonal is exposed by the Suganthans BigQuery MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the gsc_seasonal tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
FULL SUGANTHANS BIGQUERY MCP SERVER LISTINGOther tools in Suganthans BigQuery MCP Server (32)
Column types, row counts, partitioning, size.
How does branded vs non-branded traffic convert?
Which pages have the biggest gap between rankings and conversions? Diagnoses each page.
Full page-level search + analytics metrics joined per landing page.
What is each search position worth on your site? Conversion rate and revenue per click by position bucket.
Which search queries actually drive revenue and conversions? Proportional attribution by click share.
Which pages have misleading or underselling snippets?
Position drops, CTR collapses, click losses, disappeared pages. Severity rated
ML anomaly detection. Flags genuinely unusual traffic patterns, not just threshold breaches.
How much traffic is hidden behind anonymous queries? The API hides ~46% of clicks entirely.
Keywords where multiple pages compete against each other
Pages declining across three consecutive 30 day periods
Topics with search demand but no real content targeting them
Prioritised actions: pages to update, content to create, pages to consolidate
Your actual CTR per position vs industry benchmarks
Pages with high impressions but CTR below expected for their position
Queries where mobile and desktop rank entirely different pages from your site.
ARIMAPLUS traffic forecasting via BigQuery ML. Predict clicks up to 365 days out.
Which queries are AI conversation fragments? Seven kinds sorted, no API row limits, plus the anonymised split the API can't see.
Classify all queries by search intent: informational, transactional, commercial, navigational.
Queries appearing in recent data that weren't present before.
Extract recurring terms from queries. Find themes your content should cover.
Keywords at positions 4 to 15 with high impressions, scored by opportunity
Full markdown performance report
How is the site doing overall? Clicks, impressions, CTR, position with period comparison
Aggregated performance for all pages matching a URL path pattern
What lost traffic, and whether it's a ranking loss, CTR collapse, or demand decline
Discover available datasets in your project.
All tables and schemas in a dataset.
Run any SELECT query. Claude writes the SQL for you.
Dry run to see bytes scanned before executing.
Preview rows without writing SQL.