Ga4 Bigquery Schema
GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips
Install
npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schemagit 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-schemaPersonal 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` | — |
Details
- Skill name
ga4-bigquery-schema- Repository
- cognyai/claude-code-marketing-skills
- 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
114cognyai/claude-code-marketing-skills
Generate ad copy variations for Google, Microsoft, Meta, LinkedIn, TikTok, Reddit, Snapchat and X Ads (plus Apple Search Ads guidance)
Ad Kill Rules
114cognyai/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
Brand Kit
114cognyai/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.
Utm Builder
114cognyai/claude-code-marketing-skills
UTM Parameter Strategy & Builder — naming conventions, GA4 channel grouping rules, auto-tagging, common mistakes, and BigQuery validation queries
Ga4 Audit
114cognyai/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
Caching Strategies
272curiositech/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
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.