Google Analytics 4 Connector

Start moving your Google Analytics 4 data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Google Analytics 4 connector in the Weld documentation

campaign_performance

property_id

string

session_campaign_name

session_default_channel_g...

5 more google-analytics-4 tables

Explore available Google Analytics 4 data

Browse all the data tables available for the Google Analytics 4 connector, in our interactive ERD data viewer.

View the Google Analytics 4 Data Schema

Transform and model Google Analytics 4 data

Get clean data models from your Google Analytics 4 data. Weld makes it easy to transform and model with the powerful built in SQL editor and AI Assistant.

Google Analytics 4

raw.google_analytics 4.table1

raw.google_analytics 4.table2

Get started with Google Analytics 4 SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Google Analytics 4.

Account Report

This 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.

User Activity Overview

This 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.

Campaign Report

This 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 Overview

This 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 Performance

This 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.

View all Google Analytics 4 templates

Send data to Google Analytics 4

Sync data from any data source to Google Analytics 4, with the Weld Reverse ETL, for powerful data enrichment. Easy setup fully managed data pipeline to Google Analytics 4 in minutes with no coding required.

View more about the Google Analytics 4 integration in the Weld documentation