Ga4 Bigquery Schema

GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips

114 stars 16 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema
Manual install
git clone --depth 1 https://github.com/cognyai/claude-code-marketing-skills.git /tmp/claude-code-marketing-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-code-marketing-skills/skills/ga4-bigquery-schema ~/.claude/skills/ga4-bigquery-schema

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# GA4 BigQuery Export Schema Reference

Complete reference guide to the Google Analytics 4 BigQuery export schema, including table structure, nested fields, common queries, and data processing best practices.

Full docs: https://cogny.com/docs/ga4-bigquery-export-schema

## Usage

```
/ga4-bigquery-schema                      # Show full schema overview
/ga4-bigquery-schema event_params         # Explain event_params structure
/ga4-bigquery-schema conversion funnel    # Show conversion funnel query pattern
/ga4-bigquery-schema ecommerce            # Explain ecommerce fields
```

## Instructions

You are a GA4 BigQuery schema expert. Use this reference to help users understand the GA4 export schema, write correct BigQuery SQL queries against GA4 data, and follow performance best practices.

When the user asks a question, find the relevant section below and provide precise, actionable answers with ready-to-use SQL examples.

If the user provides a specific topic as an argument, focus on that area. Otherwise, provide an overview of the schema structure.

## Works with

Works with zero accounts: every query below is copy-paste SQL. When connected:

| Job | Solo / no account | Cogny Cloud | Plus GA4 connected |
|-----|-------------------|-------------|--------------------|
| Find the export dataset | user supplies `project.analytics_ID` | `list_datasets` → `list_tables` | — |
| Check the real schema | the reference below | `inspect_schema` | — |
Read the full skill on GitHub

Details

Skill name
ga4-bigquery-schema
Path
skills/ga4-bigquery-schema/SKILL.md
Repo updated
12 October 2026

FAQ

What does the Ga4 Bigquery Schema skill do?

GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips

How do I install the Ga4 Bigquery Schema skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Ga4 Bigquery Schema popular?

It lives in cognyai/claude-code-marketing-skills, which has 114 GitHub stars and 16 forks, and is included in 3 curated skill lists.

Related skills

Ad Copy Writer

114

cognyai/claude-code-marketing-skills

Generate ad copy variations for Google, Microsoft, Meta, LinkedIn, TikTok, Reddit, Snapchat and X Ads (plus Apple Search Ads guidance)

Marketing, Sales & BusinessIn 3 lists16

Ad Kill Rules

114

cognyai/claude-code-marketing-skills

Enforce a pre-declared evidence bar on every ad — after it spends enough, pause it if it misses (e.g. CTR < 1% or cost per lead over cap) across Meta, TikTok, LinkedIn, Google and Bing — as a dry-run report, an approved pause, or a scheduled pause-only Cogny script

Marketing, Sales & BusinessIn 3 lists16

Brand Kit

114

cognyai/claude-code-marketing-skills

Build a portable brand-kit.json for the user's product — colors, typography, voice — that other skills (video, ad creative, landing page) can consume. Multiple discovery paths so it works whether the user has access to their site's source code or only a public URL or just a logo image.

Frontend & DesignIn 3 lists16

Utm Builder

114

cognyai/claude-code-marketing-skills

UTM Parameter Strategy & Builder — naming conventions, GA4 channel grouping rules, auto-tagging, common mistakes, and BigQuery validation queries

DatabasesIn 3 lists16

Ga4 Audit

114

cognyai/claude-code-marketing-skills

Google Analytics 4 configuration and data-quality audit — key events, data streams, custom dimensions, attribution, retention, PII, Ads link, BigQuery export

DatabasesIn 3 lists16

Caching Strategies

272

curiositech/some_claude_skills

Design multi-tier caching architectures for web applications — cache-aside vs write-through vs write-behind, TTL design, cache invalidation, Redis patterns, CDN configuration, browser caching, and stampede prevention. Use when choosing a caching pattern, designing cache invalidation strategies, implementing Redis caching, configuring Cache-Control headers, or preventing cache stampedes. Activate on "cache invalidation", "cache-aside", "write-through", "TTL", "Redis cache", "CDN caching", "cache stampede", "stale data", "browser cache". NOT for database query caching within an ORM, memoization

Databases46

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.