ga4-bigquery-schema
A reference skill from Cogny AI on the schema of the Google Analytics 4 export in BigQuery.
What the skill teaches
A reference skill from Cogny AI on the schema of the Google Analytics 4 export in BigQuery. It explains daily and intraday tables, top-level fields and nested records such as event parameters, user properties, device, geo, traffic source, ecommerce and items, and gives ready SQL for sessions and users, page views, conversion funnels, acquisition and cohort retention. Performance advice covers table-suffix pruning and pre-aggregated summary tables, plus checks for missing export days. It works with no account by handing over SQL to run; with Cogny's own MCP connection it can list datasets, inspect schemas and run read-only queries. It is invoked as a slash command.
Capabilities
- Explain the GA4 BigQuery export schema and nested fields
- Provide SQL for sessions, funnels, acquisition and retention
- Advise on table-suffix pruning and summary tables
- Check export data for missing days
About
- Publisher
- Cogny AI
- Tool
- BigQuery
Install
- Run this to add it to Any client:
curl -sSL https://raw.githubusercontent.com/cognyai/claude-code-marketing-skills/main/install.sh | bash
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tools | BigQuery, Google Analytics | |
| Publisher | Cogny AI | source |
| Official status | Community (not published by the tool's vendor) | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Oct 12, 2026114 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
Sources
- Skill file (SKILL.md)github.com/cognyai/claude-code-marketing-skills · Backs: Official status, PublisherNov 10, 2026
- README (README.md)github.com/cognyai/claude-code-marketing-skills · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/cognyai/claude-code-marketing-skills · Backs: Activity, LicenceNov 11, 2026
- Folder in the repository (ga4-bigquery-schema)github.com/cognyai/claude-code-marketing-skills · Backs: Includes scriptsNov 10, 2026