Agent skill

Ga4 Bigquery Schema

by cognyai in cognyai/claude-code-marketing-skills

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

No licenceAuto-check: notesDatabases

Install Ga4 Bigquery Schema

skills CLI
$ npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install cognyai/claude-code-marketing-skills ga4-bigquery-schema --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/cognyai/claude-code-marketing-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/ga4-bigquery-schema .claude/skills/ga4-bigquery-schema && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
ga4-bigquery-schema
GitHub stars
104
Token cost
~4.7k tokens
SKILL.md length
468 words
Files
1
Skills in repo
47
Repo updated
First seen
Licence
None found

At a glance

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

  • Tasks that involve Data warehousing
  • SKILL.md covers Usage, Instructions, Overview and Top-Level Fields, plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Ga4 Bigquery Schema is an agent skill from cognyai/claude-code-marketing-skills. GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips

Its SKILL.md is about 4.7k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Data warehousing. It works with Google Analytics and Google BigQuery. The repository describes itself as: Marketing skills for Claude Code — SEO audits and implementation, ad analysis, ad optimization. Free skills need no account. $9/mo for live Search Console, Bing & LinkedIn data.

When your agent uses it

  • Tasks that involve Data warehousing

Example prompts

  • “/ga4-bigquery-schema”

Requirements

  • Pre-approved tools (allowed-tools): WebSearch, Read, Write, Bash

What it can do on your machine

Read from SKILL.md and the folder at commit a062fb4. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • WebSearch
    • Read
    • Write
    • Bash

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are sql).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • cogny.com
    • support.google.com
    • cloud.google.com
    • developers.google.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Ga4 Bigquery Schema loads about 4.7k tokens when it runs. Until then it costs about 35 tokens; SKILL.md has 468 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~35
When it runs · the whole SKILL.md, loaded when a task matches
~4.7k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NotePre-approves every shell command (allowed-tools: Bash)SKILL.md
    allowed-tools: WebSearch, Read, Write, Bash

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Without a licence we can't republish the file, so here is its outline and opening line. It has 468 words (~4,654 tokens).

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

— opening of SKILL.md by cognyai
name
ga4-bigquery-schema
allowed-tools
WebSearch, Read, Write, Bash
version
1.0.0
author
Cogny AI
user-invocable
true
argument-hint
<query or topic>

Read the full SKILL.md on GitHub

Files

Just SKILL.md in skills/ga4-bigquery-schema of cognyai/claude-code-marketing-skills.

Open the folder on GitHubat commit a062fb4

Compare with similar skills

Ga4 Bigquery Schema next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Ga4 Bigquery Schema compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Ga4 Bigquery Schema this skillcognyai/claude-code-marketing-skills104—~4.7kAutomated safety check: NotesNone
Gx Ga4 Expertcriptogus/agent-evolve-network288—~749Automated safety check: PassMIT
Ga4 Bigquery Exportjeremylongshore/tons-of-skills-marketplace2.8k—~2.8kAutomated safety check: PassMIT
Neocarta Add Source Connectorneo4j-labs/neocarta147—~1.9kAutomated safety check: PassApache-2.0
Write Script Bigquerywindmill-labs/windmill18k—~2.2kAutomated safety check: PassCustom licence
Bigquery Sentimentinfometa/workbuddyskills348—~3.3kAutomated safety check: WarnNone

Similar skills

  • Gx Ga4 Expert

    criptogus/agent-evolve-network

    Configure GA4 properties, GTM, custom events, conversions, audiences, and BigQuery export.

    288 GitHub stars~749 tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • Ga4 Bigquery Export

    jeremylongshore/tons-of-skills-marketplace

    Wire GA4 → BigQuery for unsampled, queryable event-level data.

    2.8k GitHub stars~2.8k tokensUpdated today
    DatabasesAuto-check passed
  • Scaffold, build, and verify a neocarta source or format connector against the connector contract.

    147 GitHub stars~1.9k tokensUpdated yesterday
    DatabasesAuto-check passed
  • Write Script Bigquery

    windmill-labs/windmill

    MUST use when writing BigQuery queries.

    18k GitHub stars~2.2k tokensUpdated today
    DatabasesAuto-check passed
  • Bigquery Sentiment

    infometa/workbuddyskills

    Core skill for game sentiment querying and analysis. An agent skill from infometa/workbuddyskills.

    348 GitHub stars~3.3k tokensUpdated today
    DatabasesAuto-check: warnings
  • Foundations

    openshift-eng/ai-helpers

    A skill your agent uses when executing any BigQuery CI data query — provides the shared safety protocol, cost controls, bq CLI patterns, and caching workflow

    120 GitHub stars~1.2k tokensUpdated 3 days ago
    DatabasesAuto-check passed

More from cognyai/claude-code-marketing-skills

All 47 skills in this repo
  • Gtm Audit

    cognyai/claude-code-marketing-skills

    Google Tag Manager container audit — tag health, orphaned and paused tags, duplicate GA4 config, trigger coverage, Consent Mode, naming, workspace hygiene

    104 GitHub stars~1.6k tokensUpdated 3 mo ago
    Auto-check passed
  • Gtm Setup

    cognyai/claude-code-marketing-skills

    GTM Event Tracking & Setup Reference — dataLayer fundamentals, trigger types, variable types, GA4 tag configuration, debug mode, and best practices

    104 GitHub stars~4.8k tokensUpdated 3 mo ago
    Auto-check: notes
  • Gtm Tracking Plan

    cognyai/claude-code-marketing-skills

    Turn a measurement plan into a Google Tag Manager spec — tags, triggers, variables, and copy-paste dataLayer snippets for every event

    104 GitHub stars~1.4k tokensUpdated 3 mo ago
    Auto-check: notes
  • Pre Send QA

    cognyai/claude-code-marketing-skills

    Pre-flight QA for an email campaign — merge tags, broken links, spam triggers, compliance, mobile rendering — before you hit send

    104 GitHub stars~2.2k tokensUpdated 3 mo ago
    Auto-check: notes
  • Brand Kit

    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.

    104 GitHub stars~3.4k tokensUpdated 3 mo ago
    Auto-check: notes
  • Linkedin Launch Video

    cognyai/claude-code-marketing-skills

    Produce a LinkedIn-native 1:1 (or 16:9) launch video using HyperFrames.

    104 GitHub stars~2.7k tokensUpdated 3 mo ago
    Auto-check: notes

Categories

Questions about Ga4 Bigquery Schema

What does Ga4 Bigquery Schema do?

GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips. Ga4 Bigquery Schema is an agent skill from cognyai/claude-code-marketing-skills.

When should I use Ga4 Bigquery Schema?

Ga4 Bigquery Schema fits situations like: tasks that involve Data warehousing.

How do I install Ga4 Bigquery Schema in Claude Code?

Run `npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema -a claude-code`. Or copy the skill folder (skills/ga4-bigquery-schema in cognyai/claude-code-marketing-skills) into .claude/skills/ga4-bigquery-schema in your project. Claude Code loads it when a task matches its description.

How do I install Ga4 Bigquery Schema in Codex?

Run `npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema -a codex`. Or copy the skill folder (skills/ga4-bigquery-schema in cognyai/claude-code-marketing-skills) into .agents/skills/ga4-bigquery-schema in your project. Codex loads it when a task matches its description.

Can I use Ga4 Bigquery Schema in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add cognyai/claude-code-marketing-skills --skill ga4-bigquery-schema -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/ga4-bigquery-schema, .gemini/skills/ga4-bigquery-schema, .github/skills/ga4-bigquery-schema and .opencode/skills/ga4-bigquery-schema in your project.

What does Ga4 Bigquery Schema need to run?

SKILL.md names no scripts, command-line tools or credentials: Ga4 Bigquery Schema is instructions for the agent only. Its frontmatter pre-approves these tools: WebSearch, Read, Write, Bash.

Does Ga4 Bigquery Schema access the network?

SKILL.md names 4 domains. As links in the text: cogny.com, support.google.com, cloud.google.com and developers.google.com. This is read from the text; nothing was executed.

Is Ga4 Bigquery Schema safe to install?

Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Ga4 Bigquery Schema use?

No licence was found for Ga4 Bigquery Schema or its repository. Without one, default copyright applies: ask the author before reusing or redistributing it.

How many tokens does Ga4 Bigquery Schema use?

About 4.7k tokens (SKILL.md is roughly 19k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Ga4 Bigquery Schema?

Skills that share tags, products or a category with Ga4 Bigquery Schema: Gx Ga4 Expert (criptogus/agent-evolve-network, 288 stars), Ga4 Bigquery Export (jeremylongshore/tons-of-skills-marketplace, 2.8k stars), Neocarta Add Source Connector (neo4j-labs/neocarta, 147 stars) and Write Script Bigquery (windmill-labs/windmill, 18k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Ga4 Bigquery Schema?

cognyai (a GitHub organization) maintains it in cognyai/claude-code-marketing-skills, which has 104 GitHub stars. The repository holds 47 skills in this directory. The repository was last updated on June 16, 2026.

Source: cognyai/claude-code-marketing-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.