Can I query Google Analytics in plain English instead of writing SQL?

Yes. Dataki works with Google Analytics through its BigQuery dataset (GA4's free BigQuery export). Ask in plain English and Dataki writes the SQL against that dataset, runs it and returns a chart. The query is shown with every result, so you can check or edit it.

How do I build a dashboard from Google Analytics data without an ETL pipeline?

Follow the Google Analytics setup guide once and your data lands in BigQuery automatically, with no pipeline to maintain. Connect that dataset to Dataki, ask your question and save the answer as a dashboard widget. Dataki queries the dataset live, so the dashboard is always as fresh as the export.

Can Claude, ChatGPT or Cursor query my Google Analytics data?

Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Google Analytics 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 your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.

Dataki for Google Analytics

Ask Google Analytics in plain English

Ask Google Analytics 4 questions in plain English. Dataki reads GA4's free BigQuery export, every event unsampled, and charts users, sessions, pages and purchases from it.

Through BigQuery GA4's free BigQuery export. The guide takes about 10 minutes.

Follow the setup guide Open Dataki

app.dataki.ai / chat BigQuery · analytics_123456789

Which pages brought in the most new users last month?

Reading the schema, writing the query…

SELECT (SELECT value.string_value FROM UNNEST(event_params)
        WHERE key = 'page_title') AS page,
       COUNT(DISTINCT user_pseudo_id) AS new_users
FROM   `analytics_123456789.events_*`
WHERE  event_name = 'first_visit'
  AND  _TABLE_SUFFIX BETWEEN '20260801' AND '20260831'
GROUP BY page ORDER BY new_users DESC LIMIT 5

The home page brought in 8,940 new users in August; the SQL joins post led the blog.

01Questions

What people ask Google Analytics

Each one becomes a query against the Google Analytics 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 brought in the most new users last month?
What is the conversion rate by traffic source for the last 30 days?
Which events did users fire before their first purchase?
How did sessions from organic search change week on week?

02From your assistant

Ask Google Analytics from Claude, ChatGPT or Cursor

Dataki runs a hosted MCP server. Add it to your assistant once and it can read the Google Analytics 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 · analytics_123456789

Using our GA4 export, which landing pages brought the most new users last month, by source?

list_sources · finds BigQuery · analytics_123456789
get_data_context · reads the tables and what the columns mean
query · runs the SQL read-only, returns the rows
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 Analytics data to Dataki

GA4's free BigQuery export. The setup guide covers it step by step.

Setup: About 10 minutes, then up to 24 hours before the first day of data arrives.
Cost: The daily export is free. BigQuery bills storage and queries beyond its free tier: 10 GiB of storage and 1 TiB of queries a month.
History: From the day you link. Nothing before it is exported, so link now even if you connect Dataki later.
You need: Editor on the GA4 property, and Owner on a Google Cloud project with the BigQuery API enabled.

Read the Google Analytics 4 guide Open Dataki

Live dashboards

Every answer can become a live dashboard.

Ask in plain English. Dataki writes the SQL, runs it on your database and charts the answer. Keep it as a dashboard with its own link, and your team sees current numbers every time they open it.

app.dataki.ai/dashboards/new-users-by-landing-page BigQuery · analytics_123456789

3 views · Updated just now

One click turns the answer into a dashboard:

app.dataki.ai/dashboards/new-users-by-landing-page

Always current. The query runs again whenever the dashboard opens, so Friday's meeting sees Friday's numbers.

Share it: Send the link to anyone. Viewers are free on every plan.
Refine it: The SQL is always visible. Adjust it by hand or ask for a change.
Embed it: Put the same dashboard in your own product with two HTML tags.

Start free More on dashboards

Using Dataki with Google Analytics

Can I query Google Analytics in plain English instead of writing SQL?: Yes. Dataki works with Google Analytics through its BigQuery dataset (GA4's free BigQuery export). Ask in plain English and Dataki writes the SQL against that dataset, runs it and returns a chart. The query is shown with every result, so you can check or edit it.
How do I build a dashboard from Google Analytics data without an ETL pipeline?: Follow the Google Analytics setup guide once and your data lands in BigQuery automatically, with no pipeline to maintain. Connect that dataset to Dataki, ask your question and save the answer as a dashboard widget. Dataki queries the dataset live, so the dashboard is always as fresh as the export.
Can Claude, ChatGPT or Cursor query my Google Analytics data?: Yes, through Dataki's hosted MCP server at https://dataki.ai/api/mcp. Connect Google Analytics 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 your assistant can read the schema and run read-only queries. It works with the results, while your credentials stay encrypted in Dataki and never reach the model.

Product

Solutions

Resources