Can I use this for real-time GA4 data analysis?

The skill includes guidance for both Daily exports and Streaming exports, the latter of which provides near real-time data for GA4 360 properties.

How do I handle nested event parameters in GA4 BigQuery?

Use the UNNEST function within a subquery or JOIN to extract specific string or integer values from the event_params array based on a target key.

How do I join GA4 data with other sources using this skill?

It provides SQL patterns for joining GA4 events with external datasets like CRM logs or product catalogs using common identifiers like user_id or transaction_id.

Does this skill help with BigQuery cost management?

Yes, it provides best practices such as using _TABLE_SUFFIX filters and selecting specific columns to minimize the volume of data scanned during queries.

GA4 BigQuery Analysis & Export

Name: GA4 BigQuery Analysis & Export
Author: henkisdabro

byhenkisdabro

•

分析と監視

Facilitates the setup, querying, and analysis of raw Google Analytics 4 data within BigQuery using optimized SQL patterns and schema documentation.

The ga4-bigquery skill empowers users to bridge the gap between GA4 event collection and raw data analysis by providing comprehensive guidance on BigQuery export setup, table schema navigation, and advanced SQL querying. It simplifies complex tasks such as working with nested and repeated fields using the UNNEST function, building custom attribution models, and performing unsampled user journey analysis. By integrating performance optimization best practices and cost management strategies, this skill ensures developers and data analysts can efficiently extract actionable insights from large-scale GA4 datasets beyond the limitations of the standard GA4 user interface.

主な機能

01Step-by-step guidance for BigQuery export setup and linking

028 GitHub stars

03Automated SQL query generation for GA4 nested schemas

04Advanced UNNEST pattern implementation for event parameters

05Query performance optimization using _TABLE_SUFFIX and clustering

06Comprehensive schema reference for events, users, and e-commerce

ユースケース

01Analyzing long-term historical trends beyond standard GA4 data retention limits

02Integrating GA4 data with CRM or external business databases for holistic reporting

03Building custom attribution models from raw, unsampled event-level data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add henkisdabro/wookstar-claude-code-plugins ga4-bigquery

For use in Claude.ai and ChatGPT

Download Skill