Skip to content
Kitbay
Skill

ga4-bigquery-schema

MITUpdated on Oct 12, 2026114GitHub stars

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