Ga4 Bigquery Schema (Grade A) logo

Ga4 Bigquery Schema (Grade A)Security-tested data-ai skill for Claude AI. Grade A. GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips

(0)
Daniel NikulshynReviewed by Daniel Nikulshyn·Updated July 2026

Overview

The Ga4 Bigquery Schema is a security-tested data-ai skill for Claude AI, providing a complete field reference, nested structures, query patterns, and performance tips for the Google Analytics 4 BigQuery export schema. It is designed to help users understand the GA4 export schema, write correct BigQuery SQL queries against GA4 data, and follow performance best practices. The schema exports raw event data to BigQuery in a nested, denormalized format, with daily and intraday tables available. Each row represents a single event with nested fields for event parameters, user properties, and e-commerce data. The top-level fields include event_date, event_timestamp, event_name, event_params, and more. The event_params field is an array of event parameters stored as key-value pairs, with common event parameters including page_location and page_title. The schema also includes nested structures for user properties, device information, geographic information, and e-commerce transaction data. The Ga4 Bigquery Schema skill provides a reference guide to help users navigate the schema and write effective queries. It includes usage instructions, examples, and performance tips to help users get the most out of their GA4 data. By using this skill, users can gain a deeper understanding of their GA4 data and make data-driven decisions. The Ga4 Bigquery Schema is a valuable resource for anyone working with GA4 data in BigQuery, providing a comprehensive and detailed guide to the schema and its many features. With its security-tested and Grade A certification, users can trust that the skill is reliable and accurate. Overall, the Ga4 Bigquery Schema is a powerful tool for anyone looking to unlock the full potential of their GA4 data in BigQuery. Its comprehensive reference guide, nested structures, and performance tips make it an essential resource for anyone working with GA4 data.

Key features

  • Complete field reference
  • Nested structures
  • Query patterns
  • Performance tips
  • Ready-to-use SQL examples

Pricing

Model
Free
Category
Skills
Rating
No reviews yet

Use cases

GA4 Data Analysis

Analyze Google Analytics 4 data in BigQuery to gain insights into user behavior and event patterns.

BigQuery SQL Querying

Write efficient BigQuery SQL queries against GA4 data using the provided schema reference and query patterns.

Pros & Cons

Pros

  • Comprehensive reference guide
  • Nested structures and query patterns
  • Performance best practices
  • Ready-to-use SQL examples

Cons

  • Steep learning curve for GA4 and BigQuery
  • Requires knowledge of SQL and data modeling

Reviews

Sign in to leave a review.

No reviews yet. Be the first!

Q&A

Can I buy extra credits on Solo too?

Yes. On Solo, MCP usage stays unmetered under fair use, so driving Cogny from your own AI client never costs credits. In-app chat, image generation, and other opt-in expensive operations run on top-up credits ($20, $50, $100, or $200, rolling over indefinitely), which you can buy whenever you want to use them.

Asked by Rina Desai · May 11, 2026

What MCP tools are included in Solo?

Solo includes all current and future MCP tools and skills — the same ones available in Cloud. The difference is execution: Solo runs one channel at a time while Cloud runs all channels in parallel with automation features like scheduled jobs and daily briefs.

Asked by Uma Krishnan · Apr 16, 2026

Can I try it before paying?

Yes — every new workspace gets 15 free MCP calls to test the stack. No credit card required. Once you've used them up (or the next month rolls over), you can upgrade to Solo at $9/mo or Cloud at $499/mo, or wait for the next 15 free calls to land.

Asked by Kwame Mensah · Mar 7, 2026

What's the difference between Solo and Cloud?

Solo ($9/mo) gives you prompt-driven AI marketing with your own Claude. MCP is unmetered under fair use, so you can drive Cogny from Claude, ChatGPT, or any client without burning credits. In-app chat and image generation run on top-up credits. One channel at a time, all skills included. Cloud ($499/mo) adds 2000 AI credits per month that cover chat too, plus parallel execution across all channels, image generation, scheduled jobs, daily briefs, shared team workspace, organisational memory, custom report templates, Truth Ledger, and priority support.

Asked by Mia Andersen · Mar 2, 2026

How do Cloud credits work?

Your $499/mo Cloud plan includes 2000 AI credits each month — covering chat, MCP calls, image generation, and other AI usage. When you run out, you can top up extra credits ($20, $50, $100, or $200) that roll over indefinitely, or wait for the next billing cycle when your monthly credits reset.

Asked by Celeste Marchetti · Feb 25, 2026

Ask a question

Skills alternatives

Using Git Worktrees (Grade A) logo
Using Git Worktrees (Grade A)Skills

Security-tested data-ai skill for Claude AI. Grade A. Use when starting feature work that needs isolation from current workspace or before executing implementation plans - creates isolated git worktre

(0)
Free
Meta Capi (Grade A) logo
Meta Capi (Grade A)Skills

Security-tested data-ai skill for Claude AI. Grade A. Meta Conversions API (CAPI) Setup Reference — architecture, event types, customer information hashing, deduplication, implementation examples, AEM

(0)
Free
Callees (Grade A) logo
Callees (Grade A)Skills

Security-tested development skill for Claude AI. Grade A. Lista o que uma funcao/metodo chama (call graph direto)

(0)
Free
Test Module Name (Grade A) logo
Test Module Name (Grade A)Skills

Security-tested data-ai skill for Claude AI. Grade A. Name Haskell test modules after the module under test with a Spec suffix in the same namespace. Use when writing or reviewing Haskell test module

(0)
Free
Board Of Directors (Grade A) logo
Board Of Directors (Grade A)Skills

Security-tested data-ai skill for Claude AI. Grade A. Simulate a 5-member expert board deliberation for major decisions. Use when evaluating plans, architecture choices, feature designs, or any decisi

(0)
Free
Advpl Mvc Avancado (Grade A) logo
Advpl Mvc Avancado (Grade A)Skills

Security-tested development skill for Claude AI. Grade A. MVC avançado via PE (Pontos de Entrada) — adicionar grids customizadas em telas MVC padrão (CNTA300/MATA070/MATA440/MATA460/FINA040 via *STRU)

(0)
Free
D
Docs Writer (Grade A)Skills

Security-tested devops skill for Claude AI. Grade A. **WORKFLOW SKILL** — Maintains repository documentation accuracy and freshness across the docs site, agent files, and changelog. WHEN: "update docs

(0)
Free
Advpl Fundamentals (Grade A) logo
Advpl Fundamentals (Grade A)Skills

Security-tested development skill for Claude AI. Grade A. Fundamentos ADVPL/TLPP — notação húngara (c/n/d/l/a/o/b/x/u), naming convention, escopos Local/Static/Private/Public, limite de 10 chars em .p

(0)
Free