Google Analytics 4 Connector
Google Analytics 4 is the latest web analytics service offered by Google.
Google Analytics 4Your warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Google Analytics 4
Data source
Google Analytics 4 in your warehouse.
Ready for your agents.
Google Analytics 4 is the latest web analytics service offered by Google. Weld's Google Analytics 4 connector is fully managed: it extracts data from Google Analytics 4, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
Google Analytics 4 data schema.
The map your agents read.
Every table, field and relationship Weld syncs from Google Analytics 4 is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 7
- fields
- 93
Google Analytics 4 models.
What the numbers mean.
Open-source SQL that turns the raw Google Analytics 4 tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Account ReportThis SQL template generates a comprehensive account report by aggregating user statistics, campaign performance, and event data from Google Analytics. It combines these metrics to provide insights on total users, new users, sessions, user engagement, campaign details, and event revenue for each day. The results are ordered by date in descending order.grain: day x property x campaign
- User Activity OverviewThis SQL template aggregates monthly user activity data from Google Analytics, including total users, new users, sessions, average sessions per user, screen page views, and user engagement duration.grain: month x property
- Campaign ReportThis SQL template generates a monthly summary report of campaign performance metrics from Google Analytics data. It aggregates data such as total users, sessions, engaged sessions, events per session, engagement rate, event count, conversions, total revenue, and user engagement duration. The results are ordered by period and total users in descending order.
- Channel Traffic OverviewThis SQL template provides a monthly overview of channel traffic from Google Analytics, summarizing metrics such as total users, sessions, engaged sessions, events per session, engagement rate, event count, conversions, total revenue, and user engagement duration, grouped by channel.
- Event PerformanceThis SQL template aggregates Google Analytics event data by month, summarizing event counts, user counts, average events per user, and total revenue for each event. It groups the data by period and event name, then orders the results by event count in descending order.
- Page Path AnalysisThis SQL template aggregates Google Analytics data to provide a monthly overview of page paths, including metrics such as screen page views, total users, new users, event count, conversions, total revenue, and user engagement duration, grouped by traffic source.grain: month x property x page path
Ask your agent.
It already knows Google Analytics 4.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Google Analytics 4 context, finds the tables it needs and queries your warehouse.
- Agent contextGoogle Analytics 4 tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many campaign_performance rows do we have in our Google Analytics 4 data?
Reading the Google Analytics 4 context first, so the query uses the right tables and keys.
Load Google Analytics 4 into any warehouse.
Set up in minutes, no code.
Google Analytics 4 to Amazon Redshift
Google Analytics 4 to Amazon Redshift Cluster
Google Analytics 4 to Amazon S3
Google Analytics 4 to Apache Iceberg
Google Analytics 4 to Azure SQL Database
Azure Synapse
Google Analytics 4 to ClickHouse- Google Analytics 4 to Databricks
- Google Analytics 4 to Google BigQuery
Everything you need.
To get started.
Google Analytics 4 setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Google Analytics 4 connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Google Analytics 4 data to work.
Connect Google Analytics 4, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
