本文へスキップ
Kitbay
スキル

bigquery

MIT2026年11月11日 更新93GitHubスター

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

スキルの内容

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.

できること

  • 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