Google Analytics 4 Connector

**Bring GA4 website and app data into Snowflake — fully structured, query-ready, and continuously updated.**<br/>Windsor.ai’s GA4 connector eliminates BigQuery dependencies and JSON exports by streaming your GA4 event, session, and user data straight into Snowflake. Analysts and marketers can answer product, funnel, and attribution questions using just SQL.

What it does

- Connects to **Google Analytics 4 (GA4)** via OAuth
- Extracts **event-level** data including sessions, page views, ecommerce, user properties, and conversions
- Delivers **fully typed Snowflake tables** — no nested JSON or semi-structured blobs
- Supports **multiple GA4 properties** and **custom dimensions/metrics**
- Handles **historical backfills, incremental loads, schema evolution**, and **retry logic**
- Runs **100% inside Snowflake** for native performance and security

## Sample tables & fields

**GA4_EVENTS** — event_timestamp, event_name, session_id, page_location, page_referrer, source, medium, campaign, device_category, browser, country, event_params, user_properties,<br/>**GA4_USERS** — user_pseudo_id, first_visit_date, device_type, geo_country, traffic_channel, user_properties, total_sessions, total_conversions<br/>**GA4_SESSIONS** — session_id, user_pseudo_id, session_start_time, session_duration, page_views, bounce, source, medium, campaign, session_engagement<br/>**GA4_ECOMMERCE_EVENTS** — event_name, product_id, item_name, quantity, item_category, item_variant, price, value, currency, transaction_id

*All custom dimensions and metrics are auto-mapped to typed fields when defined in your GA4 property.*

## Key use cases

- Website & app funnel drop-off analysis
- Traffic and conversion source attribution
- Product and content performance by segment
- Joining GA4 with ad data (Google Ads, Meta Ads) or backend conversions
- Custom dashboards in Looker, Tableau, Power BI without BigQuery

Why teams choose Windsor.ai’s GA4 Snowflake Connector

- **No BigQuery required** — eliminates the GA4-BQ dependency for Snowflake users
- **Typed, flattened schema** — no need to unpack nested event_params or JSON fields
- **Works with 325+ other sources** — including Shopify, Google Ads, HubSpot, Meta Ads
- **Zero-maintenance syncs** — full control over frequency, backfill window, and destination schema
- **Native security** — ELT jobs run inside Snowflake, no data leaves your account

原始信息汇总

Google Analytics 4 Connector 数据集概述

数据集提供商

• Windsor.ai

数据集特点

• 免费
• 无限访问

数据集功能

• 将GA4网站和应用数据导入Snowflake
• 完全结构化、可查询且持续更新
• 消除对BigQuery的依赖和JSON导出
• 支持通过SQL回答产品、漏斗和归因问题

主要功能

• 通过OAuth连接到Google Analytics 4 (GA4)
• 提取事件级数据（包括会话、页面浏览、电子商务、用户属性和转化）
• 提供完全类型化的Snowflake表（无嵌套JSON或半结构化数据块）
• 支持多个GA4属性和自定义维度/指标
• 处理历史回填、增量加载、模式演变和重试逻辑
• 100%在Snowflake内运行

示例表及字段

• GA4_EVENTS — event_timestamp, event_name, session_id, page_location, page_referrer, source, medium, campaign, device_category, browser, country, event_params, user_properties
• GA4_USERS — user_pseudo_id, first_visit_date, device_type, geo_country, traffic_channel, user_properties, total_sessions, total_conversions
• GA4_SESSIONS — session_id, user_pseudo_id, session_start_time, session_duration, page_views, bounce, source, medium, campaign, session_engagement
• GA4_ECOMMERCE_EVENTS — event_name, product_id, item_name, quantity, item_category, item_variant, price, value, currency, transaction_id

关键用例

• 网站和应用漏斗流失分析
• 流量和转化来源归因
• 按细分市场分析产品和内容表现
• 将GA4与广告数据（Google Ads、Meta Ads）或后端转化数据结合
• 在Looker、Tableau、Power BI中创建自定义仪表板，无需BigQuery

优势

• 无需BigQuery
• 类型化、扁平化的模式
• 支持325+其他数据源
• 零维护同步
• 本地安全性

业务需求

• 漏斗与流失分析
• 归因分析
• 简化BI工具的数据访问
• 跨堆栈的联合分析

安全性

• 通过Snowflake安全审查
• 基于角色的访问控制
• 推荐授予的权限：账户级别权限、对象权限、连接权限、应用事件权限

类别

• 归因分析
• 连接器

联系方式

• 销售：[e-mail]
• 支持：https://support.windsor.ai/

关于Windsor.ai

• 帮助连接325+营销、分析、销售和CRM平台，并将数据流式传输到Snowflake