Skip to content
Kitbay
Skill

bigquery

MITUpdated on Nov 11, 202693GitHub stars

A skill in henkisdabro's wookstar Claude Code plugin collection for answering questions from the Google Analytics 4 export in BigQuery.

What the skill teaches

A skill in henkisdabro's wookstar Claude Code plugin collection for answering questions from the Google Analytics 4 export in BigQuery. It first checks that a BigQuery MCP server is connected, naming Google's MCP Toolbox plugin and the hosted BigQuery endpoint, then finds the analytics dataset and date range of the export shards. Cost rules come next: always filter by table suffix, name columns, filter event names early and extract parameters with scalar subqueries, followed by a dry run before the real query. It covers sessionisation, time-zone gotchas and why numbers differ from the GA4 interface, with a reference file of query patterns.

Capabilities

  • Find the GA4 export dataset and date range in BigQuery
  • Write cost-aware SQL against date-sharded event tables
  • Dry-run queries before running them
  • Rebuild sessions and landing pages from raw events