Google Search Console logo

Dataki for Google Search Console

Ask Google Search Console in plain English

Ask Search Console questions in plain English. The bulk data export puts every query and page in BigQuery, with no 1,000-row cap, and Dataki charts clicks and rankings from it.

Through BigQuery The bulk data export to BigQuery. The guide takes about 10 minutes.

Follow the setup guide Open Dataki
app.dataki.ai / chat BigQuery · searchconsole

Which pages lost the most clicks last month, compared with the month before?

Reading the schema, writing the query…
SQL 1.1 s · 1.6 GB scanned 
SELECT REGEXP_EXTRACT(url, r'//[^/]+(/[^?]*)') AS page,
       SUM(IF(data_date < '2026-08-01', clicks, -clicks)) AS clicks_lost
FROM   searchconsole.searchdata_url_impression
WHERE  data_date BETWEEN '2026-07-01' AND '2026-08-31'
GROUP BY page ORDER BY clicks_lost DESC LIMIT 5
Clicks lost, August vs July 5 rows
/blog/sql-joins/pricing/docs/embed/blog/bigquery-costs/integrations/stripe 05001k1.5k2k

/blog/sql-joins lost 1,940 clicks in August, the biggest drop on the site.

01Questions

What people ask Google Search Console

Each one becomes a query against the Google Search Console data, run read-only, with the SQL shown beside the chart so anyone who reads SQL can check it. Anything worth keeping goes on a dashboard that refreshes on its own.

  • Which pages lost the most clicks compared with last month?
  • Which queries rank between positions 5 and 15 with the most impressions?
  • How did clicks from mobile change after the last release?
  • Which new queries appeared this week?

02From your assistant

Ask Google Search Console from Claude, ChatGPT or Cursor

Dataki runs a hosted MCP server. Add it to your assistant once and it can read the Google Search Console data in BigQuery and run read-only queries through Dataki. The assistant gets the rows back; the credentials stay encrypted in Dataki and never reach the model.

Setup for your assistant:

Claude · dataki (MCP) BigQuery · searchconsole

From the Search Console export, which pages lost the most clicks this month, and on which queries?

  1. list_sources · finds BigQuery · searchconsole
  2. get_data_context · reads the tables and what the columns mean
  3. query · runs the SQL read-only, returns the rows
  4. render_ui · draws the chart from those rows, in the chat
server URL streamable http
https://dataki.ai/api/mcp

03Setting it up

Getting Google Search Console data to Dataki

The bulk data export to BigQuery. The setup guide covers it step by step.

Setup
About 10 minutes, then up to 48 hours for the first export.
Cost
The export is free, but needs a Cloud project with billing. BigQuery storage and queries are billed beyond the free tier.
History
From the day you set it up. Earlier data stays in Search Console.
You need
Owner of the Search Console property, and a Cloud project where you can grant IAM roles.
Read the Google Search Console guide Open Dataki

The answer is still there tomorrow.

Ask in plain language. Dataki writes the SQL, runs it against your warehouse and draws the chart. Anything worth keeping becomes a dashboard with a link — not a message that scrolls away.

app.dataki.ai / chat

Which channels actually brought in revenue last quarter?

Queried bigquery · payments · 1.2 GB scanned 
SELECT channel,
       SUM(amount) AS revenue
FROM   payments
WHERE  created_at >= DATE_TRUNC(CURRENT_DATE(), QUARTER)
GROUP BY channel
ORDER BY revenue DESC

Revenue by channel

Q3 · 5 rows

Organic search
$412,900
Partner referral
$268,400
Email
$151,200
Paid social
$96,700
Direct
$61,300

One click later, that chart is a dashboard of its own:

app.dataki.ai/d/revenue-by-channel

Live, not a screenshot. It re-runs the query on a schedule, so the number your team reads on Friday is Friday's number.

  • Share the link with anyone. Viewers are free on every plan.
  • Edit the SQL by hand whenever the model gets the logic almost right.
  • Drop the same dashboard into your own product with one line of HTML.
Start free See how it works

Using Dataki with Google Search Console

Can I query Google Search Console in plain English instead of writing SQL?
Yes, once Google Search Console data is in BigQuery. Dataki has no Google Search Console connector of its own; it reads the dataset the data lands in (The bulk data export to BigQuery), turns a plain-English question into SQL against it, runs it and returns a chart. The generated query is shown with every result, so you can verify or edit it.
How do I build a dashboard from Google Search Console data without an ETL pipeline?
Set up the route in the Google Search Console setup guide once. The copy into BigQuery then runs on its own, so there is no pipeline for you to maintain. Connect that dataset to Dataki, ask your question and keep the answer as a dashboard widget; Dataki queries the dataset at read time, so the dashboard is as fresh as the export.
Can Claude, ChatGPT or Cursor query my Google Search Console data?
Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Google Search Console to Dataki, add that URL as a connector in Claude or ChatGPT (or in Cursor, VS Code or Claude Code with a Dataki key), and the assistant can read the schema and run read-only queries. It gets the rows back; the credentials stay encrypted in Dataki and are never handed to the model.