Why connect BigQuery to Claude?
The GA4 interface samples, thresholds and hides the paths people take. The raw export in BigQuery has all of it, but only if someone writes the SQL. Claude does that part through Lemonado: it queries the events tables, explains what it found and builds an artifact from it, with Google Ads cost in the same view.
All your BigQuery data
Datasets and tables your account can read, ready to ask about.
Always today's numbers
Google Ads and Search Console bulk exports, if you run them, synced from BigQuery automatically, so answers use today's numbers.
Connect all your tools
Questions like "What did paid sessions earn?" use BigQuery and GA4, Snowflake at once.
How to connect BigQuery to Claude
Before you start
- A Google BigQuery account you can sign in to
- A Claude account
- A Lemonado account (the free trial works)
- 1
Connect Google BigQuery in Lemonado
In Lemonado, open Connectors, find Google BigQuery and sign in. Sign in with a Google account that can read the dataset holding your GA4 export, and pick that project. The BigQuery Data Viewer and Job User roles are enough.
- 2
Turn on external access
In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.
texthttps://mcp.lemonado.io/mcp - 3
Open Claude's connectors
Go to claude.ai and open Customize → Connectors. Click + Add, then Add custom connector.
- 4
Add Lemonado
Name it Lemonado and paste the server URL. Continue, review the sign-in settings Claude detects, and choose Sign in now.
texthttps://mcp.lemonado.io/mcp - 5
Sign in and turn it on
Approve access in the Lemonado window. Back in Claude, open a new chat and switch Lemonado on from the connectors menu.
- 6
Ask Claude about BigQuery
Try "From the GA4 export in BigQuery, compare sessions that ended in a purchase with ones that didn't over the last 30 days: pages per session, time on site and the pages they saw. Show it as an artifact." Or ask: "How long until people buy?" or "Which content assists sales?"
Good to know
- Custom connectors work on Claude Free, Pro, Max, Team and Enterprise. Free accounts can add one.
- On Team and Enterprise, an owner adds the connector first under Organization settings → Connectors → Add → Custom → Web. Members then connect their own accounts.
- Remote connectors belong to your Claude account, so the same connection shows up in Claude Desktop and Cowork. Requests come from Anthropic's cloud, not your computer.
What can Claude do with BigQuery?
Claude reads your BigQuery numbers, explains what moved and turns the answer into an artifact you can share.
ClaudeFrom the GA4 export in BigQuery, compare sessions that ended in a purchase with ones that didn't over the last 30 days: pages per session, time on site and the pages they saw. Show it as an artifact.
Done. Buyers view 7.4 pages against 2.1 and nearly all of them read a product review section. The artifact compares both groups page by page, with the SQL attached.
Source: BigQuery
Using user_pseudo_id in the GA4 export, how many days and sessions pass between first visit and first purchase?
Median 6 days and 3 sessions. A quarter of buyers purchase on their first visit, mostly from branded search.
Source: BigQuery
Which blog pages were viewed most often by users who purchased within 14 days, compared with all users?
The tent buying guide appears in 19% of buyer journeys but 4% of all journeys. The packing list post shows up a lot but rarely before a purchase.
Source: BigQuery
Sessions that used site search vs ones that didn't, last month: conversion rate and revenue per session.
Search sessions convert at 4.8% against 1.9%, and bring 2.6x more revenue per session. 31% of searches return no results.
Source: BigQuery
From the GA4 export in BigQuery, what were the last three pages people viewed before a purchase in October?
The most common path ends on the size guide, then the product page, then the cart. 41% of buyers read the size guide first.
Source: Google BigQuery
Join GA4 purchase revenue from BigQuery with Google Ads cost by campaign for last month.
Brand search returned $11.80 per dollar, Performance Max $3.10. Two PMax asset groups spent $4,200 with no GA4 purchases at all.
Source: BigQuery + Google Ads
Connect BigQuery to another AI app.
ChatGPT
Connect BigQuery to ChatGPT
Claude Code
Connect BigQuery to Claude Code
Cursor
Connect BigQuery to Cursor
VS Code (GitHub Copilot)
Connect BigQuery to VS Code (GitHub Copilot)
Codex
Connect BigQuery to Codex
Perplexity
Connect BigQuery to Perplexity
Google Antigravity
Connect BigQuery to Google Antigravity
Windsurf (Devin Desktop)
Connect BigQuery to Windsurf (Devin Desktop)
Zed
Connect BigQuery to Zed
n8n
Connect BigQuery to n8n
Other integrations for Claude
All Claude integrations
Google Analytics in ClaudeAsk Claude, ChatGPT or Cursor about GA4 traffic, conversions and funnels, next to your ad spend.
Snowflake in ClaudeAsk Claude, ChatGPT or Cursor about the numbers in your Snowflake warehouse, with live ad spend next to them.
Google Ads in ClaudeAsk Claude, ChatGPT or Cursor about your Google Ads campaigns, search terms and spend.
Google Search Console in ClaudeAsk Claude, ChatGPT or Cursor about your search queries, rankings and lost clicks.
Google Tag Manager in ClaudeAsk Claude, ChatGPT or Cursor what's in your GTM container, and what changed when tracking broke.
Pipedrive in ClaudeAsk Claude, ChatGPT or Cursor about your Pipedrive deals, and which ads bring the ones that close.
Reading this as an AI agent?
Everything an agent needs to set this up, in plain text. Paste this page's link into Claude and ask it to connect you, or copy the block.
# Connect Google BigQuery to Claude (Lemonado MCP) - Server URL: https://mcp.lemonado.io/mcp - Transport: Streamable HTTP - Auth: OAuth; the user signs in to Lemonado in the browser. No API keys. - In Lemonado: connect the Google Cloud project. Sign in with a Google account that can read the dataset holding your GA4 export, and pick that project. The BigQuery Data Viewer and Job User roles are enough. - In Claude: Customize → Connectors → Add custom connector ```text https://mcp.lemonado.io/mcp ``` One-click install: https://claude.ai/directory/lemonado First question to try: "From the GA4 export in BigQuery, compare sessions that ended in a purchase with ones that didn't over the last 30 days: pages per session, time on site and the pages they saw. Show it as an artifact." More: https://lemonado.io/integrations/bigquery · https://lemonado.io/llms.txt
Frequently Asked Questions
For event-level questions, yes. Link GA4 to BigQuery in GA4's admin and the daily export starts from that day on. Without it, Claude can still use Lemonado's GA4 connection for reports, just not the raw events.
Yes. Google's BigQuery MCP server is hosted, so Claude can use it too. It covers Google BigQuery only. Lemonado covers Google BigQuery plus your ad platforms, GA4 and the rest of your stack in one connection, so Claude can answer questions across them.
In Claude, open Customize → Connectors and check that Lemonado says Connected, then switch it on from the connectors menu in the chat. In Lemonado, check that Google BigQuery is connected and External tools is on for the company. If yesterday's GA4 data is missing, the daily export may not have landed yet. GA4 writes the events_ table for a day several hours after it ends.
Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Join GA4 purchase revenue from BigQuery with Google Ads cost by campaign for last month."
MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.
Still have a question?
Shoot us an email at hello@lemonado.io.
Try for freeStop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
Try Lemonado free