Skip to main content
Glama
Suganthan-Mohanadasan

BigQuery MCP Server

gsc_ctr_opportunities

Detect high-impression pages with click-through rate below ranking benchmarks to identify title and meta description optimization opportunities.

Instructions

Find pages with high impressions but CTR significantly below the expected benchmark for their ranking position. These are title and meta description optimisation candidates. IMPORTANT: Base your analysis ONLY on the data returned. Report exact numbers from the results. Do not speculate about causes (e.g. algorithm updates, competitor actions) unless the data explicitly supports it. If the data does not contain enough information to answer a question, say so clearly rather than guessing. PRESENTATION: Always present these results as a rich, interactive visualization using artifacts. Use summary cards for key metrics, colour-coded indicators for severity or change direction (green for positive, red for negative), bar charts or sparklines for comparisons, and tabbed sections to organise different categories of results. Make the output visually scannable and dashboard-like rather than plain text or raw tables.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
daysNoNumber of days to analyse
datasetNoBigQuery dataset containing GSC data
min_impressionsNoMinimum impressions threshold
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the behavior burden and does so well. It explicitly states to base analysis only on returned data, report exact numbers, avoid speculation unsupported by data, and honestly state when information is insufficient. It also mandates a specific presentation format (rich interactive visualization with artifacts). This gives meaningful behavioral transparency beyond the basic read-only nature.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description front-loads the core purpose in the first sentence, then separates analysis rules and presentation requirements into clearly labeled sections. While long, each section provides necessary behavioral guidance. It is somewhat verbose but every part adds practical value for correct usage.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

There is no output schema, so the description compensates by specifying how results should be presented and how the agent should reason about them. It clearly defines the analysis approach and output format. It could be more complete by mentioning when to choose this tool over related siblings, but for the tool's complexity it is sufficiently complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema covers all 3 parameters with descriptions (100% coverage), so the description adds no parameter-specific semantics. The baseline of 3 applies because the schema already documents each parameter (days, dataset, min_impressions) with defaults and thresholds. The description does not repeat or enrich these, but no extra burden is needed.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Find') and resource ('pages') with a clear qualifier: 'high impressions but CTR significantly below the expected benchmark for their ranking position.' It also names the practical output ('title and meta description optimisation candidates'), which distinguishes it from siblings like gsc_ctr_benchmark that likely just report benchmarks.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description clearly frames the tool's purpose as identifying optimization candidates, implying when to use it (when looking for CTR/title/meta opportunities). It does not explicitly name alternatives or exclusions, but the user intent is evident. The 'IMPORTANT' instructions also clarify how the tool should be used for analysis, which adds guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Suganthan-Mohanadasan/Suganthans-BigQuery-MCP-Server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server